|
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.
|
|
|
|
|
hi all..
i have a problem writing a program in vb and access as my database. actually, i want to add/minus data in my field in my database in access.. for example..
field1(Item)..................field2(Quantity)
Item1...........................5
Item2...........................8
Item3...........................9
Item4...........................3
for the example above, in my database in access there is a table with 2 field that is field1(Item) and field2(Quantity) where the datatype for field2 is in number. so how can i add/minus in field2 for example in row1 field2, i want to add the data make it 6 and the table like below..
field1(Item)..................field2(Quantity)
Item1...........................6
Item2...........................8
Item3...........................9
Item4...........................3
can someone please help me..
areon25
|
|
|
|
|
That is relate to a basic SQL statement in Ms access. I suggest you to read this article[^] to get some idea about SQL statement which relate to what you need.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
