Posted on: 4/14/2014 11:56:46 AM | Views : 415

DropDownList DDLItemCode = (DropDownList)e.Row.FindControl("DDLItemCode");
            TextBox ItemName = (TextBox)e.Row.FindControl("TBoxItemName");
 
            if (ItemName.Text != "")
            {
                string connection = dbconnection.Connection();
                SqlConnection con1 = new SqlConnection(connection);
                con1.Open();
 
                SqlCommand cmd1 = new SqlCommand("SELECT * FROM ITEMMAS WHERE CASH_ACC='" + ItemName.Text + "'", con1);
                SqlDataReader dr1 = cmd1.ExecuteReader();
  ...

Go to the complete details ...