07-09-20, 09:14 PM
السلام عليكم : لدي مشكلة عند الضغط على زر الحفظ وتتلخص المشكلة ان البرنامج يتحاج حوالي 40 ثانية لحفظ البيانات حيث ان الجدول يحتوي على 25 الف سجل عندما كانت السجلات قليلة كانت الامور تمام ما الحل ؟؟؟؟؟؟
كود حفظ السجل :
كود حفظ السجل :
Dim sql = "select * from invoice_add where invoice_number=N'" & (invoice_number.Text) & "'"
Dim adp As New SqlDataAdapter(sql, sqlconn)
Dim ds As New DataSet
adp.Fill(ds)
Dim dt = ds.Tables(0)
If dt.Rows.Count > 0 Then
Else
Dim dr = dt.NewRow
dr!invoice_number = invoice_number.Text
dr!store = store.Text
dr!invoice_date = invoice_date.Value
dr!Accounts_name = Accounts_name.Text
dr!Accounts_code = Accounts_code.Text
dr!invoice_note = ""
dr!invoice_descound = invoice_descound.Text
dr!invoice_tax = 0
dr!invoice_count = invoice_count.Text
dr!total_invoice = total_invoice.Text
dr!delegate_name = ""
dr!type_pay = type_pay.Text
dr!Shipping_company = ""
dr!earn_invoice = earn_invoice.Text
dr!Cuscusgroup = Cuscusgroup.Text
dr!cusGovernorate = cusGovernorate.Text
dr!cuscity = cuscity.Text
dr!pay_money = pay_money.Text
dr!code_print = 1
dr!user_invoice = user_name.Text
dr!total_string = amount_string.Text
dr!invoice_pound = invoice_pound.Text
dr!pay = pay_money.Text
dr!new_balace = new_balace.Text
dr!Accounts_adress = ""
dr!Accounts_phone1 = ""
dr!past_balace = Accounts_balace.Text
dr!money_plus = money_plus.Text
Dim adp As New SqlDataAdapter(sql, sqlconn)
Dim ds As New DataSet
adp.Fill(ds)
Dim dt = ds.Tables(0)
If dt.Rows.Count > 0 Then
Else
Dim dr = dt.NewRow
dr!invoice_number = invoice_number.Text
dr!store = store.Text
dr!invoice_date = invoice_date.Value
dr!Accounts_name = Accounts_name.Text
dr!Accounts_code = Accounts_code.Text
dr!invoice_note = ""
dr!invoice_descound = invoice_descound.Text
dr!invoice_tax = 0
dr!invoice_count = invoice_count.Text
dr!total_invoice = total_invoice.Text
dr!delegate_name = ""
dr!type_pay = type_pay.Text
dr!Shipping_company = ""
dr!earn_invoice = earn_invoice.Text
dr!Cuscusgroup = Cuscusgroup.Text
dr!cusGovernorate = cusGovernorate.Text
dr!cuscity = cuscity.Text
dr!pay_money = pay_money.Text
dr!code_print = 1
dr!user_invoice = user_name.Text
dr!total_string = amount_string.Text
dr!invoice_pound = invoice_pound.Text
dr!pay = pay_money.Text
dr!new_balace = new_balace.Text
dr!Accounts_adress = ""
dr!Accounts_phone1 = ""
dr!past_balace = Accounts_balace.Text
dr!money_plus = money_plus.Text