C# Discussion Boards - CodeProject

hdv2125-Jun-09 23:23

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

Re: Problem to convert Text to GUID type.

Christian Graus5-Jun-09 23:27

Christian Graus

5-Jun-09 23:27

Well, I assume this means that a GUID takes up more room than the datatype in your original table. You're cloning the table, so you're going to have columns with the same size/type as you did before, unlike your SQL DB.

Christian Graus

Driven to the arms of OSX by Vista.

Please read this[^] if you don't like the answer I gave to your question.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

Re: Problem to convert Text to GUID type.

hdv2125-Jun-09 23:59

hdv212

5-Jun-09 23:59

Hi Christian
i didn't understand what you saied. can u give me more explain ?
thanks

Re: Problem to convert Text to GUID type.

I Believe In GOD6-Jun-09 10:32

I Believe In GOD

6-Jun-09 10:32

Change the column maxlength at dataset properties ...

I know nothing , I know nothing ...

Re: Problem to convert Text to GUID type.

hdv2129-Jun-09 10:47

hdv212

9-Jun-09 10:47

Hi Stark
i tried this, but it didn't works.

Extremly sorry to interupt here..

Hema Bairavan5-Jun-09 23:14

Hema Bairavan

5-Jun-09 23:14

guys helping here are having their personal work also,, i know that..

sorry to disturb you peoples here,,

actually i have a question in WPF, i have posted there but there is no help for 3 hours.
can any one help me please.. if i disturb you peoples sorruy

Re: Extremly sorry to interupt here..

Blue_Boy6-Jun-09 3:26

Blue_Boy

6-Jun-09 3:26

You shouldn't show your sorry because here everyone are free to post questions and all what you have to do is to try by yourself to figure out until you will get any answer from this forum.

Personaly, later when I wll have enought time I will look to hand you.

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.

Re: Extremly sorry to interupt here..

Troy Russell6-Jun-09 8:59

Troy Russell

6-Jun-09 8:59

T=Troy=my name

Smile | :)

$Shucks | :-\$ Blush | :O

Re: Extremly sorry to interupt here..

Dave Kreskowiak6-Jun-09 4:51

Dave Kreskowiak

6-Jun-09 4:51

3 hours?? THAT'S ALL YOU'VE BEEN WAITING?? I was asleep 3 hours ago. Have some damn patience. After all, you're not PAYING for support.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

tableLayoutPanel

hamidhakimi5-Jun-09 23:03

hamidhakimi

5-Jun-09 23:03

I want add tableLayoutPanel control at form in the runtime and add clumnes then i want change clumnes size with MouseDownEvent on the cell border and drag cells to resize.
thanks.

[Message Deleted]

hkjghkj15-Jun-09 22:40

hkjghkj1

5-Jun-09 22:40

[Message Deleted]

Re: Looping media

Christian Graus5-Jun-09 22:51

Christian Graus

5-Jun-09 22:51

Is this WPF code ? Where is your timeline associated with your media player ?

[Message Deleted]

hkjghkj15-Jun-09 23:51

hkjghkj1

5-Jun-09 23:51

[Message Deleted]

Re: Looping media

ScottM16-Jun-09 4:09

ScottM1

6-Jun-09 4:09

myventsi wrote:
It's not WPF

It looks like WPF.
You are creating a MediaTimeline with repeat enabled but then you aren't using it.

Is there a class for doing HTTP GET requests in c#.Net

Roland Szigeti5-Jun-09 22:34

Roland Szigeti

5-Jun-09 22:34

Re: Is there a class for doing HTTP GET requests in c#.Net

I Believe In GOD5-Jun-09 22:46

I Believe In GOD

5-Jun-09 22:46

Yes.

public class Program 
{ 
static void Main(string[] args)
{ 
  HTTPGet req = new HTTPGet(); 
  req.Request("http://www.google.com"); 
  Console.WriteLine(req.StatusLine);
  Console.WriteLine(req.ResponseTime); 
 } 
}

I know nothing , I know nothing ...

Re: Is there a class for doing HTTP GET requests in c#.Net

0x3c05-Jun-09 22:48

0x3c0

5-Jun-09 22:48

You could probably use the System.Net.WebRequest class[^], setting the Method property to "GET". There's a code snippet on the MSDN page I linked to which shows you roughly how to use it

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

Re: Is there a class for doing HTTP GET requests in c#.Net

Garth J Lancaster5-Jun-09 22:50

Garth J Lancaster

5-Jun-09 22:50

do a search for HttpWebRequest and its counterpart HttpWebResponse

(thats one way, afaik HttpWebRequest is quite customisable)

'g'

In _keyDown I don't receive events for the arrows keys

Roland Szigeti5-Jun-09 22:33

Roland Szigeti

5-Jun-09 22:33

In _keyDown I don't receive events for the arrows keys

Re: In _keyDown I don't receive events for the arrows keys

I Believe In GOD5-Jun-09 22:45

I Believe In GOD

5-Jun-09 22:45

a sample of your code would be greate ....

I know nothing , I know nothing ...

Re: In _keyDown I don't receive events for the arrows keys

DaveyM695-Jun-09 23:49

DaveyM69

5-Jun-09 23:49

Just tried it on a form and it works for me:

public Form1()
{
    InitializeComponent();
    KeyPreview = true;
    KeyDown += new KeyEventHandler(Form1_KeyDown);
}

void Form1_KeyDown(object sender, KeyEventArgs e)
{
    Console.WriteLine(e.KeyData);
}

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)
Why are you using VB6? Do you hate yourself? (Christian Graus)

Re: In _keyDown I don't receive events for the arrows keys

I Believe In GOD6-Jun-09 10:36

I Believe In GOD

6-Jun-09 10:36

I think he missing this one "KeyPreview = true;"

I know nothing , I know nothing ...

Re: In _keyDown I don't receive events for the arrows keys

Roland Szigeti6-Jun-09 10:45

Roland Szigeti

6-Jun-09 10:45

_PreviewKeyDown works for me

Smart Card Reader/Writer

ddravin20005-Jun-09 21:45

ddravin2000

5-Jun-09 21:45

Hi dear all,
   i have a RFID reader. in my project i have to read data from smart card and also write data in the card.

   i attached the reader to com port "com 3".
   and i am using ..
   private SerialPort comport = new SerialPort();
   for the communication.

      i am using the object "comport"   to read and write   data..
      the read is..
      // Read all the data waiting in the buffer
            string data = comport.ReadExisting();
   and write is..
      // Send the user's text straight out the port
            comport.Write(txtSendData.Text);

   <big><b>But i want to read data from a specific block of SMART CARD.</b></big>.
   How it is possible...

   any one can help me...

   thanks! Rose | [Rose]

Re: Smart Card Reader/Writer

Garth J Lancaster5-Jun-09 22:09

Garth J Lancaster

5-Jun-09 22:09

usually theres a manual and/or SDK that comes with such a device - you could look to see if the manufacturer has a website where they post the details.

'g'

Last Visit: 31-Dec-99 18:00 Last Update: 27-May-24 14:47

Refresh

ᐊ Prev 1...4929 4930 4931 493249334934 4935 4936 4937 4938 Next ᐅ

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