Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [WebMethod]
- public DataSet GetUserAcc(string username)
- {
- DataSet ds = new DataSet();
- string database = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|/dvd_forum.accdb;Persist Security Info=True";
- string queryStr = "SELECT * FROM users WHERE username LIKE '%" + username + "%'";
- OleDbConnection myConn = new OleDbConnection(database);
- OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(queryStr, myConn);
- myConn.Open();
- myDataAdapter.Fill(ds, "Users");
- myConn.Close();
- return ds;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement