// 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]")
// 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!
Habe mal ein SQL Beispiel aufgebaut. DB ------- Schlüssel Id int Name NCHAR(25) X Model NCAHR(25) X Year NCHAR(10) X
Datagrid abrufen geht.
Update kommt eine Fehlermeldung!
The Request for procedur "tblCarDetails" failed because "tblCarDetails" is a table object
Was heist das!
Update Code SQL
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();
Fehlermeldung Update: System.Data.SqlClient.SqlException: "Could not find stored procedure 'update tblCarDetails set Name=@name,Model=@model,Year=@year where Id=@Id'."
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));
So update funktioniert jetzt, aber für was verwendet man StoredProcedur!
So gehts 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=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));