Saving Dataset Back to Database

[Madz]

I am having a problem
I have a connections which i accessing data from a database. after connecting a database i am filling a dataset with a table and showing results in a Grid. i grid i change many values
but these values are not commited to database

is there any way so i could be able to commit that dataset back to there from where it was originated

 

[quwiltw]

Are you using the Update method on the dataadapter?

 

[a_jam_sandwich]

Whats your code

Look at the Update method with the CommandBuilder using the dataadapter this will do what you want

Andy

 

[Madz]

I am working on a project with which an administrator can enter informaton about his dealers and distributors. this is code of customers table

this is the Dataset which i am using

<?xml version="1.0" standalone="yes" ?>
<xs:schema id="dtCustomers" targetNamespace="http://www.tempuri.org/dtCustomers.xsd" xmlns:mstns="http://www.tempuri.org/dtCustomers.xsd" xmlns="http://www.tempuri.org/dtCustomers.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" attributeFormDefault="qualified" elementFormDefault="qualified">
	<xs:element name="dtCustomers" msdata:IsDataSet="true">
		<xs:complexType>
			<xs:choice maxOccurs="unbounded">
				<xs:element name="Customers">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="Name" type="xs:string" />
							<xs:element name="Distributor" type="xs:boolean" />
							<xs:element name="Dealer" type="xs:boolean" />
							<xs:element name="Address" type="xs:string" />
							<xs:element name="City" type="xs:string" />
							<xs:element name="Phone" type="xs:string" />
							<xs:element name="Fax" type="xs:string" minOccurs="0" />
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:choice>
		</xs:complexType>
	</xs:element>
</xs:schema>

next with a search button i am doing this filling the Dataset and Refreshing the Results in a Grid

dsShowCustomers.Clear()
        On Error Resume Next
        If Not cboCity.Text = "" Then  cbocity is a Combo Box in which some cities are listed.
            cmdSelectCustomer.CommandText = "Select Name, Distributor, Dealer, Address, City, Phone, Fax From Customers Where City = " & cboCity.Text & ""
            Debug.WriteLine(cmdSelectCustomer.CommandText)
        Else
            cmdSelectCustomer.CommandText = "Select Name, Distributor, Dealer, Address, City, Phone, Fax From Customers"
        End If
        mySQL.Open()
        cmdSelectCustomer.ExecuteNonQuery()
        mySQL.Close()
        myAdapter.Fill(dsShowCustomers)
       datagrid here        
        dgCustomers.Refresh()

Here i am able to generate the Dataset i am making changes in Data in DataGrid but i dont know how to send it back to Database
here myAdapter.update(dataset) doesnot working.
Is there any solution

 

[quwiltw]

Have you set up the update/insert/delete commands? either manually or with commandbuilder? This link might help.
http://samples.gotdotnet.com/quickstart/howto/doc/adoplus/UpdateDataFromDB.aspx