|
Thanks a lot! it worked excellent!
|
|
|
|
|
I dont know if this is the best place to post this but here goes.
I have an exisiting VB6 application that uses SQLDMO to search for any SQL Server instance on a LAN. It works fine but SQLDMO is a nightmare to redistribute. I am currently re-writing the application in dotnet 2.0 (some C# for business objects and VB.NET front end).
My question is - is there any alternative to using SQLDMO? I would like to avoid any COM Interop if possible and dont wantthe hassel of distributing the dozen of so files to the multitude of directories the SQLDMO requires.
Jon
|
|
|
|
|
System.Data.Sql.SqlEnumerator - Provides a mechanism for enumerating all available instances of SQL Server within the local network.
'--8<------------------------
Ex Datis:
Duncan Jones
Merrion Computing Ltd
|
|
|
|
|
Thats it. Thanks.
I knew there had to be a better way.
The hardest thing about .net is learning the framework itself, The languages are pretty simple. The framework is just so big.
Jon
|
|
|
|
|
how could i read data from excel sheet and and compaire them with some data in sql and save them in sql server .
amarni
|
|
|
|
|
I have solved some excel queries using ASD.Net - it is very powerful.
Thanks.
|
|
|
|
|
|
hello friends,
i developed one application on XP os , which contains backbround color as &H80000013& (ie Inactive Title Bar Text) and &H80000003& (ie Inactive Title Bar).
when i execute program on XP , it works finely . No problem in color displaying.
But if i execute its exe ob Windows98 or 2000server, that color does not displayed.(it display plan gray or diff color)
Plz help me , how to maintain the same color on different different OS
Rahul here
|
|
|
|
|
If you set the color on the properties window pane, make sure you didn't select a from the System color pallete. Those colors change based on the system settings for the computer.
The only other reason I could think of is perhaps your display settings are different across these platforms....Maybe you picked a 256 color that couldn't convert to a 16 bit color or something like that???
|
|
|
|
|
Hi All,
I made an activex dll in VB for my application which has some forms in it. The captions of controls in these forms are read at runtime from a properties file. I find that the captions are not shown correctly to the user when I load a properties file having Unicode Chars.
Can anyone tell me what could be wrong here?
Thanks and Regards,
Anil
|
|
|
|
|
Hi All,
I have setup of my application running on computer with backend sqlserver2000 on one computer. I want that I can run my application on many computers which are networked with the same central database. Can any one please suggest me what parameters should I have to keep in my mind or simply how can I achieve this?
I will be very thankful.
Varun Arora,
Software Engineer,
Knowledge Calls,
Gurgaon, India
|
|
|
|
|
|
how do display the data in flex grid after i extend the child of parent tree view?
my coding had error after i extend the child of tree view
Private Sub treeMain_MouseDown(Button As Integer, Shift As Integer, x As Single, y As Single)<br />
<br />
' Dim objNode As Node<br />
' ' Selecting the next node<br />
' objNode = treeMain.HitTest(x, y)<br />
<br />
' Selecting the first parent node if not is selected<br />
If treeMain.HitTest(x, y).Key = "" Then<br />
treeMain.SelectedItem = treeMain.Nodes(1)<br />
treeMain.SelectedItem.Selected = True<br />
End If<br />
<br />
While treeMain.SelectedItem Is Nothing<br />
Debug.Print "Waiting"<br />
DoEvents<br />
Wend<br />
<br />
Debug.Print "treeMain_MouseDown" & CStr(Button) & treeMain.SelectedItem.Key<br />
<br />
treeMain.SelectedItem.Selected = True<br />
treeMain.SelectedItem.Expanded = True<br />
If treeMain.SelectedItem.Parent Is Nothing Then<br />
treeMain.DragMode = ccOLEDragManual<br />
Else<br />
treeMain.DragMode = ccOLEDragAutomatic<br />
End If<br />
<br />
End Sub
Thanks
angela
|
|
|
|
|
Hi
Can any one explain me how an application can be made to work only for 7 days, what i mean is how can we force an application to be a demo version. and also how to conver the demo version to full version based on registration key.
Kind Regards
Sandy
|
|
|
|
|
I think this would be far to complex to just post here. There are Install packages that handle this or you would need to figure out how to create keys for products, encrytion, storing them , generating a license ( temp or perm), protecting the keys, Checking this information in your application code etc...
If you do not want to buy install software try this free open source product
http://www.activelocksoftware.com/[^]
|
|
|
|
|
let me in brief?
bcoz I want add a client side validation to a control?
want to be best student for ever.
|
|
|
|
|
Does anybody have knowledge of creating a MS Access "Relationships" form on which a control component can be moved, resized and linked using a line? Thank.
DYeh
|
|
|
|
|
I mean how to make a MS Access "Relationships" view style form. Within this form, I'd put some graphs/Icons which can be moved and linked with arrowed lines. Thanks.
|
|
|
|
|
hi all..
i have a question, how to write a program for barcode scanner in vb and access as my database.. did someone know about that..
areon25
|
|
|
|
|
|
hi all, i have a question, how to save image in access. can someone please help me..
areon25
|
|
|
|
|
|
You can get the complete visual basic source I submitted on
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=13693&lngWId=1
This is an ocx tha will add the photo outomatically for you just.
Check it out.
Rodney Godfried
Tiger Group/Pillar Software
|
|
|
|
|
hi all..
i have a question about how to filter the data.. acctually, what know how to filter data is
object.recordset.filter = filterstring
for example
adodc1.recordset.filter = "author = 'david'"
the question from the example above, it will filter only the word david..
so how i want to filter all the name david ??
for example in my database there are many david like david reader, david blake and what ever david, so how i want to filter all the name david??
after i filter it, how i want to display all record back..
what i do is with this code
adodc1.recordset. filter = ""
or
adodc1.recordset.filter = adfilternone
but there are nothing happen.. actually, i display my data with datagrid..
can someone know how to solve the problem..
thanks..
areon25
|
|
|
|
|
areon25 wrote: adodc1.recordset.filter = "author = 'david'"
the question from the example above, it will filter only the word david..
so how i want to filter all the name david ??
for example in my database there are many david like david reader, david blake and what ever david, so how i want to filter all the name david??
after i filter it, how i want to display all record back..
what i do is with this code
adodc1.recordset. filter = ""
or
adodc1.recordset.filter = adfilternone
but there are nothing happen.. actually, i display my data with datagrid..
can someone know how to solve the problem..
thanks..
I also used to work with data in access or from vb6. I never use filter to get data. But it doesn't mean that it is wrong at all. What I usually done is query data by using sql statement. I suggest you to read some information from here[^], and you might get some idea relate to your question.
|
|
|
|