|
Ok, I am frustrated! I am trying to find the most optimal way to retrieve Data from a Database. I understand that there are basically 3 ways to do this: 1.) Stored Procedure (DataCommand), 2.) DataSet, 3.) DataReader.
My dilemma is, I do not need to store this data for Saving later on (basically I am loading some ComboBoxes). I would like to use a DataReader but sometimes I hit conflicts where the program tries to open more than one Reader (which can't be done on the Same Connection). I do not want more than one connection. I do NOT want to use a DataSet because I do not want the Overhead of creating one since it's not needed.
I've tried MSSQLXML 3.0 SP2 to retrieve data through XML. I have tried using the SqlCommand.ExecuteXMLReader. Any method that using a "Reader" of some sort basically uses a DataReader behind the scenes!
Is there some way that I can retrieve all of the Records into a Stream of some sort and then loop through it? In VB6 this was easy...I created a Forward Only / Read Only Disconnected Recordset.
|
|
|
|
|
Can anybody help, please tell me how to create a progress bar in VB.Net as soon as the user click on the save button or open a connection to my database(SQL). Thank you so much...
MichaelCollins
|
|
|
|
|
Well, you're going to have to be a little more clear. What are you trying to do? Are you trying to determine the Progress of Opening the Connection? Or are you trying to determine the Progress of Saving Data? Are you using a DataSet, Stored Procedure, or XML file?
|
|
|
|
|
I have very simple question ... I want to know the current resolution or current screen size of system.
I mean that Screen is on the 1024x768 OR 800x600 Size.
(I hope u can understand my question ... not very good in english)
Any help through code, web site or any thing will be appreciated and i will be thankful for that.
Thanx in advance ...
|
|
|
|
|
Hi !
For VB6 :
<br />
Dim iScreenWidth as integer<br />
Dim iScreenHeight as integer<br />
<br />
iScreenWidth=Screen.Width / Screen.TwipsPerPixelX<br />
iScreenHeight=Screen.Height / Screen.TwipsPerPixelY<br />
I don't know how to do it with VB.NET.
Hope this helps.
Jerome
|
|
|
|
|
would something like this work in VB.Net?
and i was just wondering if anyone knows a site that explains basic graphic style coding
like maybe how to make a basic side-scrolling game in VB.Net
thanks
______________________________________________
"I'm not me when I dream...anymore." -TRUSTcompany
|
|
|
|
|
Hi there,
I am trying to make a page for the users to enter their data and one of the columns of this datagrid should be a combo box.
I really appreciate if someone can give me a hint.
cheers,
Arshia
|
|
|
|
|
Sorry i forgot to say I am writing this with vb.net
|
|
|
|
|
Is there a tutorial on this somewhere?
I'm going nuts here....
how many different variables do i need?
i'm writing a program that uses a function to accept a number as a parameter. make some calculations to it, and return it..
then sub main will output the results...
don't give me code please...i just want some pointers...
"I'm not me when I dream...anymore." - TRUSTcompany
|
|
|
|
|
thanks for the help! NOT!
______________________________________________
"I'm not me when I dream...anymore." -TRUSTcompany
|
|
|
|
|
Sorry for not responding dude, but really now....
There are examples on how to create/call functions in VB everywhere. Just download just about any sample VB code and you will see a sample of how to write and consume a function.
I did not answer this question because I felt that it was asked by someone that clearly needed to do some looking around themselves on the subject. Sorry...
Looking at the responses that you did get and what you found on your own you got the concept.
Just please remember that no one here OWES anyone an answer.
Just as a personal note… I hate function that have byref arguments. They are used alot in the Windows world and I still hate them. IMHO functions take in arguments and return a value. That is the pure way of thinking about it. When you use a function you always think of it as:
returnValue = FunctionName(arg1, arg2, … argn)
And the function looks as follows:
<scope> Function FunctionName(arg1 As Type, arg2 As Type, … argn As Type) As ReturnType
'define the return value to use
Dim retVal as ReturnType
'perform what ever calculations you need to do
'set the return value
retVal = answerToCalculation
Return ReturnType 'if you are using VB.NET
FunctionName = answerToCalulation 'if you are using VB6
End Function
The number of input args are up to what you need, and it is very clear as to what is being returned and where.
Using ByRef is called output arguments. I don't like them at all. As I see it, if the returned values does not end up on the left side of a function call then it is not a function, it is a Subroutine.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
Ummm...pass it "ByRef"? Or make your Function return the Value? Function should ALWAYS Return something. So if you want the ByRef method, make it a Sub Routine. Your question isn't really clear, so I hope this Helps.
'Pass ByRef Example
Public Sub Test(ByRef MyValue as Integer)
MyValue = 5
End Sub
'Return a Variable
Public Function Test(ByRef MyValue as Integer) As Integer
Return 5 'VB.NET
Test = 5 'VB6 / VB.NET
End Sub
|
|
|
|
|
i asked the professor
what i forgot was that when u call the function you have to store the value somewhere: thanks though
ex: Sub Main()
Dim int as integer
int = MyFunction(5)
End Sub
Private Function MyFunction(ByVal int as integer) as integer
Dim sum as integer
sum = int * 10
return sum
End Function
----------------------------------------------------------------------------
This works right?
______________________________________________
"I'm not me when I dream...anymore." -TRUSTcompany
|
|
|
|
|
Hi all I have word automation project.
the project, opens the file, formats it, prints it and closes it.
but when the program execute word.document.close line, the message box asking , " do you want to save the file? yes, no , cancel " pops up.
How can I get rid of it...
I tried
word.document.close(False,True,True) <br />
but it give me compile error.<br />
<br />
<br />
thank you
|
|
|
|
|
To stop the save prompt you should just be able to call:
word.document.close(False)
using this I've opened a doc, applied a theme (thus changing it) printing then closed it without any prompts.
HTH
|
|
|
|
|
Ok this is my code
Dim sqlstr as String
sqlstr = "SELECT * FROM Products WHERE PrdName Like 'MS'"
Data1.RecordSource = (sqlstr)
Data1.Refresh
the string "MS" exists in so many records but the result is not what it should be ???
It returns 0 records found.
any ideas ???
Thanx
|
|
|
|
|
Try this...
sqlStr = "SELECT * FROM Products WHERE PrdName LIKE 'MS%'"
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
For the sake of this question I will use the old animal example that gets used in all the basic inheritance books..
Lets say that I have a base class called CAnimal and I inherit it to another class called CDog
Form within CAnimal, is there a way that I can get the type that is the parent (CDog in this case)? I would like to perform some processing differently in the base class depending on what subclass has called it.
If there some way I can do something like Me.Parrent.GetType("Cdog") ?
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
You can use TypeOf(Me) :
Public Class Animal
Public Sub Bark()
If TypeOf(Me) Is Dog Then
Console.WriteLine("Bark!")
Else
Console.WriteLine("I can't bark!")
End If
End Sub
End Class
Public Class Dog : Inherits Animal
End Class However, this is very bad design. You should provide generic functionality in the base class, and then override or extend that functionality in the derived class:
Public Class Animal
Public Overridable Sub Bark()
Console.WriteLine("I can't bark!")
End Sub
End Class
Public Class Dog : Inherits Animal
Public Overrides Sub Bark()
Console.WriteLine("Bark!")
End Sub
End Class If you can't provide generic functionality in the base class, you can make the method abstract (MustOverride):
Public MustInherit Class Animal
Public MustOverride Sub Bark()
End Class
Public Class Dog : Animal
Public Overrides Sub Bark()
Console.WriteLine("Bark!")
End Sub
End Class If the functionality is not applicable to all classes derived from the base class, consider removing it from the base class. For example, you wouldn't want your Cat class to have a Bark method!
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
|
|
|
|
|
I want to thank both of you for your comments on this… After taking a long hard look at the architecture I had originally selected I finally decided to refactor things a bit and moved away from the inheritance aspect since there were some apparent, albeit subtle, differences in the implementation between what each child class needed. I ended up using an interface style and backed it up by using come common helper functions behind the scenes. I even ended up lowering my LOC count by about 30% and dropping the complexity of the design a significant amount because of it.
I also noticed that the problem with my chosen implementation seemed to become apparent when I started the steps of documenting the class with XML docs. There were things showing up in the docs (I am using Ndoc) and things exposed to the outside world that I did not want exposed. The process of building the documentation for the library pointed that out very quickly.
Thanks again…
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
Actually, a better way would be to provide a ReadOnly Property called "Type". You can have this Property return an Enum (if you know how many ClassTypes you will have) or just a String if you Like. You could then Override the Property in the Derived Classes so that they can Return what Type of Class they are as well.
I find that Enums are great! Especially if you are allowing other Developers to use your Classes (since they don't know what Types to expect, Enums help a lot!).
'Base Class
Public Class Animal
'Enum
Public Enum AnimalTypes
Animal
Dog
Cat
Bird
End Enum
Public Overridable ReadOnly Property Type() As String
Get
Return "Animal"
End Get
End Property
Public Overridable ReadOnly Property Type2() As AnimalTypes
Get
Return Animal
End Get
End Property
End Class
'Derived Class
Public Class Dog:Inherits Animal
Public Overrides ReadOnly Property Type() As String
Get
Return "Dog"
End Get
End Property
Public Overrides ReadOnly Property Type2() As AnimalTypes
Get
Return Dog
End Get
End Property
End Class
|
|
|
|
|
I am taking a good look at what both of you have said...
I can understand why Richard Demming thinks that this would be very bad design, but in my defense I had a specific reason for doing it.
1 - The base class provides all but a very little part of the functionality of the library.
2 - The base library only exposes 3 classes that derive from the base class, and these classes can not be inherited from any further.
3 - The base class implementations of each method very only slightly in how certain database connections are handled based upon what class has inherited the base class.
4 - The bass class implementations are not really overridden. The derived class calls the base class implementations by using MyBase.Methodname.
I considered using an interface and some helper functions here in place of inheritance, but because the implementations are so close I was seeing the possibility for a lot of duplicated code.
As for your suggestions about using Enums, I totally agree I use enums wherever I can. In fact I have been accused of their overuse if you can imagine such a thing. I figure that, besides the other benefits, enums offer a way for the user to enter in parameters in a way that removes a large likelihood of error. They can't just make up values that way, but have to pick form a list.
Paul Watson wrote:
"At the end of the day it is what you produce that counts, not how many doctorates you have on the wall."
George Carlin wrote:
"Don't sweat the petty things, and don't pet the sweaty things."
|
|
|
|
|
Hello,
I have following code
<br />
Dim i As Integer<br />
i = 3/2<br />
from my knowleadge, if you set the variable as an integer, when you divide, (from the example) suppose to be i= 1 but right now i=2 because the answer i = 1.5 and automatically set the i to 2 . why is that? I don't want the decimal numbers, I want the integer. How can I fix that problem
Thanks
|
|
|
|
|
From my knowlage of vb, when it preforms type casting for you, it will always try to round. More information on this in the MSDN under cint(). If you just want to truncate your number, in this case either fix() or int() will do the job, however there is a subtle difference (regarding negetives) between them.
Try:
i = int(3/2)
Now i = 1
|
|
|
|
|