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

Question

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();

}

ali tuncer · Answer

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 }

Atul Rokade · Answer

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

ali tuncer · Answer

Check Ledger table which columns do not allow null values?

Atul Rokade · Answer

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();

Manas Mohapatra · Answer

What is the error you are currently getting?

ali tuncer · Answer

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

Atul Rokade · Answer

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].Valueout number); --- error coming on this line sir cmd.Parameters.AddWithValue(@Balance number); int n = cmd.ExecuteNonQuery(); con.Close(); Load_data(); }

Krishna Rajput Singh · Answer

http://krishnasinghprogramming.blogspot.in

Atul Rokade · Answer

hello krishna sir  side is not opening

Krishna Rajput Singh · Answer

http://krishnasinghprogramming.blogspot.in

Manas Mohapatra · Answer

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 ));