当前位置:编程学习 > C#/ASP.NET >>

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 问题 添加数据

CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,