remove redundant data from database.

Mittal Joshi

I have some application no stored in database through search.if i again search any journal and if no is again match then it will no be store.........can anybody give me code for this.
i have tried this....
con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|app_search.mdb;Persist Security Info=True");
con.Open();
cmd = new OleDbCommand("select Application_no from Published_Application", con);

adp1 = new OleDbDataAdapter(cmd);

adp1.Fill(ds2);
int s = ds2.Tables[0].Rows.Count ;
int t = 0;
dr3 = cmd.ExecuteReader(CommandBehavior.Default);
while(dr3.Read())
{
if (t < s)
{
//string abc = dr1[0].ToString();
if (test_app1 != dr3[0].ToString())
{
while(t == s)
{
if (k.Trim().Contains(test_app))
{
//test_app = test_app.Replace(" ", "/");
string k1 = k.Trim();
cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|app_search.mdb;Persist Security Info=True");
int pNum = int.Parse(myFields.ExecuteThisJavascript("event.value=this.getPageLabel(" + p + ",true);"));
cn.Open();
query = "insert into Published_Application (Application_no,country,date_app,date_pub,invention,classification,doc_no,priority_date,priority_country,filing_date,international_publication,patent_no,divisonal,Applicant_name,Applicant_Address,inventor_name,journal_no,page_no,j_year) values('" + test_app1 + "', '" + test1 + "','" + test2 + "','" + test3 + "','" + test4 + "' , '" + test5 + "','" + test6 + "','" + test7 + "', '" + test8 + "','" + test9 + "','" + test10 + "' ,'" + test11 + "','" + test12 + "', '" + test13 + "','" + test13_1 + "', '" + test14 + "','" + journal + "','" + p1 + "','" + journal2 + "')";
cmd = new OleDbCommand(query, cn);
cmd.ExecuteNonQuery();
cn.Close();
}

}
t = t + 1;
}
//t = t + 1;

}

}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

Roei Bar17y ago
you should add to the query the following

if not exsist(select application_no from Published_Application where application_no = test_app1)

this will make sure that the application does not exists before commiting the insert
0

jinge17y ago

See the following code:

         void Insert()
        {
            while (dr3.Read())
            {
                if (dr3[0].ToString() != No)
                {
                    DoInsertThisRecord();
                }
            }
        }

One suggestion, please do not create connection object in the while statement, this is an expansive operation, and might degrade your application a lot it there are potential lots of records.
regards,
jinge.

Mittal Joshi17y ago
i have tried condition (t
0
Mittal Joshi17y ago
I have to search journals.if in any journal application no is match of our client then it will store in database.and if this no will again publish in any journal.it should not be inserted into databse.
0
Roei Bar17y ago
first thing
change the while(t == s)
to
while(t <= s)

in the while
increase the t

in the while loop end add:

t++;

that should run on the dataset rows and insert them if i got the logic right
0
Kirtan Patel17y ago
Can you Explain it more clearly ?? could not understood you :)

Exactly what out put you want and what will you do tell me that

0