hi everyone,
iam a newbie in asp.net.even it sounds silly doubt to u ,plz help me.i want parameters in a sql query to insert a record.i wrote the program like this,but iam not able to insert the data.so,plz say my mistake .
Dim str As String
con = New SqlConnection("user id=sa;password=;data source=charan;database=master")
command = New SqlCommand(str, con)
command.Parameters.Add(New SqlParameter(" @empid ", TextBox1.Text))
command.Parameters.Add(New SqlParameter("@empname", TextBox2.Text))
command.Parameters.Add(New SqlParameter("@salary", TextBox3.Text))
command.Parameters.Add(New SqlParameter("@comm", TextBox4.Text))
str = "insert into employees(empid,empname,salary,comm)values (@empid,@empname,@salary,@comm)"
con.Open()
command.ExecuteNonQuery()
da = New SqlDataAdapter("select distinct * from employees ", con)
da.Fill(ds, "employees")
GridView1.DataSource = ds
GridView1.DataBind()
con.Close()