C# Discussion Boards - CodeProject

3-Jun-09 1:12

Hi, my database has a column called 'course'. I have a value "Game & Entertainment Technology"

when i extract the value using

acc.Course = reader.GetValue(4).ToString();<br />
lblCourse.Text += " " + acc.Course.ToString();

the value becomes Game Entertainment Technology.. the & disappear

Rob Philpott3-Jun-09 1:21

3-Jun-09 1:21

That's because & is used to underline a letter for a shortcut. You need to double it to &&.

acc.Course = reader.GetValue(4).ToString();
lblCourse.Text += " " + acc.Course.ToString().Replace("&", "&&");

Regards,
Rob Philpott.

Rob Philpott3-Jun-09 1:24

3-Jun-09 1:24

Actually, presuming reader is a SqlDataReader and acc.Course is a string you can shorten this to:

acc.Course = reader.GetString(4);
lblCourse.Text += " " + acc.Course.Replace("&", "&&");

Regards,
Rob Philpott.

benjamin yap3-Jun-09 1:26

3-Jun-09 1:26

thanks alot!

1 more question. My first screen is a login screen. Therefore i have a username and password textbox.

private void btnLogin_Click_1(object sender, EventArgs e)<br />
{<br />
    bool validate = db.authenticate(tbxUsername.Text, tbxPassword.Text);<br />
    if (!validate)<br />
    {<br />
        MessageBox.Show("Invalid Credentials");<br />
    }<br />
    else<br />
    {<br />
        frmMain main = new frmMain(tbxUsername.Text);<br />
        <br />
        main.Show();<br />
        this.Hide();<br />
        <br />
    }<br />
}

Is it possible to close the login form instead of hiding it? I do a this.close() but after i login everything close.

Also, my db.authenticate is not case sensitive. The password in the database is 'test'. However when i entered 'TEST', it works too.

Henry Minute3-Jun-09 1:33

Henry Minute

3-Jun-09 1:33

If the login form is the first one created and called from Program.cs, the application classes it as the 'Main' form of the application. When the main form closes, the application closes.

There are loads of examples of using a login form on the web, have a quick google to see how to do it.

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.”

benjamin yap3-Jun-09 1:38

3-Jun-09 1:38

Okay. Noted. Thanks

What bout make the password and username case sensitive?

Henry Minute3-Jun-09 2:03

Henry Minute

3-Jun-09 2:03

You stated that db.authenticate was not case sensitive. I can not find any reference to an authenticate method for any database related classes, so I assume that it is one you have written yourself.
If that is so, take a look at this[^].

I not, I am unable to help.

benjamin yap3-Jun-09 3:52

3-Jun-09 3:52

thanks. i found the solution.

inside phpmyadmin, i change the collation to latin1_general_cs.

cs refers to case sensitive

Rob Philpott3-Jun-09 2:19

3-Jun-09 2:19

Certainly you'd want to close the login screen when you're finished with it. There are a few ways to do this. Also, you don't want to do a main.Show() in the login screen - you lose reuse and abstraction if you do that by tightly coupling the login and main screen.

To open the main screen after the login either call ShowDialog() on the login form from the main form's on load event or you can change your main() function to look like this:

[STAThread]
static void Main()
{
	Application.EnableVisualStyles();
	Application.SetCompatibleTextRenderingDefault(false);
	Application.Run(new LoginForm());
	Application.Run(new MainForm());
}

Regards,
Rob Philpott.

Moreno Airoldi3-Jun-09 1:24

Sybase connection error...

3-Jun-09 1:24

Ampersand "&" is used as a special character in Windows Forms controls: it will cause the next character to be underlined. You can solve your problem by replacing each ampersand with a double ampersand.

Try something like:

lblCourse.Text += " " + acc.Course.ToString().Replace("&", "&&");

2+2=5 for very large amounts of 2
(always loved that one hehe!)

The_Collector3-Jun-09 0:24

The_Collector

3-Jun-09 0:24

I'm trying to connect to Sybase Server (Adaptive Server Anywhere 6.0) from my C# application but failed to establish a connection.... it seems the C# use a default MSSQL driver. Below is the error:

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

below is the code:

//string bartsConnect = "Driver={Adaptive Server Anywhere 6.0};SRVR=MyServer;DB=MyDatabase;UID=myUserId;PWD=myPassword";

string myConnection = "server=ServerName;Database=myDatabase;uid=myUserId;pwd=myPassword";
SqlConnection myConnection = new SqlConnection(myConnection);
myConnection.Open();

hope to hear some answers soon,,,, thank you.

xxx

Moreno Airoldi3-Jun-09 0:40

3-Jun-09 0:40

You are using an SqlConnection, which is specifically for SQL Server.

Try to use an OleDbConnection and you should be all right. Smile | :)

2+2=5 for very large amounts of 2
(always loved that one hehe!)

The_Collector3-Jun-09 4:00

The_Collector

3-Jun-09 4:00

yes, thank you but my problem is the connection string that i can be use to connect to Sybase(Adaptive Server Anywhere 6.0)... most of the examples in the net use access database..... can u give me the right connection string for the above server?...

xxx

Moreno Airoldi3-Jun-09 5:21

3-Jun-09 5:21

Sorry I have no experience with Sybase, so I cannot help you with connection strings.

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Exception when making a control button

The_Collector3-Jun-09 14:36

The_Collector

3-Jun-09 14:36

thax anyway......

xxx

gwithey3-Jun-09 0:08

gwithey

3-Jun-09 0:08

I am trying to make a button to represent a volume control knob such as on a CD player in c#

The following error has croped up and i cant find any "Useful" information on what could be wrong.

Does anyone know how to resolve this Exception:

"WindowsFormsControlLibrary1.dll' doesn't contain any UserControl types."

Why would the namespace not contain a user control or could i have not linked the dll properly?

Thanx

Re: Exception when making a control button

Moreno Airoldi3-Jun-09 0:21

Re: Exception when making a control button

3-Jun-09 0:21

I guess you get this error when you try to run your solution (F5) inside Visual Studio.

You cannot directly run a dll, you should set up an executable project in your solution and make it the "Startup Project" for the solution.

For example, create a new Windows Form executable and link your dll in it, in order to test your custom button.

2+2=5 for very large amounts of 2
(always loved that one hehe!)

Rob Philpott3-Jun-09 0:21