|
I am looking for the steps on how to save and how to read images from/to mysql using C#?
Thanks.
|
|
|
|
|
jrahma wrote: I am looking for the steps on how to save and how to read images from/to mysql using C#?
Would a CodeProject article[^] on the subject help?
I are Troll 
|
|
|
|
|
hello - how can you configure auto shrink for SQL server Trasnaction log?
Thanks
dev
|
|
|
|
|
EXEC SP_DBOPTION 'MYDBNAME', 'trunc. log. on chkpt', true
modified on Wednesday, November 17, 2010 3:29 AM
|
|
|
|
|
|
hi all
I was wondering if anyone could help, I need to pass 2 variables to a stored procedure that in turn fires off an SSIS job that calls a stored procedure.... (dont ask!). I can get the variables into the stored procedure no problem, but getting them through to the job is proving harder than I would expect. I can set static params through the Set Values option but cannot see a way of making them dynamic ?> any thought greatly appreciated
ta
|
|
|
|
|
Can you post some code from the stored procedure where you "fire off" the SSIS job?
Greetings
Manfred
|
|
|
|
|
ta,
I am sure that there is a way to pass those values though another option that I have used before is to update a parm table with the values from the stored procedure and then kick off the SSIS package which reads the parm table.
I hope that this helps
Robert Ford
|
|
|
|
|
hi... to all..
i've written the code in expression field...
=format(sum(fields!salary.value),"##\,##\,##\,##\,##\,##\,##0.00")
the code is for printing the number in this format(12,23,23,34,123.00)
now i got an problem i.e if i give 5 digit the it will print ,,,,,12,123.00 the remaining commas
are printed.. i dont want to print the extra commas.. how the word length is there that much it
should take..i.e( for 5 digit 12,123.00 and for 9 digit 12,23,23,123.00)...
i've tried by removing some of the #'s but it is for fixed number..
please help me...
|
|
|
|
|
It is customary to group 3 digits at a time. To achieve that you simply need to use "#,##0.00" as your number format - the result will contain as many ',' characters as necessary e.g.
Format(123.45, "#,##0.00") -> 123.45
Format(1234.56, "#,##0.00") -> 1,234.56
Format(12345.67, "#,##0.00") -> 12,345.67
Format(123456.78, "#,##0.00") -> 123,456.78
Format(1234567.89, "#,##0.00") -> 1,234,567.89
|
|
|
|
|
thanku.. for reply
i have just change the language setting..
|
|
|
|
|
please help to update image using c# i'm new to .net
i have successfully inserted image in database but i couldn't update it,using c# if any one finds the answer please let me know it
advance thanks 
|
|
|
|
|
chandru222 wrote: i have successfully inserted image in database but i couldn't update it
Why not? Did you get an error? What did it say?
I are Troll
|
|
|
|
|
|
vijay2482 wrote: I would like to know how to retrive data from Access table to a excel spread sheet with a click of a button in the excel spreadsheet.
Using VBA. I don't have the exact code - you'll have to search a bit 
I are Troll
|
|
|
|
|
Better start to learn C# or any another programming language.
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
Blue_Boy wrote: Better start to learn C# or any another programming language.
You can use C# as a macro language in Excel?
|
|
|
|
|
|
Hi there
I need to add periodically some data from a remote mysql database into our postgresql database. So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?
Best regards
|
|
|
|
|
franrtorres77 wrote: So, does anyone know how to do it having in mind that it must be runned every minute or so for adding new records to the postresql?
Perhaps the Sync Framework[^]? I'm not sure on the performance though.
I are Troll 
|
|
|
|
|
|
Could someone pont me in the right direction here cos I am pulling my hair out and I have little to start with lol
I am working with 3 tables
User Table:
Auto_ID
User_Name
Profile Table:
Auto_ID
User_ID (This is taken from the Auto_ID in the User Table e.g. 20)
Prof_Img
Comments Table:
Auto_ID
Message_To (This is taken from the Auto_ID in the User Table e.g. 41)
Message_From (This is taken from the Auto_ID in the User Table e.g. 20)
Message
I need to be able to display the Prof_Img for who the message was _to and _from I just can't figure how to get the individual picture references from the same table in the same query. I can get one of the pictures but not both, am probably not thinking about it correctly, well obviously I am or it would work lol
Oh and I need the User_Name to go with each relevant picture
If someone could give me a little guidance please it would save my hair line lol
Many thanks in advance
Regards
Ray
|
|
|
|
|
OK, you need two joins to the same tables (once for from, once for to; and both once for name, once for image); this will only work when you use aliases to discriminate the identical tables.
This will not be correct, but indicates the technique; try something like this:
SELECT FU.Name, TU.Name FROM Comments
JOIN User as FU ON Comments.Message_From=FU.Auto_ID
JOIN User as TU ON Comments.Message_To=TU.Auto_ID
WHERE Comments.Auto_ID=MessageID
which, once correct, you can extend to also handle the images.
|
|
|
|
|
I finally got to sit and try your suggestion and this was wonderful help thank you so much.
I do have another question about this which I will post a new messgae for shortly.
Again thank you very much for your help
Regards
Ray
|
|
|
|
|
You're welcome.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
