http://chs.gotdotnet.com/quickstart/aspplus/doc/webdataaccess.aspx#storedprocs
解决方案 »
- aspnet后台循环生成xml节点对象
- 在使用updatepanel的时候,如何在执行某个按钮操作后,给变量赋值,并传值到前台的js脚本中呢?
- 关闭IE时清空COOKIES值
- 自定义分页问题
- 如何让datagrid 在编辑状态下不变形呢
- Visual Studio 2005 Beta2中站点如何设置端口号?
- 父窗口在一个IFrame中,showModalDialog后的子窗口一关闭,整个iframe都没了?
- 按钮失灵了asp.net的问题多多
- RadioButtonList 按钮,js如何实现取值。
- 关于web默认键的问题,不好解决,请高手帮忙。
- 莫名其妙的插入错误!真是晕了!
- 按钮的焦点问题;
--判断此存储过程名是否已经存在
if exists (select name from sysobjects where name = 'add'and type = 'p')
drop procedure add
gouse example
gocreate procedure add
@Username,char 20,
@Password char 20
as
insert into UserLogin(Username,Password) values (@Username,@Password )
go
--执行存储过程
exec add '帅哥','是我'存储过程就是数据库对象
<%@ Import Namespace="System.Data.SqlClient" %><html>
<script language="C#" runat="server"> protected void Page_Load(Object Src, EventArgs E)
{
SqlConnection myConnection = new SqlConnection("server=(local)\\NetSDK;database=northwind;Integrated Security=SSPI");
SqlDataAdapter myCommand = new SqlDataAdapter("Ten Most Expensive Products", myConnection); myCommand.SelectCommand.CommandType = CommandType.StoredProcedure; DataSet ds = new DataSet();
myCommand.Fill(ds, "Products"); MyDataGrid.DataSource=ds.Tables["Products"].DefaultView;
MyDataGrid.DataBind();
}</script><body> <h3><font face="Verdana">Simple Stored Proc Select to a DataGrid Control</font></h3> <ASP:DataGrid id="MyDataGrid" runat="server"
Width="360"
BackColor="#ccccff"
BorderColor="black"
ShowFooter="false"
CellPadding=3
CellSpacing="0"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
EnableViewState="false"
/></body>
</html>
(
@ProductName NVarchar(80),
@UnitPrice Money
)as insert products(ProductName,UnitPrice)
values (@productname,@unitprice)
__________________________________________
dim conn as new sqlconnection("Server=localhost;user id=sa;password=xxx;database=Northwind;")
dim cmd as new sqlcommand("insertData",conn)
cmd.commandtype=commandtype.storedprocedure
cmd.parameters.add("@productname","abc")
cmd.parameters.add("@unitprice",12.5)
conn.open
cmd.Executenonquery()
conn.close
——————————————————————————————————————
以上程序使用的是Northwind数据库
{
if(flag==true)
{
string MyConnectionString=ConfigurationSettings.AppSettings["ConnectionString"];
SqlConnection MyConn=new SqlConnection(MyConnectionString);
SqlDataAdapter MyDataAdapter=new SqlDataAdapter();
DataSet MyDataSet=new DataSet();
SqlCommand MySelectCommand=new SqlCommand();
MySelectCommand.Connection=MyConn;
MyDataAdapter.SelectCommand=MySelectCommand;
MySelectCommand.CommandType=CommandType.StoredProcedure;
MySelectCommand.CommandText="[M_SelectAllPicture]";
MyDataAdapter.Fill(MyDataSet,"Picture");
Cache["AllPicture"]=MyDataSet;
DataGridAllPic.DataSource=MyDataSet.Tables["Picture"].DefaultView;
DataGridAllPic.DataBind();
}
else
{
DataSet ds=new DataSet();
ds=(DataSet)Cache["AllPicture"];
if(ds==null)
{
DataBindAllPic(true); }
else
{ DataGridAllPic.DataSource=ds.Tables["Picture"].DefaultView;
DataGridAllPic.DataBind();
}
}
}