|
I am working on a VB6 application which also uses Crystal Reports. However whenever I run my form I get this error message "Invalid formula name". I was wondering if anyone knew how to correct this problem or reset the formula name. Any useful suggestions would be great.
|
|
|
|
|
I have the following code but when it gets to the "Cmd.ExecuteNonQuery()" it just stops and throws an error. anyone any ideas why this is not working?
Cmd = New SqlCommand("sproc_DomainName", Conn)
Cmd.CommandType = CommandType.StoredProcedure
Param = Cmd.Parameters.Add("@domainName", SqlDbType.Char, 64)
Param.Direction = ParameterDirection.Input
Param.Value = strUser
Param = Cmd.Parameters.Add("@staffID", SqlDbType.Int, 4)
Param.Direction = ParameterDirection.Output
Param = Cmd.Parameters.Add("@roleID", SqlDbType.Int, 4)
Param.Direction = ParameterDirection.Output
Param = Cmd.Parameters.Add("@firstName", SqlDbType.Char, 20)
Param.Direction = ParameterDirection.Output
Param = Cmd.Parameters.Add("@surname", SqlDbType.Char, 20)
Param.Direction = ParameterDirection.Output
Conn.Open()
Cmd.ExecuteNonQuery()
Conn.Close()
|
|
|
|
|
|
I have an MDI child form. When the user uses the arrow keys to go between main menu items they can get to both the child forms system menu and the parent forms system menu. How do I delete/remove the child forms system menu? I've tried the ControlBox property but that doesn't work (VB.NET bug?). I've also tried deleting all the items in the system menu using API calls but that still leaves the little icon. Thanks so much for any help. I've looked everywhere but can't seem to find anything.
|
|
|
|
|
Can someone please explain the difference between LDAP and MAPI? When should one be used instead of the other?
Thanks,
Sam
|
|
|
|
|
LDAP -> Lightweight Directory Access Protocol. Used to access directories that contains many kinds of information about networks, users, computers, services, ...
MAPI -> Messaging Application Programming Interface. Used by email applications to send and receive mail through certain messaging systems.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I need to have the records from my Ms Sql table between two dates.
I have a Vb.Net form and two DateTimePicker on it to get the first and second date.
What must sql tables "DateKeeper" coloumn type be?(smalldatetime for dd.mm.yyyy?)
And in which type i have to send my dates that i receive from DateTimePickers?
If possible plz write the Select sentence of this code.("select * from MyTable Where DateKeeper>=firstDate And DateKeeper
|
|
|
|
|
hakanaktan wrote:
What must sql tables "DateKeeper" coloumn type be?(smalldatetime for dd.mm.yyyy?)
That depends on how fine grained you want your dates and what range of dates you want. You know that the most important tool of a good developer (assuming you aspire to be more than a coder and become a developer) is to be able to find stuff in the documentation. Google is a great way to find stuff. Try this in Google:
site:msdn.microsoft.com smalldatetime And the first link is datetime and smalldatetime[^] which tells you exactly the accuracy and range of the two chronological types in SQL Server.
hakanaktan wrote:
And in which type i have to send my dates that i receive from DateTimePickers?
The DateTimePicker will give the date in a DateTime object, you don't need to convert it if you create your SqlCommand properly (by using parameterise queries)
hakanaktan wrote:
If possible plz write the Select sentence of this code.("select * from MyTable Where DateKeeper>=firstDate And
SELECT * ??? You should be listing each of the columns you want. If your data model changes then you could break your .NET application to easily without knowing immediately. If you don't know immediately then it becomes harder to track where the bug came from.
The SQL you need in your SqlCommand.CommandText is something like this:
SELECT MyColumn1, MyColumn2
FROM MyTable
WHERE DateKeeper>=@firstDate
AND DateKeeper<=@lastDate
Your SqlCommand object will take two Parameters
MyCommand.Parameters.Add("@firstDate", firstDateTime);
MyCommand.Parameters.Add("@lastDate", lastDateTime);
hakanaktan wrote:
-MCP& MCAD &junior coder--
I noticed you added MCP and MCAD to your signature recently. Congratulations on passing these exams.
My: Blog | Photos
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More
|
|
|
|
|
Thank you very much for your detailed answer to my questions..
-MCP& MCAD &junior coder--
|
|
|
|
|
Can anyone please tell me know how to connect to a remote computer, not shares using vb.net. I want to connect to remote computer and get available shares on the computer and list them.
I just want to connect to \\server not \\server\share.
After connecting i want to retrieve the shares.
Thanks in advance
 
Aniruddha
|
|
|
|
|
Hi,
Can any one help me by telling how to call a windows application (standard exe) from vb.net
Thank you
Mahesh
|
|
|
|
|
|
gemnet wrote:
use the shell command
deprecated
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
You're looking for the Process class[^], specifically, it's .Start method.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
How do I merge these 2 functions into 1 or better yet have one function that does the clear and add methods for all bindable controls.
This function will not be called in the formLoad because it will be called repeatedly by a button click. (thus the clear method must be called)
Also, I have OPTION STRICT turn on so the first parameter cannot be a system.object. (unless you can think of way to get by it)
Private Sub BindTextBox(ByRef txtBox As TextBox, ByVal sProperty As String, ByVal obj As Object, ByVal sObjectProperty As String)
txtBox.DataBindings.Clear()
txtBox.DataBindings.Add(sProperty, obj, sObjectProperty)
End Sub
Private Sub BindLabel(ByRef lbl As Label, ByVal sProperty As String, ByVal obj As Object, ByVal sObjectProperty As String)
lbl.DataBindings.Clear()
lbl.DataBindings.Add(sProperty, obj, sObjectProperty)
End Sub
|
|
|
|
|
Just make the functions have the same name(overload) when you call BindMe the program will determine the correct function to use based on either textbox or label
Private Sub BindMe(ByRef txtBox As TextBox, ByVal sProperty As String, ByVal obj As Object, ByVal sObjectProperty As String)
txtBox.DataBindings.Clear()
txtBox.DataBindings.Add(sProperty, obj, sObjectProperty)
End Sub
Private Sub BindMe(ByRef lbl As Label, ByVal sProperty As String, ByVal obj As Object, ByVal sObjectProperty As String)
lbl.DataBindings.Clear()
lbl.DataBindings.Add(sProperty, obj, sObjectProperty)
End Sub
|
|
|
|
|
Can someone please help fix this function below? I have option strict turned on so it requires a lot of explicit conversions. I am passing data from datatables back to a business object.
for instance I have to use CTYPE a lot to convert to an explicit datatype but the DBNulls are killing me!!!!
busObj.field1 = ctype(dtrow("field1"), string)
'Private Function CTypes(ByVal obj As Object, ByVal Type As Type) As Object
' If Not (obj Is DBNull.Value) Then
' Return CType(obj, Type)
' Else
' If Type.Name = "String" Then
' Return String.Empty
' ElseIf Type.Name = "Integer" Then
' Return 0
' ElseIf Type.Name = "Date" Then
' Return "01/01/1900" 'or some other value
' End If
' End If
'End Function
|
|
|
|
|
I am creating an application which will create folders and will place web pages on the web server.
Now that's easy and it's done. Now the difficult part
The application has also to configure IIS and i've not been able to configure IIS for the website through vb.net. Is it possiable to configure IIS through vb.net and
Is there any way that i can protect the ASP code from being viewed.
|
|
|
|
|
 I am having difficulty reading the images. I want the images to be embedded so that the are built into the .dll of the control. Every time i try and use my control i get 'null is not a valid value for stream.' i have verified the names of my control, image , .dll name. i have also tried diferent variations to get the image. Please help.
|
|
|
|
|
I think I have it. I had a similar problem in a C# project, the IDE kept changing the line that creates the ResourceManager, and I had to change it to something like this or I got the same error:
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(MyControlType))
I believe if you create your ResourceManage with this line and then use it to load your Bitmap, there's a good chance it will work.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
I have created my own DLLs in VB.NET. However, this DLL has a couple of dependent DLLs. Is it possible to combine all the dependednt DLL along with my user control to create only one combined DLL?
Thanks
|
|
|
|
|
Yep - if you have the code to all the dlls, there's no reason why you can't merge them. If you don't, then I doubt it, at least not simply.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
Nope I do have the code to them. I am using some DLL from other SDKs and my own code. I would like to combine those DLLs with mine since it is easier to move around 1 DLL rather than a bunch of them when I want to use my created user control elsewhere.
Thanks
|
|
|
|
|
In that case, remove all references to external dlls and copy the source files in from the external dlls until you have everything you need.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
There is a tool from Microsoft Research called IlMerge which probably does what you try to achieve. There is even an article about it here on CodeProject.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
