I made connection with sql Server 2000.When Write Normal add querry
I gives error.Remember Insertion is in table.But When i write following code it works.

System.Data.SqlClient.SqlCommand
sqlInsertCommand1.CommandText="INSERT INTO Student(id) VALUES (@id)";
System.Collections.IEnumerator a=sqlInsertCommand1.Parameters.GetEnumerator();
a.MoveNext();
SqlParameter myParm=(System.Data.SqlClient.SqlParameter)a.Curre nt;
myParm.Value='12';
sqlInsertCommand1.ExecuteNonQuery();


I donot know why is so.Further more similar code for delete require all parameter in condition of delete querry.Thats not feasible.Can anybody tell me what is the problem.Why normal querry doesnot work.

Hi (just joined today!!!)

System.Data.SqlClient.SqlConnection cn = new System.Data.SqlClient.SqlConnection(strConnectStri ng);
System.Data.SqlClient.SqlCommand cmd = cn.CreateCommand();
cmd.CommandText = "Insert into Clients(ClientID,Name,Surname,IDNo,PostalAddress,R esidentialAddress,
HomeTel," +
"Mobile,Remarks,BankName,BranchName,BranchCode,Acc ountNumber,
CardNumber," +
"ExpDate,PIN,TypeAccount,EmpNumber,Department,PayD ate,NettSal,EmployersID,UserID,Borrowing_Limit,Bla ckList)" +
"values('" + txtClientNum.Text + "','" + txtCustName.Text + "','"
+ txtSurname.Text + "','" + txtCustID.Text + "','" + txtPostal.Text + "','"
+ txtResid.Text + "','" + txtMobile.Text + "','"
+ txtHomeTel.Text + "','" + txtRemarks.Text + "','"
+ txtBankName.Text + "','" + txtBranch.Text + "','"
+ txtBranchCode.Text + "','" + txtAccNum.Text + "','"
+ txtCardNum.Text + "','" + txtExpDate.Text + "','"
+ txtPIN.Text + "','" + cbAccTypes.Text + "','"
+ txtEmpNum.Text + "','" + txtDept.Text + "','"
+ cbPayDate.Text + "','" + txtNettSal.Text + "','"
+ lblEmpID.Text + "','" + lblUsID.Text + "','" + txtBorrowLimit.Text + "','" + blacklist + "')";
cmd.CommandType = System.Data.CommandType.Text;
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();

This should work. The plus signs are for concatenation purposes.
This is the actual query that I use and it works everytime

jan

dude_in_africa

I have table name Id in which Id is the primary key.
I have one another table name Size ,I want to insert the values in size table for the value of field Id in Id table, So please tell me my Insert querry is of what type which makes joint of two table. by the way I am using access database
Please help me