I can't seem to find CONVERT() in the list of SSIS functions. What I did was to create an Script Component (duh!) and convert each column using VB code. I just wish I could find a more user-friendly solution.
Here is the VB code (thanks to google):
Row.Digit1 = Chr(CInt(Val("& H" & Row.Digit1.ToSt ring()))) 'Digit1 is the name of the column
[...]
The CInt function was recommended by VS...
TonFrere
Last Activity: Oct 3 '08, 03:15 PM
Joined: Nov 13 '07
Location:
-
SSIS and HEX conversion.
Hello,
I must convert a CSV file which is simply hexadecimal words. There is a SSIS function to convert from decimal to hex but none for either hex to decimal or hex to ASCII.
Here is what my file looks like:
3032;3631;3031
3032;3631;3032
Here is what it should give:
026101
026102
I already started a DataFlow task which seperates each hex combo into different columns and get... -
Eureka! I'm the only one to blame... me and my love for drag'n'drop thingies.
As a former MS Access programmer I'm used to creating controls by draging it from the datadource panel to the form and then, modifying it.
The thing is, I dragged and droped my FAB_num field to the form as a new combobox. What I should have done, is to create the combobox by draging the FAB datatable (as a combobox) and droping it to the...Leave a comment:
-
No, since other numeric fields are correctly stored to the database.
Thanks for your help. If I ever found an answer, I'll let you know.
JustinLeave a comment:
-
Hello, thanks for your quick reply.
This is a Windows application.
SelectedValue, as you said, retreive the value selected. This is why it is linked to the RMA_NUM field of the RMABindingSourc e.
As for the code, absolutely no code is entered concerning this field (exept for Visual Studio auto-generated code) Frankly, I have no idea how to display it but you're right, the problem might be there.
...Leave a comment:
-
Type validation nightmare in windows form.
Hello,
I have a visual C# application that is binded to a Sql server DB. I'm experiencing a lot of frustration when it comes to bind a combobox to a specific table. It seems that validation never succeeds.
Two tables are involved:
RMA
--------------------
RMA_Num - integer
FAB_Num - integer
...
FAB
--------------------
FAB_Num - integer
Desc - string... -
Populate dropdown list with parameterized stored procedure.
Hello,
I'm building a windows form application in Visual C# using VS 2005. On my form I need to populate a combobox with Invoices# linked to the current reccord's Order# value. This means that:
- The combobox should repopulate if the user changes the value of Order#.
- The combobox should repopulate if the user moves through records (using the binding navigator.
My problem is that whenever I repopulate the combobox,... -
I hope to help other users by posting a solution to my own problem.
First of all, the problem I had with using the escape key to undo changes was entirely my fault since I mistook two controls of the same name when testing the Undo() method of the textbox control. Anyways, here is how it's done:
On the keydown event, call the undo method if the key is "escape"
if (e.KeyCode == Keys.Escape)...Leave a comment:
-
C# - Desktop App: Windows form, canceling changes in a control.
Hello,
I'm building a solution using Visual Studio Windows Forms and I'm coding in C#.
I have a windows form with databinded textboxes, comboboxes and a datagrid. Everything works fine until a user enter a wrong value in a textbox binded to a numeric field on the form. There is no way to get back to the old value by pressing escape (canceling changes).
Strangely, this works fine with the datagridview columns:... -
I think I found the perfect combo to make this work:
- For each control TextChange (or equivalent for other controls) I set IsDirty to True. (Capturing users changes)
- On BindingSource CurrentChanged, I set IsDirty to False. (Because it is set to true when controls are filled with db values.)
- On form OnActivated event, I set IsDirty to false (this way I don't get it set to true after the initial binding...Leave a comment:
-
Sorry, I'll try to describe a little more.
I want IsDirty set to true whenever a user changes a value on the form. This is to track changes (and to advice the user if he leaves without saving).
If I set IsDirty to True in the "TextChange d" event, it happens whenever a user make changes (which is good) but also, whenever a user move between records using the Binding Navigator move next, move previous etc. buttons...Leave a comment:
-
I can't use "TextChange d" because this would be raised each time the user changes record.
Windows Forms, C#, Visual Studio 2005.
Still need help.
Thanks!Leave a comment:
-
Common controls: Combobox, CheckBoxes etc. Is it ok to look it from the control side or should I find a way to check if the bindingsource or dataset are changed?
I'm a little embarrassed to be stock on something that seems so obvious.
Justin...Leave a comment:
-
Form close changes notification and databinding
Hello,
I'm simply trying to keep track of changes on a windows form as users modify control values. I created a boolean variable called IsDirty and want it set to true whenever the user changes something.
The problem is: where to set IsDirty to true?
If I raise the event on "TextChange d" event of a control (let say a textbox), it is set to true whenever the user changes current record.
...
No activity results to display
Leave a comment: