Private Sub btnOK_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click
If Not IsValid Then
Exit Sub
End If
Dim cnn As New SqlConnection(ConfigurationSettings.AppSettings("strConnection"))
Dim cmd As New SqlCommand("insert into leaveword(schoolid,author,title,content)values(@schoolid,@author,@title,@content)", cnn)
Dim name As String
name = HttpContext.Current.User.Identity.Name
cmd.Parameters.Add("@schoolid", Session("schoolid"))
cmd.Parameters.Add("@author", name)
cmd.Parameters.Add("@title", txtTitle.Text)
cmd.Parameters.Add("@content", txtContent.Text)
Try
cnn.Open()
cmd.ExecuteNonQuery()
cnn.Close()
Response.Write("<script>alert('添加成功,谢谢合作!')</script>")
Response.Redirect("News.aspx")
Catch ex As Exception
Response.Write(ex.Message)
Finally
cnn.Close()
End Try
End Sub
If Not IsValid Then
Exit Sub
End If
Dim cnn As New SqlConnection(ConfigurationSettings.AppSettings("strConnection"))
Dim cmd As New SqlCommand("insert into leaveword(schoolid,author,title,content)values(@schoolid,@author,@title,@content)", cnn)
Dim name As String
name = HttpContext.Current.User.Identity.Name
cmd.Parameters.Add("@schoolid", Session("schoolid"))
cmd.Parameters.Add("@author", name)
cmd.Parameters.Add("@title", txtTitle.Text)
cmd.Parameters.Add("@content", txtContent.Text)
Try
cnn.Open()
cmd.ExecuteNonQuery()
cnn.Close()
Response.Write("<script>alert('添加成功,谢谢合作!')</script>")
Response.Redirect("News.aspx")
Catch ex As Exception
Response.Write(ex.Message)
Finally
cnn.Close()
End Try
End Sub
using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
namespace luntan
{
/// <summary>
/// SqlClass1 的摘要说明。
/// </summary> public class SqlClass1: System.Web.UI.Page
{
protected static string strconn= ConfigurationSettings.AppSettings["strcon"];
public System.Data.SqlClient.SqlConnection conn;
public System.Data.SqlClient.SqlDataAdapter da;
public System.Data.SqlClient.SqlCommand cmd;
public System.Data.SqlClient.SqlDataReader dr;
public System.Data.DataSet ds;
public SqlClass1()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public SqlConnection connect(string strser,string strdata)
{
SqlConnection conn=new SqlConnection(strconn);
return conn;
}
public DataSet Binding(string strsql)//返回数据集
{
conn=new SqlConnection(strconn);
da=new SqlDataAdapter(strsql,conn);
ds=new DataSet();
da.Fill(ds);
return ds;
} public SqlDataReader ReaderSql(string strsql)
{
conn=new SqlConnection(strconn);
cmd=new SqlCommand(strsql,conn);
try
{
conn.Open();
dr=cmd.ExecuteReader();
return dr;
}
catch(System.Data.SqlClient.SqlException E)
{
throw new Exception(E.Message);
}
} public int ExecuteSql(string strsql)
{
conn=new SqlConnection(strconn);
cmd=new SqlCommand(strsql,conn);
try
{
conn.Open();
cmd.ExecuteNonQuery();
return 0;
}
catch(System.Data.SqlClient.SqlException E )
{
throw new Exception(E.Message);
}
finally
{
cmd.Dispose();
conn.Close();
}
}
}
}
{
if(TextBox2.Text=="")
{
Response.Write("<script>alert('请填写车牌号!');</script>");
return;
}
string strinsert="insert into cardj(car_chepai,car_siji,car_changpaixh,car_zaizhong,car_danwei)values('"+TextBox2.Text.Trim()+"','"+TextBox3.Text.Trim()+"','"+TextBox4.Text.Trim()+"','"+TextBox5.Text.Trim()+"','"+TextBox6.Text.Trim()+"')";
SqlClass1 sqlc=new SqlClass1();
int a=sqlc.ExecuteSql(strinsert);
if(a==0)
{
Response.Redirect("WebForm1.aspx");
}
}