UserID and Password Authentication using Web Service

[Sangeetha Nagaraj]

Hi Pals,
I am a starter to web services. I have a requirement.
I want to develop a web service, which accepts userid and password from the
user and checks it with the MS Access database. If the userid and password
found correct in the database, it must return the address of the person in
the XML format.
Can any one please give me the code, so that I can modify it to fit to my
project.
Thanks in Advance..

--
Rgds,
Sang

[John Paul. A]

Dear Sangeetha Nagaraj,

Here's the code:

Database Name : DB1.MDB
Table Name : CUSTOMER

[WebMethod(Description="Get Employee Info")]
public string GetUserInfo( string userId , string password )
{
private OleDbConnection conn;
conn=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\\DB1.MDB");
conn.Open();

string XMLFormat ;
string command = "select NAME , AGE , ADDRESS1 , ADDRESS2 , CITY , STATE ,
ZIP , TEL , EMAIL from CUSTOMER WHERE USERID = '" + userId + "' AND PASSWORD
= '" + password + "'";
OleDbCommand cmd=new OleDbCommand(command,conn);
OleDbDataReader rdr;
rdr=cmd.ExecuteReader();
bool ret = rdr.Read();
if ( ret )
{
XMLFormat = "<DETAILS>\n";
XMLFormat += "<NAME>"+rdr.GetValue(0).ToString()+"</NAME>\n";
XMLFormat += "<AGE>"+rdr.GetValue(1).ToString()+"</AGE>\n";
XMLFormat += "<ADDRESS1>"+rdr.GetValue(2).ToString()+"</ADDRESS1>\n";
XMLFormat += "<ADDRESS2>"+rdr.GetValue(3).ToString()+"</ADDRESS2>\n";
XMLFormat += "<CITY>"+rdr.GetValue(4).ToString()+"</CITY>\n";
XMLFormat += "<STATE>"+rdr.GetValue(5).ToString()+"</STATE>\n";
XMLFormat += "<ZIP>"+rdr.GetValue(6).ToString()+"</ZIP>\n";
XMLFormat += "<TEL>"+rdr.GetValue(7).ToString()+"</TEL>\n";
XMLFormat += "<EMAIL>"+rdr.GetValue(8).ToString()+"</EMAIL>\n";
}
else
XMLFormat= "" ;

rdr.Close();
return XMLForat;
}

"Sangeetha Nagaraj" wrote:

Hi Pals,
I am a starter to web services. I have a requirement.
I want to develop a web service, which accepts userid and password from the
user and checks it with the MS Access database. If the userid and password
found correct in the database, it must return the address of the person in
the XML format.
Can any one please give me the code, so that I can modify it to fit to my
project.
Thanks in Advance..

--
Rgds,
Sang

[Sangeetha Nagaraj]

Hi John,
Can you please give me a crisp note about the code.
"John Paul. A" wrote:

Dear Sangeetha Nagaraj,

Here's the code:

Database Name : DB1.MDB
Table Name : CUSTOMER

[WebMethod(Description="Get Employee Info")]
public string GetUserInfo( string userId , string password )
{
private OleDbConnection conn;
conn=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\\DB1.MDB");
conn.Open();

string XMLFormat ;
string command = "select NAME , AGE , ADDRESS1 , ADDRESS2 , CITY , STATE ,
ZIP , TEL , EMAIL from CUSTOMER WHERE USERID = '" + userId + "' AND PASSWORD
= '" + password + "'";
OleDbCommand cmd=new OleDbCommand(command,conn);
OleDbDataReader rdr;
rdr=cmd.ExecuteReader();
bool ret = rdr.Read();
if ( ret )
{
XMLFormat = "<DETAILS>\n";
XMLFormat += "<NAME>"+rdr.GetValue(0).ToString()+"</NAME>\n";
XMLFormat += "<AGE>"+rdr.GetValue(1).ToString()+"</AGE>\n";
XMLFormat += "<ADDRESS1>"+rdr.GetValue(2).ToString()+"</ADDRESS1>\n";
XMLFormat += "<ADDRESS2>"+rdr.GetValue(3).ToString()+"</ADDRESS2>\n";
XMLFormat += "<CITY>"+rdr.GetValue(4).ToString()+"</CITY>\n";
XMLFormat += "<STATE>"+rdr.GetValue(5).ToString()+"</STATE>\n";
XMLFormat += "<ZIP>"+rdr.GetValue(6).ToString()+"</ZIP>\n";
XMLFormat += "<TEL>"+rdr.GetValue(7).ToString()+"</TEL>\n";
XMLFormat += "<EMAIL>"+rdr.GetValue(8).ToString()+"</EMAIL>\n";
}
else
XMLFormat= "" ;

rdr.Close();
return XMLForat;
}

"Sangeetha Nagaraj" wrote:

Hi Pals,
I am a starter to web services. I have a requirement.
I want to develop a web service, which accepts userid and password from the
user and checks it with the MS Access database. If the userid and password
found correct in the database, it must return the address of the person in
the XML format.
Can any one please give me the code, so that I can modify it to fit to my
project.
Thanks in Advance..

--
Rgds,
Sang

[John Paul. A]

Dear Sangeetha Nagaraj,

Here are the steps..
1. Create the Database in MS Access
2. Create the database connection and open the connection.
3. Create command and the reader to read from the database.
4. create a string which does XML formatting manually.
5. Populate the string and return it.

Thats it.. It is simple and cool...

"Sangeetha Nagaraj" wrote:

Hi John,
Can you please give me a crisp note about the code.
"John Paul. A" wrote:

Dear Sangeetha Nagaraj,

Here's the code:

Database Name : DB1.MDB
Table Name : CUSTOMER

[WebMethod(Description="Get Employee Info")]
public string GetUserInfo( string userId , string password )
{
private OleDbConnection conn;
conn=new OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; Data
Source=C:\\DB1.MDB");
conn.Open();

string XMLFormat ;
string command = "select NAME , AGE , ADDRESS1 , ADDRESS2 , CITY , STATE ,
ZIP , TEL , EMAIL from CUSTOMER WHERE USERID = '" + userId + "' AND PASSWORD
= '" + password + "'";
OleDbCommand cmd=new OleDbCommand(command,conn);
OleDbDataReader rdr;
rdr=cmd.ExecuteReader();
bool ret = rdr.Read();
if ( ret )
{
XMLFormat = "<DETAILS>\n";
XMLFormat += "<NAME>"+rdr.GetValue(0).ToString()+"</NAME>\n";
XMLFormat += "<AGE>"+rdr.GetValue(1).ToString()+"</AGE>\n";
XMLFormat += "<ADDRESS1>"+rdr.GetValue(2).ToString()+"</ADDRESS1>\n";
XMLFormat += "<ADDRESS2>"+rdr.GetValue(3).ToString()+"</ADDRESS2>\n";
XMLFormat += "<CITY>"+rdr.GetValue(4).ToString()+"</CITY>\n";
XMLFormat += "<STATE>"+rdr.GetValue(5).ToString()+"</STATE>\n";
XMLFormat += "<ZIP>"+rdr.GetValue(6).ToString()+"</ZIP>\n";
XMLFormat += "<TEL>"+rdr.GetValue(7).ToString()+"</TEL>\n";
XMLFormat += "<EMAIL>"+rdr.GetValue(8).ToString()+"</EMAIL>\n";
}
else
XMLFormat= "" ;

rdr.Close();
return XMLForat;
}

"Sangeetha Nagaraj" wrote:

Hi Pals,
I am a starter to web services. I have a requirement.
I want to develop a web service, which accepts userid and password from the
user and checks it with the MS Access database. If the userid and password
found correct in the database, it must return the address of the person in
the XML format.
Can any one please give me the code, so that I can modify it to fit to my
project.
Thanks in Advance..

--
Rgds,
Sang