Loading

In this it throw error as invalid object sudha

selvi subramanian

14y2.8k.NET

create procedure insert_selvi

@name varchar(20),@gender varchar(30),@education varchar(30)

as

begin

insert into sudha(name,gender,education)

select @name,@gender,,@education

end

==================================================

string qry="exec insert_selvi ' "+ TextBox1.Text;

qry+=" ' ' " + TextBox2.Text;

qry+=" ' ' " + TextBox3.Text;

qry+=" ' ";

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ish Bandhu14y ago
create table sudha, after that run this procedure.
Atul Kumar14y ago
select @name,@gender,,@education is wrong.
It should be (select name,gender,education from table)