how to update table to a certain fields

Abdalla Elawad

9y879Visual Basic .NET

Hi Guys

i need to update to specific fields for seprate tow forms in same table

This is Form1 just designed to Insert data only as below :

and this is Form2 Designed just to Update Field in same Tbl as below :

what is a correct way to make this secenario

thanks

3 Replies

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

Karthik Elumalai9y ago
Good, If you got solution for your problem and find my reply as somewhat helpful. kindly accept the answer

Thanks
karthik
Abdalla Elawad9y ago
Thank you My Dear I have one table for both Forms ..First one for insert only ... Second Form Update only .how to update data through second form this question .Fitst Form is good working . Gridview in Sevond Form To Show only . I use asp.net with C# Sql server Use StoredProcedures. I hope Understand me What is Request -How to Update Data in Second Form (Fig-1) to Impact directly Into First Form (Fig-2) both working with Same Tho . Thank you

Karthik Elumalai9y ago

Hi Abdalla Elawad

You can update the row in the second table by using the following code in asp.net C#. If you are using any other language just make few changes.


protected void yourgridviewid_RowUpdating(object sender, GridViewUpdateEventArgs e)  
    {  
        GridViewRow row = (GridViewRow)GridView1.Rows[e.RowIndex];  
          
        TextBox txt1 = (TextBox)row.FindControl("txt1");  
        GridView1.EditIndex = -1;  
        string s="your update query";  
        Sqlcommand cmd=new Sqlcommand(s,connection object);  
 cmd.executenonquery();  
   
BindGridData();  
}

Refer this link for additional info:

http://www.c-sharpcorner.com/UploadFile/1e050f/edit-and-update-record-in-gridview-in-Asp-Net/

Hope it will help to solve your problem, kindly let me know your thoughts or feedbacks

thanks

karthik