|
It looks to me like google will at least explain what those algorithms are. So, how about just writing them yourself, and perhaps writing an article here for the next person that needs them ?
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.
|
|
|
|
|
|
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();
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 });
}
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.
|
|
|
|
|
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.
|
|
|
|
|
Hi Christian
i didn't understand what you saied. can u give me more explain ?
thanks
|
|
|
|
|
Change the column maxlength at dataset properties ...
I know nothing , I know nothing ...
|
|
|
|
|
Hi Stark
i tried this, but it didn't works.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
Is this WPF code ? Where is your timeline associated with your media player ?
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.
|
|
|
|
|
|
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.
|
|
|
|
|
|
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 ...
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
a sample of your code would be greate ....
I know nothing , I know nothing ...
|
|
|
|
|
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);
}
DaveBTW, 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)
|
|
|
|
|
I think he missing this one "KeyPreview = true;"
I know nothing , I know nothing ...
|
|
|
|
|
_PreviewKeyDown works for me
|
|
|
|