How to recursive function use in this code?

Question

0.00/5 (No votes)

See more:

C#

private void SaveMact(string ComboxSelectedValue)
        {
            if (MessageBox.Show("You are about to save current operation. Do you want to proceed?", "Save Data", MessageBoxButton.YesNo, MessageBoxImage.Question) != MessageBoxResult.Yes)
                return;
            try
            {
                using (SqlConnection conn = new SqlConnection(GlobalClass.DataConnectionString))
                using (SqlCommand cmdsave = new SqlCommand())
                {
                    conn.Open();
                    cmdsave.Connection = conn;

                    foreach (Menuitem mi in oMenuitemlist)
                    {

                        if (mi.RowChanged > 0 )
                          {
                              cmdsave.CommandText = "UPDATE MENUITEM SET MCAT = @MCAT WHERE MCODE = @MCODE OR PARENT = @MCODE OR MGROUP=@MCODE;
                            cmdsave.Parameters.AddWithValue(@MCAT, mi.Mcat);
                            cmdsave.Parameters.AddWithValue(@MCODE, mi.Mcode);
                            cmdsave.ExecuteNonQuery();

}
}

Posted 17-Nov-15 17:55pm

Member 12033805

Updated 17-Nov-15 17:57pm

PIEBALDconsult

v2

Add a Solution

Comments

PIEBALDconsult 17-Nov-15 23:58pm

It looks like you're missing a closing quote.
Other than that, I have no idea what your problem might be. Please use Improve question to add context and detail.
And avoid recursion.

Patrice T 18-Nov-15 0:03am

The title do not make sense.
details needed

Member 12033805 18-Nov-15 0:24am

In above code data update from grid view in the relation of parent and child.in above code my problem is only parent and child updated but sub parent and child not update. Row change is the flag 0 and 1 if 1 get data update in database.

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2015-11-17T18:21:00

Solution 1

Never a good idea to use recursion with the database.

Its better to build a single query to update all records rather than update recursively.

Posted 17-Nov-15 18:21pm

Abhinav S

Comments

Member 12033805 18-Nov-15 0:43am

In above code data update from grid view in the relation of parent and child.in above code my problem is only parent and child updated but sub parent and child not update. Row change is the flag 0 and 1 if 1 get data update in database.1 value get only top parent but change sub parent top parent row change value o so loop dos not enter the row change>0 so data not update in databse

Abhinav S 18-Nov-15 1:20am

Can you check if the update query works in sql server?

Member 12033805 · Accepted Answer · 2015-11-17T22:22:00

public void ExecuteSave(object obj)
{
SqlTransaction Tran;
if (MessageBox.Show("You are about to save current operation. Do you want to proceed?", "Save Data";, MessageBoxButton.YesNo, MessageBoxImage.Question) != MessageBoxResult.Yes)
return;
try
{
using (SqlConnection Conn = new SqlConnection(GlobalClass.DataConnectionString))
using (SqlCommand cmd = Conn.CreateCommand())
{
Conn.Open();
Tran = Conn.BeginTransaction();
cmd.Transaction = Tran;
try
{
SaveMCAT(oMenuitemlist, cmd);
Tran.Commit();
}
catch (Exception)
{
if (Tran.Connection != null)
Tran.Rollback();
throw;
}
}
}
catch (Exception)
{

throw;
}
MessageBox.Show("Category Mapped Sucessfully", "Alert")
}

private void SaveMCAT(ObservableCollection<menuitem>, SubGroup, SqlCommand cmdsave)
{
foreach (Menuitem mi in SubGroup)
{
if (mi.RowChanged > 0)
{
cmdsave.CommandText = "UPDATE MENUITEM SET MCAT = @MCAT WHERE MCODE = @MCODE OR PARENT = @MCODE OR MGROUP=@MCODE";
cmdsave.Parameters.AddWithValue(@MCAT;, mi.Mcat);
cmdsave.Parameters.AddWithValue(@MCODE, mi.Mcode);
cmdsave.ExecuteNonQuery();

cmdsave.Parameters.Clear();

}
if (IsCheackedNonTree == true)
{

}
else
{
if (mi.Children.Count> 0)
{
SaveMCAT(mi.Children, cmdsave);
}
}

}

}

How to recursive function use in this code?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

How to recursive function use in this code?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us