这个不难 输入产品代号 带出产品名称 ¦代理价 ¦积分 ¦返款 和计算 总贷款用ajax做,参考下面代码:用的是ajax.dll
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm8.aspx.cs" Inherits="GridviewGenColum.WebForm8" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<input id="proNo" type="text" onblur="getDate(this)" />
<input id="proName" type="text" />
<input id="price" type="text" />
<input id="jifen" type="text" />
<input id="huankuan" type="text" /></div>
</form>
<script type="text/javascript" >
function getDate(obj)
{
var info=WebForm8.GetData(obj.value).value;
if(info!=null )
{
document.getElementById("proName").value=info[0];
document.getElementById("price").value=info[1];
document.getElementById("jifen").value=info[2];
document.getElementById("huankuan").value=info[3];
}
}
</script>
</body>
</html>
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;namespace GridviewGenColum
{
public partial class WebForm8 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(WebForm8));
}
[Ajax.AjaxMethod()]
public string[] GetData(string proNo)
{ DataSet ds = GetData(proNo); //根据产品编号取数据的方法返回dataset
if (ds.Tables[0].Rows.Count != 0)
{
string[] info = new string[4];
info[0] = ds.Tables[0].Rows[0]["产品名称"].ToString(); info[1] = ds.Tables[0].Rows[0]["代理价"].ToString();
info[2] = ds.Tables[0].Rows[0]["积分"].ToString();
info[3] = ds.Tables[0].Rows[0]["返款"].ToString();
}
}
}
}
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm8.aspx.cs" Inherits="GridviewGenColum.WebForm8" %><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<input id="proNo" type="text" onblur="getDate(this)" />
<input id="proName" type="text" />
<input id="price" type="text" />
<input id="jifen" type="text" />
<input id="huankuan" type="text" /></div>
</form>
<script type="text/javascript" >
function getDate(obj)
{
var info=WebForm8.GetData(obj.value).value;
if(info!=null )
{
document.getElementById("proName").value=info[0];
document.getElementById("price").value=info[1];
document.getElementById("jifen").value=info[2];
document.getElementById("huankuan").value=info[3];
}
}
</script>
</body>
</html>
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;namespace GridviewGenColum
{
public partial class WebForm8 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Ajax.Utility.RegisterTypeForAjax(typeof(WebForm8));
}
[Ajax.AjaxMethod()]
public string[] GetData(string proNo)
{ DataSet ds = GetData(proNo); //根据产品编号取数据的方法返回dataset
if (ds.Tables[0].Rows.Count != 0)
{
string[] info = new string[4];
info[0] = ds.Tables[0].Rows[0]["产品名称"].ToString(); info[1] = ds.Tables[0].Rows[0]["代理价"].ToString();
info[2] = ds.Tables[0].Rows[0]["积分"].ToString();
info[3] = ds.Tables[0].Rows[0]["返款"].ToString();
}
}
}
}
文本框中
点击提交存储应该就比较简单了,直接捞数据 调用存储过程就可以了