一个asp.net初学者的添加数据的问题~
我是一个刚从PHP转到asp.net的新手
帮我看看我的代码到底有什问题,谢谢~
<%@ Page Language="C#" Debug="true" ContentType="text/html" ResponseEncoding="gb2312" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
void Page_Load()
{
string strConn = "server=(local);database=sricc;trusted_connection=true";
string strSQL = "INSERT INTO 'user' ('nickname','password','name','sex') VALUES ('freewolf','spectre','cheng','m')";
SqlConnection myConn = new SqlConnection(strConn);
myConn.Open();
SqlCommand sqlCmd = new SqlCommand(strSQL,myConn);
sqlCmd.ExecuteNonQuery();
lbStatus.Text = "OK~!";
}
</script>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<form runat="server">
<asp:Label ID="lbStatus" runat="server" />
</form>
</body>
</html>