Inserire dei record
<%@ Page language="c#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SQLClient" %>
<script language="c#" runat="server">
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection cnn = new SqlConnection("server=DBSERVER;User id=USER;password=PASSWORD;database=DB");
SqlCommand InsertCommand = new SqlCommand();
InsertCommand.Connection = cnn;
string sql;
sql = "INSERT INTO TABELLA (campo) VALUES ('valore')";
InsertCommand.CommandText = sql;
try
{
cnn.Open();
InsertCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.ToString());
}
finally
{
cnn.Close();
}
}
</script>
Scarica il Codice...
Stampa la pagina