how to bind data in asp.net using 3tier

selvi subramanian

i need to use 3tier in asp.net

design

Welcome

CANCEL PRODUCTS

	onselectedindexchanged="ddcan_SelectedIndexChanged"> Select
onselectedindexchanged="GridView1_SelectedIndexChanged" Width="427px">

in DropDownList i have 3 list namely 1.Vegetables 2. Grocery 3.Pharmacy ,if i choose Vegetables a list will shown in gridview in that i have to edit and cancel .(using link button)

i have to edit and cancel the item if i choose Vegetables in dropdownlist. i never use storeprocedure

8 Replies

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

Dorababu Meka14y ago
Final code with update if you have any issue let me know. Check my attachment.. Page name is

LIST.ASPX
Dorababu Meka14y ago
Have you tested my code
selvi subramanian14y ago
Dropdown is in outside in dropdown there are three data 1.Vegetables 2. Grocery 3.Pharmacy .
if i chose vegetables and the details in vegetables in table shown in gridview in grid view i have to edit and update the details
Dorababu Meka14y ago
Check this example run list.aspx you can also find the database in APP_DATA folder. If you have anu questions let me know.

This is what I done binding dropdown and gridview with stroredprocedure and 3 tier architecture
Dorababu Meka14y ago
Hi can you tell me one thing does dropdown will exist in gridview too or only outside gridview
Dorababu Meka14y ago
Stroedprocedure is similar to a function where you write all your necessary queries in that and use it for example

Create Procedure updateTable// give a name here
(
@yourvariable Varchar(200),
@ yourvariable Varchar(200),
@ yourvariable Varchar(50)
)
As
Begin
UPDATE tblname SET
your necessary query to update
End

When coming to code

m_oCmd = new MySqlCommand("your storedprocname", m_oConn);
m_oCmd.CommandType = CommandType.StoredProcedure;
m_oCmd.Parameters.AddWithValue("_EmpID", EmpID); //Here your field that you have defined in stored procedure

// Add necessarry and required as per you need

m_oCmd.ExecuteNonQuery();
selvi subramanian14y ago
i never use store procedure ... and have to edit and update in gridview
Dorababu Meka14y ago
If I am not wrong you would like to bind gridview based on the selection of dropdownlist using 3 tier architecture and storedprocedure right.

inside gridview you will have a dropdown with the same category on edit and update if user change and update you have to update back to the DB using the same architecture .

Is it Right