Click here to Skip to main content
15,905,508 members
Home / Discussions / C#
   

C#

 
GeneralRe: & missing Pin
Rob Philpott3-Jun-09 2:19
Rob Philpott3-Jun-09 2:19 
AnswerRe: & missing Pin
Moreno Airoldi3-Jun-09 1:24
Moreno Airoldi3-Jun-09 1:24 
QuestionSybase connection error... Pin
The_Collector3-Jun-09 0:24
The_Collector3-Jun-09 0:24 
AnswerRe: Sybase connection error... Pin
Moreno Airoldi3-Jun-09 0:40
Moreno Airoldi3-Jun-09 0:40 
GeneralRe: Sybase connection error... Pin
The_Collector3-Jun-09 4:00
The_Collector3-Jun-09 4:00 
GeneralRe: Sybase connection error... Pin
Moreno Airoldi3-Jun-09 5:21
Moreno Airoldi3-Jun-09 5:21 
GeneralRe: Sybase connection error... Pin
The_Collector3-Jun-09 14:36
The_Collector3-Jun-09 14:36 
QuestionException when making a control button Pin
gwithey3-Jun-09 0:08
gwithey3-Jun-09 0:08 
AnswerRe: Exception when making a control button Pin
Moreno Airoldi3-Jun-09 0:21
Moreno Airoldi3-Jun-09 0:21 
AnswerRe: Exception when making a control button Pin
Rob Philpott3-Jun-09 0:21
Rob Philpott3-Jun-09 0:21 
GeneralRe: Exception when making a control button Pin
gwithey3-Jun-09 0:56
gwithey3-Jun-09 0:56 
QuestionHow to encapsulate C++ in C# Pin
sbotz2-Jun-09 23:55
sbotz2-Jun-09 23:55 
AnswerRe: How to encapsulate C++ in C# Pin
Simon P Stevens3-Jun-09 1:02
Simon P Stevens3-Jun-09 1:02 
GeneralRe: How to encapsulate C++ in C# Pin
sbotz3-Jun-09 1:20
sbotz3-Jun-09 1:20 
GeneralRe: How to encapsulate C++ in C# Pin
Simon P Stevens3-Jun-09 3:16
Simon P Stevens3-Jun-09 3:16 
GeneralRe: How to encapsulate C++ in C# Pin
Dave Kreskowiak3-Jun-09 3:24
mveDave Kreskowiak3-Jun-09 3:24 
Questioncross thread events Pin
spiritboy2-Jun-09 23:55
spiritboy2-Jun-09 23:55 
AnswerRe: cross thread events Pin
Moreno Airoldi3-Jun-09 0:15
Moreno Airoldi3-Jun-09 0:15 
GeneralRe: cross thread events Pin
harold aptroot3-Jun-09 0:22
harold aptroot3-Jun-09 0:22 
AnswerRe: cross thread events Pin
S. Senthil Kumar3-Jun-09 9:12
S. Senthil Kumar3-Jun-09 9:12 
QuestionProblem with multiple versions of references Pin
vijaylumar2-Jun-09 23:47
vijaylumar2-Jun-09 23:47 
Questionmysql connect + retrieving record Pin
benjamin yap2-Jun-09 23:40
benjamin yap2-Jun-09 23:40 
Hi, i am using mysql connector for my C# project.

I want to retrieve all the values from the database where username = "testing"

Database.cs

public MySqlDataReader getAccountDetails(String username)<br />
{<br />
    Connect();<br />
    command = conn.CreateCommand();<br />
    command.CommandText = "Select * from accounts where admin_num  ='" + username + "'";<br />
    reader = command.ExecuteReader();<br />
    Close();<br />
    return reader;<br />
}


frmMain.cs

private void frmMain_Load(object sender, EventArgs e)<br />
{<br />
    toolStripDateLabel.Text = DateTime.Now.ToString();<br />
    db.Connect();<br />
    MySqlDataReader reader = db.getAccountDetails(username.ToString());<br />
    <br />
    while (reader.Read())<br />
    {<br />
        string thisrow = "";<br />
        for (int i = 0; i < reader.FieldCount; i++)<br />
            thisrow += reader.GetValue(i).ToString() + ",";<br />
        listBox1.Items.Add(thisrow);<br />
    }<br />
    db.Close();<br />
}<br />

it gives me an error "Invalid attempt to Read when reader is closed."
AnswerRe: mysql connect + retrieving record Pin
Blue_Boy2-Jun-09 23:52
Blue_Boy2-Jun-09 23:52 
AnswerRe: mysql connect + retrieving record Pin
Moreno Airoldi2-Jun-09 23:58
Moreno Airoldi2-Jun-09 23:58 
GeneralRe: mysql connect + retrieving record Pin
benjamin yap3-Jun-09 0:01
benjamin yap3-Jun-09 0:01 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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