Jump to content

Flat Files


Lakshmi

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...