Comments by Member 10059109

Member 10059109 14-Jul-15 5:02am View

Indeed it returns more that one row.The logic is that 1 row can fill my excel sheet so i wont for every row that comes from my query to create a new excel sheet

Member 10059109 14-Jul-15 5:02am View

Deleted

Indeed it returns more that one row.The logic is that 1 row can fill my excel sheet so i wont for every row that comes from my query to create a new excel sheet

Member 10059109 19-Feb-15 8:38am View

It's always in the same place so you think i need to go with the substring method right?

Member 10059109 12-Feb-15 5:07am View

Thanks for the tip i will try it and i think its perfect for my app :)

Member 10059109 11-Feb-15 7:28am View

Thank you so much you helped me a lot ,have a nice day good sir!

Member 10059109 11-Feb-15 7:11am View

Hi at that state of my app i just wnt to validate all the textboxes with some logical criteria and store the wrong ones in my arraylist that' all.As of my streamreader my only question is that i need to simple call my function like this
checkdata= ValidateControls() before my Dim objStreamWriter As New StreamWriter(My.Settings.PathToShared & "\Arrival\Arrival - Saved.xml")" to store the textboxes in my list correct?

Member 10059109 11-Feb-15 6:29am View

that's perfect my friend only one more question for the returned arraylist.
I have an Streamwriter to store all the data from the text boxes in an xml document
"Dim objStreamWriter As New StreamWriter(My.Settings.PathToShared & "\Arrival\Arrival - Saved.xml")"
i wnt to call my function before the Streamwriter to kick in.So if i am understood correct the only thing i need to do is to call the function before streamwriter like
checkdata= ValidateControls() ?

Member 10059109 11-Feb-15 4:56am View

I wont have any capacity problems with the list correct?

Member 10059109 23-Jan-15 9:17am View

You are getting there i need to be like this
arr[0] = 1,2,3,4,5,6....->Submit_ID
arr[1]= Cotrol_Id,Form_ID,Row_NO(the rest columns) i want that because my submit id has multiple identical records because of Control_Id.Control_ID gets standar values between 15568 to 15578.

so its like that now
Submit ID Control ID
1 (SPACE) 15568
2 (SPACE) 15569
3 (SPACE) 15570
4 ....
... ...
10 (SPACE) 15568

I want to be like
SubmitID =1 ,2 ,3,4,.......
Controlid
formid
row_no
etc
To make it more clear i wnt per Submit_id to link all the columns beneath it

Member 10059109 23-Jan-15 7:29am View

it wont deploy online so that's not so important but thanks

Member 10059109 23-Jan-15 7:06am View

yes i am the connection is solid i cant configure my data though

Member 10059109 23-Jan-15 7:02am View

i wnt to store my whole table and then my first column with the name submit_id to convert her to row.So my final table will be something like
submit_ID submit_ID submit_ID submit_ID submit_ID submit_ID
control_id......
form_id.......
row_no..........

My table now is
submid_id Control_id row_no

Member 10059109 23-Jan-15 5:56am View

C# and VB but i prefer VB

Comments by Member 10059109 (Top 13 by date)