Click here to Skip to main content
15,881,938 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionWPF Datagrid from XML Pin
Member 1007423926-Jul-14 22:19
Member 1007423926-Jul-14 22:19 
QuestionDirectinput error Pin
mr.kage26-Jul-14 4:27
mr.kage26-Jul-14 4:27 
AnswerRe: Directinput error Pin
Dave Kreskowiak26-Jul-14 10:10
mveDave Kreskowiak26-Jul-14 10:10 
AnswerRe: Directinput error Pin
ZurdoDev28-Jul-14 8:01
professionalZurdoDev28-Jul-14 8:01 
AnswerRe: Directinput error Pin
Gerry Schmitz28-Jul-14 10:13
mveGerry Schmitz28-Jul-14 10:13 
QuestionExchange 2010 - Out Of Office Rule Pin Pin
Serrurier Toulon19-Jul-14 8:44
Serrurier Toulon19-Jul-14 8:44 
AnswerRe: Exchange 2010 - Out Of Office Rule Pin Pin
Eddy Vluggen21-Jul-14 3:17
professionalEddy Vluggen21-Jul-14 3:17 
QuestionFatal error encountered during command execution asp.net C# Pin
ven75319-Jul-14 4:38
ven75319-Jul-14 4:38 
Hi i have created one web application and in that i need to read the data from Mysql database and bind to gridview.

I have written Mysql query as follows
SELECT @row_number:=@row_number+1 AS row_number,Name FROM tablename, (SELECT @row_number:=0) AS r

After running in Mysql in database it will and work show the result.

But if take same query and execute through C# code below error is coming.

An exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll but was not handled in user code

Additional information: Fatal error encountered during command execution.

and i will get Break or continue pop up. If i give continue it will show Parameter '@row_number' must be defined.
even i defined like int @row_number = 0; but same error.

I need to achieve serial number as shown below

ex in database
slno name
10102 nama1
2123 name2
5203 name3

result
1 nama1
2 name2
3 name3

how to achieve this. If anybody knows please reply me.

Thanks in advance.
AnswerRe: Fatal error encountered during command execution asp.net C# Pin
Eddy Vluggen21-Jul-14 3:15
professionalEddy Vluggen21-Jul-14 3:15 
QuestionThe Operation Has time out problme while sending SMS Pin
hareshdgr810-Jul-14 21:01
hareshdgr810-Jul-14 21:01 
AnswerRe: The Operation Has time out problme while sending SMS Pin
Dave Kreskowiak11-Jul-14 1:39
mveDave Kreskowiak11-Jul-14 1:39 
SuggestionRe: The Operation Has time out problme while sending SMS Pin
jinzai17-Jul-14 0:57
jinzai17-Jul-14 0:57 
AnswerRe: The Operation Has time out problme while sending SMS Pin
jinzai17-Jul-14 1:09
jinzai17-Jul-14 1:09 
Questionis it possible to sample my screen? Pin
neodeaths7-Jul-14 13:24
neodeaths7-Jul-14 13:24 
AnswerRe: is it possible to sample my screen? Pin
Dave Kreskowiak7-Jul-14 15:25
mveDave Kreskowiak7-Jul-14 15:25 
GeneralRe: is it possible to sample my screen? Pin
neodeaths7-Jul-14 17:12
neodeaths7-Jul-14 17:12 
GeneralRe: is it possible to sample my screen? Pin
Dave Kreskowiak7-Jul-14 17:45
mveDave Kreskowiak7-Jul-14 17:45 
AnswerRe: is it possible to sample my screen? Pin
PIEBALDconsult7-Jul-14 15:42
mvePIEBALDconsult7-Jul-14 15:42 
AnswerRe: is it possible to sample my screen? Pin
Tino Fourie12-Jul-14 11:46
Tino Fourie12-Jul-14 11:46 
QuestionDetect when iOS or Android connected to PC Pin
Becky Alpha5-Jul-14 13:41
Becky Alpha5-Jul-14 13:41 
AnswerRe: Detect when iOS or Android connected to PC Pin
Eddy Vluggen7-Jul-14 7:15
professionalEddy Vluggen7-Jul-14 7:15 
AnswerRe: Detect when iOS or Android connected to PC Pin
jschell7-Jul-14 10:04
jschell7-Jul-14 10:04 
GeneralRe: Detect when iOS or Android connected to PC Pin
EYESTRA1N17-Jul-14 8:33
EYESTRA1N17-Jul-14 8:33 
GeneralAn unhandled exception of type 'System.Net.Sockets.SocketException' occurred in System.dll Pin
ganeshmyname28-Jun-14 6:39
ganeshmyname28-Jun-14 6:39 
GeneralRe: An unhandled exception of type 'System.Net.Sockets.SocketException' occurred in System.dll Pin
Dave Kreskowiak28-Jun-14 9:57
mveDave Kreskowiak28-Jun-14 9:57 

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.