string CommandText = "select subjectneme,detilesub,description,molahzat,fileatt ch,emtiaz,usercreat from tajrobe where";
void serachsub()
{
if (subject==1)
{
CommandText = CommandText + "subject='" + s + "'";
}
if (detile==1)
{
CommandText = CommandText + "detilesub like '%" + txtdetil.Text.Trim() + "%'";
}
if(descrip==1)
{
CommandText = CommandText+ "description like '%" + txtdescrip.Text.Trim() + "%'";
}
if(user==1)
{
CommandText = CommandText + "usercreat like '%" + txtuser.Text.Trim() + "%'";
}
SqlCoection Co = new SqlCoection(coectionString);
SqlCommand sqlComm = new SqlCommand(CommandText, Co);
Co.Open();
SqlDataReader reader = sqlComm.ExecuteReader();
برچسب:
نویسنده: خنج