How to store data in table format?

[chaitanya reddy]

Hi every one i want to store data in data table and send that data in xml format to web service after fetching it from sql query can any one help me plz .Here is my code

string username = Request.QueryString["username"];
string password = Request.QueryString["password"];
int response;
string constr = "Data Source=ITS-BA-DC02\\MSSQL2008_SAND;Initial Catalog=TestDB_Chaitanya;User ID=sa;Password=01Explore";
SqlConnection conn = new SqlConnection(constr);
conn.Open();
SqlCommand cmd = new SqlCommand("select * from users where username = '" + username + "'and password='" + password + "'", conn);
SqlDataAdapter da = new SqlDataAdapter("select * from users where username = '" + username + "'and password='" + password + "'", conn);
SqlDataReader dr = cmd.ExecuteReader();
DataSet ds = new DataSet();
DataTable dt;
da.Fill(ds, "users");

[dilipkakadiya]

hope this help

http://www.aspdotnetwork.com/2011/11...-services.html