Asp.net VB保存数据问题,无法保存到数据库

来源:百度知道 编辑:UC知道 时间:2024/06/30 06:18:54
<body>
<form id="login" name="login" method="post" action="" runat="server">
<table width="100%" border="0" cellspacing="0">
<tr>
<td colspan="2" align="center" valign="bottom"><span class="STYLE1">用户注册信息</span></td>
</tr>
<tr>
<td colspan="2" bgcolor="#99CCFF"><span class="STYLE4">带*项目为必填项目</span></td>
</tr>
<tr>
<td colspan="2" bgcolor="#CCCCCC"> </td>
</tr>
<tr>
<td width="8%" align="left">用户姓名:</td>
<td width="92%" height="30"><asp:TextBox ID="name" runat="server" />
*&

database

using System;
using System.Data;
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;
using System.Data.SqlClient;

/// <summary>
/// database 的摘要说明
/// </summary>
public class database
{
private SqlConnection conn;
public database()
{
//
// TODO: 在此处添加构造函数逻辑
//
string sqlcon = "Server=localhost;Initial catalog=mydb;user=sa;password=123456";
conn = new SqlConnection(sqlcon);
}
public int executenon(string sqlstr)
{

conn.Open();
SqlCommand cmd = new SqlCommand(sqlstr, conn);
int num = cmd.ExecuteNonQuery();
return num;
conn.Close();
}
public int executesal(string sqlstr)
{
conn.Open(