|
Hello,
Right click your project and then click on Add->Add Module. Give the module any name.
Create a Function within the module, such as: (in this case, I named my Module "Functions" and my Function "Test()". I used the code you provided just for an example. You can name the Module and the Function differently. Here is the complete module)
Module Functions
Function test()
Dim cm As New SqlClient.SqlCommand
Dim cn As New SqlClient.SqlConnection
cn.ConnectionString = "data source=abc; initial catalog=books; user id= sa; password=sa;"
cn.Open()
cm.Connection = cn
cm.CommandText = "select * from info"
cm.CommandType = CommandType.Text
End Function
End Module
To call the function, all that you need to do is use the function name that you put it under. In my case, I would use test() wherever I needed the code to be executed.
I hope this solves your problem  ,
Programmer2k4
My sig:
"The so-called 'Bugs' do not exist, they are merely features hidden by developers with message boxes that say 'An unhandled exception has occurred'." - Programmer2k4
"And it is a professional faux pas to pay someone else to destroy your computer when you are perfectly capable of destroying it yourself." - Roger Wright
I now use my CodeProject Blog!
|
|
|
|
|
hi,
you are done a wonderful job (SQL code generator) but there is a problem in my system while executing your project. at run time a message "Could not bind to the new display member.
Parameter name: newDisplayMember" is displayed and the project can't run on my machine. so please be kind enough to give me a remedy as soon as possible. my email id is shiju_puravoor@hotmail.com.
thanking you,
yours truely,
theertha
|
|
|
|
|
The chances of the person you posted this message for are zero! The only place your going to get a response from this person is if you post your message in his article's forum, not here.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello,
I am currently writing an application using the Windows Media Player library to read files. However, since Windows Media Player takes a couple seconds to buffer the data, everytime I call WMP1.status it returns "Opening Media..." (a string). Is it possible to pause/stall the sub or function until the value for WMP1.status changes? (For an example, once it changes from the "Opening Media...", I could go about doing the rest of my function.)
I have tried using a Do Loop, however, with the way I coded it, the loop freezes the application forever.
Edit:
I have noticed something strange with the behavior of Windows Media Player. After I set it to a file, and I display a MsgBox, it all loads very fast; however, without a message box, it seems to take quite a while. Is this caused due to the MsgBox 'somewhat rushing' the previous code to finish loading? It doesn't matter what the contents of the MsgBox are, as long as it (the MsgBox) is displayed. Would it be possible for me to fake the MsgBox, so that the user doesn't have to press any buttons, and yet it still forces the previous code to run fast?
Edit #2:
Is it possible for me to stall the Sub of the Button Click event for a predetermined amount of time (eg, 3 seconds) to allow the media player to finish loading?
This problem has really gotten me this time. 
Any suggestions or help will be greatly appreciated,
Programmer2k4
My sig:
"The so-called 'Bugs' do not exist, they are merely features hidden by developers with message boxes that say 'An unhandled exception has occurred'." - Programmer2k4
"And it is a professional faux pas to pay someone else to destroy your computer when you are perfectly capable of destroying it yourself." - Roger Wright
I now use my CodeProject Blog!
|
|
|
|
|
Programmer2k4 wrote:
However, since Windows Media Player takes a couple seconds to buffer the data, everytime I call WMP1.status it returns "Opening Media..." (a string). Is it possible to pause/stall the sub or function until the value for WMP1.status changes?
No. The usual way to achieve this is to let the object you use notify you when its state has changed. According to the Windows Media Player 10 SDK[^] there is a Player.StatusChange Event[^]. So instead of constantly checking the Player.status[^] property you should use an event handler.
Programmer2k4 wrote:
I have tried using a Do Loop, however, with the way I coded it, the loop freezes the application forever.
Don't use polling[^] as long as there's a better alternative, especially not by using a loop as it (without any precautions) will take all available CPU time. If you really need polling then at least use a timer[^].
Programmer2k4 wrote:
After I set it to a file, and I display a MsgBox, it all loads very fast; however, without a message box, it seems to take quite a while. Is this caused due to the MsgBox 'somewhat rushing' the previous code to finish loading?
I guess that this is just a side effect of your usage of polling. As long as the message box is displayed your program is not "trapped" in your loop which leaves considerably more CPU time for the Media Player. I suggest you try to solve your problem with event handling. If you run into any problems just ask again (maybe with some small code excerpts this time).
Best regards
Dennis
|
|
|
|
|
Thanks for the information in regards to my problem. I never knew there was a Windows Media Player 10 SDK, the whole time I've been trying just to link to the file under "C:\Windows\"
Thanks,
Programmer2k4
My sig:
"The so-called 'Bugs' do not exist, they are merely features hidden by developers with message boxes that say 'An unhandled exception has occurred'." - Programmer2k4
"And it is a professional faux pas to pay someone else to destroy your computer when you are perfectly capable of destroying it yourself." - Roger Wright
I now use my CodeProject Blog!
|
|
|
|
|
Edit #2
You can use Threads to stop the function for predetermined amount of time.
|
|
|
|
|
Hi,
I'm a beginner programmer and I was wondering would it be possible to make a simple program in VB or C++ that would allow you wake up your pc from stand by or hibernate mode? If so, how would I go about doing this?
Thanks,
Jackie
|
|
|
|
|
|
Well, then how do those programs like pc alarm clocks do it?
|
|
|
|
|
Jackiem3001 wrote:
Well, then how do those programs like pc alarm clocks do it?
I repeat part of my answer: "Of all the wake from stand-by or hibernate functions I've heard of are all hardware related"
So, given the breadth of my knowledge (which I've already stated), you would need the hardware in the PC to support this function. I've never heard of a PC that will wake at a specific time (That is not to say that they don't exist).
Of all the PC alarm clock programs I've ever heard of they all sit in the background while the PC is running waiting for their preset time to arrive so they can do what they need to do.
Cada uno es artifice de su ventura
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
Dear members of CodeProject,
I want to invite the most experienced coders (C#, VC++, VB, VB.NET, ASP, ASP.NET and all the other technologies) to join the new outsourcing auction site. There is over 5 the most famous sites on the web now (like RentACoder.com, Elance.com, GetAFreelancer.com and other) but our site is absolutely outstanding because it have now and will have in future a lot of functions and features.
Now under the launch of our site we are looking for skilled, experienced and honest developers to join us. You will work directly with customers, NO agencies, NO third party providers. We need teams of developers or very experienced individuals with perfect English (and maybe German) skills.
If you are INDIVIDUAL you MUST have at least 2 years in outsourcing like freelancer (development, working with customers directly, knowledge about full cycle of development, keep in mind deadlines, etc.).
If you are TEAM or COMPANY you must have at least 3 years of experience and 5-15 developers (or designers, or other personal depending on skills) inside of your group.
All the questions and suggestions you may send at rec@modelstyle.com,
Good luck!
|
|
|
|
|
Maybe you'd like to click on the Advertise link on the left nav panel of the home page here on Code Project and support this site with some REAL advertising, instead of using the forums as a cheap (and HIGHLY unprofessional) way of spreading the word about your new site.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
PavelMenshikov wrote:
We need teams of developers or very experienced individuals with perfect English
Just like this eh?
PavelMenshikov wrote:
There is over 5 the most famous sites on the web now...
A case of "Do as I say, not as I do"?
I second Dave's comments regarding supporting CP.
|
|
|
|
|
Oh! I'm also not impressed with RentACoder either. The coders get screwed and the customers run away with code at no cost! RAC always sides with the customer, no the coder! Why? Just ask yourself sho's supplying the cash for their little endevor? So, if you want to lump yourself in with these crack-pots...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dave Kreskowiak wrote:
The coders get screwed and the customers run away with code at no cost!
This is absurd! How can anyone make the claim that "coders get screwed" in a system where the guidelines and the percentage RAC makes is clearly stated, and all bidding is voluntary on the part of the coder? Just because you don't agree with the prices does not mean anyone is getting "screwed".
I certainly agree that projects on RAC are heavily discounted. I rarely bid on projects on RAC, unless it is something I know I can easily do or I already have similar code written.
But that's a factor of supply and demand. There is a lot of competition for bidding on projects on sites like RAC. RAC does not dictate the bids - clients set the amount and coders submit their bids.
If you don't want to do the project for the price offered, don't bid. But don't blame the management of RAC.
RAC always sides with the customer, no the coder!
RAC really should not have to "side" with anyone. Disputes are best avoided by clear communication with the client and establishing exactly what the requirements and expectations are.
If you have had negative experiences on RAC in terms of disputes with buyers, maybe you should step back and review the tone of many of your posts on this forum. Being demeaning,condescending, and sometimes just plain insulting is not likely to lead to good results in communication.
It is a two way street. Both parties are responsible for a successful outcome in any sort of outsourcing endeavor.
Of course there will still be an occasional disagreement. I had a valid complaint against a buyer on one occasion, and contacted RAC. The situation was resolved in my favor two days later.
I have no personal interest in this - I'm not affiliated with RAC in any way, and have not even bid on a project there in probably a year. I am just trying to present a more objective viewpoint.
|
|
|
|
|
Oh, I'm not saying that RAC is directly screwing the coders. It's when the customers pull some crap like getting their hands on the code and then claiming it doesn't meet the specs (that you never heard got changed) and not paying the agreed on price, if anything at all. And there are customers that do this on a regular basis! Don't get me wrong, I've heard stories where the complaint worked out. But, I've also heard too many stories where it didn't work out in favor of the coder.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
rwestgraham wrote:
How can anyone make the claim that "coders get screwed" in a system where the guidelines and the percentage RAC makes is clearly stated, and all bidding is voluntary on the part of the coder?
Personal incredulity is not a valid counter argument.
rwestgraham wrote:
Just because you don't agree with the prices does not mean anyone is getting "screwed".
He didn't mention the bid prices. He said "the customers run away with code at no cost!" - In other words the customer receives the code, then says it isn't to the spec and the coder gets no money, but the customer actually does have working code.
rwestgraham wrote:
I had a valid complaint against a buyer on one occasion, and contacted RAC. The situation was resolved in my favor two days later.
Curiously, of the stories that I have heard, this is the first that was resoved in the coder's favour in such a short timeframe.
Cada uno es artifice de su ventura
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
Colin Angus Mackay wrote:
Curiously, of the stories that I have heard, this is the first that was resoved in the coder's favour in such a short timeframe.
I am speaking of my own personal experience. Are you speaking from actual experience or merely hearsay?
Robert
|
|
|
|
|
rwestgraham wrote:
Are you speaking from actual experience or merely hearsay?
Well, since I stated "of the stories that I have heard" you should have been able to infer that this is not first hand experience. However, I have talked to people who do have first hand experience (which I'd categorise as less than "hearsay") and that is what I've been told.
rwestgraham wrote:
I am speaking of my own personal experience
So, a sampling of one. 
If you want from my experience then I'll tell you that although I have never got work this way I have on occasion looked at RentACoder with a view to making a little extra money and have come to the conclusion that the people offering the work often don't know what they actually want/need (which isn't actually that unusual), their requirements are too fuzzy to be able to accurately pin down and should a dispute break out the requirements would be of no real use in determining which side is at fault. In short, I came to the conclusion that the risks weighed up against the potential amount of money available was not worth it.
Cada uno es artifice de su ventura
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and Forums
|
|
|
|
|
Colin Angus Mackay wrote:
I came to the conclusion that the risks weighed up against the potential amount of money available was not worth it.
After talking to some other people who got "screwed", I did some research myself and came to the same conclusion. Therefore, I too, don't have any first-hand experience, just because it didn't look like my future experience was going to be any different than the stories I've heard.
Basically, it comes down to a long interview process, from 10,000 miles away!, to get the requirements nailed down, and even then, the req's are only nailed down with bubble gum!
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
 Hello,
i am using report in my project. if i change table cotent and i see the report, i got only the older content of the table, how can i got the newly updated content with out closing project because i got the newly added content when i restart the project.
Jayakumar
|
|
|
|
|
Since you haven't given us any technical information about your project, like what controls your using, especially what report control, what data source, and how you've boud the report to the data... There's nothing can do to help you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hello,
I am using MSFlexGrid control to display the data from the table. The size of each column is fixed so i cant see the full text in that particular column.
Note: I want to change the column size through coding or atleast during design time.... can I?, waiting for reply.
Jayakumar
|
|
|
|
|
Set column widths at runtime with the syntax
MSFlexGrid.ColWidth(Index) = <Width in Twips>
Robert
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
