Newsgroup: it.comp.www.asp
Titolo: Problema con C# .net

Preciso subito che sono alle prime armi e sto provando le funzionalita
di c#. Tramite C# .net ho creato un nuovo progetto "Applicazione Web"
e con tutti gli automatismi prodotto ho inserito un sqlconnection,
dataadapter e ho creato un dataset e inserito nella webform una
Datagrid cercando di agganciare la tabella di SQLSERVER 2000 Customers
del database Northwind. Nella scherma di progettazione di .Net sembra
tutto ok , nel senso che le colonne dalla Datagrid assumono in
automatico i nomi dei campi della tabella Curstomers. Inserisco il
codice della mia applicazione se avete voglio o tempi di darmi una
mano. Grazie mille
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 WebApplication7
{
	/// <summary>
	/// Descrizione di riepilogo per WebForm1.
	/// </summary>
	public class WebForm1 : 
System.Web.UI.Page
	{
		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 WebApplication7.DataSetProva dataSetProva1;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
 
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Inserire qui il codice utente necessario per inizializzare la
pagina.
		}
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: questa chiamata è richiesta da Progettazione Web Form
ASP.NET
.
			//
			InitializeComponent();
			base.OnInit(e);
		}
 
		/// <summary>
		/// Metodo necessario per il supporto della finestra di
progettazione. Non modificare
		/// il contenuto del metodo con l'editor di codice.
		/// </summary>
		private void InitializeComponent()
		{    
			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.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.dataSetProva1 = new WebApplication7.DataSetProva();
			((System.ComponentModel.ISupportInitialize)(this.dataSetProva1)).BeginInit();
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT CustomerID,
CompanyName, ContactName, ContactTitle, Address, City, Region," +
				" PostalCode, Country, Phone, Fax FROM Customers";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO
Customers(CustomerID, CompanyName, ContactName, ContactTitle, Address,
City, Region, PostalCode, Country, Phone, Fax) VALUES (@CustomerID,
@CompanyName, @ContactName, @ContactTitle, @Address, @City, @Region,
@PostalCode, @Country, @Phone, @Fax); SELECT CustomerID, CompanyName,
ContactName, ContactTitle, Address, City, Region, PostalCode, Country,
Phone, Fax FROM Customers WHERE (CustomerID = @CustomerID)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@CustomerID",
System.Data.SqlDbType.NVarChar, 5, "CustomerID"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@CompanyName",
System.Data.SqlDbType.NVarChar, 40, "CompanyName"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@ContactName",
System.Data.SqlDbType.NVarChar, 30, "ContactName"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@ContactTitle",
System.Data.SqlDbType.NVarChar, 30, "ContactTitle"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Address",
System.Data.SqlDbType.NVarChar, 60, "Address"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@City",
System.Data.SqlDbType.NVarChar, 15, "City"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Region",
System.Data.SqlDbType.NVarChar, 15, "Region"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@PostalCode",
System.Data.SqlDbType.NVarChar, 10, "PostalCode"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Country",
System.Data.SqlDbType.NVarChar, 15, "Country"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Phone",
System.Data.SqlDbType.NVarChar, 24, "Phone"));
			this.sqlInsertCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Fax",
System.Data.SqlDbType.NVarChar, 24, "Fax"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE Customers SET
CustomerID = @CustomerID, CompanyName = @CompanyName, ContactName =
@ContactName, ContactTitle = @ContactTitle, Address = @Address, City =
@City, Region = @Region, PostalCode = @PostalCode, Country = @Country,
Phone = @Phone, Fax = @Fax WHERE (CustomerID = @Original_CustomerID)
AND (Address = @Original_Address OR @Original_Address IS NULL AND
Address IS NULL) AND (City = @Original_City OR @Original_City IS NULL
AND City IS NULL) AND (CompanyName = @Original_CompanyName) AND
(ContactName = @Original_ContactName OR @Original_ContactName IS NULL
AND ContactName IS NULL) AND (ContactTitle = @Original_ContactTitle OR
@Original_ContactTitle IS NULL AND ContactTitle IS NULL) AND (Country
= @Original_Country OR @Original_Country IS NULL AND Country IS NULL)
AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND
(Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL)
AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL
AND PostalCode IS NULL) AND (Region = @Original_Region OR
@Original_Region IS NULL AND Region IS NULL); SELECT CustomerID,
CompanyName, ContactName, ContactTitle, Address, City, Region,
PostalCode, Country, Phone, Fax FROM Customers WHERE (CustomerID =
@CustomerID)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@CustomerID",
System.Data.SqlDbType.NVarChar, 5, "CustomerID"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@CompanyName",
System.Data.SqlDbType.NVarChar, 40, "CompanyName"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@ContactName",
System.Data.SqlDbType.NVarChar, 30, "ContactName"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@ContactTitle",
System.Data.SqlDbType.NVarChar, 30, "ContactTitle"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Address",
System.Data.SqlDbType.NVarChar, 60, "Address"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@City",
System.Data.SqlDbType.NVarChar, 15, "City"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Region",
System.Data.SqlDbType.NVarChar, 15, "Region"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@PostalCode",
System.Data.SqlDbType.NVarChar, 10, "PostalCode"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Country",
System.Data.SqlDbType.NVarChar, 15, "Country"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Phone",
System.Data.SqlDbType.NVarChar, 24, "Phone"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Fax",
System.Data.SqlDbType.NVarChar, 24, "Fax"));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_CustomerID",
System.Data.SqlDbType.NVarChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "CustomerID", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Address",
System.Data.SqlDbType.NVarChar, 60,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_City",
System.Data.SqlDbType.NVarChar, 15,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_CompanyName",
System.Data.SqlDbType.NVarChar, 40,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "CompanyName",
System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_ContactName",
System.Data.SqlDbType.NVarChar, 30,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "ContactName",
System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_ContactTitle",
System.Data.SqlDbType.NVarChar, 30,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "ContactTitle",
System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Country",
System.Data.SqlDbType.NVarChar, 15,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Country", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Fax",
System.Data.SqlDbType.NVarChar, 24,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Fax", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Phone",
System.Data.SqlDbType.NVarChar, 24,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_PostalCode",
System.Data.SqlDbType.NVarChar, 10,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "PostalCode", System.Data.DataRowVersion.Original,
null));
			this.sqlUpdateCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Region",
System.Data.SqlDbType.NVarChar, 15,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Region", System.Data.DataRowVersion.Original,
null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM Customers WHERE
(CustomerID = @Original_CustomerID) AND (Address = @Original_Address
OR @Original_Address IS NULL AND Address IS NULL) AND (City =
@Original_City OR @Original_City IS NULL AND City IS NULL) AND
(CompanyName = @Original_CompanyName) AND (ContactName =
@Original_ContactName OR @Original_ContactName IS NULL AND ContactName
IS NULL) AND (ContactTitle = @Original_ContactTitle OR
@Original_ContactTitle IS NULL AND ContactTitle IS NULL) AND (Country
= @Original_Country OR @Original_Country IS NULL AND Country IS NULL)
AND (Fax = @Original_Fax OR @Original_Fax IS NULL AND Fax IS NULL) AND
(Phone = @Original_Phone OR @Original_Phone IS NULL AND Phone IS NULL)
AND (PostalCode = @Original_PostalCode OR @Original_PostalCode IS NULL
AND PostalCode IS NULL) AND (Region = @Original_Region OR
@Original_Region IS NULL AND Region IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_CustomerID",
System.Data.SqlDbType.NVarChar, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "CustomerID", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Address",
System.Data.SqlDbType.NVarChar, 60,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Address", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_City",
System.Data.SqlDbType.NVarChar, 15,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "City", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_CompanyName",
System.Data.SqlDbType.NVarChar, 40,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "CompanyName",
System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_ContactName",
System.Data.SqlDbType.NVarChar, 30,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "ContactName",
System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_ContactTitle",
System.Data.SqlDbType.NVarChar, 30,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "ContactTitle",
System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Country",
System.Data.SqlDbType.NVarChar, 15,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Country", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Fax",
System.Data.SqlDbType.NVarChar, 24,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Fax", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Phone",
System.Data.SqlDbType.NVarChar, 24,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Phone", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_PostalCode",
System.Data.SqlDbType.NVarChar, 10,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "PostalCode", System.Data.DataRowVersion.Original,
null));
			this.sqlDeleteCommand1.Parameters.Add(new
System.Data.SqlClient.SqlParameter("@Original_Region",
System.Data.SqlDbType.NVarChar, 15,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "Region", System.Data.DataRowVersion.Original,
null));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "data
source=127.0.0.1;initial catalog=Northwind;persist security
info=False;user " +
				"id=SA;workstation id=HOME;packet size=4096";
			// 
			// 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", "Customers", new
System.Data.Common.DataColumnMapping[] {
																																																				   new
System.Data.Common.DataColumnMapping("CustomerID", "CustomerID"),
																																																				   new
System.Data.Common.DataColumnMapping("CompanyName", "CompanyName"),
																																																				   new
System.Data.Common.DataColumnMapping("ContactName", "ContactName"),
																																																				   new
System.Data.Common.DataColumnMapping("ContactTitle", "ContactTitle"),
																																																				   new
System.Data.Common.DataColumnMapping("Address", "Address"),
																																																				   new
System.Data.Common.DataColumnMapping("City", "City"),
																																																				   new
System.Data.Common.DataColumnMapping("Region", "Region"),
																																																				   new
System.Data.Common.DataColumnMapping("PostalCode", "PostalCode"),
																																																				   new
System.Data.Common.DataColumnMapping("Country", "Country"),
																																																				   new
System.Data.Common.DataColumnMapping("Phone", "Phone"),
																																																				   new
System.Data.Common.DataColumnMapping("Fax", "Fax")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// dataSetProva1
			// 
			this.dataSetProva1.DataSetName = "DataSetProva";
			this.dataSetProva1.Locale = new
System.Globalization.CultureInfo("it-IT");
			this.dataSetProva1.Namespace =
"
http://www.tempuri.org/DataSetProva.xsd
";
			this.Load += new System.EventHandler(this.Page_Load);
			((System.ComponentModel.ISupportInitialize)(this.dataSetProva1)).EndInit();
		}
		#endregion
	}
}

 }
Scusa ma non so aiutarti direttamente, perché quando uso VS il dataset e
connessioni varie le inserisco io direttamente da codice, ma su
www.aspnextgen.com
 era apparso qualche tempo fa, come costruire
un'applicazione con richiesta al database, datagrid, ecc... solo con i
wizard di VS... Prova a fare una ricerca su quel portale, dovresti trovarlo
abbastanza velocemente.
Ciao
--
AZ