|
Hello Gurus!
am looking for a code that can help me add or create an sql user using vb.net in my project. I hope this is the right forum to post this since it relates to vb.net!
BTW am using ms sql server 2005
Thank for ur anticipated reply or links.(Pls code!)
|
|
|
|
|
Is google broken where you live?
Anyway, try this[^] and if you don't like/understand it then google for either create sqlserver user vb.net or create sqlserver login vb.net
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.”
|
|
|
|
|
Henry Minute wrote: Is google broken where you live?
Errmm, yes
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Hi. Im new to visual basic 2008. I am now learning classes and how to make an instance of a class. Below are my codes. I have a problem in which the system says my "Calculator.DateCalc2008()" is not defined.
The following is my class code.
PublicClass DateCalc2008
Private _startDate As DateTime
Private _endDate As DateTime
Private _span AsInteger
PublicProperty StartDate() As DateTime
Get
StartDate = _startDate
EndGet
Set(ByVal value As DateTime)
_startDate = value
EndSet
EndProperty
PublicProperty EndDate() As DateTime
Get
EndDate = _endDate
EndGet
Set(ByVal value As DateTime)
_endDate = value
EndSet
EndProperty
PublicProperty Span() AsInteger
Get
Span = _span
EndGet
Set(ByVal value AsInteger)
_span = value
EndSet
EndProperty
PublicSub IncreaseDate()
EndDate = StartDate.AddDays(Span)
EndSub
EndClass
This is my object codes. Reference from above.
PublicClass Calculator
PrivateSub StartDatePicker_ValueChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles StartDatePicker.ValueChanged
Dim myCalc AsNew Calculator.DateCalc2008() //THE PROBLEM!
myCalc.StartDate = StartDatePicker.Value
myCalc.Span = 7
myCalc.IncreaseDate()
EndDate.Text = myCalc.EndDate.ToString()
EndSub
EndClass
|
|
|
|
|
I suspect VB is not happy because it is confusing the class Calculator with the namespace you are using. If both the calculator class and the DateCalc2008 class are in the same namespace you should be able to omit Calculator when declaring your variable, i.e.
Dim myCalc AsNew DateCalc2008()
|
|
|
|
|
Dim myCalc As New Calculator.DateCalc2008()
take off the work Calculator
Dim myCalc As New DateCalc2008()
DateCalc2008 would need to be nested within Calculator to be declared like that.
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
|
I tried, but still has the error. ok. cause i following the directions of a book, it taught me this way. "To run your new DLL file, you need to add a project with a user interface to the same solution that holds your DLL project."
so, the Class DateCalc2008 is the .dll file which is used as a reference for the user interface which is the class Calculator.
Thanks Alot! =)
|
|
|
|
|
Does your new project have a reference to your dll ? If not, that would cause this error.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
yup. it does. Assuming i am following the book correctly, which im pretty sure i am.
what does each part of this code means anyway? "Dim myCalc As New DateCalc2008()".
just a thought, so usually if i were to have a class and want to create instances of it, i could just write it all out on the long sheet of codes instead of using the .dll as reference method?
Thanks a million!
|
|
|
|
|
gjx_junxian1989 wrote: Dim myCalc As New DateCalc2008()
It means, create a new object, call it myCalc, and initialise it by calling the constructor of DateCalc2008.
gjx_junxian1989 wrote: ust a thought, so usually if i were to have a class and want to create instances of it, i could just write it all out on the long sheet of codes instead of using the .dll as reference method?
The only reason for the dll reference, is that you put the code in a dll. You would rarely do this, and I'm shocked that a book is telling you to mess with dlls, before explaining to you what a constructor does. If you have a reference to the dll, then you DO need to reference the full namespace of the dll, to get access to the object. If you start to type in the name of the top level namespace in the dll, autocomplete should kick in. If it doesn't, I doubt you have that reference. Also, if you made the reference, THEN added the class, you probably need to remove and re-add the reference to update it.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
ic. Thanks alot. so if im not wrong, Dim myCalc As New DateCalc2008(), creates an object myCalc, which thus enables me to gain access to functions and variables in the class DateCalc2008 and assigning values to it. so the DateCalc2008 is like a template for many other uses of same application? But usually we write classes and make objects of the class in a single sheet of code?
|
|
|
|
|
gjx_junxian1989 wrote: so the DateCalc2008 is like a template for many other uses of same application? But usually we write classes and make objects of the class in a single sheet of code?
Not really. A class would be created in one file inside your project, other classes, in other files, would create instances of the class and use them
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
ok. Hey, thanks, you've been a great help. Is there anyway i can contact u in future if i have problems with VB?
|
|
|
|
|
I don't actually do VB, I just help here b/c it's all .NET. There's other people on these forums far better at VB than me, your best bet is to ask here, I'm here all the time, so I'll answer if no-one else does
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Alright! Thanks man!
|
|
|
|
|
I'm not good at English.
Not enough data to answer, because you didn't say about all the parts in your project and your project name.
May be you have a class named "DateCalc2008" and a form named "Calculator". The form "Calculator" has a control named "StartDatePicker", and you created a subroutine which handles "StartDatePicker.ValueChanged" event.
The error is: The form "Calculator" doesn't have a member named DateCalc2008.
You should fix your code like this:
Dim myCalc As New {project name}.DateCalc2008
I hope this will be an useful answer.
Good luck !
chilinhhacker
|
|
|
|
|
I have a combobox that all my formname such as form1,form2,... listed that.
i want when i select a formname from combobox the component of selected form list in listbox such as button1,textbox1,....
but when i choose a formname from combobox because it is a string havenot form property such as control,enabled,...
how can convert selectitem in combobox from string to form??
|
|
|
|
|
you cannot convert a string to a form, I would hope that is obvious. You could make the tag of the item the form that your string refers to, and then grab it from there, or build a map of strings to forms.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
|
Hello Experts!!
I am declaring one array (having size 10) as an integer and bind array data to grid combobox.It works well but in combobox it shows values as well as zeros....means if array contains 3 values then remaining values shows zero(remaining 7).
How to taggle with this? Combo shows like this->1,2,3,0,0,0,0,0,0,0...I dont want that zeros
My code is
<pre>Dim o As New design
Dim i As Integer = 0
Dim rowArray As String()
Dim no(10) As Integer //Declaration
rssearch = New ADODB.Recordset
rssearch.Open("select srno from design", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockPessimistic)
While Not rssearch.EOF
o = New design
o.dsrno = rssearch.Fields("srno").Value
Dim row1() As String = {o.dsrno}
Dim rows() As Object = {row1}
For Each rowArray In rows
no(i) = rowArray(0) // Assign value one by one
i = i + 1
Next rowArray
o = Nothing
o = New design
rssearch.MoveNext()
'i = i + 1
End While
CType(dgvbottom.Columns(8), DataGridViewComboBoxColumn).DataSource = no // Display values in combo
|
|
|
|
|
This is why you should use dynamic lists instead of fixed arrays. The control is doing exactly what you asked it to. Use List<int> instead.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
hi,
an int array of dimension 10 always contains 10 numeric values, they get initialized at zero.
solutions:
1. give your array the right dimension
2. use a collection instead of an array, say a List Of Int
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
List of (int ), worked..Thanx...
|
|
|
|
|
Hello Friends,
How to convert a bound field to template field in vb .net window application
In website there exist a link to convert bound field to template field.
Thanks In Advance
Praveen
|
|
|
|
|
You are working with a completly different control. The DataGridView does not have the concept of the Template column. Google working with DataGridView, there are plenty of examples out there.
Never underestimate the power of human stupidity
RAH
|
|
|
|