ASP.NET和SQL数据库连接的问题···
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 fuliguanli_add : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
// xingbie.Items.Add("male");
// xingbie.Items.Add("female");
// addxiala("kehuxinxi","bianhao","kehubianhao");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
string sql;
sql="insert into fuliguanli(fulibianhao,fulimingcheng,fuliedu,fulineirong) values('"+fulibianhao.Text.ToString().Trim()+"','"+fulimingcheng.Text.ToString().Trim()+"','"+fuliedu.Text.ToString().Trim()+"','"+fulineirong.Text.ToString().Trim()+"') ";
int result;
result = new Class1().hsgexucute(sql);
if (result == 1)
{
Response.Write("<script>javascript:alert('添加成功');</script>");
}
else
{
Response.Write("<script>javascript:alert('系统错误,请检查数据库的连!');</script>");
}
}
}
总是显示系统错误,请检查数据库的连!
补充:public int hsgexucute(string sql)
{
//myConnection.Open();
SqlConnection conn = new SqlConnection();
conn.ConnectionString = connstring;
SqlCommand myCommand = new SqlCommand(sql, conn);
// SqlCommand cmd = new SqlCommand(sql, conn);
try
{
conn.Open();
myCommand.ExecuteNonQuery();
return 1;
}
catch
{
//Console.WriteLine("SqlException:{0}",SQLexc);
return 0;
}
finally
{
conn.Close();
}
}
追问:CLASS1比较大 能不能加好友帮个忙 谢谢 我传给你 QQ28281919
答案:Class1呢
其他:检查一下你的Class1()类,构造有没有问题;
其次是,考虑一下在当前代码中,你的引用,加个
using System.Data.SqlClient;
试试 为什么不看看他到底报啥错
上一个:asp.net mvc框架中 怎样在一个 View 内传递多个 Model,最好有代码,谢谢
下一个:asp 问题 添加数据