Re: C# application written for Access 2003, will it work on 2007? - C# Discussion Boards

First Prev Next

Re: Database connections

beatles16921-Jan-08 5:21

beatles1692

1-Jan-08 5:21

Hi Here's my suggestion
Have a DataHelper(or DataManager) class that is responsible to do DB management and other stuffs (like opening connections) make it singleton.
It can have a OpenConnection method that opens a new connection and returns it every time you want an open connection.For example

using(SqlDBConnection cnn=DataManager.Instance.OpenConnection())<br />
{<br />
    //do something with connection.<br />
    cnn.Close()<br />
}//Since SqlDBConnection is IDisposable it will dispose automatically<br />

Hamidian

Re: Database connections

beatles16921-Jan-08 5:32

beatles1692

1-Jan-08 5:32

Oh I forgot that you were not using SQL Server.Then replace the SqlDbConnection with OleDbConnection.

Smile | :)

Re: Database connections

Pete O'Hanlon1-Jan-08 10:38

Pete O'Hanlon

1-Jan-08 10:38

It doesn't seem to bad to me. This is (in effect) the way that you would be working with the connections if you were working in a technology like ASP.NET. If the connection is pulled from the Connection Pool then you shouldn't have too many problems.

Deja View - the feeling that you've seen this post before.

My blog | My articles

Drag and Drop Picture boxes?

DSdragondude31-Dec-07 9:41

DSdragondude

31-Dec-07 9:41

I'm using visual C# 2005 to develop software, and I was wondering if certain drag commands could be used to drag a picture box from one window to another and the picture in the picture box onto the other window.

If you need it describing in more detail, then I will.

If this is possible, could someone tell me how to do it?

C# application written for Access 2003, will it work on 2007?

Skcheng31-Dec-07 8:15

Skcheng

31-Dec-07 8:15

Hi there,

I've written a c# application that uses Access 2003 as the backend database. Does anyone know of any potential complications I should be aware of if the the databasse is upgraded to Access 2007? I personally don't think there should be any issues, but wanted to poll the audience to see if anyone's tried it and ran into problems. Thanks!

~~~~~~~~~~~~
Dead | X|

Over-worked, under-paid, glorified "secretary" Sigh | :sigh:

Re: C# application written for Access 2003, will it work on 2007?

Paul Conrad31-Dec-07 8:40

Paul Conrad

31-Dec-07 8:40

Don't think there is going to be any issues. Have done so without any problems.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Re: C# application written for Access 2003, will it work on 2007?

Skcheng31-Dec-07 12:00

Skcheng

31-Dec-07 12:00

Thanks!

~~~~~~~~~~~~
Dead | X|

Over-worked, under-paid, glorified "secretary" Sigh | :sigh:

Re: C# application written for Access 2003, will it work on 2007?

Paul Conrad31-Dec-07 13:05

Paul Conrad

31-Dec-07 13:05

No problem. Only thing that does come to mind, is that I've seen connection strings be a bit different for 2007. But, it shouldn't be something to break your app.

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

msagent output voice file

Muammar©31-Dec-07 7:41

Muammar©

31-Dec-07 7:41

Anyone here knows how to save spoken voice from msagent characters as an output to a wave file??
Thank you guys Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: msagent output voice file

Dave Kreskowiak31-Dec-07 9:10

Dave Kreskowiak

31-Dec-07 9:10

And this has what to do with C#??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: msagent output voice file

Muammar©31-Dec-07 18:40

Muammar©

31-Dec-07 18:40

Dave Kreskowiak wrote:
And this has what to do with C#??

Dave Kreskowiak wrote:
A guide to posting questions on CodeProject[^]

Ok, it's an ActiveX control but come on, it can be implemented in C# and I just wanted to know if there's any way round someone could do it Unsure | :~

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Re: msagent output voice file

Dave Kreskowiak1-Jan-08 6:02

Dave Kreskowiak

1-Jan-08 6:02

Then you should have been more specific. For all we know, you were trying to record stuff from Messenger in an IM session.

No, AFAIK, there isn't a way to do it directly. You'd have to write your app to record the sound just like you were recording from a microphone.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: msagent output voice file

Muammar©1-Jan-08 6:11

Muammar©

1-Jan-08 6:11

Dave Kreskowiak wrote:
Messenger in an IM session.

Did I sound like I was trying this sh*t Laugh | :laugh:

Sorry

, thanks for the tip Dave, I thought so as well but also thought to dig it around in the cp before giving up to recording.. Thanks again Dave Rose | [Rose]

Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)

Navigating a web form

brsecu31-Dec-07 6:31

brsecu

31-Dec-07 6:31

I'm trying to fill in a text box then hit the submit button using httpwebrequest.

Here is a sample using googles home page(just because everyone can use it). I just cant seem to get it to work. Thanks for the help.

string Uri = "http://www.google.com";

string requestString = "q=test&btnG=Clicked";
byte[] requestData = Encoding.UTF8.GetBytes(requestString);

HttpWebRequest request = null;
Stream stream = null;
HttpWebResponse response = null;

// set up request
CookieContainer _cookies = new CookieContainer();
request = (HttpWebRequest)WebRequest.Create(Uri);
request.Proxy = null;
request.CookieContainer = _cookies;
request.Method = "POST";
request.ContentType = "application/x-www-form-urlencoded";
request.ContentLength = requestData.Length;
// make form post
stream = request.GetRequestStream();
stream.Write(requestData, 0, requestData.Length);

// get response
response = (HttpWebResponse)request.GetResponse();

Re: Navigating a web form

DotNetXenon31-Dec-07 7:45

DotNetXenon

31-Dec-07 7:45

Where exactly do you get the error?

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

Datagrid and combo box or drop down list

Saamir31-Dec-07 5:07

Saamir

31-Dec-07 5:07

Hi guys,
Need help please, is it possible to have a drop down list or combo box in a C# datagrid with .NET 1.1? Please advice on how to go about it.

Thank you

Sameer

Re: Datagrid and combo box or drop down list

Justin Perez31-Dec-07 5:24

Justin Perez

31-Dec-07 5:24

No, there is no built in way to do it. What you can do, however, is this: You can get the location of the cell where you would like the combobox, or whatever. You have the location, then dynamically create the control, and set the location to inside the cell that you want it to be in. Then, handle the scroll event of the datagrid, and then get the location of the cell again, and then move the control that you created.

"If an Indian asked a programming question in the forest, would it still be urgent?" - John Simmons / outlaw programmer

I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")

Re: Datagrid and combo box or drop down list

Saamir31-Dec-07 6:14

Saamir

31-Dec-07 6:14

Thank you for your quick response Justin, do you have an example on how to do this?

Thanks

Sameer

Re: Datagrid and combo box or drop down list [modified]

awiesendanger2-Jan-08 2:23

awiesendanger

2-Jan-08 2:23

Its pretty easy, you can just use the ItemTemplate property. Here's an example:

<columns>
<asp:templatecolumn>
<itemtemplate>
<asp:dropdownlist id="ddl" width="150" runat="server"></asp:dropdownlist>
</itemtemplate>
</asp:templatecolumn>
</columns>

To access in code behind, you can use the FindControl method on a datagrid row or cell.

<div class="ForumMod">modified on Wednesday, January 02, 2008 9:04:48 AM</div>

SendKeys Oddity???

tboydva31-Dec-07 3:56

tboydva

31-Dec-07 3:56

I have a small program to monitor a sensor, detect an error state (sensor value goes over a setpoint), then change focus to a running application and send the {END} key to stop acquisition (before bad things happen!). I am using this code which seems to work fine...:

<br />
methodcall....<br />
{<br />
                Process pr = new Process();<br />
                pr = Process.GetProcessesByName("PeakSimple329")[0];<br />
                IntPtr psHandle = pr.MainWindowHandle;<br />
<br />
                // Try and get process of interest, get main window handle<br />
                // Get a handle to PeakSimple application. The window class<br />
                // and window name were obtained using the Spy++ tool.<br />
                // Verify that PeakSimple is a running process.<br />
                if (psHandle == IntPtr.Zero)<br />
                {<br />
                    MessageBox.Show("Peak Simple is not running.");<br />
                    return;<br />
                }<br />
<br />
                // Make PeakSimple the foreground application and send it <br />
                // the <end> key to stop acquisition.<br />
                SetForegroundWindow(psHandle);<br />
                SendKeys.SendWait("{END}");<br />
                SendKeys.Flush();</end>

}

<br />
<br />
        // Activate an application window.<br />
        [DllImport("USER32.DLL")]<br />
        public static extern bool SetForegroundWindow(IntPtr hWnd);<br />

This works perfectly "the first time." So if I reset the my C# application (to start monitoring again) and restart a run on the PeakSimple program, when triggered, the method call will set focus to PeakSimple, but won't send the {END} key anymore? If I shut down my C# app, then re-run it, the method call will work???? I added the SendKeys.Flush() command, thinking perhaps it would "clean up" any reference to previous key sends, but it doesn't help. I tried to Invalidate() the form, again to no avail.... I can't figure what "state" needs to be flushed, reset or invalidated to make the SendKeys.X command work a second time within a running C# app? I tried just doing a SendKeys.Send("{END}") instead of the SendWait which works, but also only the first time (I have to restart the app to get it to work "again"). If I set breakpoints, it goes through the code and performs the SendKeys.SendWiat or .Send method, but it doesn't actually "send" the key-stroke on subsequent calls to the method??? I must be missing something, but I can't find anything in my searching that explains this behavior??? Any help appreciated...

Thanks!

TextBox indentation???

JoZ CaVaLLo31-Dec-07 2:24

JoZ CaVaLLo

31-Dec-07 2:24

Hi, I have 1 TextBox with the follwing properties:

<br />
tbx1.Size = new System.Drawing.Size(155, 28);<br />
tbx1.MultiLine = true;<br />

and an other one like this

<br />
tbx2.Size = new System.Drawing.Size(155, 14);<br />
tbx2.MultiLine = false;<br />

Why, on the screen, tbx1 has an indentation of one space? I don't like to see the texts not aligned. Does some body have any idea?

Happy new year to everybody!!!

Life is not short... the problem is only how you organize yourself

Re: TextBox indentation???

Justin Perez31-Dec-07 2:25

Justin Perez

31-Dec-07 2:25

Are you sure that tbx1 doesn't have a space in the text field of the Properties window?

Re: TextBox indentation???

JoZ CaVaLLo31-Dec-07 2:49

JoZ CaVaLLo

31-Dec-07 2:49

Here is the string

"this controls contains the alue of it self I will see how many lines are there"

and here is what I can see in the tbx1
--------------------------------
this controls contains the alue
of it self I will see how many
--------------------------------

and this is what I have in tbx2
--------------------------------
this controls contains the alue
--------------------------------

But if I set the properties of tbx2 like tbx1, I have the same indentation... the question is: why when I have a multiline textbox I have this indentation?

Life is not short... the problem is only how you organize yourself

Re: TextBox indentation???

Skippums31-Dec-07 7:40

Skippums

31-Dec-07 7:40

Is your text align set to Center or Right? If so, change it to left. I simply don't see any other way they could be different. In the designer I typed the same thing in two textboxes (one single-line and one multi-line) and the text lined up just fine. If the fonts are the same, they should line up. Any additional info you can give may help.

Sounds like somebody's got a case of the Mondays

-Jeff

How to get the values of dynamic fileupload

Elena200631-Dec-07 1:49

Elena2006

31-Dec-07 1:49

Hi
How to get the values of dynamic fileupload controls in Submit button click without using AJAX.

I am creating the control/setting the IDs at runtime.

FileUpload uploadDataFile = new FileUpload();
uploadDataFile.ID = "FileUpload1";

Thanks in advance

Last Visit: 31-Dec-99 18:00 Last Update: 2-May-24 8:41

Refresh

ᐊ Prev 1...7873 7874 7875 787678777878 7879 7880 7881 7882 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.