Search results for query: *

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 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>>"...

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

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

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.

Hello I have a question if have tables like this NEWS A table ID NAME 1 NEWS1 2 NEWS2 NAME B table ID NAME 1 JIM 2 ADAM ISSUE C table ID NAME 1 ISSUE1 2 ISSUE2 3 ISSUE3 4 ISSUE4 (if a new ISSUE row is added a row whith BID is set...

Hello If i have a query like this SELECT * FROM table1 WHERE exid = @exid if i use this query and like to display all lines from table1 What value should @exid have to show all or is this not possible thankfull for answers

hello If i have a table like this id Actstart Actend Activity 1 12:00 13:00 test1 2 15:15 test2 3 13:00 15;00 test3 4 15:00 test4 and the Actstart and Actend are datetime and i use this query SELECT ID, Actstart, Actend...

Hello I wonder if it is possible to see what server collation a SQL Server 7.0 whithout starting the sql server in a file or something and if there isn't any way if i start the sql server what query can i do to find out

Hello I am wondering if this is possible table1 id name 1 aaaa 2 bbbb 3 cccc table2 id Category 1 cata 2 catb 3 catc table3 id tabel1id tabel2id 1 1 1 2 1 3 3 2 1 4 2 2 5 3 2 6 3...

how do i start for example explorer.exe from a button on a form

how do i pass a value from a text box on the form to a field in a datagrid

Hello If i have a table and one related table and i like to show them on a form and i like only to show one kolumn from each table i use one listbox to show from one table and a textbox to show a value from the other related table my problem is how i do to update the related table the main...

If have a table like this Activity Id Starttime Endtime Activity and i like to generate a new row in the dataset but i like the starttime field to be the datetime now if i use a textbox i understand how i can do it but if i don't how do i do...

Hello If i try to resize with width i get width is inaccessible due to its protection level i cant figure out how it works please help

hello if i use a listbox to present data from a db and i like that if i double click on a value i like to start a program with parameters from the value i clicked how do i do

Hello If i have form with a listbox on left and textboxes on right When i start i like the window to show only halt the form so it only shows the listbox. If i click in the listbox i like the form grow so it shows the textboxes and then if i click again it shrink please help

If i have two tables like Doing doingtime and i would like to query Doing table and if one or some datetime values in one field in doingtime table is null i like a value of * I use sql2000 how will i do please help