Master-Detail Form with DataGridView

See more:

C#3.0

C#

Dear All,

I have designed a form which fulfills production data manipulation.

AdaptMst.SelectCommand = new SqlCommand("SELECT * FROM Iss_Mst WHERE FromDeptID=8 AND ToDeptID!=8 ORDER BY DATE DESC", baseConnection);
            ADaptDetails.SelectCommand = new SqlCommand("SELECT ID,IssMstID,ToOprID,ToDrgId,BatchNo,Qty,FromOprID,Rew,Back FROM Iss_Dtl",baseConnection);
            try
            {
                baseConnection.Open();
                AdaptMst.Fill(tblMst);
                ADaptDetails.Fill(tblDetails);
                dsInspProd.Tables.Add(tblMst);
                dsInspProd.Tables.Add(tblDetails);

                dsInspProd.Tables[0].TableName = "tblMst";
                dsInspProd.Tables[1].TableName = "tblDetails";

                dsInspProd.Tables[0].Columns["ID"].AutoIncrement = true;
                dsInspProd.Tables[0].Columns["ID"].Unique = true;
                
                dsInspProd.Tables[1].Columns["ID"].AutoIncrement = true;
                dsInspProd.Tables[1].Columns["ID"].Unique = true;
                

                dsInspProd.EnforceConstraints = false;
                DataRelation dr = new DataRelation("IssDtl",dsInspProd.Tables[0].Columns["ID"],dsInspProd.Tables[1].Columns["IssMstID"]);
                dr.Nested = true;
                dsInspProd.Relations.Add(dr);

                bsMaster.DataSource = dsInspProd;
                bsMaster.DataMember = "tblMst";

                bsDetails.DataSource = bsMaster;
                bsDetails.DataMember = "IssDtl";
                bnBase.BindingSource = bsMaster;
                InitCommonData();
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
            }
            finally
            {
                baseConnection.Close();
            }

 protected override void tsbtnBaseSave_Click(object sender, EventArgs e)
        {
            base.tsbtnBaseSave_Click(sender, e);
            try
            {

                dsInspProd.AcceptChanges();
                SqlCommandBuilder Updt = new SqlCommandBuilder(AdaptMst);
                AdaptMst.UpdateCommand = Updt.GetUpdateCommand();
                AdaptMst.Update(dsInspProd, "tblMst");

                SqlCommandBuilder UpdtDetails = new SqlCommandBuilder(ADaptDetails);
                ADaptDetails.UpdateCommand = UpdtDetails.GetUpdateCommand();

                SqlCommandBuilder InsertDetails = new SqlCommandBuilder(ADaptDetails);
                ADaptDetails.InsertCommand = InsertDetails.GetInsertCommand();

                ADaptDetails.Update(dsInspProd, "tblDetails");
            }
            catch (Exception ex)
            {
                //MessageBox.Show(ex.Message.ToString());
                tsBaseLabel.Text = ex.Message.ToString();
            }
        }

I am able to Update/Edit records, But When I am trying to add a new record, It gives an Instance error.

What is the missign for adding new records in master-detail record...?

I have designed a base form which contains BindingNavigator and BindingSource Objects, the methods of these objects are implemented on the derived form.

Please help.

Thanks,
Bhavin.