基于asp.net开发的,数据库是sql server2005.无法将信息添加到数据库中。
添加按钮click事件代码如下:
protected void Button1_Click(object sender, EventArgs e)
{
string sql;
sql = "insert into shipinxinxi(mingcheng,leibie,danjia) values('"+mingcheng.Text.ToString().Trim() + "','"+leibie.Text.ToString().Trim() + "','"+danjia.Text.ToString().Trim() + "') ";
int result;
result = new Class1().hsgexucute(sql);
if (result == 1)
{
Response.Write("javascript:alert('添加成功');");
}
else
{
Response.Write("javascript:alert('系统错误,请检查数据库设置问题');");
}
}
Class1.cs中代码如下:
using System;
using System.Data;
//using System.Data.OleDb;
using System.Data.SqlClient;
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;
///
/// Class1 的摘要说明
///
public class Class1
{
//SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["testConnectionString"]);
public Class1()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
// public static string connstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Web.HttpContext.Current.Server.MapPath("~/App_Data/web.mdb");
public static string connstring = ConfigurationManager.AppSettings["cn"]; //设置连接数据库的代码是webconfig里面的cn那句,即:server=.;database=net05qingongzhuxue;uid=sa;pwd=;
public static DataSet GDS(string sql)
{
//OleDbDataAdapter dap = new OleDbDataAdapter(sql, connstring);
SqlDataAdapter dap = new SqlDataAdapter(sql, connstring);
DataSet ds = new DataSet();
dap.Fill(ds);
return ds;
}
public static void Dsql(string sql)
{
// OleDbConnection conn = new OleDbConnection();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connstring;
conn.Open();
// OleDbCommand cmd = new OleDbCommand(sql, conn);
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
public int hsgexucute(string sql) //自定义函数:执行sql语句,如果执行成功,返回值1,否则0
{
//myConnection.Open();
SqlConnection conn = new SqlConnection(); //定义新数据库连接
conn.ConnectionString = connstring; //设置该新连接字符串是connstr,即上面的webconfig里的cn值
SqlCommand myCommand = new SqlCommand(sql, conn); //设置新执行命令
// SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open(); //打开数据库连接
myCommand.ExecuteNonQuery(); //执行sql语句
return 1; //执行成功,返回1
}
catch
{
//Console.WriteLine("SqlException:{0}",SQLexc);
return 0; //执行失败,返回0
}
finally
{
conn.Close(); //关闭数据库连接
}
}
每次点击添加按钮,就会弹出提示框显示'系统错误,请检查数据库设置问题',这是怎么回事呢?