Click here to Skip to main content
15,889,462 members
Home / Discussions / C#
   

C#

 
GeneralRe: Hide Form?? Pin
DaveyM696-Jun-09 8:58
professionalDaveyM696-Jun-09 8:58 
QuestionType conversion in C# Pin
ManAm16-Jun-09 0:18
ManAm16-Jun-09 0:18 
AnswerRe: Type conversion in C# Pin
0x3c06-Jun-09 0:31
0x3c06-Jun-09 0:31 
AnswerRe: Type conversion in C# Pin
palvaibhav6-Jun-09 0:35
palvaibhav6-Jun-09 0:35 
Question[Message Deleted] Pin
orfan5-Jun-09 23:45
orfan5-Jun-09 23:45 
AnswerRe: UFFT (Ultra Fast Forest Tree) Algorithm Pin
Christian Graus5-Jun-09 23:56
protectorChristian Graus5-Jun-09 23:56 
AnswerRe: UFFT (Ultra Fast Forest Tree) Algorithm Pin
Lutosław6-Jun-09 3:45
Lutosław6-Jun-09 3:45 
QuestionProblem to convert Text to GUID type. Pin
hdv2125-Jun-09 23:23
hdv2125-Jun-09 23:23 
Hi in my first db (access 2003), i have some tables which has Text columns as PK, my app create new GUID and convert it to Text, then save back to access db.
Now i want to transfer data from access to sql server, to do this, i must load data from access, convert PK from Text to GUID, then save back to sql server database.

i use this code to load original data and convert PK from Text to GUID :

this.personsTableAdapter1.Fill(this.testDataSet1.Persons);

            DataTable dtImported = this.testDataSet1.Persons.Clone();

            // because PK dataType in sql server is uniqueidentifier, hence i convert PK column to guid
            dtImported.Columns["PersonID"].DataType = typeof(Guid);
            foreach (TestDataSet.PersonsRow row in this.testDataSet1.Persons.Rows)
            {                
                Guid g = new Guid(row.PersonID);                
                dtImported.Rows.Add(new object[] { g, row.PersonName }); // ERROR
            }


but the following error message thrown in above line of code :

Cannot set column 'PersonID'. The value violates the MaxLength limit of this column.


can anyBody help me ?
Note : first, i convert my data from sql server to access 2003 by ssis package. now i want to transfer it again from access 2003 to sql server.
AnswerRe: Problem to convert Text to GUID type. Pin
Christian Graus5-Jun-09 23:27
protectorChristian Graus5-Jun-09 23:27 
GeneralRe: Problem to convert Text to GUID type. Pin
hdv2125-Jun-09 23:59
hdv2125-Jun-09 23:59 
GeneralRe: Problem to convert Text to GUID type. Pin
I Believe In GOD6-Jun-09 10:32
I Believe In GOD6-Jun-09 10:32 
GeneralRe: Problem to convert Text to GUID type. Pin
hdv2129-Jun-09 10:47
hdv2129-Jun-09 10:47 
QuestionExtremly sorry to interupt here.. Pin
Hema Bairavan5-Jun-09 23:14
Hema Bairavan5-Jun-09 23:14 
AnswerRe: Extremly sorry to interupt here.. Pin
Blue_Boy6-Jun-09 3:26
Blue_Boy6-Jun-09 3:26 
GeneralRe: Extremly sorry to interupt here.. Pin
Troy Russell6-Jun-09 8:59
Troy Russell6-Jun-09 8:59 
AnswerRe: Extremly sorry to interupt here.. Pin
Dave Kreskowiak6-Jun-09 4:51
mveDave Kreskowiak6-Jun-09 4:51 
QuestiontableLayoutPanel Pin
hamidhakimi5-Jun-09 23:03
hamidhakimi5-Jun-09 23:03 
Question[Message Deleted] Pin
hkjghkj15-Jun-09 22:40
hkjghkj15-Jun-09 22:40 
AnswerRe: Looping media Pin
Christian Graus5-Jun-09 22:51
protectorChristian Graus5-Jun-09 22:51 
General[Message Deleted] Pin
hkjghkj15-Jun-09 23:51
hkjghkj15-Jun-09 23:51 
GeneralRe: Looping media Pin
ScottM16-Jun-09 4:09
ScottM16-Jun-09 4:09 
QuestionIs there a class for doing HTTP GET requests in c#.Net Pin
Roland Szigeti5-Jun-09 22:34
Roland Szigeti5-Jun-09 22:34 
AnswerRe: Is there a class for doing HTTP GET requests in c#.Net Pin
I Believe In GOD5-Jun-09 22:46
I Believe In GOD5-Jun-09 22:46 
AnswerRe: Is there a class for doing HTTP GET requests in c#.Net Pin
0x3c05-Jun-09 22:48
0x3c05-Jun-09 22:48 
AnswerRe: Is there a class for doing HTTP GET requests in c#.Net Pin
Garth J Lancaster5-Jun-09 22:50
professionalGarth J Lancaster5-Jun-09 22:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.