|
actully i want to copy the XML file into the database table, but in distination table there is an extra column. i want to add a new column and gave it a value.
DataSet ds = new DataSet();
ds.ReadXml("C:\\abc.xml");
DataTable sourceData = new DataTable();
sourceData = ds.Tables[0];
DataColumn UID = new DataColumn();
UID.DataType = System.Type.GetType("System.Int32");
UID.ColumnName = "UID";
sourceData.Columns.Add(UID);
sourceData.Columns["UID"] = 12;
i have done the mapping....
bulkCopy.ColumnMappings.Add("UID", "UID");
.
.
.
.
and in end
bulkCopy.DestinationTableName = "Contact";
bulkCopy.WriteToServer(sourceData);
but UID column always gave the null value in database...
any idea??
|
|
|
|
|
i got it...
i have tried this
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].Rows[i]["UID"] = 12; // or your dates
}
instead of
ds.Tables[0].Columns.Add("UID").defaultValue=12;
Thanks to every one of those who could not help me
|
|
|
|
|
Currently the application I have is single threaded. When the user goes into the form it sends a query to mySQL and starts to populate the UI with data.
The question I have is should I being running this on a separate thread using the invoke methods or is there some other/better way of doing this.
The queries are fairly optimized although they are not stored procs. When we run this in some of our centers that are on VPN this can take alot of time.
Any ideas and or suggestions welcome.
Thank you.
BTW I will be doing this reworking in VS2010 so these would actually be task...
Humble Programmer
|
|
|
|
|
IMO everything that fetches data outside the local PC needs to be threaded (as well as lengthy calculations), you simply should never let the GUI responsiveness depend on external factors. However I'm not sure many will agree, this point of view may well be considered too academic.
Example: I just finished tthis article[^], it is a little app that fetches web pages from the CodeProject site, using BackgroundWorkers. Data fetching tends to take several seconds.
|
|
|
|
|
What are your thoughts on updating the ui like that would it be better to load all of the data into a class and update the ui from that
Humble Programmer
|
|
|
|
|
I think that goes without saying. But using MVC or MVVM doesn't preclude performing the data fetch asynchronously.
/ravi
|
|
|
|
|
I am not familiar with MVS MVVM...
I am referring to winforms I don't know if that makes a difference or not...
Humble Programmer
|
|
|
|
|
MVVM = Model View View-Model
Model = "class" (what holds the data)
View = "ui" (what presents the data)
View-Model = "ui class" (adds properties and such to a model so it plays well with the view)
Of those, the view-model is probably the most difficult to understand. For example, if you had a TreeView (a "view" component) that presented Animals (the model/class), you'd use an AnimalNode that both holds a reference to an Animal (exposing all it's properties) and has properties such as "IsSelected" (a view-centric property that needs to be stored somewhere, in this case on the view-model).
That's the high level... but to answer your question, yes it's a good idea to store data in instances of a class and then present that using a ui. I recommend loading all the data into an intermediate collection on a different thread, then call back to the main thread to present all that data in the view. Depending on the scenario, you may want to present the items in a streaming manner rather than after it's completely loaded (streaming = slower, but user gets first results faster).
|
|
|
|
|
Pretty much any lengthy processing should be performed on a separate thread.
|
|
|
|
|
I am using this code when for activated to get the URL address but the Messagebox keeps poping up when user clicked Yes or No.. why it's not returning? where is my mistake?
private void frmLinksEntry_Activated(object sender, EventArgs e)
{
string url_address = Clipboard.GetText();
if (url_address != string.Empty)
{
try
{
System.Uri xx = new Uri(url_address);
}
catch (FormatException exp)
{
return;
}
if (MessageBox.Show("Do you want to use the selected URL?", "Link", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
txtURL.Text = url_address;
}
}
}
|
|
|
|
|
You have shown a handler for the Activated event which will be called whenever the frmLinksEntry control receives focus. It's a bad idea to pop up a messagebox from the handler as this causes the control to lose and then regain focus. The Activated event fires again and the messagebox reopens etc etc etc.
Alan.
|
|
|
|
|
but that's what i want, i mean when the user go to copy the URL from the browser then comes back to my application with the URL in clipboard and the frmLinksEntry active it should ask if he wants to use the copied URL?!
|
|
|
|
|
If the URL you get from the clipboard is the same as the URL in the textbox, then do not show the dialog again.
|
|
|
|
|
but it's not the same! the textbox is empty already!
|
|
|
|
|
I didn't say anything about the textbox being empty.
|
|
|
|
|
How can I apply bullets or numbering for the selected text in Rich Text Control using C#? and how to make the selected numbering 2 if there is a previous numbered 1?
|
|
|
|
|
I am trying to create Microsoft Word Document in C# using [this article] and other articles but it's not working! the Word.Application is not recognized! do I have to add a using declaration as well?
|
|
|
|
|
How do you expect anyone to give you a solution if your only symptom is "It's not working"?
Alan.
|
|
|
|
|
Read the article again; point 3 explains how to add the reference.
txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
thanks it's working now but one question... where can i get a a step-by-step or reference on how to create full document including tables and pictures and font formatting using C#?
|
|
|
|
|
jrahma wrote: where can i get a a step-by-step or reference
You will have to read the documentation on MSDN, and also try searching Google. There is no universal index of this sort of thing and people tend to publish articles on lots of sites. I doubt that you will find a full step by step guide to what you want though.
txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
so you mean there is no reference guide for it?!!
|
|
|
|
|
As I said before you can go through the MSDN Documentation[^]. If you want to get familiar with Microsoft technology you need to use MSDN as your prime source of information.
txtspeak is the realm of 9 year old children, not developers. Christian Graus
|
|
|
|
|
Does anybody know how to do this with the information entered in
this format? ##.####
I thought it might be in the Math class but isn't.
Thanks for any help.
|
|
|
|
|
Darrall wrote: I thought it might be in the Math class but isn't.
Wikipedia does http://en.wikipedia.org/wiki/Geographic_coordinate_conversion[^].
Tarakeshwar Reddy
There are two kinds of people, those who do the work and those who take the credit. Try to be in the first group; there is less competition there. - Indira Gandhi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
