|
Doug Ancil wrote: HTH,
 "HTH" is not my name... it is short for "hope that helps" 
Doug Ancil wrote: here is the exact query (with variables included) that I just tried in my sql query analyzer:
Just looked at your query again - doesn't a "select into" query create a table? it does not really return a result? How about creating a statement with a select * from the [new table]?
|
|
|
|
|
Chandra,
Sorry about that, but what I'm trying to do is to display that data back into a datagrid view (which is why the adapter.Fill(ds)) is there. Are you suggesting that after I run the query, to then create a select* from that table and then populate that to a datagridview via an adapter?
|
|
|
|
|
Doug Ancil wrote: Are you suggesting that after I run the query, to then create a select* from that table and then populate that to a datagridview via an adapter?
Yes.
|
|
|
|
|
Chandra,
Can you give me a good example of that that wouldnt require me to re-write a lot of code?
|
|
|
|
|
How about using a dataReader.ExecuteNonQuery on the first sql and then a data adapter for the select * to fill the data set?
|
|
|
|
|
from the sample:
Dim dataSet As DataSet = New DataSet("Suppliers")
...
I don't speak Idiot - please talk slowly and clearly
'This space for rent'
Driven to the arms of Heineken by the wife
|
|
|
|
|
Doug,
For your future reference, could you use <pre lang="vb"> your code goes here </pre> instead of <code></code>. The pre tags preserve formatting and give some syntactical colouring. As you will have seen, the code tags just give a horrible reddish colour. this hurts my eyes so much (genuinely) that I am unable to read your code, not that I could have helped anyway .
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Henry,
Thanks for that. I've now fixed the code.
|
|
|
|
|
FYI[^]
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Hi,
What is the best way to store/retrieve binary data in/from SQL server DB via VB.Net.
I have inheritate an SQL server database that has stored PDF files in a table and not got a clue in how to store or retrive the binary data. I plan to write a VB.Net application to display the contents.
Any ideas?
|
|
|
|
|
|
Is it possible to make the tab (a text 'Main Report' appears in it) invisible that appears in a CrystalReportViewer just below the Toolbar? I know it shows which section of the report is opened currently but in certain scenario I need it not to be visible. Please help. Regards.
|
|
|
|
|
priyamtheone wrote: Is it possible to make the tab (a text 'Main Report' appears in it) invisible that appears in a CrystalReportViewer just below the Toolbar? I know it shows which section of the report is opened currently but in certain scenario I need it not to be visible.
Are you referring to the group tree? If so, you can set it to not show by setting the DisplayGroupTree value to false.
HTH
|
|
|
|
|
Hello Everybody,
How can i add Embedded Menifest With Appliation of Visual Basic 2005 (Framework 2.0)
Thanks & Regards
If you can think then I Can.
|
|
|
|
|
|
Hi all, I'm going to finish the IT professional and management have to develop a final draft of the course. My project will be a program for managing a business lunch. Still have not programmed anything, just created the forms. When I change any label or whatever is the form the program does not change, crashes and it takes ages to open. If someone can explain to me why thanks.
|
|
|
|
|
exotiick wrote: why
because you did something wrong. Without any information to work on, that is as specific an answer you will get.
If there is a compile-time or run-time error, look at it; or report it here.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Luc Pattyn wrote:
because you did something wrong
used VB?
Software rusts. Simon Stephenson, ca 1994.
|
|
|
|
|
Not necessarily. I once wrote a VB.NET app that didn't crash, in fact I have had more C# crashes than VB ones. Although my crash/LOC ratio is better overall in C#.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
exotiick wrote: If someone can explain to me why thanks.
I suspect that there is something wrong with your code, but without seeing some of it (or receiving a better explanation) it is impossible to guess.
I must get a clever new signature for 2011.
|
|
|
|
|
i dont have any code, i only have created the forms and design of forms
|
|
|
|
|
Visual Designer keeps track of your actions by creating one or more (hidden) source files, probably called form1.designer.vb or something similar. You can see them with Windows Explorer; and with Visual Studio provided you make it show all files, there is an icon button for that.
When you run your app, it either works fine or throws an exception, and since you did not add any explicit code, it will not be swallowed by an empty catch block. Look at the exception, pay attention to class names, file names, and line numbers mentioned, or report it here.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Without Code and Without Error How can i know that what is the problem is generating with u.
If you can think then I Can.
|
|
|
|
|
Search for the main method in your project and see what form it trying to open. You may have changed the name of the form but not the reference to it in the main method.
Hope that helps
Architecture is extensible, code is minimal.
|
|
|
|
|
Hi,
I do not know if this is the correct place to put this question but maybe someone has come acroos this problem. So sorry in advance.
Is there a way to generate multiple files from 1 run i.e. via vb.net create a pdf file but the pdf has more than 1 page. I want to create a new file for every page e.g. Page1.PDF, Page2.PDF etc.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
