I am adding a checkboxlist control to a C# asp.net 2010 since I am new to working with web pages. The following code works if I hardcode the value in the where clause. However, I want to pass the value in the where clause as a paramter. Thus can you tell me what I could change in the code below to pass the value to the where statement not as a hardcoded value?
DBConnection.FillAttChkListBox(ChkBoxLstPlan, "Hnumber", "Hnumber",
DBConnection.ExecuteQuery("select p.Hnumber from dbo.Org o inner join Pl p on o.OrganizationID =p.OrganizationID where OrganizationName='orgname1'"), false);
public static DataTable ExecuteQuery(string SQLstring)
{
string constr = ConfigurationManager.ConnectionStrings["DBConnectionString"].ConnectionString;
//string constr = ConfigurationManager.ConnectionStrings["Client_ServiceConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(constr);
DataTable dt = new DataTable("tbl");
using (conn)
{
conn.Open();
SqlCommand comm = new SqlCommand(SQLstring, conn);
comm.CommandTimeout = 0;
SqlDataAdapter da = new SqlDataAdapter(comm);
da.Fill(dt);
}
return dt;
}
public static void FillAttChkListBox(CheckBoxList chklistBox, String dataValueField, string dataTextField, DataTable dataTbl, bool bHasBlank)
{
chklistBox.DataTextField = dataTextField;
chklistBox.DataValueField = dataValueField;
chklistBox.DataSource = dataTbl;
chklistBox.DataBind();
if (bHasBlank)
{
chklistBox.Items.Insert(0, new ListItem());
// chklistBox.Items.Insert(1, new ListItem("All"));
}
}