Advertisement
Guest User

Untitled

a guest
May 16th, 2012
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. [WebMethod]
  2. public DataSet GetUserAcc(string username)
  3. {
  4. DataSet ds = new DataSet();
  5. string database = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/dvd_forum.accdb;Persist Security Info=True";
  6. string queryStr = "SELECT * FROM users WHERE username LIKE '%" + username + "%'";
  7. OleDbConnection myConn = new OleDbConnection(database);
  8. OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(queryStr, myConn);
  9. myConn.Open();
  10. myDataAdapter.Fill(ds, "Users");
  11. myConn.Close();
  12. return ds;
  13. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement