有没有办法只使用代码文件从aspx页面（设计）更新数据库。 [英] Is there any way to update database only from aspx page(design) with out using code file.
本文介绍了有没有办法只使用代码文件从aspx页面（设计）更新数据库。的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我的一个客户需要更新他们的网站上的sourse代码不可用。有没有办法只使用aspx文件更新数据库。请帮助
解决方案
你可以使用jQuery来保存数据。
创建一个web服务来保存数据，然后在那个aspx文件上从jquery调用webservice。
是的，你能够。尝试使用 SqlDataSource [ ^ ]
示例代码：
< ％@ Page < span class =code-attribute>语言 = C＃ ％>
< ！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 > ; ASP.NET示例< / title >
< / head >
< body >
< 表格 id = form1 runat = server >
< asp：SqlDataSource
< span class =code-attribute> id = SqlDataSource1
runat = server < span class =code-attribute>
< span class =code-attribute> DataSourceMode = DataSet
ConnectionString = <％
ConnectionStrings：MyNorthwind ％>
SelectCommand = SELECT EmployeeID，FirstName ，LastName，Title FROM Employees
UpdateCommand = 更新员工SET FirstName = @ FirstName，LastName = @ LastName，Title = @ Title WHERE EmployeeID = @ EmployeeID < span class =code-keyword>>
< / asp：SqlDataSource >
< asp：GridView
id = GridView1
runat = server
AutoGenerateColumns = False
DataKeyNames = EmployeeID
AutoGenerateEditButton = True
DataSourceID = SqlDataSource1 >
< 列 >
< asp：BoundField HeaderText = 名字 DataField = FirstName / >
< asp：BoundField HeaderText = 姓氏 DataField = LastName / >
< asp：BoundField HeaderText = 标题 DataField = 标题 / >
< / columns >
< / asp：GridView >
< / form >
< / body >
< / html >
One of my client needs updation on their site whose sourse code is not available.So is there any way to update database using only aspx file.Please Help
解决方案
You can use jQuery to save data.
Make a webservice to save the data and then call the webservice from jquery on that aspx file.
Yes, you can. try with SqlDataSource [^]
sample code:
<%@ Page Language="C#" %> <!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>ASP.NET Example</title> </head> <body> <form id="form1" runat="server"> <asp:SqlDataSource id="SqlDataSource1" runat="server" DataSourceMode="DataSet" ConnectionString="<%
ConnectionStrings:MyNorthwind%>" SelectCommand="SELECT EmployeeID,FirstName,LastName,Title FROM Employees" UpdateCommand="Update Employees SET FirstName=@FirstName,LastName=@LastName,Title=@Title WHERE EmployeeID=@EmployeeID"> </asp:SqlDataSource> <asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="EmployeeID" AutoGenerateEditButton="True" DataSourceID="SqlDataSource1"> <columns> <asp:BoundField HeaderText="First Name" DataField="FirstName" /> <asp:BoundField HeaderText="Last Name" DataField="LastName" /> <asp:BoundField HeaderText="Title" DataField="Title" /> </columns> </asp:GridView> </form> </body> </html>
这篇关于有没有办法只使用代码文件从aspx页面（设计）更新数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
