|
Assuming SQL Server
SELECT ColumnNames
FROM Database1.dbo.TableName
INNER JOIN Database2.dbo.TableName2
If that doesn't help you then you are going to have to give us more information about what you are actually trying to do.
|
|
|
|
|
Dear All,
I am displaying a data in a data grid using data set, and I need to export these data to Excel sheet, did any one try this thing and succeed with???
|
|
|
|
|
Hi All
I have written an application the I would like to run from a network share but I get a security warning.
My application will need file system access and if I ignore the error all works but this is not sutible for my users. I should also point out that this is a stand alone exe and does not have an installer.
Very new to Dev and this one has me stumped...
Please help...
Error Warning reads...
"Application attempted to perform an operation not allowed by the security policy. ... contact admin"
Click continue to ignore or quite to exit.
Request for the permission of type "System.Security.Permission.FileIOPermission,mscorlib, Version=2.0.0.0,Culture=neutral,PublicKeyToken= bla bla bla.
-- modified at 21:14 Saturday 12th August, 2006
When people make you see red, be thankful your not colour blind.
|
|
|
|
|
In code, how would i add, romove, clear and access items on a string collection in my.settings. I am doing a search of a directory, pulling out selected files and adding their names to the string list but when i go to access these items, there is no returned value, i dont get error, it's just, nothing happens.
Thanx in advance
Posted by The ANZAC
|
|
|
|
|
First step - post your code
So are you an ex soldier, or a biscuit ? :P
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hi,
Hash Tables can contain lots of objects and are very useful. But if you want to organise a whole bunch of TCPClient objects are they the way to go or is there some other way? If Hashtables are the best way to go then how would you go about checking when data has arrived and knowing which object to send data from? And where would threading come into this? Would you create a hashtable of threads running TCPClients or create a new thread only when needed?
You've probably guessed I'm trying to develop my own server class, there's no specific reason for this aside from the fact I want to learn how to do this sort of thing.
Any help is appreciated.
---
Assimilating Knowledge
irc.heavenlyplace.net #vb
|
|
|
|
|
Start simple. Use a new thread for each TCPClient. Actually, use one thread for the TCPListener to get new connections. On each new connection (TCPClient), invoke a new thread to handle it. When the TCPClient closes, you let the thread finish.
In real world use, you'll find that this is very effective and a lot more scalable than you might at first think.
|
|
|
|
|
Hie ,
ok i know that one must use the SetMenuItemBitmaps API to add a bitmap on a menu.. .BUT.. it is limited ONLY to a about a 13 X 13 pic.THe icons kinda get clipped if they're bigger.. BUT I know it is possible to hav a SLIGHTLY bigger icon on a menu.There are so many apps with about a 16*16 icon. Infact the min. size SHOULD be about 16 X 16.
Does anyone know how to do that?? ... perhaps.. by using BitBlt
Thanx
Gideon
|
|
|
|
|
hie,
thanx for nothing.. i found out myself;P... you use the LoadImage API.. and specify 16 *16 in the size params and the icon resizes ... !... ALSO.. thanx to some1 on another forum.. i found out although loadImage loads from a file , YOU CAN specify a resource ID .. instead of a .ico file..BUT this will not work in the IDE. :->
hope that helped!
|
|
|
|
|
I'm using a 'regular expression validator' to valid use input on a text box
I have two different web pages that use the same validation expression criteria for two different text boxes; one of them works, the other does not work. I dont understand why
The field is 3 alpha characters followed by 3 numeric. Doesn't matter if they are caps or small letters
I use \w{3} to signify alpha and \d{3} to signify numeric. It works on one page ( adding a new record ) but on another page ( view existing records)
it only works if I turn cap locks on for alph and turn it off for numeric and even then it is not consistent
Any thoughts?
Thanks
|
|
|
|
|
About a year ago I created a usercontrol in VB 6. I use in in an MFC app that I wrote in VC++ 6. On the dev (WinXP) machine the control functions fine and the dialog box appears. On the target machine (also WinXP) the dialog box will not appear at all. I believe that my ActiveX control is not initializing so the dialog aborts. I checked and the ocx file is registered on the target machine (C:\Windows\System32\myctrl.ocx).
I need help figuring out why there is a problem.
Thanks in advance,
Mark
"Complexity breeds problems. Keep it simple." - Mark
|
|
|
|
|
I want to include a help function in my system im developing, how would i go about doing this?
Is there a pre-set way of implementing this?
thank you 
Nothing lasts but nothing is lost
|
|
|
|
|
Solly74 wrote: I want to include a help function in my system im developing, how would i go about doing this?
What do you mean by include a help function? Do you mean on how to creat a help file for your application?
|
|
|
|
|
Yeah like microsoft word or powerpoint includes...
thank you
Nothing lasts but nothing is lost
|
|
|
|
|
When I use get files function, ie:
di.getfiles(searchpattern as string)
Is it possible to have more than one search pattern? e.g.(as oppose to just .jpg image files, how would i 'get' .jpg and .bmp and .gif and .png)
thanx in advance
Posted by The ANZAC
|
|
|
|
|
No, you can only have one search pattern.
You can make one search for each pattern, or you could get all files and filter them yourself.
---
b { font-weight: normal; }
|
|
|
|
|
thanx for your help, ive done the first suggestion, multipls searches.
Posted by The ANZAC
|
|
|
|
|
how i can search in foldres with this functions?
|
|
|
|
|
tarksiala wrote: how i can search in foldres with this functions?
In .NET 2.0 you can seach subfolders. Example:
Dim files as String()<br />
files = Directory.GetFiles("d:\images\", "*.jpg", SearchOption.AllDirectories)
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
I am trying to get the files in folder using this function and showing these files in an OpenFileDialog, and it is done.
But I am trying to get these files using the same function but I wanna use a DropDownList to select some file in the folder.... may some body has an idea to do that????
|
|
|
|
|
I recently created a program that gets all the files of a certain format from a directory then adds them to a combobox, the user could then select the file they wanted, using this info, on what they had selected, i was able to use the file because i knew it's directory, name and format.
If u want to fill a combobox using a similar method do this. (keep in mind, i was searching for images and removing the .jpg from the end of the image names)
Browse is a folder browser dialog. comSelect is a combobox on my form.
Using a browse button the user chose a folder and then clicked ok, my program then use this info to get all the .jpg files from that folder and added each to a combobox
If Browse.ShowDialog() = Windows.Forms.DialogResult.OK Then
Dim Di As New System.IO.DirectoryInfo(Browse.SelectedPath)
Dim Img As System.IO.FileInfo
Dim Holder
Dim Holder2
For Each Img In Di.GetFiles("*.jpg")
Holder = Img.Name.IndexOf(".")
Holder2 = Img.Name.Remove(Holder, 4)
Me.comSelect.Items.Add(Holder2)
Next
End If
You should be able to adjust this for next statement to your own needs.
Posted by The ANZAC
|
|
|
|
|
Hai,
I want to extract the data from the excel sheet like Sheet name, cell value, cell name using the VB.Net meanwhile i want the same in the SQL Server. please give the solution
Regards
Murthy
|
|
|
|
|
dwadasi wrote: I want to extract the data from the excel sheet like Sheet name, cell value, cell name using the VB.Net meanwhile i want the same in the SQL Server. please give the solution
Vb.Net + Excel[^]
VB.Net + Sql Server[^]
|
|
|
|
|
Okay, this is pretty complicated so let me see if I can try to explain my problem.
First I have an enumeration:
Enum BracingMemberTypes As Integer<br />
FirstItem = 0<br />
Diagonal = 0<br />
Horizontal = 1<br />
Internal = 2<br />
SubDiagonal = 3<br />
SubHorizontal = 4<br />
SubInternal = 5<br />
TopDiagonal = 6<br />
BottomDiagonal = 7<br />
TopSubHorizontal = 8<br />
BottomSubHorizontal = 9<br />
LastItem = 9<br />
End Enum
I have a file called clsSection with this declaration:
Protected m_BracingMembers As New clsBracingMemberDictionary
In the same file I also have some properties. I'll only show a couple:
ReadOnly Property Diag() As clsBracingMember<br />
Get<br />
<br />
'10-Aug-2006 Changed to use the dictionary LLS (1 of 10)<br />
If m_BracingMembers(BracingMemberTypes.Diagonal) Is Nothing Then<br />
m_BracingMembers(BracingMemberTypes.Diagonal) = New clsBracingMember(Me, BracingMemberTypes.Diagonal)<br />
<br />
End If<br />
Return m_BracingMembers(BracingMemberTypes.Diagonal)<br />
End Get<br />
End Property<br />
<br />
ReadOnly Property TopDiag() As clsBracingMember<br />
Get<br />
'10-Aug-2006 Changed to use the dictionary LLS (2 of 10)<br />
If m_BracingMembers(BracingMemberTypes.TopDiagonal) Is Nothing Then<br />
m_BracingMembers(BracingMemberTypes.TopDiagonal) = New clsBracingMember(Me, BracingMemberTypes.TopDiagonal)<br />
End If<br />
Return m_BracingMembers(BracingMemberTypes.TopDiagonal)<br />
End Get<br />
End Property
I need to create a copy function so I can have two objects and compare them. This is what I have thus far:
For i As Integer = BracingMemberTypes.FirstItem To BracingMemberTypes.LastItem<br />
If Not .BracingMembers(i) Is Nothing Then<br />
m_BracingMembers(i).Copy(.BracingMembers(i))<br />
<br />
End If
Next
Basically what I am doing is looking up the bracing information. There are different bracing configurations such as X. The problem is that in the X bracing, some of the types of the enumeration do not exist. It has a diagonal (0), horizontal (1) but once it gets to internal (2) I get the null reference object error which makes sense.
This is not my code, my boss wanted me to change the code using a dictionary object.
Any ideas how to fix this short of using if statements based on the bracing configuration?
Is there a real benefit to using dictionaries? (VB programming dictionaries before the jokes come in.) 
|
|
|
|
|
Hello evreyone,
Is anyone could tell me what's wrong with code snippet. I get an error in vb.net 2005:
<br />
'1. Create 6 classes (I've removed all internal code since it is useless for the test)<br />
<br />
Public Class LockableDataObject<br />
<br />
End Class<br />
<br />
<br />
Public Class Business<br />
<br />
Inherits LockableDataObject<br />
<br />
End Class<br />
<br />
<br />
Public Class LockableDataManager(Of CustomType As LockableDataObject)<br />
<br />
End Class<br />
<br />
<br />
Public Class BusinessManager<br />
<br />
Inherits LockableDataManager(Of Business)<br />
<br />
End Class<br />
<br />
<br />
<br />
Module main <br />
<br />
Public Sub main() <br />
<br />
'This line works<br />
<br />
Dim MyManager As LockableDataManager(Of Business) = New BusinessManager<br />
<br />
<br />
<br />
'This line doesn't (Is this a bug? or is this wanted?)<br />
<br />
Dim MyManager2 As LockableDataManager(Of LockableDataObject) = New BusinessManager <br />
<br />
End Sub<br />
<br />
End Module
Thanks a lot in advance.
Jugurten.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
