Lakshmi Posted September 6, 2008 Share Posted September 6, 2008 Hiwe r developing windows application(vb.net,flat files(databse)).i want to check login information(user enter the correct information or not) i need the code for login checking i write some code its not executingThis is my codesConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dbs\;Extended Properties=text;" sSQL = "SELECT count(*) as cnt FROM users.txt where users.Field1='" & TextBox1.Text & "' and users.Field2 ='" & TextBox2.Text & "'" Dim conn As New System.Data.OleDb.OleDbConnection(sConnectionString) Dim cmd As New System.Data.OleDb.OleDbCommand(sSQL, conn) Dim dr As System.Data.OleDb.OleDbDataReader conn.Open() cmd.CommandText = sSQL cmd.ExecuteNonQuery()giving error on this line 'cmd.ExecuteNonQuery() 'Thanks for any help. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.