C# connectivity with SQL Server 2008 -


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