|
Hi All,
I am Atheeq Software Developer in VB.Net using backend SQL2000. I need help in writing Sql Query in VB.Net. Please any body help me how to write the following code in VB.Net procedure.
Select 'AsplData','Select * from Customer order by customer','C:\test.xls'
Best Regards
Atheeq
India
|
|
|
|
|
Atheeque wrote: Select 'AsplData','Select * from Customer order by customer','C:\test.xls'
Would you mind describing what you want this to do?? It doesn't mean anything in the form you've prsented it.
|
|
|
|
|
I am a vb user(addict) from vb1 up till vb6.
Trying to decide where to go (I am 68 years old)
How long can I keep on using VB6?
What would be an interesting update?
Presently a am designing a system to send alarmmessages across
the net to afully automated alarmcontroll centre.
suggestions welcome
Mark
|
|
|
|
|
johnsevennl wrote: How long can I keep on using VB6?
"Can" or "should"?? In either case, IMHO, that time has long since past. Your about 3 versions of VB.NET behind.
johnsevennl wrote: What would be an interesting update?
VB.NET 2005 or 2008. You'd probably be surprised to find you've been wasting your time writing code for so much basic stuff that comes standard in the .NET Framework.
|
|
|
|
|
Thanks for replying. I just downloaded VB express 2008.
I felt more comfortable when I tried it.
Do I miss much not using the full blown version?
Regards Mark
|
|
|
|
|
If following VB6, probably not missing much from the professional version. But you may find new stuffs that you will want to make use of in Visual Studio (ie Mobile Device Dev).
Here's a comparison chart for VS2005, VS2008 shouldn't be very far off (Haven't found the comparison chart for 2008 yet).
http://www.microway.com.au/microsoft/vs_compare.stm[^]
If it is for your company, you can always get the company to buy it.
|
|
|
|
|
|
Sounds like fun. Good luck !!!!
(seriously, this is not a question, try doing some research, start your project, and ask specific questions when you have them )
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 )
|
|
|
|
|
Yet another newbie with a chat app attempt.
|
|
|
|
|
|
What do you mean by 'template' ? You can't hijack a browser on another computer via a windows program, no.
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 I need help with my program I'm trying to read bits and write bits in a set of bytes.
Any Idea on how to do that under VB.net.
If you do not have an answer just don't answer.
BiG RaLpH
|
|
|
|
|
Have a look at the BitVector32[^] structure. It is specifically designed to assist with bit manipulation operations.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi Frnd's
I have datetimepicker control for which i need to change the forecolor to red when it is selected i.e the text should be change to Red color
Plz help me..
Thnks...
|
|
|
|
|
Requirement: In vb.net
I want to add records in gridview text boxes? how it will be possible.
Explaination:
I have gridview named gridAsset with 5 columns all are text boxes.
suppose now i am entring values in first row then after that with out saving these values in data base i want to enter another one more record.it means now grid row count is 2.
after this on click on save button it should be saved in data base.
please give me solution aspx as well as in aspx.vb in both.
Thanx
|
|
|
|
|
Well, a gridview can be set up to support an 'add' link that gives you a row with textboxes and saves the data to the server.
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 )
|
|
|
|
|
Private Structure CUSTOM_EXPORT
Dim Name_Renamed As String
Dim ViewName As String
Dim List() As String
Dim filter_Renamed() As String
Dim ColHeadName() As String
Dim ColWidth() As Object
Public Sub Initialize()
ReDim List(255)
ReDim ColHeadName(255)
ReDim ColWidth(255)
End Sub
End Structure
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Dim udtCustom() As CUSTOM_EXPORT
udtCustom(1).List(0) ="Area Code"
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I face with "Area Code" is not assigned to udtCustom(1).List(0) ,
Object Reference not set to an instance of an object.
pls solve my problem,
what other is needed i do for this problem,
THANKS FOR ALL!!!!!!!!!!!!!
|
|
|
|
|
Sorry!!!!
I forget this is
VB.Net Code
|
|
|
|
|
|
Michael Sync
Sorry !!!Please forgive me.
This is my mistake of your annoyance.
Because ,I did not see your answer at .NetFrameWork Boards.
So i make my second time of my question at VB/VB.Net Boards.
Now ,i see your answer at .NetFramework board.
So,Please forgive me again.
THANKS FOR YOUR ANSWER!!!
Now i can resolve my problem.
Sorry!!!
|
|
|
|
|
Meenge,
What Michael has been saying is:
Dim udtCustom() As CUSTOM_EXPORT '<< executing this lines does not actually create any instances of the array. You must specify a size by putting a number between the (). When you do that, now you can use that instance.
Dim udtCustom(1) As CUSTOM_EXPORT '<< now 0 and 1 (because the array is zero based) instances are available for accessing.
---------
Your other problem is the arrays within you structure. Creating instances of your structure does not create any instances of the arrays within. If you notice, in your original post, the () are empty. So once again the variable is created but equal to nothing or has a length of zero (depending on the type of object). So you have to create the instances for those arrays as well by specifying a size. You can do that either at the point of DIMming your variables or using Redim to allocate after DIMming. Michael has chosen to call a routine within the structure to set those sizes. You can either hardcode the size within the () or call a routine or set them outside the structure ex: ReDim udtCustom(1).List(5)
Hope this helps...
Nathan
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
|
|
|
|
|
nlarson11
THANKS A LOT FOR YOUR ANSWER AND KINDNESS!!!!!!!!
Your answer can resolve my problem.My problem is everything OK because of you.Now ,you see my happiness.
|
|
|
|
|
Don't cross post. It's just plain rude.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
How to retrieve a record set from XML file, I want to use data from XML file to add to a drop down combo box for user selection.
Saseendran Kombath
|
|
|
|
|
You can use some XML reader or DataSet.ReadXml().
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
