| | |
Problem with connect to MS Access...
Please support our C# advertiser: Intel Parallel Studio Home
![]() |
Hey people, I have a problem with connect to MS Access database...
I use C#.NET and MS Access 2002-2003
Here is my code:
And now, when I start the application I get message „No value given for one or more required parameters“.
Where I wrong ?
Thanks...
I use C#.NET and MS Access 2002-2003
Here is my code:
C# Syntax (Toggle Plain Text)
... using System.Data.OleDb; namespace Потсетник { public partial class Form1 : Form { public OleDbConnection database; public Form1() { InitializeComponent(); string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=zapis.mdb"; try { database = new OleDbConnection(connectionString); database.Open(); string queryString = "SELECT ID, Име, Презиме, Ник, Мобилен, Мобилен2, e-Mail, e-Mail2, Type FROM Table1 WHERE Table1.ID = Table1.ID"; loadDataGrid(queryString); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } ...
And now, when I start the application I get message „No value given for one or more required parameters“.
Where I wrong ?
Thanks...
Is this statement "SELECT ID, Име, Презиме, Ник, Мобилен, Мобилен2, e-Mail, e-Mail2, Type FROM Table1 WHERE Table1.ID = Table1.ID" valid?
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
•
•
•
•
I had some problems with using cyrilic letters with SQL a while back, try reverting to latin? Just for test
).Here is the code for my first program:
C# Syntax (Toggle Plain Text)
string queryString = "SELECT movieID, Наслов, Издавач, Гледан, Година, Type FROM movie,movieType WHERE movietype.typeID = movie.typeID";
Last edited by Krstevski; Jul 5th, 2009 at 10:29 am.
C# Syntax (Toggle Plain Text)
string queryString = "SELECT movieID, Наслов, Издавач, Гледан, Година, Type FROM movie,movieType WHERE movietype.typeID = movie.typeID"; //Sure you mean string queryString = "SELECT movieID, Наслов, Издавач, Гледан, Година, Type FROM movie,movieType WHERE movietype.typeID =" movie.typeID;
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
![]() |
Similar Threads
- how to connect ms access database to html webpage (JavaScript / DHTML / AJAX)
- Connect to access database on a shared folder (C#)
- Filemaker Pro 9: "Connect to a MS Access DB" (MS Access and FileMaker Pro)
- connect VB 6 to Access 2007 (Visual Basic 4 / 5 / 6)
- connect to access database over network (C#)
- any1 knw how 2 connect access data to dW cs3 (Database Design)
- how to connect access with vb.net (VB.NET)
- Problem with VB.NET and MS Access (VB.NET)
- connect with access (Visual Basic 4 / 5 / 6)
Other Threads in the C# Forum
- Previous Thread: Problem: Flicking with Double Buffering on transparent control
- Next Thread: Delegate Events
| Thread Tools | Search this Thread |
.net access algorithm alignment app array barchart bitmap box broadcast c# c#gridviewcolumn cast check checkbox client combobox communication concurrency control conversion csharp custom database datagrid datagridview dataset datatable datetime degrees development draganddrop drawing elevated encryption enum excel file focus form format forms function gdi+ hospitalmanagementsystem image index input install java label list listbox localization login mandelbrot math messagebox mouseclick mysql operator path photoshop picturebox pixelinversion plotting pointer post programming radians read regex remote remoting richtextbox server sleep socket sql statistics stream string stringformatting sun table text textbox thread time timer update usercontrol validation visualstudio webbrowser whileloop windows winforms wpf xml






