|
Have you asked here:
http://discuss.microsoft.com/archives/DIRECTXDEV.html
|
|
|
|
|
Hi,
I'm trying to open MS Access using OleDbConnection in a windows application but form will just frozen and not continue to the OleDbCommand? anybody knows why please?
Many Thanks,
Jassim Rahma
Jassim Rahma
|
|
|
|
|
Sounds like there is a problem connecting to the datasource. I'd say start by checking your connection string.
The word abbreviation is awfully long for what it means.
|
|
|
|
|
but Chris I'm using the same connection string for all my applications and never had a problem plus this application is working perfect on my laptop.
Jassim Rahma
|
|
|
|
|
I'm using the same code in all my other applications and the strange thing that the same application which is giving an error is working on my laptop with no problems:
strSQL = "SELECT * FROM account WHERE department = 'CRM' AND account_pin = '234567'";
// open database;
strConnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\temp\\Apps\\CRM Queries\\accounts.mdb;Jet OLEDB:Database Password=mem";
OleDbConnection dbConnection = new OleDbConnection(strConnection);
dbConnection.Open();
OleDbDataReader dbReader;
OleDbCommand dbCommand = new OleDbCommand(strSQL, dbConnection);
dbReader = dbCommand.ExecuteReader();
try
{
update_log("validating department and PIN");
while (dbReader.Read())
{
account_department_name = dbReader["department"].ToString();
account_department_pin = dbReader["account_pin"].ToString();
}
dbReader.Close();
}
catch(Exception exp)
{
MessageBox.Show(exp.Message, "Error");
}
finally
{
dbConnection.Close();
}
Many Thanks,
Jassim Rahma
Jassim Rahma
|
|
|
|
|
Not having much luck creating messages and changing the sent date/time for archiving imported messages from Notes to Exchange.
I'm not having much luck getting hints on how to do this from any boards or newsgroups either. 
Does anyone here at CP have any experience doing this in C# or with any other language for that matter? 
Thanks bunches.
|
|
|
|
|
Hello,
How does a service control manager (or operating system) know that a windows service did not start successfully? Should I throw an exception in the overriden OnStart function? Or is there some other way? Thank you in advance!
Rado
|
|
|
|
|
Hi!
Do you remember "continuous form" in form view in MS Access form designer? I need something like that in C# - one data source supplies multiple data forms (or custom controls dynamically placed on the form). How can I make it?
thanks
Hubert
|
|
|
|
|
I'm not quite sure what you mean since I havent been forced to use Access for a long time. But, a DataSet should be usable for multiple data views.
The word abbreviation is awfully long for what it means.
|
|
|
|
|
I have meant the component which is multiplicated as many times on the form/panel as the number of records in database is, and all of these components displays data from just one datasource.
In special cases this may look similar to the DataGrid bounded to data table in dataset - each row of data from the table is represented as single row of controls (TextBoxes typically) in DG. I have much more complicated data to work/visualize (about 50 data columns represented as buttons, combo boxes, text fields) so DG fails ;-(
I hope this made my question more clear 
thanks again
h.
|
|
|
|
|
Off hand, I'd say you have two options.
First, you can add customized columns to a datagrid on the fly as you read the data from the dataset. Or second, you can enumerate the dataset and add the controls to your form on the fly.
A nice sample on this site that does the second option and can be found here [^]
For the first option, take a look here [^], while it may not be exactly what you need, the code does show how to add custom column types to a datagrid.
Best of luck.
The word abbreviation is awfully long for what it means.
|
|
|
|
|
hm, well, both of the above articles/codes are pretty good (and useful for other parts of my project) but it is still not what I've meant.
But... in the meantime, i have made something which realizes my functionality - it is pretty simple now, but tomorrow I'm going to apply it to my project and test.
And maybe I'll write a little article about writing my own DataPanel...
Thanks very much for help and (again) for interesting links above
H.
|
|
|
|
|
In the Windows App world, is there a C# property that will tell me if my application is the currently active app; the application that currently has focus? I've experimented with checking the TopMost property, but that seems to be more for when I want my app to always be on top; even if it isn't active. Sorry if this is a stupid question...I'm still a C# novice.
Ron Ward
|
|
|
|
|
|
Try the following out. Why is the emailsettings element tree read <b><i>BEFORE</i></b> the othersettings element (its parent)! Am I blind?
while( settings.Read() )
{
string section = settings.Name;
switch( section.ToLower() )
{
case "pollagentsettings":
break;
case "profileragentsettings":
break;
case "othersettings":
break;
}
}
/* Use this as your settings.xml document - it is the output from the XmlTextWriter
<?xml version="1.0" encoding="utf-8" standalone="yes"?><Settings><PollAgentSettings><ExecOptions type="SP" procedure="asdfasdf" interval="10"><TSQL /></ExecOptions><Servers><Server name="qwer" enabled="True" /></Servers></PollAgentSettings> <OtherSettings><EmailSettings from="qwer" host="asdf" subject="zxcv" /></OtherSettings></Settings>*/
|
|
|
|
|
Holy crapper!
If you put a space between the opening OtherSettings element and the opening EmailSettings element, it works fine. Can anyone think of a real good reason that is a bug?
Modified: Sorry make that just before the opening OtherSettings element.
|
|
|
|
|
is there a way to point all try and catch statments to my own custom error handler by (going on a long shot here) a single property... or do i have to do what i have been doing and go through and point each individual try and catch to my error provider... thanks for the info.... i suspect that there isnt a way to do this...but hey you never know right?
Jesse M
The Code Project Is Your Friend...
|
|
|
|
|
No, each try and catch have to have their own code?
Why do you have a lot of try-catch blocks. You generally only want to be writing them if you have a specific recovery in mind. If not, it's better to just let the exception propagate up to the caller.
|
|
|
|
|
Is there any source of information and samples about using MIDI in
C# ? If not, where should I start to research if I want to program
an application that "talks" with my MIDI instruments?
Thx in advance.
C.N.
|
|
|
|
|
possible try looking into directx 9 it has support for midi i noticed...but then agian i havent tested it really so this is just a guess....but it does have full C# compatiblity...and playing audio with dx9 is super easy.....good luck
Jesse M
The Code Project Is Your Friend...
|
|
|
|
|
|
I need to be able to verify that a UserID (in the format DOMAIN\USERID) is a valid user on a domain. In VB6 I used API, but I was hoping that C# had a better way. Any help would be much appreciated. Thanks in advance.
-Andy
|
|
|
|
|
Hi,
How can I create Property Pages and Property sheets using the .net framework ?
Thanks in advance
Braulio
|
|
|
|
|
I have some data from DataTable to DataGrid.
I want to search data by some field and
display his record in a DataGrid, but the data in a
DataGrid is sorted by some column and order of records
in a DataSource and DataGrid is not same. After the
finding this record DataGrid not displays correct
record (reason is a sort).
Questio:
How can i to get data imediately from DataGrid cell (if
i know current row number and column number in a grid)
without his DataSource(DataTable)?
very thanks.
|
|
|
|
|
Getting data immediately from DataGrid (see Item in help; DataGrid (Win) Members):
object mydata=myDataGrid[rowNo,columnNo];
You can use DataView used by DataGrid. It's sorted in thesame way as displyed
in DataGrid, so You can use CurrentRowIndex property. This DataView You can get from:
1. DataSource (if it's a DataSet or DataTable) by DefaultView property of DataTable (it's not a good way I think ... I can't speak English well)
2. ListManager.List protected property of DataGrid (only in inherited class)
3. DataBinding (complicated way)
But if You can get DataView it's very pleasant object to use ...
Hi,
AW
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
