帮我减少查询

扫码查看
本文介绍了帮我减少查询的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我是初学者开发一个项目,在我的项目中我使用了try catch in try catch,所以我如何专业地编写查询...



my代码是....



hi i am beginner to develop a project, in my project i used try catch with in try catch so how i write the query professionally...

my code is....

try
       {
           //connection();
           con = new SqlConnection(constr);
           con.Open();
           txtcusname.Text = "";
           txtcusnumber.Text = "";
           query = "sample_SP";
           cmd = new SqlCommand(query, con);
           cmd.CommandType = CommandType.StoredProcedure;
           cmd.Parameters.AddWithValue("@GetCusID", txtcusid.Text).ToString();
           da = new SqlDataAdapter(cmd);
           ds = new DataSet();
           da.Fill(ds);
           GrdCustomerDetails.DataSource = ds;
           GrdCustomerDetails.DataBind();
           con.Close();
           try
           {
               //connection();
               con = new SqlConnection(constr);
               con.Open();
               ViewState["VSCusID"] = txtcusid.Text;
               cmd = new SqlCommand("select contname,mob from CustContacts_TB where cid='" + ViewState["VSCusID"] + " '", con);
               dr = cmd.ExecuteReader();
               dr.Read();
               txtcusname.Text = dr["contname"].ToString();
               txtcusnumber.Text=dr["mob"].ToString();
               con.Close();
           }
           catch(Exception ex)
           {

           }
           finally
           {
               //connection();
               con = new SqlConnection(constr);
               con.Open();
               ViewState["VSCusID"] = txtcusid.Text;
               //cmd = new SqlCommand("select compname from CustCreate_TB inner join CustContacts_TB on CustContacts_TB.'" + ViewState["VSCusID"] + "'=CustCreate_TB.'" + ViewState["VSCusID"] + "' ", con);
               cmd = new SqlCommand("select compname from CustCreate_TB where cid='" + ViewState["VSCusID"] + " ' ", con);
               dr = cmd.ExecuteReader();
               dr.Read();
               txtcompname.Text = dr["compname"].ToString();
               con.Close();
               //txtcusname.DataBind();
           }
       }
       catch (Exception ex)
       {

       }
       finally
       {
           //connection();
           con = new SqlConnection(constr);
           con.Open();
           cmd = new SqlCommand("select compliantID,priorty,status from NewComp1 where customerid='" + ViewState["VSCusID"] + "' and status='open'", con);
           SqlDataAdapter da = new SqlDataAdapter(cmd);
           DataSet ds = new DataSet();
           da.Fill(ds);
           grdpending.DataSource = ds;
           grdpending.DataBind();

           cmd = new SqlCommand("select compliantID,priorty,status from NewComp1 where customerid='" + ViewState["VSCusID"] + "' and status='closed'", con);
           da = new SqlDataAdapter(cmd);
           ds = new DataSet();
           da.Fill(ds);
           grdClosed.DataSource = ds;
           grdClosed.DataBind();
           con.Close();
       }





可以减少代码和格式正确....感谢您的帮助和它对于开发我的编码技巧很有用



it possible to reduce code and it correct format.... thank you for helping and its useful to develop my coding skills

推荐答案



这篇关于帮我减少查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

09-15 10:21
查看更多