请问,ASP.NET(C#)里怎么样用代码实现对sqlserver调用select存储过程??
下面是我的代码private void get_guest()
{
string con=ConfigurationSettings.AppSettings["dsn"];
SqlConnection conn = new SqlConnection(con);//连接字符串
conn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter(); //创建SqlDataAdapter 类
myCommand.SelectCommand=new SqlCommand("guest_select",conn);
myCommand.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet ds=new DataSet(); //建立并填充数据集
myCommand.Fill(ds,"Article");
DataGrid1.DataSource=ds; //绑定
DataGrid1.DataBind();
}myCommand.SelectCommand.CommandType=CommandType.StoredProcedure ;这句话在用时有错误!
不知道怎么回事!
下面是我的代码private void get_guest()
{
string con=ConfigurationSettings.AppSettings["dsn"];
SqlConnection conn = new SqlConnection(con);//连接字符串
conn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter(); //创建SqlDataAdapter 类
myCommand.SelectCommand=new SqlCommand("guest_select",conn);
myCommand.SelectCommand.CommandType=CommandType.StoredProcedure ;
DataSet ds=new DataSet(); //建立并填充数据集
myCommand.Fill(ds,"Article");
DataGrid1.DataSource=ds; //绑定
DataGrid1.DataBind();
}myCommand.SelectCommand.CommandType=CommandType.StoredProcedure ;这句话在用时有错误!
不知道怎么回事!
解决方案 »
- C# 调用.bat批处理文件
- 急急急.fpSpread如何选中多个单元格后计算出所有单元格中数字之和
- 用moden如何获取来电号码
- 思归,能进来一下吗,我这问题挺长时间没解决了。。
- 如何实现DataGridViewr双标题头(vs2005 winform)
- 求根据输入汉语得到拼音码的C#程序(不要带数据库的)
- C#.NET有"另存为"这样的函数吗?
- DataView 中 RowFilter 属性聚合类型怎么用啊??像Sum(求和) Max(最大值)等
- 关于dll 版本的问题。
- 在C#中怎么做一个证书?
- 急!急!急! 各位大侠,我想查找表中TimeBeign和TimeEnd之外的值并插入到另外一张表中,怎么办啊?
- c#在应用程序中的2个小问题,包你会!
你可以参考一下这个:http://blog.csdn.net/berlin8600/archive/2005/03/24/329341.aspx
string connectionString = "server=\'db01\'; user id=\'sa\'; password=\'\'; database=\'MIS\'";
System.Data.IDbConnection dbConnection = new System.Data.SqlClient.SqlConnection(connectionString);
string queryString = "addrequest '" +
DropDownList1.SelectedValue + "','"
+ TextBox2.Text + "','"
+ TextBox3.Text + "','"
+ TextBox4.Text + "','"
+ TextBox5.Text + "','"
+ TextBox6.Text + "','"
+ DropDownList7.SelectedValue + "','"
+ TextBox8.Text + "'";
System.Data.IDbCommand dbCommand = new System.Data.SqlClient.SqlCommand();
dbCommand.CommandText = queryString;
dbCommand.Connection = dbConnection;
dbConnection.Open();
int result = dbCommand.ExecuteNonQuery();
if ( result == 1)
{
Response.Redirect("default.aspx");
}
else
{
Msg.Text = "添加记录失败";
}
}
CREATE PROCEDURE AddRequest
@Department varchar(255),
@UserName varchar(255),
@Category varchar(255),
@ProblemDescription varchar(255),
@SolutionWorkaround varchar(255),
@Phone varchar(255),
@CompletedBy varchar(255),
@Re varchar(255)
AS
INSERT INTO ServiceRequest (Department,UserName,Category,ProblemDescription,SolutionWorkaround,Phone,CompletedBy,Re)
VALUES (@Department,@UserName,@Category,@ProblemDescription,@SolutionWorkaround,@Phone, @CompletedBy,@Re)
GOCREATE TABLE [dbo].[ServiceRequest] (
[SN] uniqueidentifier ROWGUIDCOL NOT NULL ,
[DateofRequest] [datetime] NOT NULL ,
[Department] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[UserName] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Category] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ProblemDescription] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SolutionWorkaround] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Phone] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Completed] [bit] NOT NULL ,
[CompletedBy] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DateOfCompleted] [datetime] NULL ,
[Re] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO