Problem in Master/Detail Update

Hot Topic

Comvisible object, config files, and classic ASP
Access Excel File On Different Server ** Help Urgently Needed Plz **
(MDAC) 2.6 or later required
How to run an sql stored procedure on my aspx page ?
Selecting / Update records - Concurrancy
Audit/Log the change in DataSet
Extracting public exposed methods from a dll
How can I use the .NET Framework to find out if an app is installed?
Best Practices: Creating an Access Database at Runtime
MS Access supports Cascade deletes but SQL 2000/2005 doesn't?

.NET Development

Issue in Sending mail through SMTP
ManualResetEvent
where can i find...
XmlSchemaCollection, 1.1 vs. 2.0
Chunked transfer encoding problem
Data trasfering tip required
selecting a child
Create Message Queue
Reload Assemblies
Win32 interop ( How to get the value from the calculator textbox ) ???

Problem in Master/Detail Update

Hi Guys

i am new to vb.net and i am using visual studio 2003. I have created a master detail relationship between two tables. My problem is i am not able to update the changes. I am pasting the code please help me.

Imports System.Data

Imports System.Data.SqlClient

Imports System.Configuration

Public Class AsnEdit

Inherits System.Windows.Forms.Form

Dim cn As New SqlConnection(ConfigurationSettings.AppSettings("constring")) 'OleDbConnection i

Dim cmd As New SqlCommand("Select * from asnhdr_sql", cn)

Dim da As New SqlDataAdapter(cmd)

Dim ds As New DataSet

Private Sub AsnEdit_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

da.Fill(ds, "asnhdr_sql")

cmd.CommandText = "Select * from asnlin_sql"

da.Fill(ds, "asnlin_sql")

Dim hd() As DataColumn

Dim ld() As DataColumn

hd = New DataColumn() {ds.Tables(0).Columns("HASNTP"), ds.Tables(0).Columns("HASNBATCH"), ds.Tables(0).Columns("HASNTYPE")}

ld = New DataColumn() {ds.Tables(1).Columns("LASNTP"), ds.Tables(1).Columns("LASNBATCH"), ds.Tables(1).Columns("LASNTYPE")}

Dim rel As New DataRelation("View Details", hd, ld)

ds.Relations.Add(rel)

grdOrders.DataSource = ds.Tables(0)

End Sub

Private Sub btnsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

'da.Update(ds)

'da.Update(ds, "asnhdr_sql")

da.Update(ds.Tables(0))

End Sub

Answer this question

Problem in Master/Detail Update

  • AtomZ .be

    You havent set the dataadapter's UpdateCommand property.

    // i think the following code sample would help you some what.

    // Create the UpdateCommand.

    cmd = new SqlCommand("UPDATE Customers SET CustomerID = @CustomerID, CompanyName = @CompanyName " +
    "WHERE CustomerID = @oldCustomerID", conn);

    cmd.Parameters.Add("@CustomerID", SqlDbType.NChar, 5, "CustomerID");
    cmd.Parameters.Add("@CompanyName", SqlDbType.NVarChar, 40, "CompanyName");

    parm = cmd.Parameters.Add("@oldCustomerID", SqlDbType.NChar, 5, "CustomerID");
    parm.SourceVersion = DataRowVersion.Original;

    da.UpdateCommand = cmd;

    Thanks

    Asad Iqbal



  • Problem in Master/Detail Update
Answer this question