|
how to create database with sql connection in vb.net
|
|
|
|
|
To which TYPE of database? Oracle, Sql Server, TimesTen?
See the Howto[^] in the documentation. You could generalize it like this;
Dim ConnectionString as String = ""
Using con As New SqlConnection(ConnectionString)
Using cmd As SqlCommand = con.CreateCommand
cmd.CommandText = "SELECT 1"
con.Open
cmd.ExecuteNonQuery
End Using
End Using
There are quite some tutorials on the internet. I suggest downloading a few and playing a bit with them.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
Another cross posting
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
I am new to the .NET Framework and i will love to learn all its languages but i do not know if it is a good idea to actually learn the whole framework documentation.
My question is how do i get to know a framwork?
|
|
|
|
|
Georges23 wrote: My question is how do i get to know a framwork?
Step by step, bit by bit.
Step trough the Beginner Portal[^], and choose one of the four directions to start with.
As you build more applications, you'll encounter new controls, new problems and new possibilities. That's the moment you hit either MSDN or CodeProject. That way you get to know the library gradually.
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
You might want to use the Object Browser within Microsoft's Visual Studio to view the available objects and classes within the System namespaces.
Within Visual Studio, use the view menu option to open, if not listed, within the same menu click the Other Windows sub menu. If you're unsure what the classes do visit the MSDN website for details on how to implement or use.
AsaApplications Com LLC
|
|
|
|
|
The best way is to pick up a book and read.
|
|
|
|
|
I do not think it is necessary or advisable to learn all its languages. Select one of them, and study it thoroughly. Later on, get used to the different look of the other languages, generally it is enough to understand code written in the other languages, and to port it to your favorite language.
|
|
|
|
|
Buckle up for this one.
So the company i've been working for, for the last two years asked me to train someone.
Two years ago I walked in here not knowing anything about programming, I learned several languages in a few months and ive become "the best programmer they have ever had".
So now I was asked to train someone. Not just anyone though, the bosses son.
Smart kid, just lacks any motivation and has zero work ethic. He has moments of promise, and then there was yesterday.
For the past 6 months i've been attempting to teach him HTML, VB JQUERY etc. Basic "hello world" stuff.
We've been using Lynda.com to give him a more visual example etc, giving him stuff thats simple.
Yesterday I had to show him again how to Define a variable in VB (you know DIM), which wasnt the bad part.
The bad part when he asks me whats wrong with his code and I find PHP  in there, and he's arguing with me about it.
No idea what to do with this one. Really seems like im at the end of my rope/patience.
Any idea's on how to feed someone the fundamentals?
|
|
|
|
|
This realllllllly isn't the right forum for this post. Head over to the Lounge, pull up a chair and prepare to be regaled with anecdotes, good advice, bad advice, and the downright bizarre.
|
|
|
|
|
Why are you wasting yours and the bosses' sons time? If he does not wants to learn, that's his decision. And yes, it's nothing else but a decision on his side - the stuff can be learnt from books, without any help for those willing.
It's no use to push a mule, it will not walk.
..tell the son he is fortunate to have you as a mentor. I would have advised the boss to put his son to work at cleaning toilets - at least it'd motivate him (in time) to learn something to make him valuable outside of the toilet. That way he'd at least be contributing as opposed to being a burden
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
I'm having trouble choosing a class to do the following job, any help appreciated.
Thus far I've been trying to make it work via List(Of custom structure), the generic SortedList(Of Single, Of Color) and SortedList() to little avail, both directly and sub-classing them.
1. Map numbers (from 0 to 1) to colours
2. The mappings would be discrete, e.g. you could have just two, or 500 (or more)
3. Either a class function or an external one would translate an input (0 < = x <= 1) into a color, either interpolated between two anchors or the color matching the next lowest or next highest anchor.
4. There must always be an anchor at 0 and another at 1 with n inbetween.
Initially I used a List(Of custom structure) and had a separate class that used a bunch of static functions to create said Lists but then decided I wanted to wrap the whole thing up in its own class, probably inlcuding that look-up function (plu various overloads). That's when I started having headaches.
Having a class with a List(Of T) member did the job pretty well until I realised that it would help if it was sorted and also ensured no duplicate anchors (and that there was always a 0 and a 1). So a SortedList seemed a muh better place to start and then I got quite stuck picking the best base class.
I'm pretty sure I need to subclass here since otherwise I can see myself having to implement ICollection, IList, IDictionary, I?Comparable, IEquatable etc. not my idea of fun!
Thanks,
Mike
|
|
|
|
|
Hello Sir/Mam
I'm trying connect sql server 2000 in windows service with other system on same network.
there are 4 system connected without any problem. But on other 4 system, it is giving error
on connection open while starting windows service. The error is: "the service on local computer started and then stopped some services stop automatically" etc. Same Connection string working in web service
without any error. But giving problem in Window Service. Is there any Configuration setting of that server or sql server 2000. Any help will be highly appreciated.........
|
|
|
|
|
Please do not cross post. You have already posted this in at least 2 other forums.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
And still failed to post it in the Database forum 
Soren Madsen
|
|
|
|
|
Hi
please Setup the COnnection pool size in your connection string
vijay
|
|
|
|
|
While that may be the answer to some question, it's not the answer to this question.
|
|
|
|
|
hello people this is the deal i have a problem i have "CALC" open but i want to close "CALC" when "TEST.EXE" is close thru the task manager
so
Private Sub OnApplicationExit(ByVal sender As Object, ByVal e As System.Windows.Forms.FormClosingEventArgs) Handles MyBase.FormClosing
For Each testproc As Process In Process.GetProcesses
If testproc.ProcessName = "calc" Then
testproc.Kill()
MsgBox("working good")
End If
Next
e.Cancel = False
End Sub
it works when i CLOSE the form manually File -> Exit ... but when i go to taskmgr and "End Process" is not closing "CALC"
any idea there ?
|
|
|
|
|
jitforce2585 wrote: any idea there
Yep... because your application is not being notified that it's being killed by the task manager.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
In Windows, processes are not notified before they are killed, so your TEST.EXE has no way of knowing that.
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
You don't understand how Task Manager does an "End Process", do you??
When you "End Process" something in Task Manager, it first tries to shutdown the process gracefully by sending a WM_CLOSE message to the app's main window. If the app doesn't respond to it, Task Manager will call TerminateProcess on the targeted process which will immediately halt all threads in the process, wait for any pending I/O operations to complete and then free up the memory that the process occupies.
When I say halt the process/threads, I mean your process stops executing immediately. Your code never gets notified of anything and never gets a chance to respond to ANYTHING. It just ceases to exist. That's why your code never gets executed.
|
|
|
|
|
i created a listener with the Waitforexit()
|
|
|
|
|
OK, and that means what to me, exactly?
|
|
|
|
|
my bad i wanted to reply and i clicked reply to u ...
|
|
|
|
|
Yes. You have two applications, that should act like a single. It's called a dirty hack.
There are enough known alternatives to the hack; instead of closing CALC when you exit, have CALC check whether you are still alive (poll using a backgroundthread) and exit if you ain't. Create a watchdog (a third app) that checks whether both are alive. Create a SERVER and send a heartbeat. Create a remote thread in CALC.exe and hide your check there.
In your case the watchdog is easiest; I'm betting a banana that your CALC is a native app and that you don't have the code.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
