Yes
SqlConnection cnn = new SqlConnection(cs.constring());
cnn.Open();
string query = "Select * from tblresident where gender=@gender";
SqlCommand cmd = new SqlCommand(query, cnn);
cmd.Parameters.AddWithValue("@gender", textBox1.Text);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds, "tblresident");