No overload for method 'TryParse' takes '1' arguments

Atul Rokade

Actually im trying to insert as well as update data into datagridview at run time for that i have written one code but while executing it give me Data type No overload for method 'TryParse' takes '1' arguments

my accdb table structure is like below

(guys need urgent help please)

Field Datatype

Account-- Memo

AccountNumber--Number

Date--Date/Time

Description--Memo

Post_Ref--Memo

Debit--Number

Credit--Number

Balance--Number

code is :

private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)

{

string connectionString = null;

connectionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;

con.ConnectionString = connectionString;

string cmd1 = "insert into Ledger([Account],[AccountNumber],[Date],[Description],[Post_Ref],[Debit],[Credit],[Balance])values(?,?,?,?,?,?,?,?)";

OleDbCommand cmd = new OleDbCommand(cmd1, con);

con.Open();

cmd.CommandType = CommandType.Text;

cmd.Parameters.AddWithValue("@Account",dataGridView1.Rows[e.RowIndex].Cells["Account"].Value.ToString());

cmd.Parameters.AddWithValue("@AccountNumber",int.TryParse(dataGridView1.Rows[e.RowIndex].Cells["AccountNumber"].Value));

cmd.Parameters.AddWithValue("@Date", DateTime.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Date"].Value));

cmd.Parameters.AddWithValue("@Description", dataGridView1.Rows[e.RowIndex].Cells["Description"].Value.ToString());

cmd.Parameters.AddWithValue("@Post_Ref", dataGridView1.Rows[e.RowIndex].Cells["Post_Ref"].Value.ToString());

cmd.Parameters.AddWithValue("@Debit", Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Debit"].Value));

cmd.Parameters.AddWithValue("@Credit", Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Credit"].Value));

cmd.Parameters.AddWithValue("@Balance", Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Balance"].Value));

int n = cmd.ExecuteNonQuery();

con.Close();

Load_data();

}

11 Replies

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

ali tuncer10y ago
I think because of insert statement, for every parameter, if it is null, still need to insert DBNull.value..

like this way :

if (BalancesHasValue)
{
cmd.Parameters.AddWithValue("@Balance", Balances);
}
else
{
cmd.Parameters.AddWithValue("@Balance", DBNull.Value); //do this for every parameter
}

0
Atul Rokade10y ago
i check table but every column is allow null value
Field DataType Required
AccountNumber Number         No
Account                       Memo           No
Date                                Date/Time No
Description                 Memo              No
Post_Ref                        Memo            No
Debit                              Number         No
Credit                             Number           No
Balance                          Number        No
0
ali tuncer10y ago
Check Ledger table, which columns do not allow null values?
0
Atul Rokade10y ago
hi actually im modify in code and written like below but still its giving me Object cannot be cast from DBNull to other types. error

private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
string connectionString = null;
connectionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;
con.ConnectionString = connectionString;
string cmd1 = "insert into Ledger([AccountNumber],[Account],[Date],[Description],[Post_Ref],[Debit],[Credit],[Balance])values(?,?,?,?,?,?,?,?)";
OleDbCommand cmd = new OleDbCommand(cmd1, con);
con.Open();
cmd.CommandType = CommandType.Text;

int accountnumber = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["AccountNumber"].Value.ToString());
cmd.Parameters.AddWithValue("@AccountNumber", accountnumber);
string accounts = dataGridView1.Rows[e.RowIndex].Cells["Account"].Value.ToString();
cmd.Parameters.AddWithValue("@Account", accounts);

DateTime dates = Convert.ToDateTime(dataGridView1.Rows[e.RowIndex].Cells["Date"].Value);
cmd.Parameters.AddWithValue("@Date", dates);
string Description = dataGridView1.Rows[e.RowIndex].Cells["Description"].Value.ToString();
cmd.Parameters.AddWithValue("@Description", Description);
string Post_Ref = dataGridView1.Rows[e.RowIndex].Cells["Post_Ref"].Value.ToString();
cmd.Parameters.AddWithValue("@Post_Ref", Post_Ref);
int Debits = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["Debit"].Value.ToString());
cmd.Parameters.AddWithValue("@Debit", Debits);
int Credits = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["Credit"].Value.ToString());
cmd.Parameters.AddWithValue("@Credit", Credits);
int Balances = int.Parse(dataGridView1.Rows[e.RowIndex].Cells["Balance"].Value.ToString());
cmd.Parameters.AddWithValue("@Balance", Balances);
cmd.ExecuteNonQuery();
con.Close();

Load_data();
}

my access database table structure is

AccountNumber--Number
Account-- Memo
Date--Date/Time
Description--Memo
Post_Ref--Memo
Debit--Number
Credit--Number
Balance--Number

fed up now :(
----------------------------------------------------------
iam updatedmy code also now but still its giving me No value given for one or more required parameters.
int accountNumber;
bool accountHasValue = int.TryParse(dataGridView1.Rows[e.RowIndex].Cells["AccountNumber"].Value.ToString(), out accountNumber);
if (accountHasValue)
{
cmd.Parameters.AddWithValue("@AccountNumber", accountNumber);
}
string accounts = dataGridView1.Rows[e.RowIndex].Cells["Account"].Value.ToString();
cmd.Parameters.AddWithValue("@Account", accounts);
DateTime datetime;
bool dateTimeHasValue = DateTime.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Date"].Value.ToString(), out datetime);
if (dateTimeHasValue)
{
cmd.Parameters.AddWithValue("@Date", datetime);
}
string Description = dataGridView1.Rows[e.RowIndex].Cells["Description"].Value.ToString();
cmd.Parameters.AddWithValue("@Description", Description);
string Post_Ref = dataGridView1.Rows[e.RowIndex].Cells["Post_Ref"].Value.ToString();
cmd.Parameters.AddWithValue("@Post_Ref", Post_Ref);
int debit;
bool debitHasValue = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Debit"].Value.ToString(), out debit);
if (debitHasValue)
{
cmd.Parameters.AddWithValue("@Debit", debit);
}
int Credits;
bool CreditsHasValue = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Credit"].Value.ToString(), out Credits);
if (CreditsHasValue)
{
cmd.Parameters.AddWithValue("@Credit", Credits);
}
int Balances;
bool BalancesHasValue = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Balance"].Value.ToString(), out Balances);
if (BalancesHasValue)
{
cmd.Parameters.AddWithValue("@Balance", Balances);
}
cmd.ExecuteNonQuery();

con.Close();

Load_data();

0
Manas Mohapatra10y ago
What is the error you are currently getting?
0
ali tuncer10y ago
try this :

result = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Balance"].Value.ToString(),out number);

0
Atul Rokade10y ago
The best overloaded method match for 'int.TryParse(string, out int)' has some invalid arguments

i written code
public static bool TryParse(
string s,
out int result
);
private void dataGridView1_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
int number;
string word;
bool result;
string connectionString = null;
connectionString = ConfigurationManager.ConnectionStrings["AccessConnectionString"].ConnectionString;
con.ConnectionString = connectionString;
string cmd1 = "insert into Ledger([Account],[AccountNumber],[Date],[Description],[Post_Ref],[Debit],[Credit],[Balance])values(?,?,?,?,?,?,?,?)";
OleDbCommand cmd = new OleDbCommand(cmd1, con);
con.Open();
cmd.CommandType = CommandType.Text;
result = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Balance"].Value,out number); --- error coming on this line sir
cmd.Parameters.AddWithValue("@Balance", number);
int n = cmd.ExecuteNonQuery();
con.Close();

Load_data();

}
0
Krishna Rajput Singh10y ago
http://krishnasinghprogramming.blogspot.in
0
Atul Rokade10y ago
hello krishna sir , side is not opening
0
Krishna Rajput Singh10y ago
http://krishnasinghprogramming.blogspot.in
0
Manas Mohapatra10y ago
Firstly TryParse takes two parameters like :

public static bool TryParse(
string s,
out int result
)

In order to resolve your problem try like this:
int number;
bool result = Int32.TryParse(dataGridView1.Rows[e.RowIndex].Cells["Balance"].Value, out number); // current value is present in number variable
cmd.Parameters.AddWithValue("@Balance", number));
0