private void ButUpdate_Click(object sender, EventArgs e)
{
//Verbindung oeffnen
string connectionString;
SqlConnection cnn;
connectionString = @"Data Source=NB\SQLEXPRESS;Initial Catalog=emc;User ID=SA;Password=******;";
cnn = new SqlConnection(connectionString);
cnn.Open();
MessageBox.Show("Connection Open !");
// DGView ---------------------
// SQL-Kommando abschicken
var select = "SELECT * FROM [dbo].[Order]";
var c = new SqlConnection(connectionString); // Your Connection String here
var dataAdapter = new SqlDataAdapter(select, c);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet("State");
dataAdapter.Update(ds); // Update view ist das Richtig!!!!! (ds, "[dbo].[Order]")
cnn.Close();
MessageBox.Show("Connection Update !");
}
|
|
|
private void ButUpdate_Click(object sender, EventArgs e)
{
//Verbindung oeffnen
SqlCommandBuilder cmdbl; //#######################
string connectionString;
SqlConnection cnn;
connectionString = @"Data Source=NB-TM2\SQLEXPRESSEROWA;Initial Catalog=***;User ID=SA;Password=************;";
cnn = new SqlConnection(connectionString);
cnn.Open();
MessageBox.Show("Connection Open !");
// DGView ---------------------
// SQL-Kommando abschicken
var select = "SELECT * FROM [dbo].[Order]";
var c = new SqlConnection(connectionString); // Your Connection String here
var dataAdapter = new SqlDataAdapter(select, c);
var commandBuilder = new SqlCommandBuilder(dataAdapter);
var ds = new DataSet();
//datagridview1.update();
//datagridview1.refresh();
// Datenzeile ändern
cmdbl = new SqlCommandBuilder(dataAdapter);
dataAdapter.Update(ds, "[State]"); // #### Was muss den hier stehen wenn nur State geändert wird!
DGView.Update();
DGView.Refresh();
cnn.Close();
MessageBox.Show("Connection Update !");
}
|
|
|
int carIdValue = int.Parse(LblId.Text); // Was mache ich mit der ID !!!!
string cName = TxtCarName.Text;
string mName = TxtModel.Text;
string yName = TxtYear.Text;
string conString;
conString = @"Data Source=nb-tm2\sqlexpresserowa;Initial Catalog=CarModels;User ID=SA;Password=******;"; //Properties.Settings.Default.SDB; // Was mus hier stehen!!!!!
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd = new SqlCommand("tblCarDetails", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Id", carIdValue));
cmd.Parameters.Add(new SqlParameter("@Name", cName));
cmd.Parameters.Add(new SqlParameter("@Model", mName));
cmd.Parameters.Add(new SqlParameter("@Year", yName));
cmd.ExecuteNonQuery();
MessageBox.Show("Update:");
con.Close();
|
|
|
int carIdValue = int.Parse(LblId.Text); // Was mache ich mit der ID !!!!
string cName = TxtCarName.Text;
string mName = TxtModel.Text;
string yName = TxtYear.Text;
string conString;
conString = @"Data Source=NB-TM2\SQLEXPRESSEROWA;Initial Catalog=CarModels;User ID=sa;Password=********D;MultipleActiveResultSets=True"; //Properties.Settings.Default.SDB; // Was mus hier stehen!!!!!
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd = new SqlCommand("update tblCarDetails set Name=@name,Model=@model,Year=@year where Id=@Id", con); // set value = @Value where Id = @Id
cmd.CommandType = CommandType.StoredProcedure; // Was ist StoredProcedure!!!!
//cmd.Parameters.Add(new SqlParameter("@Id", carIdValue));
cmd.Parameters.Add(new SqlParameter("@Name", cName));
cmd.Parameters.Add(new SqlParameter("@Model", mName));
cmd.Parameters.Add(new SqlParameter("@Year", yName));
cmd.ExecuteNonQuery();
MessageBox.Show("Update:");
con.Close();
|
|
|
int carIdValue = int.Parse(LblId.Text); // Was mache ich mit der ID !!!!
string cName = TxtCarName.Text;
string mName = TxtModel.Text;
string yName = TxtYear.Text;
string conString;
conString = @"Data Source=NB-TM2\SQLEXPRESSEROWA;Initial Catalog=CarModels;User ID=sa;Password=MNgbOI5cznEPJPhnEb2D;MultipleActiveResultSets=True"; //Properties.Settings.Default.SDB; // Was mus hier stehen!!!!!
SqlConnection con = new SqlConnection(conString);
con.Open();
SqlCommand cmd = new SqlCommand("update tblCarDetails set Name=@name,Model=@model,Year=@year where Id=@Id", con); // set value = @Value where Id = @Id
//cmd.CommandType = CommandType.StoredProcedure; // Was ist StoredProcedure!!!!
cmd.Parameters.Add(new SqlParameter("@Id", carIdValue));
cmd.Parameters.Add(new SqlParameter("@Name", cName));
cmd.Parameters.Add(new SqlParameter("@Model", mName));
cmd.Parameters.Add(new SqlParameter("@Year", yName));
cmd.ExecuteNonQuery();
MessageBox.Show("Update:");
con.Close();
|
|
|
