|
True, assuming you pass the value from the UI to the data layer unaltered.
So either use a sproc or:
StringBuilder sb = New StringBuilder(id)
sb.Replace("\", "\\")
sb.Replace("'", "\'")
...
string.Format("select logo from pub_info where pub_id='{0}' ESCAPE '\'", sb.ToString())
Something like that will work I believe.
I'm largely language agnostic
After a while they all bug me 
|
|
|
|
|
i was doing the deployment of my program in vb.net.i faced the following problem.i need to install the .net framework 2.0.50727.i have added the .net framework in the project.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
|
well if you have studio installed then framework must be there automatically
this problem generally comes when you install your package on any other system which doesnt have framework installed.
coz dot net application needs framework to run.
please specify your problem more clearly.
|
|
|
|
|
How can i display time in following format
10:20 AM (without seconds)
on "datetimepicker"
thanks..
|
|
|
|
|
(1) set the Format property to Custom
(2) set the CustomFormat either to "h" or"hh".
BTW I don't know how is it possible to show the AM/PM indicator.
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
|
Good to know, Thank you!
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
Anyway it doesn't work on my DateTimePicker (I have VS 2003).
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
|
I really need help... Please can somebody tell me the source codes how to create a simple program with VB 6 / .net to capture an image from webcam.. thanks for the help!!!!
Caliber Studio
|
|
|
|
|
That depends on the webcam. Most will let you get an image from the Windows Image Acquisition API. For others, you'll have to use an SDK for that webcam, if there is one.
Google for "VB.NET WIA" for examples. Guess which site the first hit is going be??
|
|
|
|
|
Hi,
If you need something generic you can use avicap32.dll library
Regards
NajiCo http://www.InsideVB.NET[^]
It's nice 2b important, but it's more important 2b nice...
|
|
|
|
|
I have a program that imports txt files into a MySQL db. The problem is that one of the files have a invalid character(ç) and when it try to import this row I get the error "Out of range value adjusted for row "OrderItemQuantity" at row 1. Any ideas on how to remove this character from that row?
jds1207
|
|
|
|
|
Validate and normalize the data in each field before you pass that data to the database. Read a line, the parse, normalize, and validate each field before you assign it to parameters in the database INSERT statement.
|
|
|
|
|
What is the best way to get the data in a datagrid. I want to take to data in the datagrid and write it to a file. Multiple rows.
|
|
|
|
|
Stick the data in a DataTable, or if in multiple tables with relationships, a DataSetm, then bind the DataGrid to it. DataTable and DataSet both support writing their contents out to an XML file.
|
|
|
|
|
Hi,
I have two seperate forms. Lets just call them FormA and FormB. I have a function in FormA called Button_Click(). How would I (while in FormB) call this function?
I have tried, while in the FormB code, using Form_FormA.Button_Click. But that doesn't seem to work. Can anyone help me with this?
|
|
|
|
|
if formA is the one that created formB:
- formA needs to pass over a delegate to formB so that B can call back to A.
- another method, however not a good one, is for A to pass over a pointer of itself to B then B can call this routine (routine must be changed to public for this to work).
|
|
|
|
|
Thanks, I'll give it a shot
|
|
|
|
|
This is a bad idea. The function you're calling, since it's used by BOTH forms, should be moved to a seperate class as a, possibly, shared method. You will, of course, have to supply this new method, through the method parameters, with the data it needs to do its job.
|
|
|
|
|
Dave Kreskowiak wrote: This is a bad idea. The function you're calling, since it's used by BOTH forms
I agree. It would open a can of worms for debugging headaches...
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
FormA.Button.PerformClick
Tom Garth
Developer
R. L. Nelson and Associates, Inc., Virginia
|
|
|
|
|
That only works if FormB has a reference to the existing FormA object and that reference is called FormA. Not a good idea.
|
|
|
|
|
Dave,
It sure sounded like the 2 forms are part of a single project. If they are, then each has a reference to the other in My.Forms.
Tom Garth
Developer
R. L. Nelson and Associates, Inc., Virginia
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
