public static object SqlQuery(string query)
{
try
{
var Connection = Metoder.ÖppnaAnslutning();
var command = new SqlCommand();
var dataAdapter = new SqlDataAdapter(query, Connection);
var dataSet = new DataSet();
Connection.Open();
dataAdapter.Fill(dataSet, "datavarde");
return(dataSet);
}
catch { return(null); }
}
public void SqlQuery(string query)
{
try
{
var Connection = Metoder.ÖppnaAnslutning();
var command = new SqlCommand();
var dataAdapter = new SqlDataAdapter(query, Connection);
var dataSet = new DataSet();
Connection.Open();
dataAdapter.Fill(dataSet, "datavarde");
dataGridView1.DataSource = dataSet;
dataGridView1.DataMember = "datavarde";
} catch { MessageBox.Show("insert query!"); }
}