在网页中最主要的应用还是和数据库相关的。
我在在学这个的时候花了很多时间，看网上的实例是很简单，但是用起来老是不行。
后来我换access数据库sqlserver后一切都ok了。郁闷！！
废话不说看代码吧。
insertintdatabase.aspx.cs
程序代码
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
AjaxPro.Utility.RegisterTypeForAjax(typeof(ajaxstu.insertintdatabase));
}
[AjaxPro.AjaxMethod]
public string ServerSideAdd( string mytime)
{
try
{
// myconnection.Open();
string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection Con = new SqlConnection(ConnectionString);
Con.Open();
//SqlCommand cd=new SqlCommand("insert into Users (PWD) values('fsadf')",Con);
SqlCommand cd=new SqlCommand("insert into Users (PWD) values(@pwd)",Con);
cd.Parameters.Add("@pwd",SqlDbType.VarChar,256);
cd.Parameters["@PWD"].Value=mytime;
cd.ExecuteNonQuery();
return "OK";
}
catch
{
return "BAD";
}
finally
{
// myconnection.Close();
}
//return "OK";
}
insertintdatabase.aspx
程序代码
<%@ Page language="c#" Codebehind="insertintdatabase.aspx.cs" AutoEventWireup="false" Inherits="ajaxstu.insertintdatabase" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>insertintdatabase</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<script language="javascript">
function StringAdd(){
var username=document.getElementById("username").value;
var ret=ajaxstu.insertintdatabase.ServerSideAdd(username);
//window.alert(username);
alert(ret.value);
if(ret.value=="OK")
{
alert("保存成功!");
}
else
{
alert("失败!");
}
}
</script>
<FONT face="宋体"><INPUT style="Z-INDEX: 101; LEFT: 472px; POSITION: absolute; TOP: 72px" onclick="javascript:StringAdd()"
type="button" value="Button"></FONT><INPUT id="username" style="Z-INDEX: 102; LEFT: 216px; POSITION: absolute; TOP: 56px" type="text"
value="admin" name="username">
</form>
</body>
</HTML>
我在在学这个的时候花了很多时间，看网上的实例是很简单，但是用起来老是不行。
后来我换access数据库sqlserver后一切都ok了。郁闷！！
废话不说看代码吧。
insertintdatabase.aspx.cs
程序代码private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
AjaxPro.Utility.RegisterTypeForAjax(typeof(ajaxstu.insertintdatabase));
}
[AjaxPro.AjaxMethod]
public string ServerSideAdd( string mytime)
{
try
{
// myconnection.Open();
string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection Con = new SqlConnection(ConnectionString);
Con.Open();
//SqlCommand cd=new SqlCommand("insert into Users (PWD) values('fsadf')",Con);
SqlCommand cd=new SqlCommand("insert into Users (PWD) values(@pwd)",Con);
cd.Parameters.Add("@pwd",SqlDbType.VarChar,256);
cd.Parameters["@PWD"].Value=mytime;
cd.ExecuteNonQuery();
return "OK";
}
catch
{
return "BAD";
}
finally
{
// myconnection.Close();
}
//return "OK";
}
insertintdatabase.aspx
程序代码<%@ Page language="c#" Codebehind="insertintdatabase.aspx.cs" AutoEventWireup="false" Inherits="ajaxstu.insertintdatabase" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>insertintdatabase</title>
<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
<meta content="C#" name="CODE_LANGUAGE">
<meta content="JavaScript" name="vs_defaultClientScript">
<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
</HEAD>
<body MS_POSITIONING="GridLayout">
<form id="Form1" method="post" runat="server">
<script language="javascript">
function StringAdd(){
var username=document.getElementById("username").value;
var ret=ajaxstu.insertintdatabase.ServerSideAdd(username);
//window.alert(username);
alert(ret.value);
if(ret.value=="OK")
{
alert("保存成功!");
}
else
{
alert("失败!");
}
}
</script>
<FONT face="宋体"><INPUT style="Z-INDEX: 101; LEFT: 472px; POSITION: absolute; TOP: 72px" onclick="javascript:StringAdd()"
type="button" value="Button"></FONT><INPUT id="username" style="Z-INDEX: 102; LEFT: 216px; POSITION: absolute; TOP: 56px" type="text"
value="admin" name="username">
</form>
</body>
</HTML>
浙公网安备 33010602011771号