the Cheat Death
Yes, 2 times actually - directly behind the other - am I just jumped the Cheat Death . Both male drivers have their red lights overlooked. First time here and is 2 minutes later here.
The first time the woman has not seen me it, I only noticed when it squeaked right by me and a car swerved around me made (and then continue on without me much as a glance). The second time the driver would not even have to check, but my adrenaline was fortunately still high enough to escape the danger ... present first a smoke ...
Monday, March 30, 2009
Friday, March 27, 2009
Dark Smelly Foamy Urine
why it is no longer en vogue to hate Microsoft
Oh man, as we have previously hated Microsoft, right? A real reason gabs not really up on the stories that DOS and Windows are actually stolen and stuff. And well, To write a major document in Word, with reasonable formatting is quite a PITA
In revenge for every single blue screen then you have entered at all sites where you had to specify an email address, "bill@microsoft.com" (simply says , you have not done this?). From Clippit I will not even begin ...
But, the times are over. Microsoft has bought obviously better designer. MacOS does indeed still much better than Windoze, but the system with the largest distribution happens to Windows (which makes it interesting from a commercial point of view for developers). The current office suite is really fun and you can Power Point presentations and build now, do not look the like the beginnings of the computer era. MS, from its developer tools to the Express versions, of course, not all features of the large versions, but still are far from crippled. You can even commercial products with it - create - all legal.
So I'm just about to me - completely free of charge - in C # & WPF incorporate (as a transition from VB6 / VBA) and learn to appreciate it more and more. The possibilities are enormous and you also feel that because people have really thought what with.
(Clippit hate but is still allowed!)
some links that prove the coolness of M $:
C64 emulator in Silverlight
MIXonline descry - visualizing information
Codename Chimpanzee (vertical scrolling shmup)
integration of Vuze (BitTorrent Client , Azureus successor) in XBOX360
Oh man, as we have previously hated Microsoft, right? A real reason gabs not really up on the stories that DOS and Windows are actually stolen and stuff. And well, To write a major document in Word, with reasonable formatting is quite a PITA
In revenge for every single blue screen then you have entered at all sites where you had to specify an email address, "bill@microsoft.com" (simply says , you have not done this?). From Clippit I will not even begin ...
But, the times are over. Microsoft has bought obviously better designer. MacOS does indeed still much better than Windoze, but the system with the largest distribution happens to Windows (which makes it interesting from a commercial point of view for developers). The current office suite is really fun and you can Power Point presentations and build now, do not look the like the beginnings of the computer era. MS, from its developer tools to the Express versions, of course, not all features of the large versions, but still are far from crippled. You can even commercial products with it - create - all legal.
So I'm just about to me - completely free of charge - in C # & WPF incorporate (as a transition from VB6 / VBA) and learn to appreciate it more and more. The possibilities are enormous and you also feel that because people have really thought what with.
(Clippit hate but is still allowed!)
some links that prove the coolness of M $:
C64 emulator in Silverlight
MIXonline descry - visualizing information
Codename Chimpanzee (vertical scrolling shmup)
integration of Vuze (BitTorrent Client , Azureus successor) in XBOX360
Wednesday, March 25, 2009
Pirates Of The Caribbean Strumming
My body - my temple. How do I get body and soul? (1)
What comes after the body when we develop ourselves spiritually? A strange question ...... I eingentlich have already indicated that I had previously given little attention to my body because my goals were all spiritual in nature ;-)) I am fascinated by reports of swallowed food light, rise and duration of meditation. Even as a teenager I had said: "I wish we would eat anything and could just live like it would be easier and everything unkoplizierter.." Although I knew in my head that my body, "my friend" is, but honestly for a TEMPLE I did not keep him! He was not at all important, but many more it was about to rise above ..... in my head was INCREDIBLY MUCH spiritual knowledge, my Content, "up" constant, but the results in real life were absent. Who has?
What lies behind it? The belief that it actually " ht what else GE " as I fully engage in life here, that it rather a transition to something "more important" was, that it is not "Superficial" to all the could go etcetc.
-engage fully, what does this mean? to say
* YES to the point where we just now are at this moment in life to say
* YES to our body As it is right now, to accept it to appreciate to love with him to speak his praise skills and praise
* YES to say ourselves ; to accept our skills as well as our " expansion capabilities " (sometimes called errors). The light and the darkness within us to honor and respect. to say
* YES to our divine and to know that the LIFE is divine himself with every aspect! There is nothing outside of God.
* Recognise: There are only the flow of "Well-Being," of abundance of harmony health, happiness, happiness and joy and if we do not even, then it is because we are currently confronted the universal flow and block him ..... can not flow freely through us to calm: even that was planned before we came, we knew that it would be in a duality so and we were excited and enthusiastic experience, this contrasts to can.
* YES to our relationships, families, neighbors, colleagues .... every person in our life has a certain Sense, even if we do not yet understand now. Everyone has a wrapped gift for us - do you mean?!
* YES to our past and all that goes with it.
* YES to our family of origin with all the challenges and growth opportunities it has given us. And yes to all the skills, talents and values that we got from there.
fully engage oneself is simply coming into line with the way it is, without having to change it.
it a try: Imagine a person, a situation, a weakness of character of yourself a controversial issue, a problem or similar before. Let ds picture quite vividly alive and appear before you. See the person or the topic directly in front of you now and say aloud the word "YES". Do this several times, out loud, "YES" to say and watch what happens! Changing the image? Try it out and share your experience here with us ;-)))
PS: the next day's go further! This was just the beginning of the line body-mind ;-))
What comes after the body when we develop ourselves spiritually? A strange question ...... I eingentlich have already indicated that I had previously given little attention to my body because my goals were all spiritual in nature ;-)) I am fascinated by reports of swallowed food light, rise and duration of meditation. Even as a teenager I had said: "I wish we would eat anything and could just live like it would be easier and everything unkoplizierter.." Although I knew in my head that my body, "my friend" is, but honestly for a TEMPLE I did not keep him! He was not at all important, but many more it was about to rise above ..... in my head was INCREDIBLY MUCH spiritual knowledge, my Content, "up" constant, but the results in real life were absent. Who has?
What lies behind it? The belief that it actually " ht what else GE " as I fully engage in life here, that it rather a transition to something "more important" was, that it is not "Superficial" to all the could go etcetc.
-engage fully, what does this mean? to say
* YES to the point where we just now are at this moment in life to say
* YES to our body As it is right now, to accept it to appreciate to love with him to speak his praise skills and praise
* YES to say ourselves ; to accept our skills as well as our " expansion capabilities " (sometimes called errors). The light and the darkness within us to honor and respect. to say
* YES to our divine and to know that the LIFE is divine himself with every aspect! There is nothing outside of God.
* Recognise: There are only the flow of "Well-Being," of abundance of harmony health, happiness, happiness and joy and if we do not even, then it is because we are currently confronted the universal flow and block him ..... can not flow freely through us to calm: even that was planned before we came, we knew that it would be in a duality so and we were excited and enthusiastic experience, this contrasts to can.
* YES to our relationships, families, neighbors, colleagues .... every person in our life has a certain Sense, even if we do not yet understand now. Everyone has a wrapped gift for us - do you mean?!
* YES to our past and all that goes with it.
* YES to our family of origin with all the challenges and growth opportunities it has given us. And yes to all the skills, talents and values that we got from there.
fully engage oneself is simply coming into line with the way it is, without having to change it.
it a try: Imagine a person, a situation, a weakness of character of yourself a controversial issue, a problem or similar before. Let ds picture quite vividly alive and appear before you. See the person or the topic directly in front of you now and say aloud the word "YES". Do this several times, out loud, "YES" to say and watch what happens! Changing the image? Try it out and share your experience here with us ;-)))
PS: the next day's go further! This was just the beginning of the line body-mind ;-))
Tuesday, March 24, 2009
Women Playing With Thenselves
the fetid swamp of hypocrisy is the so called German policy
Oh our dear Mr. Köhler. In his speech he said
The IMF uses the extension of loans as leverage to those countries in so-called structural adjustments, past of democratic structures to enforce. These include, irrespective of the particular situation of the country
I recommend for further reading the page http://www.koehler-iwf.de
Also: "The new ruler of the World "by Jean Ziegler
The only people who continue to show unflattering its neo-liberal caricature (you have to keep them almost too good) are Guido and his party of higher income earners.
Oh our dear Mr. Köhler. In his speech he said
The financial markets have been growth engines. They ran a long well. Therefore, we have left them alone. The result was dissolution of boundaries and lack of commitment. Now we see that the market is not solely directed. It needs a strong state that sets the market rules and ensures their enforcement . For market economy thrives on competition and the limitation of economic power . It thrives on responsibility and personal liability for their own actions, they need transparency and compliance. To all the people must have trust. Thecould be found in a dictionary, if by "hypocrisy" looks up - it was just the IMF, the Board of Köhler 2000 to 2004, the indebted states with the same recipes always "helped".
The IMF uses the extension of loans as leverage to those countries in so-called structural adjustments, past of democratic structures to enforce. These include, irrespective of the particular situation of the country
- deregulation of markets
- privatization of state enterprises
- focus on exports
I recommend for further reading the page http://www.koehler-iwf.de
Also: "The new ruler of the World "by Jean Ziegler
The only people who continue to show unflattering its neo-liberal caricature (you have to keep them almost too good) are Guido and his party of higher income earners.
Sunday, March 22, 2009
Fluttering In My Upper Abdomen
spirituality and physicality ! Unite!
For some time I am working intensively on how to spirituality and physicality better links. I know so many spiritual people who secretly (Or open LOL) have the opinion that their bodies would be a bad design, life here in the 3-dimensionality of a gross mistake and it would be the most important thing now quick to learn everything, so this is really the last life on Earth and they back to "home to God" to go.
has Frankly I done it long brooding, where would I confess immediately that I have witnessed this league itself is very long ;-)) a long time I've my body does not really come in possession , not his exercise, fresh air and physical experience, where, according to which he longs. More and more I understand that life here in this wonderful body no karmic kickback is because I had not yet gathered hald in the previous incarnation, but that wanted my soul and my spirit and EXTRA FULLY AWARE of this life and do . Not because I learned I had not enough to earn the "back home" ticket , but that we are here to pure joy and pleasure in life , since "Back Home" (God, primal force, universal energy, etc) and EXACTLY expresses itself through our experience this ever-expanding extended, expanded and more will .
HEY, "Back Home" will be accurate have here is not that great?
What do you think this?
For some time I am working intensively on how to spirituality and physicality better links. I know so many spiritual people who secretly (Or open LOL) have the opinion that their bodies would be a bad design, life here in the 3-dimensionality of a gross mistake and it would be the most important thing now quick to learn everything, so this is really the last life on Earth and they back to "home to God" to go.
has Frankly I done it long brooding, where would I confess immediately that I have witnessed this league itself is very long ;-)) a long time I've my body does not really come in possession , not his exercise, fresh air and physical experience, where, according to which he longs. More and more I understand that life here in this wonderful body no karmic kickback is because I had not yet gathered hald in the previous incarnation, but that wanted my soul and my spirit and EXTRA FULLY AWARE of this life and do . Not because I learned I had not enough to earn the "back home" ticket , but that we are here to pure joy and pleasure in life , since "Back Home" (God, primal force, universal energy, etc) and EXACTLY expresses itself through our experience this ever-expanding extended, expanded and more will .
HEY, "Back Home" will be accurate have here is not that great?
What do you think this?
Wednesday, March 18, 2009
Fun 21st Birthday Title
Google & phone contacts, the 2nd
Earlier mobile phone generations did have some of the possible to define for each contact a profile picture, but this was meisst reacted very inconsistent: Not enough disk space, because the images were stored full-size, unsightly, as it did not indemnify the images could not and the aspect ratio was inconsistent and the images were stored in the phone, so that with every new phone should have made the effort (ie every 2 years) the images to capture new. Conclusion: useless.
But those days are over! Thanks to the synchronization of Google mail and telephone contacts you can now easily reach the square profile images that have become quasi-standard to assign the contact and these are then displayed in the phone. Nice gimmick.
But currently there is a bug in Gmail that will prevent that you can assign a contact a picture that has not saved any email address (only a mobile number for example).
Earlier mobile phone generations did have some of the possible to define for each contact a profile picture, but this was meisst reacted very inconsistent: Not enough disk space, because the images were stored full-size, unsightly, as it did not indemnify the images could not and the aspect ratio was inconsistent and the images were stored in the phone, so that with every new phone should have made the effort (ie every 2 years) the images to capture new. Conclusion: useless.
But those days are over! Thanks to the synchronization of Google mail and telephone contacts you can now easily reach the square profile images that have become quasi-standard to assign the contact and these are then displayed in the phone. Nice gimmick.
But currently there is a bug in Gmail that will prevent that you can assign a contact a picture that has not saved any email address (only a mobile number for example).
Monday, March 16, 2009
Australian Shepherd And Poodle Mix
Hagen Rether (legally accurate ) prophecy
About one and a half years I was in Frankfurt at Hagen Rether in cheese. Great program. Yesterday I got my CD ("Love Two") by the Program again listened to in silence and came across a passage that is truly remarkable. And although it is about the shootings in Erfurt and Emsdetten in his time. In addition to his great analysis, he says even advance the next school shooting in one year:
I mean well ... you must be with the social situation which I have alluded in the previouse post, not to be clairvoyant to predict that. Nevertheless, leads Mr. Reth, given recent events, with the text just how right he was, and above all, he proved right should: Nothing happens, the necessary discourses are still not out (and the next run amok - will come sooner or later - will not this be done)!
About one and a half years I was in Frankfurt at Hagen Rether in cheese. Great program. Yesterday I got my CD ("Love Two") by the Program again listened to in silence and came across a passage that is truly remarkable. And although it is about the shootings in Erfurt and Emsdetten in his time. In addition to his great analysis, he says even advance the next school shooting in one year:
I mean well ... you must be with the social situation which I have alluded in the previouse post, not to be clairvoyant to predict that. Nevertheless, leads Mr. Reth, given recent events, with the text just how right he was, and above all, he proved right should: Nothing happens, the necessary discourses are still not out (and the next run amok - will come sooner or later - will not this be done)!
Thursday, March 12, 2009
How To Buy Community Service Hours
again Killer Game debate - it pisses me
It sickens me. Conservative politicians scream in a fit of activism again for a ban on so-called "killer games" and for security locks in schools. As always in the conservative camp is trying to turn around the symptoms rather than treat the cause. Of course, had the killer games on his computer! Which male youth in our region aged between 15 and 25 has not? 10 maybe 20 percent I would guess times carefully. The So does 80% of this group to run amok, or what?
Point 1: He was 17, would therefore not allowed to have any such games. That is, if existing laws were enforced accordingly handed the completely
Item 2: is to be called "Killer Games" and "motive" in a sentence quite simply outrageous, but a clever psychological trick. Mixing just cause and trigger in and it absorbs the reader. The trigger could have been but also the type of coverage of the BILD newspaper about the massacre in the U.S. are, or perhaps his father has given him the night before any attention. All this is not the cause of the rampage. This
All garbage is put before us so that we do not question what the actual cause for such outbreaks of violence: An increasingly fierce elbow society, which divides into winners and losers. But the boy came from a good home, was a good table tennis player! So what? Problems can not be assessed objectively when it comes to something like that. It just depends on how the problems are perceived by the person himself. Someone who pull the trigger with us from his monthly salary € 30,000 € 15,000 to the tax office has the feel may be worse than a family man in Africa, after months of drought wegstirbt one of his two cattle. What it is now life-threatening, like any decide. The fact is that this kind of feel the gravity of the problem, a very personal thing.
The gunman who shot mainly girls. Perhaps he has never had a girlfriend and the girls in his school have bullied him constantly? Every attended
in the last 20 years the school has, knows what it may be a hard place, especially if you are not the "cool" too. But by whom will the children learn empathy for, if the ruling class promoted in our country, just that everyone should look after themselves first, thinking to yourself, otherwise it does not, who can Save.
It is rushed toward them that are at the bottom, so that the shrinking expanding middle class down occurs against those who have even less - to fight rather than those who are the real perpetrators of this situation. This has always been an effective means of distraction, when the overall economic situation is worse.
In summary, I think, say that there is no simple cause for the problem of Schulamokläufe, as our politicians would have us (preferably conservative interior minister) will be happy. It might not someone come up with the idea to provide our changing society in question.
There remains a pissed off Michael.
edit 1:
to add 2 nice comments at H:
thought for politicians, Part 1: causality
shooting clubs and private gun ownership should not of course be banned
edit 2:
He is in our world has become a murderer - WEISSGARNIX (blog)
It sickens me. Conservative politicians scream in a fit of activism again for a ban on so-called "killer games" and for security locks in schools. As always in the conservative camp is trying to turn around the symptoms rather than treat the cause. Of course, had the killer games on his computer! Which male youth in our region aged between 15 and 25 has not? 10 maybe 20 percent I would guess times carefully. The So does 80% of this group to run amok, or what?
Point 1: He was 17, would therefore not allowed to have any such games. That is, if existing laws were enforced accordingly handed the completely
Item 2: is to be called "Killer Games" and "motive" in a sentence quite simply outrageous, but a clever psychological trick. Mixing just cause and trigger in and it absorbs the reader. The trigger could have been but also the type of coverage of the BILD newspaper about the massacre in the U.S. are, or perhaps his father has given him the night before any attention. All this is not the cause of the rampage. This
All garbage is put before us so that we do not question what the actual cause for such outbreaks of violence: An increasingly fierce elbow society, which divides into winners and losers. But the boy came from a good home, was a good table tennis player! So what? Problems can not be assessed objectively when it comes to something like that. It just depends on how the problems are perceived by the person himself. Someone who pull the trigger with us from his monthly salary € 30,000 € 15,000 to the tax office has the feel may be worse than a family man in Africa, after months of drought wegstirbt one of his two cattle. What it is now life-threatening, like any decide. The fact is that this kind of feel the gravity of the problem, a very personal thing.
The gunman who shot mainly girls. Perhaps he has never had a girlfriend and the girls in his school have bullied him constantly? Every attended
in the last 20 years the school has, knows what it may be a hard place, especially if you are not the "cool" too. But by whom will the children learn empathy for, if the ruling class promoted in our country, just that everyone should look after themselves first, thinking to yourself, otherwise it does not, who can Save.
It is rushed toward them that are at the bottom, so that the shrinking expanding middle class down occurs against those who have even less - to fight rather than those who are the real perpetrators of this situation. This has always been an effective means of distraction, when the overall economic situation is worse.
In summary, I think, say that there is no simple cause for the problem of Schulamokläufe, as our politicians would have us (preferably conservative interior minister) will be happy. It might not someone come up with the idea to provide our changing society in question.
There remains a pissed off Michael.
edit 1:
to add 2 nice comments at H:
thought for politicians, Part 1: causality
shooting clubs and private gun ownership should not of course be banned
edit 2:
He is in our world has become a murderer - WEISSGARNIX (blog)
Wednesday, March 11, 2009
Free Open Basketball Gym
article: "I cook therefore I am - whatever"
I found a great article on ready meals and dependence on food companies.
(Incidentally, generally a very interesting blog, this http!: / / www.muendig.at )
I found a great article on ready meals and dependence on food companies.
"[...] There are now already in plastic bottles of pancake eggs, milk and flour mixed together in the correct ratio that can apparently many do not more. The "outsourcing" of our daily work brings relief in the short term, longer term, however, the price is for a rising dependence on the supply of the food industry and supermarkets .[...]"Click Me
(Incidentally, generally a very interesting blog, this http!: / / www.muendig.at )
Tattoo Ideas For Mayan Characters
a (imho) a good tomato sauce
Ok people. I think so of myself that I have a pretty good tomatoes (pasta) sauce do. So here's my recipe. Since the preparation takes a while to claim I recommend preparing a größereb crowd. then freeze in portions, and there is always delicious food at what home. In any case better than Fertigfrass.
Ingredients (I guess times for 4 people):
we. First, the so-called
Sofritto. This is a mixture of sautéed vegetables, that is the basis of many Italian dishes. Depending on who you ask need different things "should" turn. I for one am onion, garlic and celery. But it would also take him as peppers, carrots, chilli peppers cut, etc. This
onion, garlic and celery in olive oil and small (not to be used sparingly!) Sauté over low heat until everything is soft. The mixture must not accept any color! The whole thing lasts about 15 to 20 minutes. Then, basil and tomatoes and stir well. This mixture now needs to at least (!) One hour less Cooked slowly. Every now and forget not to stir. The right time is when all the sauce has a smooth texture and no longer be separated liquid and solid components from one another. Hard to describe - there is definitely a consistency with the time change that the mixture can be homogeneous ...
can now be switched off the stove and seasoned with pepper and salt (the salt with me are just not too timid!) Are seasoned. When the sauce has ceased to cook, makes a dash of balsamic vinegar still there (such as one to two tablespoons). This contradicts the sweetness of the tomatoes and the sauce is an incomparable flavor.
n GUDN!
This is a basic tomato sauce, which in itself is pretty tasty, but can of course also serve as a basis for other sauces, ie with chillies, grilled vegetables, carrots (even the Sofritto with pure), minced, cream, tuna capers, olives, etc. ..
Ok people. I think so of myself that I have a pretty good tomatoes (pasta) sauce do. So here's my recipe. Since the preparation takes a while to claim I recommend preparing a größereb crowd. then freeze in portions, and there is always delicious food at what home. In any case better than Fertigfrass.
Ingredients (I guess times for 4 people):
- 2 stalks celery
- a medium-sized onion
- 3 Knaoblauchzehen
- 1kg (usually means the 2 packages) chopped tomatoes or whole tomatoes from can or tetra pack. Really take the lump or the whole and not the mashed tomatoes to get the sauce a nice texture and is so rustic!
- olive oil basil (frisch!)
- salt pepper balsamic
we. First, the so-called
Sofritto. This is a mixture of sautéed vegetables, that is the basis of many Italian dishes. Depending on who you ask need different things "should" turn. I for one am onion, garlic and celery. But it would also take him as peppers, carrots, chilli peppers cut, etc. This
onion, garlic and celery in olive oil and small (not to be used sparingly!) Sauté over low heat until everything is soft. The mixture must not accept any color! The whole thing lasts about 15 to 20 minutes. Then, basil and tomatoes and stir well. This mixture now needs to at least (!) One hour less Cooked slowly. Every now and forget not to stir. The right time is when all the sauce has a smooth texture and no longer be separated liquid and solid components from one another. Hard to describe - there is definitely a consistency with the time change that the mixture can be homogeneous ...
can now be switched off the stove and seasoned with pepper and salt (the salt with me are just not too timid!) Are seasoned. When the sauce has ceased to cook, makes a dash of balsamic vinegar still there (such as one to two tablespoons). This contradicts the sweetness of the tomatoes and the sauce is an incomparable flavor.
n GUDN!
This is a basic tomato sauce, which in itself is pretty tasty, but can of course also serve as a basis for other sauces, ie with chillies, grilled vegetables, carrots (even the Sofritto with pure), minced, cream, tuna capers, olives, etc. ..
Thursday, March 5, 2009
Vintage Girdle Gallery
How to make Visual Studio 2008 Express Edition (VB.net) to connect to a remote SQL Server
The Express Edition of Microsoft Visual Studio lacked the tools to connect to a remote SQL database to produce. One can indeed make the wizard to connect to a local instance, but we want a client-server database application tinker. And that "for free".
So here's a quick guide on how I do without frills a corresponding connection can produce, without the tools and wizards.
After we have created a new project (Windows Forms application), we
Create Our first and foremost a form called frmStart, comes to a text field name txtFeld . The craft was about it for now with form.
I use this example in advance of the simplicity that you have a working SQL server on the network, in which (if SQL Express) Remote Connections are enabled!
the code here:
Public Class frmStart
frmStart_Load Private Sub (ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim cmdSQL As SqlClient.SqlCommand
Dim asyncResult As System.IAsyncResult
Dim returnValue As SqlClient.SqlDataReader
Dim strSQL As String
Using conSQL As New SqlClient.SqlConnection("Data Source=[SERVERNAME/INSTANZ];Initial Catalog=[DATENBANKNAME];User Id=[USERNAME];Password=[PASSWORT];Async=true")
conSQL.Open()
strSQL = "[SQLSTRING]"
cmdSQL = New SqlClient.SqlCommand(strSQL, conSQL)
cmdSQL.BeginExecuteReader asyncResult = ()
returnValue = cmdSQL.EndExecuteReader (asyncResult)
returnValue.Read If () Then
Me.txtFeld.Text returnValue.Item = ( "[Field Name]")
End If End Using
End Sub End Class
What does this mean in detail?
The variable declaration:
As SqlConnection Dim cmdSQL
Dim asyncResult As System.IAsyncResult
returnValue SqlClient.SqlDataReader
Dim strSQL As String
Using conSQL As New SqlClient.SqlConnection ("Data Source = [SERVERNAME / INSTANCE]; Initial Catalog = [dbname]; User Id = [USERNAME] Password = [PASSWORD]; Async = true")
conSQL.Open ()
strSQL = "[SQLString]
cmdSQL = New SqlConnection (strSQL, conSQL)
asyncResult = cmdSQL.BeginExecuteReader ()
returnValue = cmdSQL.EndExecuteReader (asyncResult)
returnValue.Read If () Then
Me.txtFeld.Text returnValue.Item = ("[Field Name]")
End If
End Using
End Sub
End Class
The Express Edition of Microsoft Visual Studio lacked the tools to connect to a remote SQL database to produce. One can indeed make the wizard to connect to a local instance, but we want a client-server database application tinker. And that "for free".
So here's a quick guide on how I do without frills a corresponding connection can produce, without the tools and wizards.
After we have created a new project (Windows Forms application), we
Create Our first and foremost a form called frmStart, comes to a text field name txtFeld . The craft was about it for now with form.
I use this example in advance of the simplicity that you have a working SQL server on the network, in which (if SQL Express) Remote Connections are enabled!
the code here:
Public Class frmStart
frmStart_Load Private Sub (ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim cmdSQL As SqlClient.SqlCommand
Dim asyncResult As System.IAsyncResult
Dim returnValue As SqlClient.SqlDataReader
Dim strSQL As String
Using conSQL As New SqlClient.SqlConnection("Data Source=[SERVERNAME/INSTANZ];Initial Catalog=[DATENBANKNAME];User Id=[USERNAME];Password=[PASSWORT];Async=true")
conSQL.Open()
strSQL = "[SQLSTRING]"
cmdSQL = New SqlClient.SqlCommand(strSQL, conSQL)
cmdSQL.BeginExecuteReader asyncResult = ()
returnValue = cmdSQL.EndExecuteReader (asyncResult)
returnValue.Read If () Then
Me.txtFeld.Text returnValue.Item = ( "[Field Name]")
End If End Using
End Sub End Class
What does this mean in detail?
The variable declaration:
As SqlConnection Dim cmdSQL
Dim asyncResult As System.IAsyncResult
returnValue SqlClient.SqlDataReader
Dim strSQL As String
- cmdSQL is the Command object, which is the container for the SQL command
- asyncResult is information on the status the asynchronous operation (New in ADO.net 2.0 - try on asynchronous / synchronous operations please Googel, leading too far)
- return value is the Reader object that later will contain our result
- strSQL is only the string variable for our SQL command
Using conSQL As New SqlClient.SqlConnection ("Data Source = [SERVERNAME / INSTANCE]; Initial Catalog = [dbname]; User Id = [USERNAME] Password = [PASSWORD]; Async = true")
conSQL.Open ()
- Using [Connection variable] As New SqlClient.SqlConnection ([Connection String]) ensures that we use the connection string defined with the connection within the Using statement. As the Connection String should look like? -> http://www.connectionstrings.com/ The connection string must have the statement, included so that the asynchronous with the Async = true " Operation works!
- conSQL.Open () opens the connection finally
strSQL = "[SQLString]
cmdSQL = New SqlConnection (strSQL, conSQL)
asyncResult = cmdSQL.BeginExecuteReader ()
- strSQL = "..." Here we define our SQL string, so SELECT * FROM tblIrgendwas
- then the Command object, the SQL string and the connection will go to the command passed
- and we have the status of the async operation of the previously defined variable
returnValue = cmdSQL.EndExecuteReader (asyncResult)
returnValue.Read If () Then
Me.txtFeld.Text returnValue.Item = ("[Field Name]")
- our reader object "return value" we have the result of the query to ...
- ... then, important thing, only when the reader object has finished reading ...
- ... we have to the text box, type a value! If this would be missing if it comes höchstwarscheinlich an error because the program is faster in the next line when the server is the result has delivered! It then comes the error:
"To evaluate an indexed property, the property must be qualified and the arguments must be explicitly provided by the user." (Item) and
"Invalid attempt to read when no data are available." (Message)
End If
End Using
End Sub
End Class
- close everything back what we have to press opened
Subscribe to:
Comments (Atom)