|
How do I set up connection string for Microsoft OLE DB Provider for DB2?
Dim connection As ??????
|
|
|
|
|
|
|
See: http://www.connectionstrings.com/ibm-db2/[^]
Dim connection As New System.Data.OleDb.OleDbConnection("Provider=DB2OLEDB;...")
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Hi
I need to serialize a php named array in vb.net 2010 (Desktop app). I believe that the only easy way might be with jquery.
How do you implement a jquery function in vb.net 2010?
If there is an easier way to covert the php named array string to a .net supported object i.e. array, dictionary or collection, etc. PLEASE LET ME KNOW.
|
|
|
|
|
QuickBooksDev wrote: How do you implement a jquery function in vb.net 2010?
With extreme difficulty.
Deserialize it from what format? JSON? XML? What?
|
|
|
|
|
from a php named array string which looks like this:
a:2:{s:3:"foo";s:3:"bar";s:3:"bar";s:3:"foo";}
Is there a good way of handling this?
|
|
|
|
|
That appears to be JSON, but looks malformed.
You can try the stuff found in these[^].
|
|
|
|
|
I am not sure if it is JSON. It is coming from a blob field in a database.
What I sent was only an example of a php named array which is what I think it is.
Here is the actual text that was sent to me (some text has been changed). It comes from the HikaShop shipping_parms field in the shipping table.
o:8:"stdClass":36:{s:19:"shipping_percentage";s:1:"0";s:20:"shipping_per_product";s:1:"0";s:26:"shipping_price_per_product";s :"";s:25:"shipping_override_address";s:1:"0";s:30:"shipping_override_address_text";s :"";s:11:"access_code";s:17:" 8CDDA11596V5822B1";s:7:"user_id";s:10:"test012345";s:8:"password";s:8:"Aec3fX13";s:14:"shipper_number";s:6:"1X2167";s:11:"pickup_type";s:2:"01";s:16:"destination_type";s:4:"auto";s:15:"negotiated_rate";s:1:"0";s:13:"group_package";s:1:"1";s:13:"include_price";s:1:"1";s:18:"exclude_dimensions";s:1:"0";s:20:"weight_approximation";s:1:"5";s:17:"dim_approximation";s :"";s:25:"shipping_warehouse_filter";s :"";s:18:"shipping_min_price";s:1:"0";s:18:"shipping_max_price";s:1:"0";s:25:"shipping_virtual_included";s:1:"1";s:22:"shipping_price_use_tax";s:1:"1";s:21:"shipping_min_quantity";s :"";s:21:"shipping_max_quantity";s :"";s:19:"shipping_min_weight";s:1:"0";s:20:"shipping_weight_unit";s:1:"g";s:19:"shipping_max_weight";s:1:"0";s:19:"shipping_min_volume";s:1:"0";s:18:"shipping_size_unit";s:2:"in";s:19:"shipping_max_volume";s:1:"0";s:19:"shipping_zip_prefix";s :"";s:16:"shipping_min_zip";s :"";s:16:"shipping_max_zip";s :"";s:19:"shipping_zip_suffix";s :"";s:11:"methodsList";s:132:"a:4:{s:16:"ups_next_day_air";s:2:"01";s:18:"ups_second_day_air";s:2:"02";s:10:"ups_ground";s:2:"03";s:14:"ups_express_ca";s:2:"01";}";s:14:"warehousesList";s:275:"a:1:{i ;O:8:"stdClass":8:{s:4:"name";s:7:"Vermont";s:3:"zip";s:5:"41234";s:4:"city";s:6:"Putney";s:7:"country";s:3:"223";s:4:"zone";s:36:"country_United_States_of_America_223";s:9:"zone_name";s:28:"223 United States of America";s:5:"units";s:2:"lb";s:8:"currency";s:1:"2";}}";}
|
|
|
|
|
OK, after looking at that bigger example, that's not JSON.
I don't know of a library that handles serialization of PHP objects.
But, there is this[^]. You can create a PHP project in your solution that handles serialization and deserialization, creating the objects for you.
You can NOT just use an external PHP app because the objects that it creates will not be visible to your .NET code.
|
|
|
|
|
The web doc for Phalanger seems a bit complex.
What I need is
SomeVar = ToClass.ToFunction(BlobString)
Plalanger goes into web pages, complex class functions and cannot see how. Perhaps the simple calculates factorial example technique with
php
Function ToFunction($str)
{
$ar = unserialize($str);
return serialize($array);
}
VB
Dim Ojb as object = ToClass.ToFunction(MyBlobString)
would work???
|
|
|
|
|
You can't do that. At. All.
You cannot combine two different languages in the same code file. You can't even use two different languages in the same Project!
The PHP and Managed code execute in completely separate execution environments that don't even know about each other. So, the objects you create in one are not visible in the other.
Your only nice solution is to create a seperate PHP project (essentially PHP.NET) that handles serialization and reference it in the VB.NET code.
|
|
|
|
|
If separate programs are created then I am back to a php program creating a file that VB.Net needs to read and Deserialize into some table. So what good is that except possible to make the external interface file being more 'friendly' i.e. Key,Value instead of all the types, length, etc. And this may not work for embedded structions which I believe this blob has.
Since each record that I read would need to do the same thing it doesn't even seem to be very practical.
|
|
|
|
|
QuickBooksDev wrote: If separate programs are created
A seperate project in the same solution is compiled to a library .DLL, not a seperate .EXE.
It's not different than if you added a C# Class Library project to your Solution.
|
|
|
|
|
This might help:
Sharp Serialization Library serializes and deserializes primitives, ArrayLists and Hashtables, compatible with PHP serialize().
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Sharp Serialization Library did not work.
Failed in their test project on
Hashtable htFile = (Hashtable)this.serializer.Deserialize(stSerial);
Unable to cast object of type 'System.String' to type 'System.Collections.Hashtable'.
I just clicked on open. Browsed to my file with the data and that was it.
|
|
|
|
|
In a vb.net 2010 application, I am going to add a interface for a user to be able to do the following:
1. See what users are assigned to 5 specific active directory groups, and
2. allow the user to update the active directory groups.
Thus can you show me and/or point me to a url that shows me example code on how to accomplish this goal?
In an existing vb.net 2010 web form application, I am going to add an web interface for a user to be able to do the following:
1. See what users are assigned to 5 specific active directory groups, and
2. allow the user to update the active directory groups.
Thus can you show me and/or point me to a url that shows me example code on how to allow users to set the active directory groups and to update the active directory groups?
|
|
|
|
|
|
I have a problem in creating a VBA to perform a certain task. I have a data in excel which has exactly 20 rows and 1500 columns, in which 1st row of each column is the filename of a text file which has to be created in notepad. How can I copy from A2 to A20 from the first row in excel and open and paste it in a notepad and name it as (A1 value) and close it. And then again copy the 2nd row from B2 to B20 and open and paste it in a notepad and name it as the (B1 value), so on and so forth for 1500 columns. How can I program this task other than manually copying from excel and pasting it in a particular notepad. Kindly guide me
|
|
|
|
|
So... what have you tried?
This is a relatively simple task in VBA.
If you provide the code you've written, others may assist.
But do not expect anyone to simply provide the code.
|
|
|
|
|
I have tried this formula of visual basic which is as stated below
Sub writetotextfile1()
Dim rngLoopRange As Range
Open "C:\Users\Kanini\Desktop\VisualSudhu\A1.txt" For Output As #1
For Each rngLoopRange In Range("A2:A20")
Print #1, rngLoopRange
Next rngLoopRange
Close #1
End Sub
But this copies only the data range from A2:A20 and opens a notepad and pastes there and renames it as A1 and closes it and then comes back to the same worksheet of excel. I am not able to do rename it as A1(value) and I was not able to create a single macro which can run for the subsequent B2:B20, C2:C20, so on and so forth. Can you improvise this formula for me, please?
|
|
|
|
|
Hi Tim Carmichael,
I got the solution myself. Thanks for making me also believe that I can do it. I am very happy that my macro is working as per my requirement and saving me a lot of time.
Warm Regards,
R. Sudhakar
|
|
|
|
|
I am glad you worked it out for yourself.
|
|
|
|
|
Hi Tim Carmichael,
I have created a visual basic program as follows:
Sub writetotextfile1()
Dim rngLoopRange As Range
Open "C:\Users\Kanini\Desktop\VisualSudhu\A1.txt" For Output As #1
For Each rngLoopRange In Range("A1:A20")
Print #1, rngLoopRange
Next rngLoopRange
Close #1
End Sub
Sub writetotextfile2()
Dim rngLoopRange As Range
Open "C:\Users\Kanini\Desktop\VisualSudhu\A2.txt" For Output As #1
For Each rngLoopRange In Range("B1:B20")
Print #1, rngLoopRange
Next rngLoopRange
Close #1
End Sub
These are the macro created for 2 files created text format. But, I need to create it for 500 rows at a time, so that it can give me 500 text files. Is there any way that I can loop these macros and as well create a formula where in I can get 500 rows at a time. Kindly help me in this regard.
Thanks in advance,
Warm Regards,
R. Sudhakar
|
|
|
|
|
You need a loop within a loop, one for the rows and one fro the columns - something like this:
Sub writetotextfile1()
Dim iMasterLoop As Integer, iCellLoop As Integer
iMasterLoop = 1
Dim wsLoop As Worksheet
Set wsLoop = Worksheets("Sheet1")
Do While wsLoop.Cells(iMasterLoop, 1) <> ""
Open wsLoop.Cells(iMasterLoop, 1) For Output As #1
For iCellLoop = 2 To 20
Print #1, wsLoop.Cells(iMasterLoop, iCellLoop)
Next iCellLoop
Close #1
iMasterLoop = iMasterLoop + 1
Loop
End Sub
=========================================================
I'm an optoholic - my glass is always half full of vodka.
=========================================================
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
