select all check boxes in grid using another checkbox

Question

Sir i have a gridview its contain checkbox for single deletion

but i want to delete multiple by using out side of gridview

for that i have a saperate checkbox out side the grid

if i select outside checkbox automatically select all checkboxes in grid and viseversa

please help me

Answer 1

When You are deleting records,

You can write query as

delete table AU_Delete

or
delete from table au_Delete.

you have to use * only in select queries.

try this

 SqlConnection con = new SqlConnection("Data Source=APPLE;Initial Catalog=sam;Integrated Security=True");

            SqlCommand cmd = new SqlCommand();

            cmd.Connection = con;

            con.Open();

            string str1 = "DELETE  AU_Delete";

            cmd.CommandText = str1;

            cmd.ExecuteNonQuery();

            con.Close();

          

Answer 2

Mohammed Shamsheer,

you can't write '*' for the delete Statements

string Query="delete from AU_DELETE";

Answer 3

Hi,

Remove '*' from your SQL Query and use

string str1 = "DELETE FROM AU_Delete";

You don't need to specify '*' for DELETE statement.