|
Hey
i Got a Access data base file that i whant to open in C#, i use the folowing code
<br />
<br />
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=testdb.mdb");<br />
using(conn)<br />
{<br />
OleDbCommand com = new OleDbCommand("SELECT Medelande FROM Medelande",conn);<br />
using(com)<br />
{<br />
OleDbDataReader r = com.ExecuteReader();<br />
using(r)<br />
{<br />
this.txtBoard.Text = r["Medelande"].ToString();<br />
}<br />
}<br />
}
It says "ExecuteReader requires an open and available Connection. The connection's current state is Closed."
The file is in the projects dir and the file is named testdb.mdb .
Why is this not working? do i have to start a SQL Server? I have One SQL Server installed, but how do i get this server to know that i what to use this testdb.mdb?
And how do i rewrite the code so it takes contact with the SQL server instead?
//Jimmy
|
|
|
|
|
Hi...
Try using this:
OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\mypath\\myDB.mdb");<br />
<br />
OleDbCommand com = new OleDbCommand("SELECT Medelande FROM Medelande",conn);<br />
<br />
conn.Open();
<br />
OleDbDataReader reader = com.ExecuteReader();<br />
...<br />
...<br />
<br />
conn.Close();
|
|
|
|
|
|
It workt well =)
But now i have an other problem
OleDbCommand com = new OleDbCommand("INSERT INTO Medelande" +<br />
"(id, Medelande) " +<br />
"VALUES (2,'kalle')", conn);<br />
int i = com.ExecuteNonQuery();<br />
this.txtMessage.Text = i.ToString();
It says that i need to use a qustion that can update?? what do the mean with that?
And if ID is i counter i could live it out right? it will get a value by the counter
//JImmy
|
|
|
|
|
If you have an AutoNumber as a field type, you shouldn't include it in your INSERT or UPDATE statements.
Also, don't use string formatting like that. Learn to use the OleDbParameter, which takes care of escaping all values for you and can perform type-checking (as far as databases go) on the client as opposed to submitting the query first to get an error back from the server. This is by far a better way and makes executing batch statements easier (since you create your statement and declare the parameters once, then just change the parameter values and execute the statement with each iteration). See the documentation for the OleDbParameter[^] class in the .NET Framework SDK for more information and examples.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi everyone,
I was hoping the following code would produce a DataGrid which sorts numbers as numbers (not as strings).
DataSet myDataSet = new DataSet();
myDataSet.ReadXml(fileName,XmlReadMode.Auto);
myDataSet.ReadXmlSchema("Data.xsd");
dataGridDaSData.DataSource = myDataSet;
But '10' is listed before '2'.
[fileName is passed;
Data.xsd was created by Visual Studio and corrected by me to require doubles;
Do I need the third line? - the xsd is listed in the XML...]
Any ideas?
---
|
|
|
|
|
If you've created an XML Schema in VS.NET, you should make sure that the IsDataSet option in the property grid (when the designer is open for the schema) is set to true. If you do this, you can generate a typed DataSet class which may resolve the situation (since all tables, rows, and fields are typed according to your typed DataSet schema.
Also note that a DataSet (and hence the DataGrid which has a view on the DataSet) is not sorted by default (though, if your records were sorted to begin with, it may appear to be sorted). To sort, get the DataView from the table in question and set the Sort property according to the documentation. Use that view as the DataSource for your DataGrid. This is one way to solve the problem, so long as the DataSet recognizes the column as a number rather than a string. Again, using a typed DataSet should help solve the problem (and makes your code easier to write and faster since fewer lookups are required when you use the typed properties in your code).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
First off, thank you for your reply.
Secondly, sorry for such a late response.
Thirdly, my data comes from an XML file, so there is no DataView in use - will that affect my ability to sort it? Should I have a DTD inline within the XML?
Regards, J
---
|
|
|
|
|
I need to incorporate an unmanaged C++ dll into my C# application. I need to be able to create an object specified in the dll and call some methods on it. The documentation I have points me towards the System.Runtime.InteropServices namespace, but is not very clear. Can anyone tell me how to do this?
Thanks, G
|
|
|
|
|
i was struggling with that for a long time.
have a look here: http://www.experts-exchange.com/Programming/Programming_Languages/Dot_Net/Q_20889520.html#10405890
a question of mine on EE
Hope it at least helps a bit.
---
|
|
|
|
|
If it is a COM dll then just simply add its refrenece from COM tab to your project,add its namespace and use it,if its not COM dll then search for DllImport in this site or MSDN or google and find lots of examples.
Mazy
"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope
|
|
|
|
|
See Interoperating with Unmanaged Code[^] in the .NET Famework SDK. There's section on exposing COM controls to your .NET application, exposing .NET controls as COM controls, and P/Invoking (consuming) native APIs from unmanaged DLLs. These are full of in-depth discussions as well as examples. Since it sounds like you're wanting to call native APIs, see the DllImportAttribute[^] documentation in the .NET Framework SDK.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
You can do one of the following:
1. Use Managed Extensions for C++ to make a managed adapter around your unmanaged C++ class and then use it from C# as any other managed type.
2. Make a C wrapper around your unmanaged class (explicit passing of *this, etc) and then use DllImport on the C# side.
I have tried both approaches: the second is usually easier, but it depends on your concrete situation.
|
|
|
|
|
hi all
i have an app built with directx 9.0 and have mesh in it
and i want to get out of using for example Alt+tab to go to another app and the get back to the directx app it tells me there is error called the sample does not exist wt can i do???
|
|
|
|
|
SherKar wrote:
...i want to get out of using for example Alt+tab to go to another app and the get back to the directx app it tells me there is error called the sample does not exist ...
A little clearer please... Are you saying that when you Alt-Tab to another app and then Alt-Tab back to your app, you get an error saying "The sample does not exist."? That isn't an error in any Microsoft documentation so I don't know where it is coming from. If it is a custom error being generated by your code, you'd have to go through your code to find out where it is coming from, because as of right now, there isn't enough information to determine what piece of code is causing the error.
RageInTheMachine9532
|
|
|
|
|
The first thing that comes to mind is that you aren't loading your mesh with the painting procedures. If you're storing this in a buffer, you should also handle the Created event and re-load your mesh in the handler. This event is fired when the buffer is destroyed and re-created, which happens when the app must be repainted.
Other than that, debug your code and catch all exception like Dave was getting at to see where the problem actually happens.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi there,
How can i send a SMS to a mobile through ASP.NET page
Shanaka
|
|
|
|
|
First, ou might want to read up on it here[^]. Not all carriers support the same message transfer protocol, SNPP and WCTP being the most common. And there is even less commonality between carriers and their message formats. The easiest, but least reliable method, of sending a message is to send a standard e-mail to the paging carriers SMTP server. Since SMTP wasn't designed for instant messaging, there can be a considerable time delay before the recipient gets the message.
RageInTheMachine9532
|
|
|
|
|
Hi all,
I have created a simple plugin manager (I got some ideas from: http://www.codeproject.com/csharp/PluginsInCSharp.asp)
So when I compile I get 3 dll's:
PluginManager.dll :: this one contains all the code for loading and storing the plugins
IPlugin.dll :: interface which plugin's must implement in order to work
IPluginHost.dll :: this one contains one interface, and this dll must be made for every project, as there are programm speciffic method in it (see article).
The PluginManager.dll refrences IPlugin and IPluginHost, and the IPlugin refrences IPLuginHost.
And I would liek to make things easier for use, so you would only have to compile IPluginHost.dll if you would liek to expose some methods to plugins.
So how can I make that the PluginManager.dll and IPlugin.dll will refrence the IPluginHost.dll at run-time, knowing that the DLL wil always have the name IPluginHost.dll and that it will be in the same irectory.
If I could do this, then I could just refrence PluginManager.dll and IPlugin.dll in my project copy them in my app dir, make a IPluginHost.dll compile it put-it into my app dir and the other two would use it.
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
First, read How the Runtime Locates Assemblies[^] in the .NET Framework SDK. When developing your application, it makes it much easier if you make project references instead of assembly references for projects in your solution. So, when you right-click on your project that requires the dependencies in your solution, click Add Reference then select the Project tab. Add your project(s). This makes sure that your project is always up-to-date with the latest assemblies (since it sets up dependencies on the build order) and that whenever you switch between build configurations (like Debug and Release, which are created by default) that all the project assemblies are of that build.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanx for the link, I will check it out.
Q:What does the derived class in C# tell to it's parent?
A:All your base are belong to us!
|
|
|
|
|
Hi
Anyone out there know how to do a 'GetPixel' (i.e. find what colour is at a Point) with c#? There's a method GetPixel for a BitMap, but not for an arbitrary point on the screen (or a graphics object). MFC had what I needed, but it's gone from .NET!
|
|
|
|
|
chris fearnley wrote:
(or a graphics object).
You can assign a Bitmap to graphic object with Graphics.FromImage(),then if you do change in graphic object it is reflected in bitmap. So GetPixel() works there too. I can't undestand how it doesn't solve it.
Mazy
"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope
|
|
|
|
|
I don't have an image to use Graphics.FromImage(), I just have some lines that have been mathematically drawn. Can I convert the whole area into a Bitmap,then use GetPixel()?
|
|
|
|
|
Search this site to find lots of example. You can first create a Bitmap object and assign it to Graphics object, then draw whatever you want to it. This will works I think.
Mazy
"A bank is a place that will lend you money if you can prove that you don't need it." - Bob Hope
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
