Technicalideas FreeBooks Notes Programs Tips

Thursday, July 18, 2013

Sending SMS via C using Way2Sms

Sending SMS via C# using Way2Sms

26MAR

Create a new windows application.

Drag and drop 3 text boxes, 1 rich text box, 4 label, 1 button onto the form.

Rename the textboxes as following:

textbox1—>textBoxId
textbox2—>textBoxPassword
textbox3—>textBoxSendTo
richTextbox1—>richTextBoxText
button1—->buttonSend

In the solution explorer right cick on the Reference and add the following reference to the project:

SMSClientLibrary.dll

Include the following lines:

using System;

using SMSClientLib;

using System.Net;

Double click on the button and add the following snippet to the click event:

string status = “”;

CookieContainer cookie = Login.Connect(textBoxId.Text, textBoxPassword.Text, out status);

string[] siteParameters = Login.GetSiteParameters(cookie);

string messgeSentResult = SendSMS.Send_Processing(textBoxSendTo.Text, richTextBoxText.Text, cookie, siteParameters);

Here’s the ashKAP Texter:

Creating A simple DB2 Database Application with jsp

Creating a Database Application with jsp

In this session we are going to see that How to Create A simple DB2 Database Application with JSP (java server pages) . Application which we are going to build is login form
Topics Covered :

1. creating database for an application

2.Creating A form and sending data to server

3. connection to database with jsp

Steps to Follow

1. Create database"VOTERS"

create table "VOTER_DETAILS"
insert column "name" Character30 and "voter_id" Varchar 20
set voter_id as primary key
insert values in table

2. open RAD
3. creat dynamic web project "project1"
4. Right click on project and -> new -> webpage -> give page name as index
5. index.jsp is opened if not then explore web Content folder of project1 and double click on index.jsp
6. in that page place the code in between body tag


Voter name: 
Voter id:

7. save that page
8. now we need to create the page where the form data is passed i.e. check.jsp
9. create new page as check.jsp
10 open that page source n delete all n paste the code given below

<%@page import="java.sql.*" language="java" contentType="text/html;
charset=ISO-8859-1" pageEncoding="ISO-8859-1"%>

<%
Class.forName("com.ibm.db2.jcc.DB2Driver");
System.out.println("driver loaded sucesssssssssssssssssss");
Connection Conn=DriverManager.getConnection("jdbc:db2://localhost:50000/VOTERS","username","password");
String voter_name=request.getParameter("name");
String voter_id=request.getParameter("voter_id");
PreparedStatement Stmt=Conn.prepareStatement("SELECT NAME FROM VOTER_DETAILS WHERE NAME='"+voter_name+"' AND VOTER_ID='"+voter_id+"'");
System.out.println("Statement loaded sucesssssssssssssssssss");
Stmt.executeQuery();
ResultSet rs=Stmt.getResultSet();
System.out.println("query execute loaded sucesssssssssssssssssss");
String name= null;
while(rs.next())
{ name=rs.getString(1);
}
rs.close();Stmt.close();Conn.close();
if(name != null)
out.println("Welcome to "+name);
else
out.println("Please check your voter name and voter id...");
%>

11. now save this page
12. now what left is creating the database connection
13. open data perspective goto window -> open perspective ->select data perspective
14. creating connection