ABOUT CODE ABBREVIATION

Mehmet Yilmaz

The following 4 lines of code do not have any problems running, but the code also gives a memory-insufficient error in a 1000-line DataGridView. Will have the same end result I have a SHORT CODE

OleDbConnection connection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + hedef);
connection.Open();

if (fatura1.RowCount > 1) { try { string[] row2 = fatura1.Rows[1].Cells[1].Value.ToString().Split('.'); if (Int16.Parse(row2[1]) == 1) { crow2 = "12/" + (Int16.Parse(row2[2]) - 1); } else if (Int16.Parse(row2[1]) > 1 && Int16.Parse(row2[1]) < 11) { crow2 = "0" + (Int16.Parse(row2[1]) - 1 + "/" + row2[2]); } else if (Int16.Parse(row2[1]) > 11 && Int16.Parse(row2[1]) < 13) { crow2 = (Int16.Parse(row2[1]) - 1 + "/" + row2[2]); } OleDbCommand rowcmd2 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + crow2.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); rowcmd2.ExecuteNonQuery(); string cstdrow2 = row2[1] + "/" + row2[2]; OleDbCommand stdrow2 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + cstdrow2.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); stdrow2.ExecuteNonQuery(); } catch { } }

if (fatura1.RowCount > 2) { try { string[] row3 = fatura1.Rows[2].Cells[1].Value.ToString().Split('.'); if (Int16.Parse(row3[1]) == 1) { crow3 = "12/" + (Int16.Parse(row3[2]) - 1); } else if (Int16.Parse(row3[1]) > 1 && Int16.Parse(row3[1]) < 11) { crow3 = "0" + (Int16.Parse(row3[1]) - 1 + "/" + row3[2]); } else if (Int16.Parse(row3[1]) > 11 && Int16.Parse(row3[1]) < 13) { crow3 = (Int16.Parse(row3[1]) - 1 + "/" + row3[2]); } OleDbCommand rowcmd3 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + crow3.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); rowcmd3.ExecuteNonQuery(); string cstdrow3 = row3[1] + "/" + row3[2]; OleDbCommand stdrow3 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + cstdrow3.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); stdrow3.ExecuteNonQuery(); } catch { } }

if (fatura1.RowCount > 3) { try { string[] row4 = fatura1.Rows[3].Cells[1].Value.ToString().Split('.'); if (Int16.Parse(row4[1]) == 1) { crow4 = "12/" + (Int16.Parse(row4[2]) - 1); } else if (Int16.Parse(row4[1]) > 1 && Int16.Parse(row4[1]) < 11) { crow4 = "0" + (Int16.Parse(row4[1]) - 1 + "/" + row4[2]); } else if (Int16.Parse(row4[1]) > 11 && Int16.Parse(row4[1]) < 13) { crow4 = (Int16.Parse(row4[1]) - 1 + "/" + row4[2]); } OleDbCommand rowcmd4 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + crow4.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); rowcmd4.ExecuteNonQuery(); string cstdrow4 = row4[1] + "/" + row4[2]; OleDbCommand stdrow4 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + cstdrow4.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); stdrow4.ExecuteNonQuery(); } catch { } }

if (fatura1.RowCount > 4) { try { string[] row5 = fatura1.Rows[4].Cells[1].Value.ToString().Split('.'); if (Int16.Parse(row5[1]) == 1) { crow5 = "12/" + (Int16.Parse(row5[2]) - 1); } else if (Int16.Parse(row5[1]) > 1 && Int16.Parse(row5[1]) < 11) { crow5 = "0" + (Int16.Parse(row5[1]) - 1 + "/" + row5[2]); } else if (Int16.Parse(row5[1]) > 11 && Int16.Parse(row5[1]) < 13) { crow5 = (Int16.Parse(row5[1]) - 1 + "/" + row5[2]); } OleDbCommand rowcmd5 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + crow5.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); rowcmd5.ExecuteNonQuery(); string cstdrow5 = row5[1] + "/" + row5[2]; OleDbCommand stdrow5 = new OleDbCommand("Insert Into kdv (a,b,c,d,e,f,g,h) Values ('" + cstdrow5.ToString() + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "','" + null + "')", connection); stdrow5.ExecuteNonQuery(); } catch { } }

3 Replies

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

Gokhul Varman9y ago
Please refer the link for your answer:https://www.codeproject.com/Questions/90940/what-is-the-Abbreviation-of-asmx-in-asp-net
Mehmet Yilmaz9y ago
I am an accountant. I'm writing an audit program. I will create a form to check the tax declarations of contracted companies' goods and services companies, I will transfer the blank form to "excel" and then print it out.

(acces table to acces table data transfer)

A blank line will be added for the period the bills belong and for the previous period, and I'll then manually write some amounts.

I get an error message when adding blank lines.
Severity Code Description Project File Line Suppression State
Error CS7036 There is no argument given that corresponds to the required formal parameter 'cell' of 'Form1.InsertRow(OleDbConnection, string)' test1 c:\users\asus\documents\visual studio 2017\Projects\test1\test1\Form1.cs 103 Active

for (int i = 1; i <= 1000 && (datagrid1.RowCount > i); i++)
{
InsertRow(datagrid1.Rows[i].Cells[1].Value.ToString()); // teka a error message "cell"
}
void InsertRow(OleDbConnection conn, string cell)
{

    string patch = Application.StartupPath + "\\data.mdb";


    DateTime month;
    if (DateTime.TryParseExact(cell, "MM.yyyy", null, DateTimeStyles.None, out month))
    {
        InsertMonth(month.AddMonths(-1));
        InsertMonth(month);
    }
}

void InsertMonth(DateTime month)
{
    string patch = Application.StartupPath + "\\data.mdb";

    using (var conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" + patch))
    using (var cmd = conn.CreateCommand())
    {
        cmd.Connection.Open();
        cmd.CommandText = "insert into period (a) values (?)";
        cmd.Parameters.AddWithValue("?", month.ToString("MM/yyyy"));
        cmd.ExecuteNonQuery();
    }
}


private void addemptyperiodbutton_Click(object sender, EventArgs e)
{

    for (int i = 1; i <= 1000 && (datagrid1.RowCount > i); i++)
    {
    InsertRow(datagrid1.Rows[i].Cells[1].Value.ToString()); // teka a error message "cell"
    }

    perioddublicateclean();
    datagrid2load();
}
Please see the project in the attached file
Nilesh Shah9y ago
In which event is this code written?
Did you place a debug breakpoint and check how many times it gets executed, and is that the same way as you want it to be executed?
It seems simply that you have missed placing "else" before the last 3 "if" statements.

Just simply run this code for any data where rows are 5 or more, in that case all of these if statements will get executed.