Hastily. Wait online

kingjzm

I made a program with C#. All functions of this program can be used normally before importing other system data, but after importing 10,000 records, my program can only be added, deleted, and cannot be modified. , The program has no errors and it runs normally. (Mention here, I only use two of the tables for data, and the other tables are also empty tables, and now they cannot be modified. I don't know why), and it doesn't work to clean up the log.

alu1124

What is your modification method? Is it a direct SQL statement or a binding method?
What is a database?
Are there any special restrictions in the database?

kingjzm

I use sqlserver database
There are no special restrictions in the database.

alu1124

Post part of your program to modify the database, so you can't see what's wrong.

amdboy

Post the core code, it is difficult to diagnose

kingjzm

Class code:

        private void UpdateRecord()
        {
            try
            {
               // myDataSet.Tables["Info_List"].Rows[iCurrentRow]["Info_Id"] = base.Info_Id;
                myDataSet.Tables["Info_List"].Rows[iCurrentRow]["Info_Title"] = base.Info_Title;
                myDataSet.Tables["Info_List"].Rows[iCurrentRow]["Info_Body"] = base.Info_Body;
                if(base.Info_Date!="")
                 {
                     myDataSet.Tables["Info_List"].Rows[iCurrentRow]["Info_Date"]=Convert.ToDateTime(base.Info_Date);
                  }
                if(base.End_Date!="")
                 {
                     myDataSet.Tables["Info_List"].Rows[iCurrentRow]["End_Date"]=Convert.ToDateTime(base.End_Date);
                  }
                myDataSet.Tables["Info_List"].Rows[iCurrentRow]["uid"] = base.uid;
                myDataSet.Tables["Info_List"].Rows[iCurrentRow]["Info_Class"] = base.Info_Class;
                mySqlDataAdapter.Update(myDataSet,"Info_List");
            }

            catch
            {
            }
        }


        public void Save()
        {
            if (bIsDirty==true)
            {
                UpdateRecord();
                bIsDirty=false;
            }
        }


cs file code

CInfo_Lists m_Info_List=new CInfo_Lists();
m_Info_List.bIsDirty=true;
m_Info_List.Save ();

kingjzm

Everything is normal before the data is poured, and it is normal if the database is newly created.

alu1124

Remove
try
{
... ...
}
catch
            {
            }
It will report an error. You will ignore any errors in this exception handling.

alu1124

It may be an abnormal time conversion, or an abnormality in updating the database.
Knowing what is the exception can be dealt with in a targeted manner

kingjzm

The prompt is as follows:

Dynamic SQL generation of UPdateCommand is not supported for the Select Command value that does not return any key column information