Please Reslove me from this error {"Cannot find table 0."}

natesh ghanta

7y695Learn iOS Programming

protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("spGettblemployeeBydepartment", con);
cmd.Parameters.AddWithValue("@commandtype", "insert");
int employeeid = Convert.ToInt32(cmd.ExecuteNonQuery());
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//TextBox CategoryID = (TextBox)GridView1.Rows[0].FindControl("txtemployeeid");
// cmd.Parameters.AddWithValue("employeeid", Convert.ToInt32(txtemployeeid));
cmd.Parameters.AddWithValue("@employeename", Convert.ToString(txtemployeename.Text.Trim()));
cmd.Parameters.AddWithValue("@departmentname", Convert.ToString(txtdepartmentname.Text.Trim()));
cmd.Parameters.AddWithValue("@employeeaddress", Convert.ToString(txtemployeeaddress.Text.Trim()));
//GridView1.DataSource = ds.Tables[1].DefaultView;
Bindgrid();
con.Close();
//GridView1.DataSource = ds;
//GridView1.DataBind();
// DataSet ds = new DataSet();
sda.Fill(ds);
GridView1.DataSource = ds;
//GridView1.DataMember = ds.Tables[0].TableName;
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}

3 Replies

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

brijesh rathor7y ago
Accepted answer
Hi Natesh,

before binding gridview datasource you need to check that dataset having table or not.
protected void btnsubmit_Click(object sender, EventArgs e)
{
    SqlConnection con = new SqlConnection(connectionString);
    con.Open();
    SqlCommand cmd = new SqlCommand("spGettblemployeeBydepartment", con);
    cmd.Parameters.AddWithValue("@commandtype", "insert");
    int employeeid = Convert.ToInt32(cmd.ExecuteNonQuery());
    SqlDataAdapter sda = new SqlDataAdapter(cmd);
    DataSet ds = new DataSet();
    //TextBox CategoryID = (TextBox)GridView1.Rows[0].FindControl("txtemployeeid");
    // cmd.Parameters.AddWithValue("employeeid", Convert.ToInt32(txtemployeeid));
    cmd.Parameters.AddWithValue("@employeename", Convert.ToString(txtemployeename.Text.Trim()));
    cmd.Parameters.AddWithValue("@departmentname", Convert.ToString(txtdepartmentname.Text.Trim()));
    cmd.Parameters.AddWithValue("@employeeaddress", Convert.ToString(txtemployeeaddress.Text.Trim()));
    //GridView1.DataSource = ds.Tables[1].DefaultView;
    Bindgrid();
    con.Close();
    //GridView1.DataSource = ds;
    //GridView1.DataBind();
    // DataSet ds = new DataSet();
    sda.Fill(ds);
    if (ds.Tables.Count > 0)
    {
        GridView1.DataSource = ds.Tables[0];
    }
    GridView1.DataBind();
}
natesh ghanta7y ago
Its not working dear....
protected void btnsubmit_Click(object sender, EventArgs e)

{

    SqlConnection con = new SqlConnection(connectionString);

    con.Open();

    SqlCommand cmd = new SqlCommand("spGettblemployeeBydepartment", con);

    cmd.Parameters.AddWithValue("@commandtype", "insert");

    int employeeid = Convert.ToInt32(cmd.ExecuteNonQuery());

    SqlDataAdapter sda = new SqlDataAdapter(cmd);

    DataSet ds = new DataSet();

    cmd.Parameters.AddWithValue("@employeename", Convert.ToString(txtemployeename.Text.Trim()));

    cmd.Parameters.AddWithValue("@departmentname", Convert.ToString(txtdepartmentname.Text.Trim()));

    cmd.Parameters.AddWithValue("@employeeaddress", Convert.ToString(txtemployeeaddress.Text.Trim()));

    con.Close();

    sda.Fill(ds);

    if (ds != null)

    {

        GridView1.DataSource = ds.Tables[0];

        GridView1.DataBind();

    }

}
Jignesh Kumar7y ago
Hi Natesh,

Please try below,
protected void btnsubmit_Click(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(connectionString);
            con.Open();
            SqlCommand cmd = new SqlCommand("spGettblemployeeBydepartment", con);

            cmd.Parameters.AddWithValue("@commandtype", "insert");
            int employeeid = Convert.ToInt32(cmd.ExecuteNonQuery());
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();


            cmd.Parameters.AddWithValue("@employeename", Convert.ToString(txtemployeename.Text.Trim()));
            cmd.Parameters.AddWithValue("@departmentname", Convert.ToString(txtdepartmentname.Text.Trim()));
            cmd.Parameters.AddWithValue("@employeeaddress", Convert.ToString(txtemployeeaddress.Text.Trim()));


            con.Close();


            sda.Fill(ds);
            if(ds != null)
            {
             GridView1.DataSource = ds.Tables[0];

             GridView1.DataBind();
            }

        }