Can we update multiple table in one single update statement

See more:

C#

ASP.NET

database

, +

I have three tables......

1.Categorycrt

productid(primary key)
  productcategory
  Girthfrom
  GirthTo

2.Itemcre

Itemid(primary key)
Itemname
  </pre lang="text">
3.Pricefix
<pre lang="vb">PriceId(primarykey)
Itemid(foreign key of Itemcre)
Productid(foreign Key of Categorycrt)
Rate</pre lang="text">


I need to update the Pricefix table...please help me with the query for updating the pricefix tabletable.....


I have a gridview for pricefix table

My aspx page
<pre lang="html"> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
	            onrowcancelingedit="GridView1_RowCancelingEdit"
	            onrowdeleting="GridView1_RowDeleting" 
        onrowediting="GridView1_RowEditing" onrowupdating="GridView1_RowUpdating"
	            >
	        <columns>
	        <asp:TemplateField HeaderText="PriceId">
	        <itemtemplate>
	        <asp:Label ID="lblPriceId" runat="server" Text='<%#Eval("PriceId") %>'>'> 
	        </itemtemplate>
	        
	         <asp:TemplateField HeaderText="ItemName">
	        <itemtemplate>
	        <asp:Label ID="lblItemId" runat="server" Text='<%#Eval("Itemname") %>'>'> 
	        </itemtemplate>
	        <edititemtemplate>
	        <asp:TextBox ID="txtItemId" runat="server" Text='<%#Eval("Itemname") %>'>' >
	        </edititemtemplate>
            
	         <asp:TemplateField HeaderText="ProductCategory">
	        <itemtemplate>
	        <asp:Label ID="lblPdtId" runat="server" Text='<%#Eval("ProductCategory") %>'>'> 
	        </itemtemplate>
	        <edititemtemplate>
	        <asp:TextBox ID="txtPdtId" runat="server" Text='<%#Eval("ProductCategory") %>'>' >
	        </edititemtemplate>
	        
             <asp:TemplateField HeaderText="Rate">
	        <itemtemplate>
	        <asp:Label ID="lblRate" runat="server" Text='<%#Eval("Rate") %>'>'> 
	        </itemtemplate>
	        <edititemtemplate>
	        <asp:TextBox ID="txtRate" runat="server" Text='<%#Eval("Rate") %>'>' >
	        </edititemtemplate>
	        
	            <asp:TemplateField HeaderText="Action">
                    <itemtemplate>
                        <asp:LinkButton ID="edit" runat="server" CommandName="Edit" Text="Edit">
                        <asp:LinkButton ID="Delete" runat="server" CommandName="Delete" Text="Delete">
                    </itemtemplate>
                    <edititemtemplate>
                        <asp:LinkButton ID="Update" runat="server" CommandName="Update" Text="Update">
                        <asp:LinkButton ID="Cancel" runat="server" CommandName="Cancel" Text="cancel">
                    </edititemtemplate>
                
	        </columns>

while clicking on the edit button of the grid update and cancel link button appears for the selected row .i need to update the productcategory,itemname and rate of the pricefix table.actually in pricefix table the value stored as foreignkey value of productcategory and, itemname....actually while updating the gridview of pricefix the updated productcategory and itemname should be changed in their parent table i.e, Itemcre and Categorycrt and rate inPricefix table itself...