Search results for query: *

Thanks ESquared But do you use 4 tables???

sorry i was away thanks i will check this

thanks alot

Thanks i will check this

I found something that maked it work but if i like to do it the other way is there anyone that can help me whith that? I have a Mp3CdoleDbConnection OleDbCommand cmd = new OleDbCommand("SELECT Photo FROM Album WHERE id = 1", Mp3CdoleDbConnection); MemoryStream ms = new MemoryStream(); //...

Hello I have a database with some fields like this Name Groupnr aa 1 bb 1 cc 2 dd 2 ee 2 ff 4 sd 4 we 5 ss 7 .... and i like the Groupnr field to be like this Name Groupnr aa 1 bb 1 cc 2 dd 2 ee 2 ff 3 sd...

hello again i now understand that it's a header that tells how to open the file is there a way to get the blob without that. hope for help

Hello I'm trying to read a image from a access database and i get a file but it's corrupt and a little bigger then the original. I hope someone can help me. The code i'm working on looks like this OleDbConnection con = new OleDbConnection(@"Jet OLEDB:<<this was very long so i cut it>>"...

Thanks alot. that worked great

hello I like to an insert from a table to another like this INSERT INTO Artist ( Artistnamn ) SELECT DISTINCT mp3id3v1artist FROM Mp3Cdimport the problem is that if the artistname exist in the artist table i don't like it to be inserted hope for help

thanks alot

A question to you gurus I´m trying to learn C# and seen that in some doc´s it say´s that a string is a value and simple/primitive (must be the same or?) type or it´s a reference and class type or can it be booth thank´s

Thanks that helped me I´m using VS.net so those initially fix themselves but this was further in the code i did like this private void MainlistBoxView(string ViewTablename) { string ViewTblnametot; ViewTblnametot = ViewTablename + &quot;.Name&quot;; this.MainlistBox.DisplayMember =...

Hello yes but the tablename is Company and the column is namme i like to bas the tablename in string but columnname always the same string CompanyName = &quot;company&quot;; this.MainlistBox3.DisplayMember = CompanyName + &quot;.name&quot;; i have tables with links (constraints) so it can...

Please someone. Maybee i am way out I´m a newbee and i have orderd a book how to start but meanvile i´m hungry to try

hello i´m trying to pass a stringvalue when i display some data If i have a string named ViewTablename and like to do this the string value is for example &quot;company&quot; this.MainlistBox3.DisplayMember = &quot;company.Name&quot;; but i like to use the string how do i do...

Hello i have a question about what´s best to do if i have 3 tables and like to link them together. I use the tables like 1 - 2 - 3. I don´t want any rows to be more then once so what is best. If i make a table to link all 3 tables or if i do 2 and link table 1 - 2 and 2 - 3 I hope you understand.

Thanks a lot It worked just perfect

sorry again i saw one more foult in the sql SELECT dbo.ABC.ID, dbo.ABC.AID, dbo.ABC.BID , dbo.C.AAA should be dbo.C.Name now i hope it´s ok

and whith that query i get all these columns but my thinking was at the Activeact column ID AID BID CID ID NAME Activeact 1 1 NULL 1 1 ISSUE1 ISSUE1 2 1 NULL 2 2 ISSUE2 ISSUE2 3 1 NULL 1 1 ISSUE3 ISSUE3 4 1 NULL 2 2 ISSUE4...