protected void Button_Click(object sender, EventArgs e)
{
string CS = (string)ConfigurationManager.AppSettings["myConnectionString"];
SqlConnection cnn = new SqlConnection(CS);
string meghdar = Textsearch.Text;
string find_convert = meghdar.Replace('ی', 'ی');
string strsql = null;
switch (DDLL.SelectedIndex)
{
case 0:
strsql = "select * from DR where FAMILY = @Search ";
break;
case 1:
strsql = "select * from DR where ZONEE = @Search ";
break;
case 2:
strsql = "select * from DR where PROFICIENCY = @Search ";
break;
}
SqlDataAdapter adpDR = new SqlDataAdapter(strsql, cnn);
SqlCommand cmd = new SqlCommand(strsql, cnn);
cmd.Parameters.Add(new SqlParameter("@Search", SqlDbType.NVarChar));
cmd.Parameters["@Search"].Value = find_convert;
adpDR.SelectCommand = cmd;
DataSet DS = new DataSet();
adpDR.Fill(DS, "DR");
GridView.DataSource = DS.Tables["DR"];
GridView.DataBind();
}
