data not loading in gridview

john kanyora

Hi, i have a code that is using radiobutton to get data from a data table..i want once you click on the radiobutton it display the data on the gridview but it is not doing so..kindly help..below is the code am using.

protected void Radiobuttonlist1_CheckedChange(Object sender, EventArgs e)
{
string Value = Radiobuttonlist1.SelectedItem.Value.ToString();
if (Value == "Patients")
{
string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
SqlConnection conn = new SqlConnection(connect);
conn.Open();
SqlCommand cmd = new SqlCommand("select PatientName,PatientCellPhone from CustomerInformation", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
}
else if(Value== "Suppliers")
{
string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
SqlConnection conn = new SqlConnection(connect);
conn.Open();
SqlCommand cmd = new SqlCommand("select VendorName,VendorPhone from VendorInformation", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
}
else if ( Value== "Employees")
{
string connect = TraceBizCommon.Configuration.ConfigSettings.ConnectionString;
SqlConnection conn = new SqlConnection(connect);
conn.Open();
SqlCommand cmd = new SqlCommand("select EmployeeName,EmployeeMobilePhone from PayrollEmployees", conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
conn.Close();
GridView1.DataSource = ds;
GridView1.DataBind();
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jes Sie8y ago
Accepted answer
Do you get an error? If you did, can you post the error here?
I have a sample below which you can refer.
public static ChargesMasterDataModel GetChargesBySchoolById(string scode, int Id)
        {
            using(SqlConnection con = DBCS.GetConString())
            {
                SqlCommand cmd = new SqlCommand("spGet_ChargesBySchool_ById", con);
                cmd.CommandType = CommandType.StoredProcedure;
                con.Open();
                cmd.Parameters.AddWithValue("@SchoolCode", scode);
                cmd.Parameters.AddWithValue("@ChargesID", Id);
                SqlDataAdapter da = new SqlDataAdapter(cmd);
                DataTable ds = new DataTable();
                da.Fill(ds);
                try
                {
                    ChargesMasterDataModel item = new ChargesMasterDataModel();
                    item.ChargesID = Convert.ToInt32(ds.Rows[0]["ChargesID"]);
                    item.GradeLevel = ds.Rows[0]["GradeLevel"].ToString();
                    item.ChargeCode = ds.Rows[0]["ChargeCode"].ToString();
                    item.Description = ds.Rows[0]["Description"].ToString();
                    item.Amount = Convert.ToDouble(ds.Rows[0]["Amount"]);
                    item.SchoolCode = ds.Rows[0]["SchoolCode"].ToString();
                    item.UserLog = ds.Rows[0]["UserLog"].ToString();
                    //item.GetDateLogs = Convert.ToDateTime(ds.Rows[0]["GetDateLogs"]);
                    return item;
                }
                catch (Exception)
                {

                    throw;
                }
            }
        }
john kanyora8y ago
it does not give any errors..when i click on one of the radiobutton it simply does not load on the gridview