biran

Hi all,

i have a AccessDatabase and all fields data type are text and i am adding data from C# form window. when i click save button its giving me ERROR IN INSERT INTO STATEMENT.
I did like this:
private void SaveAndAddnew_Click(object sender, EventArgs e)
{

try
{
string strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=data\\reco.mdb";
OleDbConnection myConn = new OleDbConnection(strConn);
myConn.Open();
string strInsert = "INSERT INTO Students(ID,Student_Name,Gender,Phone_No,Year,Father_Name)VALUES("+ID.Text+",'" + Student_Name.Text + "','" + Gender.Text + " ',' " + Phone_Number.Text + " ','" + Year.Text + "','" + Father_Name.Text+"')";
OleDbCommand inst = new OleDbCommand(strInsert, myConn);
inst.ExecuteNonQuery();
myConn.Close();
}
catch (Exception ed)
{
MessageBox.Show("Error in Saving\n" + ed.ToString(), "Error");
}
}

But I am getting syntax error at "INSERT INTO STATEMENT
Where is the problem please help me tooo.

biran

nnxion

Read the how to post a question thread or announcement. Please post in [code] tags.

__________________
"Employ your time in improving yourself by other men's writings, so that you shall gain easily what others have labored hard for."
-- Socrates

Pedja

I think that you might be missing quotation marks around ID.Text.

BlazingWolf

The error suggest it is a something wrong with your SQL syntax and not your C# code.

'' aroudn ID.Text like Pedja said is probably the problem.

__________________
_______________________________
BlazingWolf

biran

Hi all,
Thanks for help,
i did fixed that problem now i am having a problem with data output in datarid.
i have a search button and one textbox for name and just below one datagrid when i click search button it will be display same name datas.
how can i do that please help with example.
thank you

TheCodeLord

Sorry I can't understand you, what happens when you press the search button?