ti inserisco i codici di crea record, cancella record e update record
CREA RECORD
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class learning_extjs_19_1_7_CREATE : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected String Give_me_connection()
{
String str_output_my, str_output_my_2;
String ID, Marca, Modello, Software, Firmware, Data, NoteNew, SoftwareVers, FirmwareVers, Visualizza;
int i;
int num_car;
Marca = Request.Form["Marca"];
Modello = Request.Form["Modello"];
Software = Request.Form["Software"];
Firmware = Request.Form["Firmware"];
Data = Request.Form["Data"];
NoteNew = Request.Form["NoteNew"];
SoftwareVers = Request.Form["SoftwareVers"];
FirmwareVers = Request.Form["FirmwareVers"];
Visualizza = Request.Form["Visualizza"];
// ----- INSERT of a new elemen -----
String ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("../../../../../../mdb-database/mpbluca/database/ONCEM_MARKET_DATI.mdb");
OleDbConnection cn = new OleDbConnection(ConnString);
String sql_str = "INSERT INTO dbo_Articoli_mia_FirmSoft (Marca , Modello , Software , Firmware , Data , NoteNew , SoftwareVers , FirmwareVers, Visualizza ) ";
sql_str = sql_str + " VALUES ('" + Marca + "','" + Modello + "','" + Software + "','" + Firmware + "','" + Data + "','" + NoteNew + "','" + SoftwareVers + "','" + FirmwareVers + "','" + Visualizza + "')";
OleDbCommand comandoSQL = new OleDbCommand(sql_str, cn);
cn.Open();
int records = (int)comandoSQL.ExecuteNonQuery();
cn.Close();
// ----- SELECT ID VALUE -----
DataSet mioDataSet;
OleDbDataAdapter mioDataAdapter;
sql_str = "SELECT MAX(ID) FROM dbo_Articoli_mia_FirmSoft ";
comandoSQL = new OleDbCommand(sql_str, cn);
cn.Open();
mioDataSet = new DataSet();
mioDataAdapter = new OleDbDataAdapter(comandoSQL);
mioDataAdapter.Fill(mioDataSet, "dbo_Articoli_mia_FirmSoft");
cn.Close();
int quantiRecord = mioDataSet.Tables["dbo_Articoli_mia_FirmSoft"].Rows.Count;
str_output_my = "not set";
i = 0;
while (i < quantiRecord)
{
str_output_my = (mioDataSet.Tables["dbo_Articoli_mia_FirmSoft"].Rows[i][0]).ToString();
i++;
}
// ----- INSERT BY WEB SERVICE -----
com.uk.######.www.Service ws = new com.uk.######.www.Service();
str_output_my_2 = ws.GiveMe_Insert(str_output_my, Marca, Modello, Software, Firmware, Data, NoteNew, SoftwareVers, FirmwareVers, Visualizza);
// ---------------------------------
if (str_output_my_2 != "")
str_output_my = str_output_my + str_output_my_2;
return str_output_my;
}
}DELETE RECORD
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class learning_extjs_19_1_7_DELETE : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected String Give_me_connection()
{
String str_output_my;
String ID;
int i;
int num_car;
ID = Request.Form["id_delete"];
ID = ID.Trim();
// ----- DELETE of a elemen -----
String ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("../../../../../../mdb-database/mpbluca/database/ONCEM_MARKET_DATI.mdb");
OleDbConnection cn = new OleDbConnection(ConnString);
String sql_str;
try
{
sql_str = "DELETE FROM dbo_Articoli_mia_FirmSoft WHERE ID = " + Int32.Parse(ID);
}
catch (Exception e)
{
return "Error on Delete: " + ID;
}
OleDbCommand comandoSQL = new OleDbCommand(sql_str, cn);
cn.Open();
int records = (int)comandoSQL.ExecuteNonQuery();
cn.Close();
// ----- DELETE BY WEB SERVICE -----
com.uk.######.www.Service ws = new com.uk.######.www.Service();
str_output_my = ws.GiveMe_Delete(ID);
// ---------------------------------
str_output_my = "Deleted : " + str_output_my;
return str_output_my;
}
}
UPDATE RECORD
using System;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
public partial class learning_extjs_19_1_7_UPDATE : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected String Give_me_connection()
{
String str_output_my;
String ID, Marca, Modello, Software, Firmware, Data, NoteNew, SoftwareVers, FirmwareVers, Visualizza;
int i;
int num_car;
ID = Request.Form["id_update"];
ID = ID.Trim();
Marca = Request.Form["Marca_v"];
Marca = Marca.Trim();
Modello = Request.Form["Modello_v"];
Modello = Modello.Trim();
Software = Request.Form["Software_v"];
Software = Software.Trim();
Firmware = Request.Form["Firmware_v"];
Firmware = Firmware.Trim();
Data = Request.Form["Data_v"];
Data = Data.Trim();
NoteNew = Request.Form["NoteNew_v"];
NoteNew = NoteNew.Trim();
SoftwareVers = Request.Form["SoftwareVers_v"];
SoftwareVers = SoftwareVers.Trim();
FirmwareVers = Request.Form["FirmwareVers_v"];
FirmwareVers = FirmwareVers.Trim();
Visualizza = Request.Form["Visualizza_v"];
Visualizza = Visualizza.Trim();
str_output_my = "";
// ----- UPDATE of a new element -----
String ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + HttpContext.Current.Server.MapPath("../../../../../../mdb-database/mpbluca/database/ONCEM_MARKET_DATI.mdb");
OleDbConnection cn = new OleDbConnection(ConnString);
String sql_str;
try
{
sql_str = "UPDATE dbo_Articoli_mia_FirmSoft ";
sql_str = sql_str + "SET Marca = '" + Marca + "', ";
sql_str = sql_str + "Modello = '" + Modello + "', ";
sql_str = sql_str + "Software = '" + Software + "', ";
sql_str = sql_str + "Firmware = '" + Firmware + "', ";
sql_str = sql_str + "Data = '" + Data + "', ";
sql_str = sql_str + "NoteNew = '" + NoteNew + "', ";
sql_str = sql_str + "SoftwareVers = '" + SoftwareVers + "', ";
sql_str = sql_str + "Visualizza = '" + Visualizza + "', ";
sql_str = sql_str + "FirmwareVers = '" + FirmwareVers + "' ";
sql_str = sql_str + "WHERE ID = " + Int32.Parse(ID);
}
catch (Exception e)
{
return "Error on ID CONVERSION: " + ID;
}
OleDbCommand comandoSQL = new OleDbCommand(sql_str, cn);
cn.Open();
try
{
int records = (int)comandoSQL.ExecuteNonQuery();
}
catch (Exception e)
{
return "Error on UPDATE: " + ID;
}
cn.Close();
// ------------- WORK WITH WEB SERVICE ----------------------------------------
com.uk.######.www.Service ws = new com.uk.######.www.Service();
str_output_my = ws.GiveMe_Update(ID, Marca, Modello, Software, Firmware, Data, NoteNew, SoftwareVers, FirmwareVers, Visualizza);
// ------------- END WORK WITH WEB SERVICE ------------------------------------
str_output_my = "Updated IT - " + str_output_my;
return str_output_my;
}
}
tutti e 3 funzionano solo sull'host italiano. Non riescono a comunicare con quello inglese. Che modifiche posso fare per risolvere il problema?
Vuoi che ti posto anche il codice che funziona di crea, delete e update su un'altra tabella del database?
grazie dell'aiuto
