hi
I have this function:
public string GetContent(string tabel, string column, int id)
{
string select="select "+ column + " from " + tabel +" where id=("+id.ToString()+")";
MessageBox.Show(select);
SqlCommand com = new SqlCommand(select, connection);
com.CommandType = CommandType.Text;
SqlDataReader rd = com.ExecuteReader(CommandBehavior.SingleRow);
rd.GetString(0);
}
i get a exeception : "Invalid attempt to read when no data is present."
but trust me there is data.. if i set it up to a tableadapter.. it shoes the correct data..
so what is wrong here
sqldataread problem
Hot Topic
Visual C#
- The IDE often automatically changes the file subtype from "Form" to "Code" in the .csproj file
- How do I compare two TimeSpan objects to see if they overlap
- Checking for internet connection!
- Delay an application
- 'My' in Vb.net
- back to the line error after error occurred
- Error during installing after publishing the app
- how can i create a class or struct and assign it a string value?
- SDK for software license keys?
- enum Property
sqldataread problem
Satinay
You need to read the data from the reader first with Read() method
if (rd.Read() == true)
{
strColumn = rd.GetString(0);
}
JBA123
Hi,
I have the same problem and I tried your solution but it even complains at "if (rd.Read() == true)". The query does return a value (I can see it in query analyzer) but SqlDataReader seems to disagree with me. Could you give me a hand
Thank you!
c#oder
Can you provide some sample code how you get the datareader
Espen S