|
hello..
i am developing an application in asp.net using c# and am getting an error in the command.executenonquery method which throws an exception that the executenonquery requires an open and active connection though just above the call to executenonquery method i have opened the connection as connection.open where connection is a property that gets the connection which has been made from configurationmanager.connectionstring... I know there is no problem with connectionstring coz i have tried executereader and it works fine... To my knowledge the error has something to do vith serverversion... coz when i run the executereader and check the connection object over there, the connection state is open but when i run the nonquery then the connection object shows in its serverversion the follwing string
"ServerVersion = 'command.Connection.ServerVersion' threw an exception of type 'System.InvalidOperationException'"
Plz note that state of connection is closed even after i call the connection.open method...
Plz provide help
haseeb
|
|
|
|
|
Well, it's obvious that your code is broken, or your database server is broken. Seeing your actual code would go a long way to helping us comment on it.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
oh hello
i am trying to insert a record to a table... the executenonquery gives the error that an open connection is rqd... when i replace the same comand with a selectcommand and the method to executereader it works but when its with executenonquery, it doesnt work
haseeb
|
|
|
|
|
hello mr. Graus
I have pasted the code... I am sorry ... Actually i didnt follow u by writin in the other message.. I thought that was a reply to my message and wrote there... Then i realized and pasted the same text in my message area... Also i wasn't online from my pc at that moment and couldnt send in the code... now i got a chance and pasted my code....
Best regards
haseeb
haseeb
|
|
|
|
|
Hi i purchased vs2005,
With that they given sqlserver2005 components,
32 bit 2 cds and 64 bit 2 cds and IA 64 bit 2 cds,
Whats the need of those?,
To develope my website or project those things need?,
Plz help me
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
|
|
|
|
|
The three lots of CDs represent three different types of processors. Install the version that matches your processor.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi thanks for ur reply,
Its need to install or no need of that?,
Becoz i am using sqlserver2000 and vs2005,
For that, the processors cd need?,
With that only we can access our database sqlserver in vs2005?,
Plz guide me
Thanks & Regards,
Mageshh,
please don't forget to vote on the post
modified on Tuesday, February 12, 2008 10:55 PM
|
|
|
|
|
Hai all,
I want to use barcode reader in my application for reading UPC code.I have the device.It should scan the UPC and that UPC code will be displayed in textbox.I dont have any idea about this.So i humbly request you to give some idea or how to do this.
With regards
Lijo
|
|
|
|
|
To do this in ASP.NET, you need to write a winforms/Java or other component that you can embed in your website. This will cause all sorts of issues with people who don't accept/allow that sort of thing to run. There's no way you can do it using ASP.NET.
Why would a website want to run a barcode scanner ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Its my client requerment.They need it in their application.
|
|
|
|
|
Well, then those are your options, you can't just use ASP.NET, you need to be able to embedd something in your web page that is running with the ability to interact with the ports on the system to read barcodes.
Although, some barcode scanners work by entering the barcode scanned as text into the textbox that has focus, I expect that would just work in a web site.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Can u please give some idea or information or usefull link for doing that.Because its necessary for me.Plse help me.
|
|
|
|
|
I've told you all you need to know. If you don't know how to do what I've told you to do, then contact your client and let them know. All I can do from here, is write the code for you, and I'm not going to do that. You cannot read barcodes using HTML and javascript. You can put a textbox up there if the barcode scanner will fill it with text for you, otherwise you need to write a component that is embedded in the page, which means you need to read on how to embedd a .NET control in a page, and read the SDK notes that came with your barcode scanner, to read how to write the actual code that does the scanning.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
In my project correctly working in IE6.
In IE7, while I open any new window using(window.open()), it shows the address.(i give location=no)
Can any one help me how to diable the address bar?
Sutheesh
|
|
|
|
|
I believe this is a security feature - you cannot hide the URL.
|
|
|
|
|
Hi Friend
i am using Split Container in windows application. It work properly. but when i drag split then focus not leave the splitter then how i can leave the focus after the drag. Please Help me
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
|
|
|
|
|
The reason someone gave you a 1 vote, is that this is plainly not an ASP.NET question
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
i know this things but there are few people in windows application and in asp.net full of .net people. so i put question here. if u know answer then give don't take otherwise.
ANSWER:-![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif) SplitContainer1.Panel2.Focus()
Thanks
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
|
|
|
|
|
Piyush Vardhan Singh wrote: but there are few people in windows application and in asp.net full of .net people
Typical response from someone who doesn't care about politeness. Sorry, it doesn't cut it. You spam the boards, with a question that turns out to be quite trivial, and you think you're justified because YOU needed something ? No, that's not how it works. If everyone spammed every board with their questions, we may as well have one board, right ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi All,
Can anyone help me, im trying to return a DataReader as a type in WCF, It must return the DataReader itself.
Thanks in advance
living life on the flip side
|
|
|
|
|
What error you are getting ? I don't think that you can returns a data reader in WCF.
|
|
|
|
|
hi,
there is a problem i m facing now, I want to perform Post Back on User Control which is placed on Page. When i click any server control on user Control, It creates whole page Post Back. Can anyone  guide me how can I stop whole page Post Back when user control call any server events? 
rup
|
|
|
|
|
I think ur trying to say something like this
U just want only a particular part of a page to be refreshed? Is it so?
And which version of framework are u using?
Believe Yourself™ :->™
|
|
|
|
|
yes, Version is Asp.net2.0
rup
|
|
|
|
|
You need to use AJAX for that. Once the page is rendered, there is no separation like user controls. Everything will be considered as a single page, and any controls on that will refresh the entire page.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
