i'm facing error when want connect sql server 2008 database.
error:
system.invalidoperationexception: executenonquery: connection property, has not been initialized.
@ system.data.sq1client.sq1command.validatecommand(string method, boolean async)
@ system.data.sq1client.sq1commandinternalexecutenonquery(taskcompletions ource'1 completion, string methodname, boolean sendtopipe, int32 timeout, boolean asyncwrite) @ system.data.sq1client.sq1command.executenonquery()
@ windowsformsapplication2.form1.create_click(object sender, eventargs e) in c:\users\admin\documents\visual studio 201caprojects\windowsformsapplicationawindowsformsapplicationaform1.cs line 127
sqlcommand cmd = new sqlcommand(); cmd.commandtext="insert dbo.student_record ( id, name, [father's cnic], [father's name], cnic ) values ('bcsf11a003', 'zargham nazeer malik', '35202-2953923-3', 'khalid nazeer malik', '35202-2235390-5')"; cmd.executenonquery(); con.close(); }
you're not adding connection command:
cmd.connection = con;
Comments
Post a Comment