尝试捕获数据表 [英] try catch for datatable

问题描述

如何为该数据表分配尝试捕获，

Hi,

How can i assign try catch for this data table,

private DataTable GetData(SqlCommand cmd)
        {
            DataTable dt = new DataTable();
            using (SqlConnection con = new SqlConnection(strConnString))
                {
                    using (SqlDataAdapter sda = new SqlDataAdapter())
                    {
                        cmd.Connection = con;
                        con.Open();
                        sda.SelectCommand = cmd;
                        sda.Fill(dt);
                        if (dt.Rows.Count > 0)
                        {
                            Session["Name1"] = Convert.ToString(dt.Rows[0]["Name"]);
                            //Session["IssueId1"] = Convert.ToInt32(dt.Rows[0]["IssueId"]);
                        }
                        else
                        {
                            lblerror.Text = "No Pending Issue";
                        }
                        con.Close();
                        return dt;

                    }
                }  
        }

提前致谢.

Thanks in Advance.

推荐答案

您好，请使用下面的代码

Hi, Use below code

private DataTable GetData(SqlCommand cmd)
            {
try
{
                  DataTable dt = new DataTable();
                  using (SqlConnection con = new SqlConnection(strConnString))
                        {
                              using (SqlDataAdapter sda = new SqlDataAdapter())
                              {
                                    cmd.Connection = con;
                                    con.Open();
                                    sda.SelectCommand = cmd;
                                    sda.Fill(dt);
                                    if (dt.Rows.Count > 0)
                                    {
                                          Session["Name1"] = Convert.ToString(dt.Rows[0]["Name"]);
                                          //Session["IssueId1"] = Convert.ToInt32(dt.Rows[0]["IssueId"]);
                                    }
                                    else
                                    {
                                          lblerror.Text = "No Pending Issue";
                                    }
                                    con.Close();
                                    return dt;
 
                              }
}
catch(Exception ex)
{
Response.Write(ex.Message);
}
                        }  
            }

这篇关于尝试捕获数据表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！