datagridview in c# application

Just try.... Not sure

Change loop to for(int i=0;i<count-1>;i++)

or

Change Cells["name"] to Cells[indexvalue] Eg: Cells[0]

or

Insert "Integrated Security=false" in connection string

Hope it will help you

i dont think one can be of much help if one doesnt know what error u r getting.

But just by looking at it. what datatype id ur amount field in teh table.. i see ur trying to insert itas a string!

IS ur connection string in correct form?

SURE the error is from the variable count
if count is intialized with value < 1 then the loop will not be entered
and if initialized with value >= 1 then the loop will be entered and it will not be left since the count is not changed inside the loop (infinite loop).
so in both cases you will not reach your target!!!

Hi ngnagarajan,

Please we need the error that faced you in order finding a solution for your problem .

There are lots of possible reasons:
1) count could be wrong: this would probably cause an "array index out of range" error.
2) The data in your DataGridView might be in the wrong format for the cells.
3) You might need a password on your DB.
4) The name of the database could be wrong.
5) You may already have identical data in your database.
6) Your database may require other information in order to do the insert.
7) You could be trying to compile this as VB.
8) Other.

Without the actual error message, it is impossible to say.
However, do not do it that way anyway: you leave yourself open to an accidental or deliberate SQL Injection attack. Use Parametrized queries instead:

string qu = "INSERT INTO feesstudcture (Fees_name, Amount) VALUES (@FEN, @AMT)";
string constring = "data source=localhost;database=newschool;userid=root;password=";
MySqlConnection con = new MySqlConnection(constring);
con.Open();
MySqlCommand cmd = new MySqlCommand(qu, con);
cmd.Parameters.AddWithValue("@FEN", dataGridView1.Rows[i].Cells["Fees_name"].Value);
cmd.Parameters.AddWithValue("@AMT", dataGridView1.Rows[i].Cells["Amount"].Value);
cmd.ExecuteNonQuery();

Oh, and move the connection outside the loop - you do not need to create a new one each time you go round!