C# Discussion Boards - CodeProject

First Prev Next

Re: SQL Connection dropping

Ennis Ray Lynch, Jr.11-Jun-09 3:15

Ennis Ray Lynch, Jr.

11-Jun-09 3:15

Make sure your connections are properly released. Also, make sure that your application accesses the database in a linear manner. Then make sure that SQL server is properly configured, etc. Your error, unfortunately, has many potential causes. The current project I am working can be built in 2.0 or 3.5 and access the database without an error so it can happen seamlessly depending on your code.

Need custom software developed? I do C# development and consulting all over the United States.

A man said to the universe:
"Sir I exist!"
"However," replied the universe,
"The fact has not created in me
A sense of obligation."
--Stephen Crane

Re: SQL Connection dropping

saurabh sahay11-Jun-09 6:34

saurabh sahay

11-Jun-09 6:34

There must not be any code changes while migrating from 2.0 to 3.5 as framework core(structure) remains the same retaining all previous functionality. All the enchancements are additional to the 2.0.

Looking for a spesific control

teknolog12311-Jun-09 1:53

teknolog123

11-Jun-09 1:53

I saw a control in a program written in VB which is very easy to adjust time and I am looking if it is possible to find the same control for csharp/vs2008. I couldn't post the picture but it's like this: "00:00" Every zero is divided into 2 parts from the middle with a horizontal line and clicking the bottom piece decreases and top part increases the numbers.
do you know such a control?

Re: Looking for a spesific control

Rob Philpott11-Jun-09 2:36

Rob Philpott

11-Jun-09 2:36

'Fraid not. But it sounds like the sort of thing you could do yourself in not too long a time.

Regards,
Rob Philpott.

Re: Looking for a spesific control [modified]

saurabh sahay11-Jun-09 6:36

saurabh sahay

11-Jun-09 6:36

That would be a customized control. You can do that yourself, infact even better and easily with 3.5

modified on Friday, June 12, 2009 7:17 PM

Re: Looking for a spesific control

teknolog12312-Jun-09 7:19

teknolog123

12-Jun-09 7:19

thanks, I will try

Re: Looking for a spesific control

saurabh sahay12-Jun-09 13:18

saurabh sahay

12-Jun-09 13:18

welcome

Datagridview double enter event handler

spikekirk11-Jun-09 1:31

spikekirk

11-Jun-09 1:31

Hi
I have a datagridview of transactions.Does anyone know if there is a way that I can catch an event handler for the double enter keypress.

Thanks
Kirk

Re: Datagridview double enter event handler [modified]

Henry Minute11-Jun-09 2:06

Henry Minute

11-Jun-09 2:06

I do not believe that there is such a thing.

What you might do is handle the keydown/keypress event, test for enter and if so check a flag, if flag is set it's a double enter. If flag not set, set it and start a timer. When timer fires reset flag and stop timer. That way you can select the double enter period for yourself.

[Edit]
Also, if key is not enter, reset the flag.
[/Edit]

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

modified on Thursday, June 11, 2009 8:16 AM

Re: Datagridview double enter event handler

saurabh sahay11-Jun-09 6:38

saurabh sahay

11-Jun-09 6:38

right solution...

Re: Datagridview double enter event handler

Henry Minute11-Jun-09 6:42

Henry Minute

11-Jun-09 6:42

Why, thank you sir! Smile | :)

Re: Datagridview double enter event handler

saurabh sahay11-Jun-09 6:47

saurabh sahay

11-Jun-09 6:47

this is called the smart way of doing Smile | :)

cannot insert into database 2005 using visual c# 2008

Adekolurejo11-Jun-09 1:14

Adekolurejo

11-Jun-09 1:14

Hello,
Please I need very urgent solution to this problem. I have an application writing in C# using sql server 2005 express and visual c# 2008 express. I want to connect and insert data to the database from textbox. Onclick on save button I want the data to be submited into database. I dont want to use the manual way of connecting to databse because the db server will not be on my local maching after the completion of the project. I also want to update retrive data from database and update them as well. Am just learning C# on my own and this is beyond my ability at the moment. Please help me.
Waiting for your kind reply
Thanks,
Ademola

Re: cannot insert into database 2005 using visual c# 2008

Ravi Mori11-Jun-09 1:18

Ravi Mori

11-Jun-09 1:18

I think following link will help you for basic insert,update and delete operations in sql using c#.

Beginners guide to accessing SQL Server through C#

Re: cannot insert into database 2005 using visual c# 2008

Adekolurejo11-Jun-09 11:31

Adekolurejo

11-Jun-09 11:31

Thank you for the link. I'm now stock here

SqlCommand myCommand= new SqlCommand("INSERT INTO table (Column1, Column2) " +
"Values ('string', 1)", myConnection);
The value is given me problem. How do I get the value from textbox before it can be inserted into batabase. I have design my form and i need to get information from user through the textbox whenever they click the save button on the form.
Thanks for your help.
Ademola

Re: cannot insert into database 2005 using visual c# 2008

saurabh sahay11-Jun-09 6:41

saurabh sahay

11-Jun-09 6:41

You may also consider storing all the SQL DB connection information in an XML file instead of hardcoding.

Re: cannot insert into database 2005 using visual c# 2008

Adekolurejo11-Jun-09 11:23

Adekolurejo

11-Jun-09 11:23

Thanks for you answer pleas how do I do that?

Re: cannot insert into database 2005 using visual c# 2008

saurabh sahay12-Jun-09 1:28

saurabh sahay

12-Jun-09 1:28

Use System.Xml.XmlDocument in you code to parse the XML document and extract the database name, connection string and other information and save them into your types objects. Use these type objects normally as you do database interaction and transaction.

BandObject _Get if my toolbar is enable /disable.

Nehal Pandya MCA11-Jun-09 0:57

Nehal Pandya MCA

11-Jun-09 0:57

Hi to all.

I am developing an IE toolbar.

Now I need to know if there is any way to identify status of my Toolbar. i.e. Is My toolbar is enable/disable in IE Which event will fire when Toolbar is disable/enable by user.

Please Help Me.

Windows Service not Installing

Sankalp Verma11-Jun-09 0:23

Sankalp Verma

11-Jun-09 0:23

i have created a windows service using VS2005 and installed it using the installutil.exe. I used the following command to install the service:

installutil /name=MyService /user=<username> /password=<password> <servcieexecutable>

After executing this command I get the output as:

The Commit phase completed successfully.

The transacted install has completed.

But still I can not see the service in services.msc window not Can I see any registry entries for this service. I have admin Privilege on my machine.

Any pointers??

PS: I am using following code to create the service:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.ServiceProcess;
using System.Text;
using System.Collections;
using System.Configuration;
using System.IO;
namespace TestService
{
public partial class myService : ServiceBase
{
public myService()
{
InitializeComponent();
}

protected override void OnStart(string[] args)
{
FileStream fs = new FileStream(@"c:\temp\mcWindowsService.txt",
FileMode.OpenOrCreate, FileAccess.Write);
StreamWriter m_streamWriter = new StreamWriter(fs);
m_streamWriter.BaseStream.Seek(0, SeekOrigin.End);
m_streamWriter.WriteLine(" mcWindowsService: Service Started \n");
m_streamWriter.Flush();
m_streamWriter.Close();
}
/// <summary>
/// Stop this service.
/// </summary>
protected override void OnStop()
{
FileStream fs = new FileStream(@"c:\temp\mcWindowsService.txt",
FileMode.OpenOrCreate, FileAccess.Write);
StreamWriter m_streamWriter = new StreamWriter(fs);
m_streamWriter.BaseStream.Seek(0, SeekOrigin.End);
m_streamWriter.WriteLine(" mcWindowsService: Service Stopped \n"); m_streamWriter.Flush();
m_streamWriter.Close();
}

}
}

Re: Windows Service not Installing

himanshu256111-Jun-09 1:14

himanshu2561

11-Jun-09 1:14

what it is showing in installLog file??
Also check the Event Log

himanshu

Re: Windows Service not Installing

Sankalp Verma11-Jun-09 1:44

Sankalp Verma

11-Jun-09 1:44

Install.log says

"Installing assembly 'C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe
logfile = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.InstallLog
No public installers with the RunInstallerAttribute.Yes attribute could be found in the C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe assembly.
Committing assembly 'C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe
logfile = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.InstallLog
No public installers with the RunInstallerAttribute.Yes attribute could be found in the C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe assembly.
Remove InstallState file because there are no installers.
Installing assembly 'C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe
logfile = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.InstallLog
No public installers with the RunInstallerAttribute.Yes attribute could be found in the C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe assembly.
Committing assembly 'C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe'.
Affected parameters are:
logtoconsole =
assemblypath = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe
logfile = C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.InstallLog
No public installers with the RunInstallerAttribute.Yes attribute could be found in the C:\Documents and Settings\sankalp_verma01\My Documents\Visual Studio 2005\Projects\TestService\TestService\bin\Debug\TestService.exe assembly.
Remove InstallState file because there are no installers."

Event viewer says:
Service cannot be started. The service process could not connect to the service controller

Re: Windows Service not Installing

himanshu256111-Jun-09 2:05

himanshu2561

11-Jun-09 2:05