|
Hi there. If you are basing your SelectCommand sql statement in your DataAdapter on the table, it wouldn't include any query-based computed fields. Can you base your SelectCommand statement on the query instead? I think you would simply use the query name in place of the table name.
|
|
|
|
|
Thanks,
About five minutes after I sent posted that message, I tried that and it has worked so far. I'm going to continue testing it though. Thanks for your help.;)
|
|
|
|
|
You should be able do something like this using the SELECT statement in your SQL command:
SELECT (lastname + ', " + firstname) AS fullname FROM myTable
This assumes that your table has 2 columns, 'lastname' and 'firstname'. The resulting table will only have one column called 'fullname'. All this does is combine both columns into one with a different name.
You will, of course, have to modify this to work with your actual data.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
 how can i write in a text control and save the text in a table.
Go forward and never Stop....
|
|
|
|
|
Firstly, set up a connection to the database (ADO is the simplest)
Open connection
Get the .Text of your control
form a string of the form "INSERT INTO (<column>) VALUES ()
Execute it on the connection.
"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox
|
|
|
|
|
i develope a client server application
and i want to enable user to send Msgbxo to another user
to inform him for somthing
|
|
|
|
|
I take it your talking about a Chat function for you application.
YOu might want to take a look at this[^] article on CodeProject. Download the demo project and look at the source.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi, Dave!
You understood wrong the problem. He want send a message box to another user, It contain in a separate window and OK button. Is it correct?
You can use code below:
Shell "Net send " & computer_name & string message
Good luck
tramdtt
|
|
|
|
|
Hi,
I am developping an application using VB6 and mapobjects (an activeX control). This activeX is used to open and display the map (vector form). When I give the applit to the users I have to include the map (basically it is similar to the dbf file). Also the activeX opent the file which in that format only.
But I want to restrict the users to take a copy of that file (more expensive). I want to restrict from copying. Any idea to do this....
P.V.Velan
Chennai, India
|
|
|
|
|
You can't... The file system will let the user copy the file to anywhere they want, so long as the user has rights to write to the destination. The user needs a minimum of Read rights to the file so the application can use it. Unfortunately, this is also all they need to copy the file.
About the only thing you could do is set the file's Hidden attribute. But, even then , all the user has to do, in Explorer, is enable the option to Display Hidden Files...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Who can help me or give some suggestions where to look for the following issue.
I am currently developing a application in VB.NET, this application was once develped in VB 6.0.
I came up with the idea to proide the application with a programming environment to give more flexibility. In my search on the internet I did not find much, except for a VBA scripting control SAX ON http://www.sax.net/activex/basic/default.aspx.
Further I want that the pogramming environment is aware of the object model inside my application.
I have no idea how to reach this goal.
Any good suggestions are very welcome, books, samples, links, downloads, utilities etc.
|
|
|
|
|
I have compiled a program and made a install file. I have 3 dependencys to my program. I am working with .NET. The other computer has been updated to .net Architecture. One dependency is an .ocx file that i have installed into the windows directory. The .ocx is a user control that is been created in 6.0 and i am referencing to this. When i reference to this .ocx it makes 2 references.
After i build the project. there are 2 dll's in the folder with my .exe. Thats fine. If you move the .ocx file out of the windows folder the app does not work. So i know that the app is looking for the .ocx file in the windows folder. Its just when i install this app on another machine it instant instantly says there has been an exception that can no be handled. Then i try the same install on my computer where i have made the 2 programs and it works fine. I just dont get it because all the files that are dependencys are there and the .ocx file is in its place when i run the install program. I just dont understand why it would not work on another machine with everything in its place with .net framework installed. Any help on this portability issue would be greatly appreciated. Thank you
|
|
|
|
|
When you place the .OCX files on the new machine, you have to register them with REGSVR32:
C:\Windows>REGSVR32 filename.ocx
Once that is done, the OCX file CANNOT be moved, unless you unregister the .OCX and re-register it when it is in it's final position. This is because the full path to the .OCX file is stored in the registry so the system knows where to find the file when it needs it.
Keep in mind, that .OCX files themselves, have dependencies. You must be sure that any .DLL files that the .OCX refers to are also copied to where the .OCX file expects them. You can use the Depends tool that comes with Visual Studio 6 to see what those dependencies are. You must also make sure that the dependent .DLL files are registered also, if they are ActiveX .DLL's.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks that worked great but how could you do this through code to register it at machine that it installs on. And how could i the my program check to see if it is already registered with that machine. Thank you
|
|
|
|
|
It has to be done by the installer. Normaly, when you build an installer project (VB.NET) or use the Package and Deployment Wizard (VB6), this dependacy is handled for you, along with the registration of the .OCX. But, neither of these will take care of the dependancies that the .OCX file has. You'll have to add those manually.
You'r app really can't check for the existance of the controls ahead of time. Your app would have to know the filename and version of each of the controls it needs, then it would have to check to see if the control is registered properly and that would require your app knowing all of the ClassID's the control registers. It's possible to do, but not worth the effort at all. Just making sure you have a properly packaged application is much easier.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
when you have string "C:\my fodler\hello" "C:\Documents and Settings\admin\"
is given, how can I use the function split to separate this string and convert into an array.
"C:\my fodler\hello"
"C:\Documents and Settings\admin\"
I have try with Chr$(22) which is the space btwn double quotation, but
seemslike it can't find the space btwn. Also I have to be aware of those
space for path"My Folder".
Probably easy for others.
Thanks
Shin
|
|
|
|
|
ASCII code 22 is not the space character, the space character is 32.
|
|
|
|
|
32 is the space character, not 22.
The problem your going to have is that splitting on the space will also split on any spaces in the path names. Your string "C:\my fodler\hello" "C:\Documents and Settings\admin\", I'm assuming your including the quotes in the string!, will split liek this:
"C:\my
folder\hello"
"C:\Documents
and
Settings
You will have to supply your own function to parse this string. Assuming your including the quotes in the string as above, you can split the string on the " character instead. Then look through the resulting array and remove the blank array items. This should give you the paths your looking for.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
char [] charArray = string.split("\"")
should do the trick you should end up with 3 parts
1 = "
2 = the dir path
3 = "
|
|
|
|
|
Nope. Using the original string he put in his first post and splitting on a backslash, he'd end up with
str = """C:\my fodler\hello"" ""C:\Documents and Settings\admin\"""
Dim charArray() = str.Split("\")
0 = "C:
1 = my fodler
2 = hello" "C:
3 = Documents and Settings
4 = admin
5 = "
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
You might want to try either of these methods:
1. Using Regular Expressions
<br />
Dim s As Regex = New Regex("\""([^\""]*)\""(?:\s)*")<br />
Dim match As Match = s.Match(w) ' where w is the string mentioned<br />
While (match.Success)<br />
' match.Groups(1).Value will contain the string<br />
match = match.NextMatch()<br />
End While<br />
2. Since filenames can't contain strings, you can replace " " sequence with a single character, trim the quotation marks at the beginning and end of the string, and use the Split function, as follows (assume w is the string that holds the folder names):
<br />
Const quotchar As String = """"<br />
w = w.Trim(quotchar) ' remove quotes from start and end<br />
w = w.Replace(""" """, quotchar) ' replace " " with "<br />
Dim stringarray As String() = w.Split(quotchar) ' Now just invoke split and save to array<br />
Hope this helps. 
|
|
|
|
|
in vb6, if i had two forms, Form1 and Form2, I would access a control in Form2 by Form2.[controlname]. How do i do it in VB .NET?
|
|
|
|
|
I take it you're trying to get at the controls in Form2 from code in Form1?
In VB6, this wasn't necessary, but in VB.NET you have to have an instantiated Form2. Something like this:
' This code is in Form1
Dim form2 As New Form2()
form2.TextBox1.Text = "Sometext..."
form2.ShowDialog()
Dim newString As String = form2.TextBox1.Text
form2.Dispose()
form2 = Nothing
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
aThanks...
I am using an MDI and I have a child form with a RichTextBox. Whenever I press the 'New' menu, I create a new instance of the child form. So when I open a file from the 'Open' menu the Dialog Box shows up and when I press open, the active child form's richtextbox should show the file. How can I do it?
How can I use the 'LoadFile' method of the Active Child Form from within the MDI?
|
|
|
|
|
I take it you mean how do you call the LoadFile method from the MDI Parent? You use the ActiveMDIChild property of the Parent form, point a variable at it, then access it's RichTextBox control:
Dim activeChild As Form2 = Me.ActiveMDIChild
If (Not activeChild Is Nothing) Then
Try
activeChild.RichTextBox1.LoadFile(whatever you're using to pass the filename)
Catch
MessageBox.Show("A problem occured loading the file...")
End Try
End If
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
