|
i have a dataset which is having all the records of a table from a database....now i want to insert all those record(which is in dataset) into a table(with same name and same fields) but to another database...how can i do this please help me...
|
|
|
|
|
use bulkcopy
Hope this will help u
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
|
|
|
|
|
How do I find a memory leak in C#, I have several hundred datatables I load data to. On shutting these datatables down I do not reclaim all the memory it used while loading, I probably loose about 50% of my memory.
Thanks in advance,
Michael
|
|
|
|
|
Try .Net Profiler.
http://www.microsoft.com/downloads/details.aspx?FamilyID=a362781c-3870-43be-8926-862b40aa0cd0
|
|
|
|
|
Hi,
I declare various objects to be available in a form immediately in the class declaration eg
public partial class MainForm : Form
{
int totalCourts;
int totalViewPeriods;
int totalBookingPeriods;
int minimumBookingPeriods;
etc...
What I want to do is declare objects conditionally ie if a variable = say 9 then make an object available. Specifically I want to make tableadapters made at design time to be available at runtime.
Is there some way to make these available in the Form Load event?
Glen Harvy
|
|
|
|
|
Your best bet is to make the object available via a property which can throw an exception or return null if you don't want it to be available.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello
It seems really impossible to programaticaly assign values to a binded datagridview. In the following example I'm trying to renum a column value
The result is unpredictible : some values are assigned, some not ?
Some are reflected to the binded dataset but not all ?
private void Rit_Renum()
{
int Step;
int Order = 1;
int.TryParse(txb_renum.Text, out Step);
if (Step < 0) Step = 1;
dgv_rit.Columns["order1"].SortMode = DataGridViewColumnSortMode.NotSortable;
Order = 1;
for (int i = 0; i < dgv_rit.Rows.Count; i++)
{
if (dgv_rit.Rows[i].Cells["order"].Value == null) break;
dgv_rit.Rows[i].Cells["order1"].Value = Order;
Order += Step;
}
dgv_rit.Refresh();
}
I start with a sorted list 1 to 12
I swap a few contiguous rows values
(11 = 12, 12=11) then sort
(10=11, 11=10) then sort
(9=10, 10=9) then sort
So now the original row 12 have the value 9 and the position of 9
Then I renum with a step of 3
The result is this ??
1
3
4
6
7
9
10
12
16
22
28
34
Does anyone undersdand what happen !
|
|
|
|
|
Generally, databound controls tend to blow up if you try to change or add to them. You should change your datasource to change the values.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Thank you
Indeed !
That was my conclusion !
But why does it works for manual entry ?
|
|
|
|
|
How do you mean ? Why does it work when the control is not bound ? Because it's not refreshing itself to a datasource. Why does it work sometimes ? I suspect because you don't know when it will rebind. All I know for sure is that it's safer not to do what you're doing.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hello
Ok I will try to do everyting directly on the datasource
Here is what I do
1- open a connection
2- Select sql from a db table
3- Fill a dataset
5- set dataset as datasource of DGV
6- Let user modify values in ONE column (my order column)
I have two way to modify values
a)- Manually
b)- Automaticaly (with renum ond reorder function)
For now a) and b) are applied directly to DGV, I will manage to do automatic modification on the datatable
AFTER : I apply change to db with getchanges
I use the same connection with different adapter and I close it when the user close the application.
Does it sounds right to you ?
|
|
|
|
|
I'm trying to open a serial port and just leave it open while my whole program is running. I don't need to write to it, I have a relay that activates when the port opens. I can open the port and everything is always fine for a while until the port closes at different times. This powers down my test equipment and ruins my test.
Can anyone tell me why the port closes? This is what I Do:
SerialPort port = new SerialPort("COM4", 9600, Parity.None, 8, StopBits.One);
// Open the port for communications
port.Open();
It stays open for anywhere between 3 and 4 minutes.
|
|
|
|
|
Is it an USB - ComPort adapter ?
|
|
|
|
|
It is a USB Commport Adapter. I have an older machine that has a real serial port. I'll try it on that one.
Could it be a problem with the USB device?
|
|
|
|
|
|
DateTime date = File.GetCreationTime(Application.ExecutablePath).AddDays(12);
stillHasTime = (date >= DateTime.Now);
I use this code to cause a demo version to expire after 12 days. We've tested it many times and it works great, but we have two users who are reporting that they got asked to register after two days. Can anyone tell me any reason why the creation time of an app that has never been installed on the PC before, would be out by 10 days ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Stupid question... What does the OS think the current creation date is for the file? It may not be your code! Its possible that something changed this value.
Hogan
|
|
|
|
|
I don't have access to the client machines to find that out. What would change the value, wouldn't the OS create that value and leave it as it is ?
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Christian,
I'm not sure what would change it, but it is possible via the .NET framework to change the Creation Date for a file or directory. I do a process at work where I have to move files and folders manually and I have to manually reset the file creation data. I'll admit that it is rare that needs to be done, but it is possible and does happen.
File.SetCreationTime();
So I wouldn't assume that your code is wrong just yet. Talk to that client first.
Hogan
|
|
|
|
|
They may have caught a virus joggling with their system time.
.Net BCL wraps the standard Win32 routines for I/O so this error shouldn't really be .Net specific.
|
|
|
|
|
Christian Graus wrote: DateTime date = File.GetCreationTime(Application.ExecutablePath).AddDays(12);
stillHasTime = (date >= DateTime.Now);
But Christian, is this the best method for checking the demo expiration when creation date can be altered ? I am just wondering.
|
|
|
|
|
There's not much you can do.
Even totally stupid noob can change their system time, so your best chance is storing a file on a clients machine with some kind of time-mark. Some sorta hidden system file stored somewhere deeeeep containing time-mark acquired from the internets is the best way I can think off right now.
|
|
|
|
|
hii
i have used mltiple regression for crime forecasting, i know all the formulas to used but i m confused for forecasting formula...
Yt+1= b0+b1(Xt+1)
where does i get the value for thsi Xt+1??
can any one help or can provide me a code in C# for forecasting of crime??
|
|
|
|
|
This is not really a C# question, it's a question for people who know about crime forecasting.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Todays forecast is for some minor fraud in the financial districts with late afternoon muggings rolling up from the poorer areas. In commercial centers managers can expect some isolated violent acts as they ask their staff to work back on the weekend.
Back to you Christian...
|
|
|
|