protected void upload_Click(object sender, EventArgs e)
{
for (int j = 0; j < GridView1.Rows.Count; j++)
{
TextBox TextBox1 =(TextBox)GridView1.Row[j].FindControl("TextBox1 ");
DropDownList Eligible=(DropWownList)GridView1.Row[j].FindControl("Eligible");
SqlCommand comm = new SqlCommand("insert into sender '" + TextBox1 .Text + "','" + Eligible.Item[Eligible.SelectedIndex].Value + "'", con);
if (con.State.Equals(ConnectionState.Open))
{
comm.ExecuteNonQuery();
}
}
}