Nå... jeg har prøvet igen - samme resultat.
Jeg har lavet en ny webform - som før med et datagrid, sqlDataAdapter, sqlConnection og et dataset.
Altsammen lavet direkte med drag'n'drop og alt det fine visual.net
Configureret datagrid'en med property builderen.
Tilsyneladende mangler jeg at få oprettet et eller andet deleteCommand Event - er der ikke en måde at få det generet automatisk (ligesom når man dobbeltklikker på datagridden - så oprettes SelectedIndexChanged????
sekhmet - dine forslag lyder som noget i den rigtige retning - men skal jeg rette i den autogenerede code (#region Web Form Designer generated code - do not modify)
Den nye version af coden er her - med nøjagtig samme resultat som før - jeg kommer aldrig ind i deleteCommand (forståeligt nok) Har du eller andre et bud??
code:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace FAN_Tools
{
/// <summary>
/// Summary description for WebForm1.
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
protected System.Data.SqlClient.SqlCommand sqlSelectCommand1;
protected System.Data.SqlClient.SqlCommand sqlInsertCommand1;
protected System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
protected System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
protected System.Data.SqlClient.SqlConnection sqlConnection1;
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected FAN_Tools.ModelsDataSet modelsDataSet1;
private void Page_Load(object sender, System.EventArgs e)
{
// Put user code to initialize the page here
sqlDataAdapter1.Fill(modelsDataSet1);
DataGrid1.DataBind ();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: This call is required by the ASP.NET Web Form Designer.
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.modelsDataSet1 = new FAN_Tools.ModelsDataSet();
((System.ComponentModel.ISupportInitialize)(this.modelsDataSet1)).BeginInit();
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "modeller", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("modelnr", "modelnr"),
new System.Data.Common.DataColumnMapping("modelnavn", "modelnavn"),
new System.Data.Common.DataColumnMapping("beskrivelse", "beskrivelse"),
new System.Data.Common.DataColumnMapping("vinnr", "vinnr"),
new System.Data.Common.DataColumnMapping("interval", "interval"),
new System.Data.Common.DataColumnMapping("service_type", "service_type"),
new System.Data.Common.DataColumnMapping("aargang", "aargang")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT modelnr, modelnavn, beskrivelse, vinnr, interval, service_type, aargang FR" +
"OM modeller";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO modeller(modelnr, modelnavn, beskrivelse, vinnr, interval, service_type, aargang) VALUES (@modelnr, @modelnavn, @beskrivelse, @vinnr, @interval, @service_type, @aargang); SELECT modelnr, modelnavn, beskrivelse, vinnr, interval, service_type, aargang FROM modeller WHERE (modelnr = @modelnr)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@modelnr", System.Data.SqlDbType.VarChar, 30, "modelnr"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@modelnavn", System.Data.SqlDbType.VarChar, 30, "modelnavn"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@beskrivelse", System.Data.SqlDbType.VarChar, 50, "beskrivelse"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@vinnr", System.Data.SqlDbType.VarChar, 20, "vinnr"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@interval", System.Data.SqlDbType.VarChar, 10, "interval"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@service_type", System.Data.SqlDbType.VarChar, 5, "service_type"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@aargang", System.Data.SqlDbType.VarChar, 20, "aargang"));
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE modeller SET modelnr = @modelnr, modelnavn = @modelnavn, beskrivelse = @beskrivelse, vinnr = @vinnr, interval = @interval, service_type = @service_type, aargang = @aargang WHERE (modelnr = @Original_modelnr) AND (aargang = @Original_aargang OR @Original_aargang IS NULL AND aargang IS NULL) AND (beskrivelse = @Original_beskrivelse OR @Original_beskrivelse IS NULL AND beskrivelse IS NULL) AND (interval = @Original_interval OR @Original_interval IS NULL AND interval IS NULL) AND (modelnavn = @Original_modelnavn OR @Original_modelnavn IS NULL AND modelnavn IS NULL) AND (service_type = @Original_service_type OR @Original_service_type IS NULL AND service_type IS NULL) AND (vinnr = @Original_vinnr OR @Original_vinnr IS NULL AND vinnr IS NULL); SELECT modelnr, modelnavn, beskrivelse, vinnr, interval, service_type, aargang FROM modeller WHERE (modelnr = @modelnr)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@modelnr", System.Data.SqlDbType.VarChar, 30, "modelnr"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@modelnavn", System.Data.SqlDbType.VarChar, 30, "modelnavn"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@beskrivelse", System.Data.SqlDbType.VarChar, 50, "beskrivelse"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@vinnr", System.Data.SqlDbType.VarChar, 20, "vinnr"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@interval", System.Data.SqlDbType.VarChar, 10, "interval"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@service_type", System.Data.SqlDbType.VarChar, 5, "service_type"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@aargang", System.Data.SqlDbType.VarChar, 20, "aargang"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_modelnr", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "modelnr", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_aargang", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "aargang", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_beskrivelse", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "beskrivelse", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_interval", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "interval", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_modelnavn", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "modelnavn", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_service_type", System.Data.SqlDbType.VarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "service_type", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_vinnr", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "vinnr", System.Data.DataRowVersion.Original, null));
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM modeller WHERE (modelnr = @Original_modelnr) AND (aargang = @Original_aargang OR @Original_aargang IS NULL AND aargang IS NULL) AND (beskrivelse = @Original_beskrivelse OR @Original_beskrivelse IS NULL AND beskrivelse IS NULL) AND (interval = @Original_interval OR @Original_interval IS NULL AND interval IS NULL) AND (modelnavn = @Original_modelnavn OR @Original_modelnavn IS NULL AND modelnavn IS NULL) AND (service_type = @Original_service_type OR @Original_service_type IS NULL AND service_type IS NULL) AND (vinnr = @Original_vinnr OR @Original_vinnr IS NULL AND vinnr IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_modelnr", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "modelnr", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_aargang", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "aargang", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_beskrivelse", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "beskrivelse", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_interval", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "interval", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_modelnavn", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "modelnavn", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_service_type", System.Data.SqlDbType.VarChar, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "service_type", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_vinnr", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "vinnr", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "data source=CARTMANN;initial catalog=Auto-Tools;password=mr2mr2;user id=sa;workst" +
"ation id=CARTMANN;packet size=4096";
//
// modelsDataSet1
//
this.modelsDataSet1.DataSetName = "ModelsDataSet";
this.modelsDataSet1.Locale = new System.Globalization.CultureInfo("da-DK");
this.modelsDataSet1.Namespace = "
http://www.tempuri.org/ModelsDataSet.xsd"; this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
this.Load += new System.EventHandler(this.Page_Load);
((System.ComponentModel.ISupportInitialize)(this.modelsDataSet1)).EndInit();
}
#endregion
private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
{
}
private void DataGrid1_DeleteCommand(object sender, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
Response.Write("testing:" + e.Item.Cells[0].Text );
}
}
}