|
How can collect the tables using MS-Access with Oledb connection in VB.Net
Johnson
-- modified at 5:03 Saturday 24th December, 2005
|
|
|
|
|
Hellow,
Any one can help.......
Johnson
|
|
|
|
|
Can someone tell me how to loop through a string array using a FOR..NEXT or DO UNTIL loop?
Public Sub Update(ByVal Product_Category As String, ByVal Percentage As Decimal, ByVal ParamArray Location_Codes() As String)
End sub
The above is my subroutine and I want to loop through the ParamArray Location_Codes(). So that I can then run some additional code for each item in that array.
Kinda like this:
For each XXXX in Location_codes()
Make some decisions
Next
Can this be done?
Thanks
|
|
|
|
|
You can loop through using the Chars method:
Dim thisstring As String = "abc"
For i As Integer = 0 To thisstring.Length
MsgBox(thisstring.Chars(i))
Next
In VB 2005, you can omit the ".Chars":
For i As Integer = 0 To thisstring.Length
MsgBox(thisstring(i))
Next
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB.NET to C# Converter
Instant VB: C# to VB.NET Converter
Instant C++: C# to C++ Converter
Instant J#: VB.NET to J# Converter
Clear VB: Cleans up outdated VB.NET code
|
|
|
|
|
Ack - that should be "thisstring.Length - 1" of course.
David Anton
www.tangiblesoftwaresolutions.com
Instant C#: VB.NET to C# Converter
Instant VB: C# to VB.NET Converter
Instant C++: C# to C++ Converter
Instant J#: VB.NET to J# Converter
Clear VB: Cleans up outdated VB.NET code
|
|
|
|
|
Public Sub Update(ByVal Product_Category As String, ByVal Percentage As Decimal, ByVal ParamArray Location_Codes() As String)<br />
<br />
For Each code As String In Location_codes()<br />
'Make some decisions<br />
Next<br />
<br />
End sub
You may have to do some error checking first, to see if Location_Codes is not nothing or empty.
Merry Christmas! ![Jig | [Dance]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/jig.gif)
"..Commit yourself to quality from day one..it's better to do nothing at all than to do something badly.."
-- Mark McCormick
|
|
|
|
|
Hello! 
I have a problem in my application that occurs after screen resolution changes. It crops the background image of the form. So the form's background image looks cropped after change from (800 x 640) to (1024 to 768). I have developed application for (1024 x 768) screen format.
Any idea how can I solve the problem!
Thanks!
Bedri
bckurd@e-kolay.net
|
|
|
|
|
I'm assuming .NET 1.1...
You'll have to resize the image your using for the background yourself. You can do this by drawing the background image yourself in the OnPaint event of the form. Use the ClientSize property of the form to determine the correct size. This will also work if the user grabs a side or corner of the form and resizes it to something smaller than the screen dimensions.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi everybody,
I use database oracle8i, and use System.Data.OracleClient to connect db, but when i insert, updat data, It can't save unicode font.
Do you what is problem? how to fix it?
Thanks!
xyz
|
|
|
|
|
What does a Font have to do with saving data in a database?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I would like to design an application to allow shoppers to check if the stocks they have in mind have arrived in a stall.
I have to use a modem which acts as the stall's SMS center and use SMS to test the program. To find out availability of stocks, the user will have to SMS to the SMS centre to specify stocks details such as:
• Model / Type
• Quantity
• Size
• Colour
Customers just have to wait for the SMS centre to notify them that the stocks have arrived. Their specified stock requests as well as their contact details are automatically stored in the database system. Staff will update the database when new stocks have arrived and the consumers will be untomatically notified once the database finds a match between customers’ request and stocks’ availability.
Customers can also easily change their requests at any time through the use of SMS.
How do i start to put this idea into codes?
Thank you!
|
|
|
|
|
Start with a pencil and paper and model out how you want the program to work, Then tackel the code.
|
|
|
|
|
Hey all,
I want to add the the template columns in my Winforms Datagrid
But know the concept behind this.(as new to vb.net)
I have add a Datetimepicker control in 2nd column of datagrid
& ComboBox(MultiColumn) in the 3rd Column of the datagrid
How to add the other Controls in datagrid Columns
Any COde Source , sample link about the Datagrid are welcome
Thanks a lot for this help
Hema Chaudhry
|
|
|
|
|
Hello,
How to add row and columns dynamically to table control and assign database data to the table control.plz help me inthis regard
Thnaks & Regards,
Nagalakshmi
|
|
|
|
|
If you assign a data source to a datagrid, it will generate the rows and columns from the source when you databind.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
My application assigns a datasource and datamember to a combobox in a datagridview based on the selection from another combobox in the grid. Everything is fine until the datasource is changed. If any previous selection is not in this datasource it disappears. It will become visible when a datsource has it as a member. My source is the new tableadapter which contains several differnt queries to choose from.
My question is how can I keep the selections visible when the datsource changes. Even if I save it to the base table it will not show up until the value is a meember in a datasource.
DavidM
|
|
|
|
|
how can I change Datagrid cell Color based on Value
that value is not visible for user
like:
in datagrid display name of staff and staff_id
and when is job ="manger"
the cell of name (only) is change color to red
and when job ="dector"
the cell of name (only) is change color to green
>>>>> when user look only name
understand job of staff
* staff_id is not change color
the datagrid is Windows Application DataGrid
and the languge is VB.Net
thank for all
|
|
|
|
|
Hi,
there is no direct way to do this. You will have to make it yourself:
1. Derive a new class from DataGridTextBoxColumn
2. Override the paint function (the one with the most parameters)
3. Get the value with function GetColumnValueAtRow
4. Choose a color depending on the value
5. Call the paint function in the base class with your choosen background color
6. Use this new column style in your table style instead of the normal DataGridTextBoxColumn (naturally only in those columns where you wish to change the color)
|
|
|
|
|
|
i cant use vb express, look:
Error
i never see anybody with this problem
i try many things to solve the problem:
uninstall eveything about framework (SDK 1.1, vb.net 2003, and others)
clean the registry after this, but no success
id like a help, tks 
|
|
|
|
|
Ok this may sound stupid but do you have debug rights in windows. You can't start the debugger unless you are administrator or have been added to the 'Visual Studio Debuggers' group in the user management of windows.
|
|
|
|
|
|
|
Right-Click MyComputer on your desktop. Click on Manage. In the window that opens up, double-click Local Users and Groups on the left. Open the Groups folder. You should find the Visual Studio Debuggers group. Double-Click that. If you're Username is not in this list, you can't launch the debugger. Simply add yourself to this group to give yoursefl debuggin rights.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
no, its allright there, im becoming crazy with this  ~~~~~
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
