SqlConnection sqlConnection = newSqlConnection("Data Source=.;DataBase=DBName;" +
"Integrated Security=True;Connect Timeout=15;User Instance=False");
SqlDataAdapter sqlDataAdater = newSqlDataAdapter();
sqlDataAdater.SelectCommand = newSqlCommand();
sqlDataAdater.SelectCommand.Connection = sqlConnection;
DataSet dataSet = newDataSet();
sqlDataAdater.SelectCommand.CommandText = "select * from tbl_name (columns_name) values (columns_value) WHERE (columns_name) LIKE 'example'";
sqlConnection.Open();
sqlDataAdater.Fill(dataSet, "tbl_name");
sqlConnection.Close();