我写了个储存过程:CREATE PROCEDURE [dbo].[TT_test]
@name nvarchar(50),
@sex nvarchar(50)
AS
begin declare @sql nvarchar(1000) set @sql= 'insert into test(name,sex)values(@name,@sex)'
--select @sql
exec(@sql)
end
GO
使用SqlDataSource控件插入数据,如何在后台写?
@name nvarchar(50),
@sex nvarchar(50)
AS
begin declare @sql nvarchar(1000) set @sql= 'insert into test(name,sex)values(@name,@sex)'
--select @sql
exec(@sql)
end
GO
使用SqlDataSource控件插入数据,如何在后台写?
@sex nvarchar(2)
declare @sql nvarchar(1000)
insert into test(name,sex)values(@name,@sex)
你完全可以这样:
int query = SqlCommand.ExecuteNonQuery();
query 就是你要的影响行数了
SqlCommand comd = new SqlCommand(cmd, connection);
int a = comd.ExecuteNonQuery();
@name nvarchar(50),
@sex nvarchar(50)
AS
begin declare @sql nvarchar(1000)
set @sql= 'insert into test(name,sex)values(@name,@sex)'
--select @sql
exec(@sql)
end
GO
.CS中这样写的:
SqlDataSource1.InsertCommand = "TT_test";
SqlDataSource1.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
SqlDataSource1.InsertParameters.Add("@name", TypeCode.String, TextBox1.Text);
SqlDataSource1.InsertParameters.Add("@sex", TypeCode.String, TextBox2.Text);
SqlDataSource1.Insert();
报错:@@name 不是过程 TT_test 的参数。 ,应该怎么写?
@name nvarchar(50),
@sex nvarchar(50)
AS
begin
declare @sql nvarchar(1000)
set @sql= 'insert into test(name,sex)values(@name,@sex)'--select @sql
exec(@sql)
endSqlDataSource1.InsertCommand = "AddTT_test";
SqlDataSource1.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;
SqlDataSource1.InsertParameters.Add("@name", TypeCode.String, TextBox1.Text);
SqlDataSource1.InsertParameters.Add("@sex", TypeCode.String, TextBox2.Text);
SqlDataSource1.Insert();
这样试试!