Re: C# and SQL Project - C# Discussion Boards

Michael Fritzius22-Jan-09 4:22

22-Jan-09 4:22

Hi everybody,

I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table.

I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first:

1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password?

2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server Smile | :)

Thanks for entertaining a complete noob about SQL.

Take care,

Michael Fritzius

Re: C# and SQL Project

led mike22-Jan-09 4:40

led mike

22-Jan-09 4:40

1) There are many options. Today the most notable is to place one or more web services behind the firewall and use them to interface with from the client.

2) I don't understand the question. How do you get a server?

led mike

Re: C# and SQL Project

Michael Fritzius22-Jan-09 4:52

Michael Fritzius

22-Jan-09 4:52

led mike wrote:
2) I don't understand the question. How do you get a server?

I meant how to get an SQL server running someplace. Something with a database on it that I can run my program against to check and see that the correct info is being added/read at the server. What would you recommend?

Re: C# and SQL Project

EliottA22-Jan-09 5:01

EliottA

22-Jan-09 5:01

Install either MySQL server or MSSQL express, both are free and you won't have to worry about firewalls and what not. You can learn how to interact C# and SQL easily here.

Good luck!

Re: C# and SQL Project

led mike22-Jan-09 5:03

led mike

22-Jan-09 5:03

For testing any workstation can operate as a server for just about everything other than load/stress testing. In many cases I have everything running on my developer workstation for developing. Then things get installed in test labs for real testing.

You probably want to start digging into Security issues sooner rather than later.

led mike

Re: C# and SQL Project

Wendelius22-Jan-09 4:50

Wendelius

22-Jan-09 4:50

Michael Fritzius wrote:
if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password?

One way is to build a three-tiered application or if you want to do this like client-server, you would need (secure) ip-connection through the firewall. Connection string is exactly what you described: ip,port (or server name), username and password.

Michael Fritzius wrote:
How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server

If you mean how would you get a database, you could use for example SQL Server Express Edition[^].

The need to optimize rises from a bad design.My articles[^]

Re: C# and SQL Project

Michael Fritzius23-Jan-09 4:26

Michael Fritzius

23-Jan-09 4:26

Ok, so I'm trying to get SQL Express on my home machine. Already tried downloading and installing it on the work machine, but for whatever reason it didn't work. This is fine, because I don't really want to develop this project on the work PC anyway.

...and it looks like I might be over my head on this. Is SQL supposed to be this hard to install?

Has anyone been successful with getting some version of the server installed and functioning properly that would be willing to walk me through the process OR point me to a tutorial on how to do it?

Thanks muchly,
Michael Fritzius

Re: C# and SQL Project

Michael Fritzius26-Jan-09 3:57

Michael Fritzius

26-Jan-09 3:57

Hi all, and thanks for all the help so far.

I've successfully gotten SQL Server 2008 running on my home machine, and can make databases, add rows/columns, everything I would need for this project.

Also, the program written to interface with the server at the local level works great.

Now I'm trying to log onto the same server and use the program to access the server remotely, from a computer on the same network, but having no success.

It gives me the following error: Login failed for user XXXX/Guest.

I know the info is getting to the server just fine, because of the nature of the error, and because I ran Wireshark to see if info was getting passed, and it was.

And, I've looked on Google and on here for a solution, but nothing seems to help.

I know that there needs to be a username/password on the SQL server itself so it knows if it can accept the incoming connection. Already tried this, but it didn't work, so I know I did something wrong... just don't know what.

If you know the answer, please help.

Thanks for all your suggestions so far and take care,
Michael Fritzius

GetDriveName in C#

mulugheta22-Jan-09 4:00

mulugheta

22-Jan-09 4:00

Hi Everybody

In VB6 we can call GetDriveName of FileSystemObject. But i don't know how it work with in c#.

Could you please help me?

THank you

Re: GetDriveName in C#

Ben Fair22-Jan-09 4:04

Ben Fair

22-Jan-09 4:04

Use DriveInfo.GetDrives(), from the System.IO namespace.

Keep It Simple Stupid! (KISS)

Re: GetDriveName in C#

mulugheta22-Jan-09 4:13

mulugheta

22-Jan-09 4:13

If you are look for lists of Drives you are right. But i am look for drive name from a give absolute path of a file.

Re: GetDriveName in C#

Ben Fair22-Jan-09 4:34

Ben Fair

22-Jan-09 4:34

OK, in that case use Path.GetPathRoot(), also in the System.IO namespace.

Keep It Simple Stupid! (KISS)

Re: GetDriveName in C#

EliottA22-Jan-09 5:01

EliottA

22-Jan-09 5:01

Short, simple and correct. 5

How do i retrieve the directory of multiple images file without hard code ?

Lim Yuxuan22-Jan-09 3:45

Lim Yuxuan

22-Jan-09 3:45

Hi. I had a photo album project and I was wondering is there anyway to retrieve the directory of images with minimum hardcoding ?

What I am currently doing now is this :

//prefix of the directory of large images
const string strLargePrefix = "/images/large/";

//suffix of the directory of large images
const string strLargeSuffix = "_large.jpg";

//group the pictures together with each of them assigned with a reference number
enum enuImages
{
//note that the first image will have its reference number
//as its position number-1.Example: 2nd image = 2-1 = reference number 1
cHTP3 =0, //1st image
cppHTP4 = 1, //second image
csharpFEP1 = 2,//third image
jHTP4 = 3, //4th image
jwsFEP1 =4, //5th image
vbnetFEP1 = 5 //6th image
}

RetrieveData()
{
// An enumeration object that represents the images based on their
// reference number. Initial reference set to 1st image

enuImages m_Images = 0;

//Array index of the image to be stored at base on their reference number.
//Index number has the same value as reference number.

int intIndex = 0;

//Retrieve directory path of the Large images and sort them
for (intIndex = 0; intIndex < int_TotalImages; intIndex++ )
{
strLargeImage[intIndex] = Directory.GetCurrentDirectory() +
strLargePrefix + m_Images + strLargeSuffix;
m_Images++;//increment the reference number to represent next image
}// end for loop
}

I dont really like the idea of grouping the images together because I have to hard code the names of the image file. But I have no choice as it works with the for loop. Is there any method that behaves like the file.ReadAllLines() that can retrieve all the images from that folder and return them as a form of array ?

Re: How do i retrieve the directory of multiple images file without hard code ?

Ben Fair22-Jan-09 4:11

Ben Fair

22-Jan-09 4:11

Sure, it is basically just a file search operation for image file types. Use the DirectoryInfo.GetFiles() method with one of the overloaded versions that allows you to pass a file search pattern (*.gif, for example). The GetFiles() method is an instance method so you have to create an instance of the DirectoryInfo object for the directory you're working with. Also, one of the overloads allows you have it search subdirectories, which is pretty handy if your files may be in multiple subfolders.

Keep It Simple Stupid! (KISS)

Re: How do i retrieve the directory of multiple images file without hard code ?

Lim Yuxuan22-Jan-09 15:13

Lim Yuxuan

22-Jan-09 15:13

Thanks

How to upload an email in to VSS through Dotnet coding

mforMurali22-Jan-09 2:43

mforMurali

22-Jan-09 2:43

Hi,
This is murali.I have one question.
How to upload an email in to VSS through Dotnet coding?

If any one knows,Please let me know.

Thanks,
Murali

Re: How to upload an email in to VSS through Dotnet coding

Wendelius22-Jan-09 3:17

Wendelius

22-Jan-09 3:17

I suppose, one way could be that you save the email to a file (for example to an eml-file if it's from Outlook), and after that you add the file to Source Safe. This would require using interop against Outlook and Source Safe.

The need to optimize rises from a bad design.My articles[^]

How to count a string for \ character?

Matjaz-xyz22-Jan-09 2:08

Matjaz-xyz

22-Jan-09 2:08

Hi. I just cant get this to work right! Frown | :(

I tried two ways... yeah... only one is correct... but the returned value is not correct.

This is my function:

public void DoYourThingBaby()
        {
            string pot = @Application.StartupPath + @"\" + lstFILES.SelectedItem;
            StreamReader sr = new StreamReader(pot);
            string tempF = sr.ReadToEnd();
            sr.Close();

            char[] tempC = tempF.ToCharArray();

// this
            int stevc=0;
            foreach(char chr in tempC)
                if(chr=='\')
                    stevc++;

// or this
            label1.Text = Convert.ToString(tempF.IndexOf(@"\", 30));
        }

the code counts something... but its not the right characters.
i tried it with my file. if i count it in ultraedit - there are 18 characters '\'.
with my application - around 300 Big Grin | :-D

help please Smile | :)

?

thanks in advance

Regards,
Matjaž

Re: How to count a string for \ character?

Rob Philpott22-Jan-09 2:23

Rob Philpott

22-Jan-09 2:23

Wild guess - something to do with Unicode/CodePage? If you open the file up using the binary editor is every other character zero?

Regards,
Rob Philpott.

Re: How to count a string for \ character?

Matjaz-xyz22-Jan-09 2:36

Matjaz-xyz

22-Jan-09 2:36

Ok. Dont know why my solution didnt work... but i've modified it a bit - a bit of a hax :P

If i putted '\\' char to search... it found something. What did it found - i dont know... but it wasn't right.

So, i've tried this - created a new textbox and enter one character inside - the '\'. And with this IT WORKED.

So, here is the new code, that works if anyone's intrested.
PS: thanks for your reply Rob.

public void DoYourThingBaby()
        {
            
            string pot = @Application.StartupPath + @"\" + lstFILES.SelectedItem;
            StreamReader sr = new StreamReader(pot);
            string tempF = sr.ReadToEnd();
            sr.Close();

            char[] tempC = tempF.ToCharArray();

            //textBox1.Text = tempF;

            int stevc=0;
            foreach(char chr in tempC)
                if(chr==Convert.ToChar(textBox1.Text))
                    stevc++;

            
        }

Regards,
Matjaž

Re: How to count a string for \ character?

J4amieC22-Jan-09 2:41

J4amieC

22-Jan-09 2:41

Can I ask what the point in the final 3 lines are below?

Matjaž Grahek wrote:
string pot = @Application.StartupPath + @"\" + lstFILES.SelectedItem;
StreamReader sr = new StreamReader(pot);
string tempF = sr.ReadToEnd();
sr.Close();

Seems a bit of a WTF to me.

Re: How to count a string for \ character?

Matjaz-xyz22-Jan-09 3:48

Matjaz-xyz

22-Jan-09 3:48

Bah... it IS WTF Smile | :)

but its easier for my understanding... dont even bother with this.

Programming is cool because of this - you have soooooo many different ways to make a program work.

Regards,
Matjaž

Re: How to count a string for \ character?

Ben Fair22-Jan-09 4:31

Ben Fair

22-Jan-09 4:31

Just Split() the string on the char you want to count, the count will be the number of resulting array elements minus 1 (have to escape the backslash as '\\'). Most likely your results were thrown off by the escaping of special characters in the text (CRLF becomes \r\n, TAB becomes \t, etc.) and perhaps it brought them over into the char[] in that manner. Either way, this will do the trick:

public void DoYourThingBaby()
{
    string pot = @Application.StartupPath + @"\" + lstFILES.SelectedItem;
    if(!System.IO.File.Exists(pot))
        return;
    int count = System.IO.File.ReadAllText(pot).Split('\\').Length - 1
}

Keep It Simple Stupid! (KISS)

Re: How to count a string for \ character?

Jon Rista22-Jan-09 4:58

Jon Rista

22-Jan-09 4:58

You can use LINQ to accomplish the same thing in a more expressive manner:

int bkslashCount = 0;
string pot = Path.Combine(Application.StartupPath, lstFILES.SelectedItem); // USE Path.Combine!!
if (File.Exists(pot))
{
    string data = File.ReadAllText(pot);
    bkslashCount = data.ToCharArray().Where(c => c == '/').Count();
}

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