Click here to Skip to main content
14,739,439 members
Home » Discussions » C#
   

C#

 
AnswerRe: Is my program idea possible? Pin
OriginalGriff27-Nov-20 21:20
mveOriginalGriff27-Nov-20 21:20 
GeneralRe: Is my program idea possible? Pin
Dioxazine28-Nov-20 6:54
MemberDioxazine28-Nov-20 6:54 
GeneralRe: Is my program idea possible? Pin
OriginalGriff28-Nov-20 7:17
mveOriginalGriff28-Nov-20 7:17 
GeneralRe: Is my program idea possible? Pin
Dioxazine28-Nov-20 9:09
MemberDioxazine28-Nov-20 9:09 
GeneralRe: Is my program idea possible? Pin
OriginalGriff28-Nov-20 9:22
mveOriginalGriff28-Nov-20 9:22 
GeneralRe: Is my program idea possible? Pin
Liktor Janos11-Dec-20 8:42
MemberLiktor Janos11-Dec-20 8:42 
GeneralRe: Is my program idea possible? Pin
Gerry Schmitz28-Nov-20 8:51
mveGerry Schmitz28-Nov-20 8:51 
QuestionError in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 4:47
MemberAlex Dunlop23-Nov-20 4:47 
Hi,
I want to save all of my DataGridView content directly into a SQL server. I'm Using SQL Light Compact 4.0
All codes related to save function are in a button:
<pre> private void btnSave_Click(object sender, EventArgs e)
        {
            SqlCeConnection connection = new SqlCeConnection();
            connection.ConnectionString = @"Data Source=C:\Users\Dell\Desktop\DataGridView\PMinfo.sdf";
            SqlCeCommand myCommand = new SqlCeCommand();
            myCommand.Connection = connection;


            for (int i = 0; i < dataGridView1.Rows.Count; i++)
            {
                myCommand.CommandText = @"INSERT into [PMinfo] (Number, CostCenter, pType, ServiceType, Receiver, WorkCenter, Start, End, Remaining, Status, ReceiveDate) values(@Number, @CostCenter, @pType, @ServiceType, @Receiver, @WorkCenter, @Start, @End, @Remaining, @Status, @ReceiveDate)";
                myCommand.Parameters.AddWithValue("@Number", dataGridView1.Rows[i].Cells[0].Value.ToString());
                myCommand.Parameters.AddWithValue("@CostCenter", dataGridView1.Rows[i].Cells[1].Value.ToString());
                myCommand.Parameters.AddWithValue("@pType", dataGridView1.Rows[i].Cells[2].Value.ToString());
                myCommand.Parameters.AddWithValue("@ServiceType", dataGridView1.Rows[i].Cells[3].Value.ToString());
                myCommand.Parameters.AddWithValue("@Receiver", dataGridView1.Rows[i].Cells[4].Value.ToString());
                myCommand.Parameters.AddWithValue("@WorkCenter", dataGridView1.Rows[i].Cells[5].Value.ToString());
                myCommand.Parameters.AddWithValue("@Start", dataGridView1.Rows[i].Cells[6].Value.ToString());
                myCommand.Parameters.AddWithValue("@End", dataGridView1.Rows[i].Cells[7].Value.ToString());
                myCommand.Parameters.AddWithValue("@Remaining", dataGridView1.Rows[i].Cells[8].Value.ToString());
                myCommand.Parameters.AddWithValue("@Status", dataGridView1.Rows[i].Cells[9].Value.ToString());
                myCommand.Parameters.AddWithValue("@ReceiveDate", dataGridView1.Rows[i].Cells[10].Value.ToString());

                connection.Open();
                myCommand.ExecuteNonQuery();
                connection.Close();
            }
        }

When I press the button, compiler gives error in line
myCommand.ExecuteNonQuery();

'There was an error parsing the query. [ Token line number = 1,Token line offset = 92,Token in error = End ]'

What is wrong with my code?
AnswerRe: Error in SQL Light Compact 4 Pin
Victor Nijegorodov23-Nov-20 4:56
MemberVictor Nijegorodov23-Nov-20 4:56 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 5:04
MemberAlex Dunlop23-Nov-20 5:04 
GeneralRe: Error in SQL Light Compact 4 Pin
Richard Deeming23-Nov-20 5:18
mveRichard Deeming23-Nov-20 5:18 
GeneralRe: Error in SQL Light Compact 4 Pin
OriginalGriff23-Nov-20 5:29
mveOriginalGriff23-Nov-20 5:29 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 8:38
MemberAlex Dunlop23-Nov-20 8:38 
GeneralRe: Error in SQL Light Compact 4 Pin
OriginalGriff23-Nov-20 8:53
mveOriginalGriff23-Nov-20 8:53 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 9:10
MemberAlex Dunlop23-Nov-20 9:10 
GeneralRe: Error in SQL Light Compact 4 Pin
OriginalGriff23-Nov-20 9:19
mveOriginalGriff23-Nov-20 9:19 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop23-Nov-20 9:28
MemberAlex Dunlop23-Nov-20 9:28 
GeneralRe: Error in SQL Light Compact 4 Pin
Richard Deeming23-Nov-20 18:43
mveRichard Deeming23-Nov-20 18:43 
GeneralRe: Error in SQL Light Compact 4 Pin
Alex Dunlop24-Nov-20 7:06
MemberAlex Dunlop24-Nov-20 7:06 
GeneralRe: Error in SQL Light Compact 4 Pin
Dave Kreskowiak24-Nov-20 9:52
mveDave Kreskowiak24-Nov-20 9:52 
AnswerRe: Error in SQL Light Compact 4 Pin
Dave Kreskowiak23-Nov-20 6:58
mveDave Kreskowiak23-Nov-20 6:58 
Questioninteresting issue with SortedSet and ElementAt Pin
BillWoodruff22-Nov-20 19:59
mveBillWoodruff22-Nov-20 19:59 
AnswerRe: interesting issue with SortedSet and ElementAt Pin
Sandeep Mewara22-Nov-20 21:06
mvaSandeep Mewara22-Nov-20 21:06 
GeneralRe: interesting issue with SortedSet and ElementAt Pin
BillWoodruff22-Nov-20 23:19
mveBillWoodruff22-Nov-20 23:19 
GeneralRe: interesting issue with SortedSet and ElementAt Pin
Sandeep Mewara22-Nov-20 23:38
mvaSandeep Mewara22-Nov-20 23:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.