Here you go:
SELECT * FROM TblEmployee WHERE experience=1 AND javaExp=2
SELECT * FROM TblEmployee WHERE experience=1
SELECT * FROM TblEmployee WHERE Tech1Exp=1 OR Tech2Exp=1 OR Tech3Exp=1
You can of course use the SQL from C#, e.g.:
string expValueinCSharp = "2";
string SQL = "SELECT * FROM TblEmployee WHERE experience=" + expValueinCSharp;
and using the SQL in C# to get data from the server, e.g.:
string sampleConString = @"Server=(local)\sqlexpress;Integrated Security=True;Database=DB";
SqlConnection Conn = new SqlConnection(sampleConString);
SqlDataAdapter thisAdapter = new SqlDataAdapter(SQL, Conn);
DataSet ds = new DataSet();
thisAdapter.Fill(thisDataSet, "Collection");
foreach (DataRow Row in ds.Tables["MyTable"].Rows)
{
}
Conn.Close();
NOTE: this is a simplified example, you can methods to improve the above code, like SQL parameters in order to avoid SQL Injection, and you can use LINQ which is pretty cool.
Cheers,
Edo