in insert query got error pls find it

try as

string date= txtusersurname.Text +"/" +dldbirthdate.Text + "/" + dldbirthmonth.Text+ "/"+ dldbirthyear.Text;

 string str="insert into tablename values(@txtusername,@txtusersurname,@date)";
SqlCommand cmd=new SqlCommand(str,connection);
   cmd.Parameters.AddWithValue("txtusername",txtusername.Text);
   cmd.Parameters.AddWithValue("txtuserurname",txtuserurname.Text);
   cmd.Parameters.AddWithValue("date",date);

Try Your query by specifying the column name like,-

insert into tablename(COLUMN1,COLUMN2,...) VALUES(VALUE1,VALUE2,....)

How many columns do you have in your table depending on that you need to specify values.

example :

in case of two column table

insert into tablename(col1, col2) values (val1, val2);

you have not specify columns for what you are inserting values. if number of columns are more or less then 3 , your query will be fail.


thanks
-amit.