direct retrieve data from database in form field

jigar patel

hello ,
i new here.
i create c# windows application, i use stored procedure for insert,delete,update operation any validation i want to see in database. now i am not use datagrid or anything .
Now the question is How can i retrieve save data in windows form using stored procedure?

i create simple Item Master page , only need to retrive last saved data on page load in fields.

i create stored procedure of item master.
i create insert stored procedure.

now when i insert record and click on save button it save record in database. i no need datagrid to see record of database.

how can i load last inserted record from database using stored procedure?

pls help me.

2 Replies

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

Bikesh Srivastava10y ago
you need to create a new procedure and write select query.
after that use in c# code.
0

Milan Prajapati10y ago

You need to use SET statement. For example :

CREATE TABLE table1(   
  id INT(11) PRIMARY KEY AUTO_INCREMENT, 
  column1 VARCHAR(10), 
  column2 VARCHAR(10) 
);

Procedure's body:

BEGIN 
INSERT INTO table1(column1, column2) VALUES ('value1', 'value2');
SET out_param = LAST_INSERT_ID();
END

Note, that ID field is not specified in INSERT statement. This value  will be inserted automatically; and of course, this ID field must have  AUTO_INCREMENT option.