There was an error parsing the query. [ Token line number = 1,Token line offset = 13,Token in error = insert ]

See more:

ASP.NET

C#3.5

C#5.0

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Net;
using System.Net.Mail;
using System.Net.Mime;
using System.Data.SqlServerCe;

namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
try
{
MailMessage mail = new MailMessage();
SmtpClient SmtpServer = new SmtpClient("smtp.gmail.com");


mail.From = new MailAddress("ajay.raturi22@gmail.com");
mail.To.Add("vicky16792@gmail.com");
mail.CC.Add(new MailAddress("sunny.raturi7@gmail.com", "Ajay raturi"));
mail.Bcc.Add(new MailAddress("shubham14091991@gmail.com", "Shubham"));
mail.Subject = "Test Mail - 1";
mail.Body = "mail with attachment";

//mail.CC.Add("ajay.raturi22@gmail.com", "Ajay");
//mail.AddCC("Chilkat HR", "vicky16792@gmail.com");
//mail.AddMultipleCC(new MailAddress(""Jack Frost <vicky16792@gmail.com>", "Bob <ajay.raturi22@gmail.com>"));

System.Net.Mail.Attachment attachment;
attachment = new System.Net.Mail.Attachment("C://Users/adiuser1/Downloads/Capture.PNG");
mail.Attachments.Add(attachment);

SmtpServer.Port = 587;
SmtpServer.Credentials = new System.Net.NetworkCredential("ajay.raturi22@gmail.com", "976079905666");
SmtpServer.EnableSsl = true;

SmtpServer.Send(mail);
MessageBox.Show("mail Send");
}

catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}

private void checkedListBox1_SelectedIndexChanged(object sender, EventArgs e)
{

}


private void button2_Click(object sender, EventArgs e)
{

SqlCeConnection x;
// SqlCeCommand y;
string constr = Properties.Settings.Default.vikasConnectionString;
try
{
x = new SqlCeConnection(constr);
x.Open();
string query="INSERT INTO insert(email,name) values ('" + textBox1.Text + "', '" + textBox2.Text + "')";
SqlCeCommand myCommand = new SqlCeCommand(query, x);
int result=myCommand.ExecuteNonQuery();

MessageBox.Show("hahahaha");
x.Close();
}
catch(Exception ex)
{
throw ex;
}
}


private void Form1_Load(object sender, EventArgs e)
{

}
}}