private string GenerateQuery()
{
string sAnd = " AND ";
StringBuilder sqlQuery = new StringBuilder();
if (txt_Admn_No.Text != "" )
{
sqlQuery.Append(" Admn_No='" + txt_Admn_No.Text + "' ");
}
if (cmbo_Class.SelectedIndex >0)
{
if (sqlQuery.Length > 0)
{
sqlQuery.Append(sAnd);
}
sqlQuery.Append( " Course_det_id=" + cmbo_Class.SelectedValue);
}
if (cmbo_Batch.SelectedIndex >0)
{
if (sqlQuery.Length > 0)
{
sqlQuery.Append(sAnd);
}
sqlQuery.Append( " batch_Id=" + cmbo_Batch.SelectedValue);
}
return sqlQuery.ToString();
}
{
string sAnd = " AND ";
StringBuilder sqlQuery = new StringBuilder();
if (txt_Admn_No.Text != "" )
{
sqlQuery.Append(" Admn_No='" + txt_Admn_No.Text + "' ");
}
if (cmbo_Class.SelectedIndex >0)
{
if (sqlQuery.Length > 0)
{
sqlQuery.Append(sAnd);
}
sqlQuery.Append( " Course_det_id=" + cmbo_Class.SelectedValue);
}
if (cmbo_Batch.SelectedIndex >0)
{
if (sqlQuery.Length > 0)
{
sqlQuery.Append(sAnd);
}
sqlQuery.Append( " batch_Id=" + cmbo_Batch.SelectedValue);
}
return sqlQuery.ToString();
}
No comments:
Post a Comment