Select Multiple Records on GridView

[code4knowledge]

Hi!

Is there a way to have a user select more than one record from a gridview?

Thanks to all for the helping hand!!!!

code4knowledge!!!

[gayathriram]

string connection = " Data Source=SERVER;Initial Catalog=databasename;User ID=; Password=;";
SqlConnection con = new SqlConnection(connection);
string query1 = "select * from table1";
SqlCommand cmd1 = new SqlCommand(query1, con);
SqlDataAdapter adap = new SqlDataAdapter(cmd1);
DataSet ds = new DataSet();
con.Open();
adap.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
con.Close();


While clicking some button event you write this code means you can get

a single and multiple rows from table to data grid.

In the above code insert your databasename,servername,user id and password and tablename,control name and all.

Try this will come output definitely

[code4knowledge]

Hi Gayathriram,

Thank you for your response, that works well. However, I may have mis interpreted what I am trying to accomplish. I need to copy the selected records from a grid view into another grid view that will allow the users to edit the data and insert as new records.

By the way, I am using C# VS2005.

Thank you!