|
Please edit your original post, and wrap the code in a code block with correct lang attribute,eg. pre lang="vb" it makes it a whole lot easier to read.
|
|
|
|
|
Thanks Dave...I learned many things from you... And also Iam posting as new thread. 
|
|
|
|
|
Don't post another thread, you get flamed! Go and delete the new one and leave this one here.
|
|
|
|
|
Thanks Dave...........I deleted the other one and also I need your guidances.
Thanks For All Guidances...
|
|
|
|
|
If I understand what you're trying to do, you can't do it using a DataAdapater. You can only work on queries that involve a single table. You'll have to update your tables independently, using two different queries. By the way, your table names suck. "table1" and "table2" are hardly descriptive of what they contain and actually make it harder to understand what your code is doing.
|
|
|
|
|
Dave Kreskowiak wrote: "table1" and "table2" are hardly descriptive
Nah. Maybe table1 is full of ones, table2 full of twos.
Luc Pattyn [Forum Guidelines] [My Articles] Nil Volentibus Arduum
Please use <PRE> tags for code snippets, they preserve indentation, improve readability, and make me actually look at the code.
|
|
|
|
|
Thanks Dave..I get clear... I will update by seperate query...
Thanks & Regards![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
PARAMU
|
|
|
|
|
Hi,
I am sending mail from my vb app using CDO with out any issues. One of my client, they does not have internet connection in the client machine. They have configured through proxy setup. I've added below two line in existing code to support for proxy.
oField = oFields["http://schemas.microsoft.com/cdo/configuration/urlproxyserver"];
oField.Value = "itgproxy";
oField = oFields["http://schemas.microsoft.com/cdo/configuration/proxyserverport"];
oField.Value = 80;
I've confirmed that the passed proxy details are correct. And I got the error "Transport failure".
If anybody have an idea / experience on this please share with me, it will be a valuable help for me.
Advance Thanks,
Regards,
Rishi
WinCrs
|
|
|
|
|
As per my observations I need to set the proxy credentials. How do I can do this?
WinCrs
|
|
|
|
|
You can't. Proxies that require authentication are not supported. You'll either have to have a proxy that is open on your end or some path to bypass the proxy entirely. You're Network Admin would have to get involved with something like this.
|
|
|
|
|
Hi All,
I am using the following line hardcoded in my vba code in excel file.
D:/PISL/Input/<filename.xls>
My problem is, in the above line instead of giving D: i should give only PISL/Input/<filename.xls>, this can exists in any of the drives like c:, d:, e:, etc.,
Please help how to configure the drive name.
Thanks in Advance,
Regards,
|
|
|
|
|
priyaahh wrote: Please help how to configure the drive name.
You could save the driveletter-prefix as a Setting[^]. Once saved, use GetSetting to read the drive and concatenate your directory-string 
I are Troll 
|
|
|
|
|
I have a whiteboard measure 77 x 100cm and i used picturebox in vb6 to be my whiteboard on software side.Can anyone help me to make the picturebox scale the same as my whiteboard in vb6 because i dont know how to scale it. 
|
|
|
|
|
You know the area available for the PictureBox.
So a little simple math will provide you with the answer.
1. obtain a Scale Factor by dividing the width of your area by the width of your whiteboard (770mm), or the height of your area by the height of the whiteboard (1000mm)
2. the width for the PictureBox will be 770 * the Scale Factor from above.
3. the height will be 1000 * the Scale Factor.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Further th what Henry says; if you want the picture to remain proportional then only apply the lowest of the 2 scale factors to both the Height and Width.
|
|
|
|
|
how to communicate with picturebox and toolbar..i want to drag n drop the icon in toolbar to picture box in same form but doesn't work, like icon rectangle and i should can control the rectangle box(resize)
|
|
|
|
|
What have you tried?
Please show the code that is not working, so that people can see where you are going wrong.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Hi;
Does anyone know of any decent VB Source Code examples for the formatting of HTML. I am looking for something that will take Html input and reformat it reasonabbly correctly, adjusting all indents, line breaks and tag captialisation / decapitalisation.
I have searched and searched and found very little, and have come to learn (through exploding head syndrome) that this task is not as easy as one might initially think!
I would also be interested in any freely distributable .NET API's (except HTML Tidy) that anyone may know about.
Any guridance would be appreciated.
Regards
Dave
|
|
|
|
|
A quick google search reveals http://www.manoli.net/csharpformat/[^] which is c# not VB. But it shouldn't be too hard to do a translation from one language to another. It might at least give you a starting point for how to go about it.
|
|
|
|
|
Hi Dave,
This may not be of any help but have you checked the formatting in Visual Studio. You can reformat your HTML in Visual Studio using the shortcut "Ctrl+E, D" or via the menu bar Edit, Advanced, Format Document.
You can change the way your document is formatted by going to the menu bar Tools, Options, Text Editor, HTML.
It's not source code but it may help.
"You get that on the big jobs."
|
|
|
|
|
I read your reply and was about to point out to you that you had mistyped your shortcut suggestion. Luckily I checked first. I have always used Ctl+K, D.
Nice to learn something new.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Ctl+K,D is still good in the Macro IDE. The other day I was playing with my macros and going Ctrl+E,D "bing" Ctrl+E,D "bing" ??? uhh, had to rediscover Ctrl+K,D.
For the life of me I couldn't remember using it. Shortcuts you do without thinking.
"You get that on the big jobs."
|
|
|
|
|
I have Visual C# Express and the suggested shortcut is Ctlr+E, D.
However I just tried the following:
Ctrl+E, Ctrl+D which works
Ctrl+K, Ctrl+D which works, and
Ctrl+K, D which does not work.
I must get a clever new signature for 2011.
|
|
|
|
|
I always thought Ctrl+E, D was shortcut notation for shortcuts. But you're right, even though Ctrl+E, D works the same as Ctrl+E, Ctrl+D, they are in fact, different shortcuts. Ok, I didn't know that.
"You get that on the big jobs."
|
|
|
|
|
My goof.
I meant Ctl+K, Ctl+D. i.e. keep ctl pressed for both keys.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
