|
You will have to loop through the rows and copy them into a new datatable. You can also use DataTable.Select method as well instead of looping through all the rows.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
The simplest way would be to write a loop that iterated over the DataTable and allocate rows accordingly. When you do this, you need to clone the table structure, and use ImportRow to copy the row from one table to another. If you attempt to copy the row over directly, you'll get a "row belongs to another table" error. The following method does what you want:
private List<DataTable> CloneTable(DataTable tableToClone, int countLimit)
{
List<DataTable> tables = new List<DataTable>();
int count = 0;
DataTable copyTable = null;
foreach (DataRow dr in tableToClone.Rows)
{
if ((count++ % countLimit) == 0)
{
copyTable = new DataTable();
copyTable = tableToClone.Clone();
tables.Add(copyTable);
}
copyTable.ImportRow(dr);
}
return tables;
}
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Thanks for your method !
But i have little experience in c#. can you explain me what is List<datatable>, how can i define ?
I'm writing in c#.net 2003
|
|
|
|
|
This code working fine..Thanks lot
|
|
|
|
|
I will try to shorten this question. If I have the following class:
public class MyClass
{
public int MyInt {get; set;}
public Button MyBtn {get; set;}
}
Now, let's say I have a for-loop that generates several objects of this class and hooks it up to an event handler like this:
for (int i = 0; i < 5; i++)
{
MyClass myClass = new MyClass();
myClass.MyInt = i;
myClass.MyBtn = new Button();
myClass.MyBtn.Click += (s, e) =>
{
};
}
So, my question is: Is it possible to get the value of 'myClass.MyInt' when the button is clicked? I mean, 'myClass.MyBtn' and 'myClass.MyInt' belongs to the same object. The problem is that I must hook up all buttons to the same event handler.
Thanks for help!
|
|
|
|
|
If you look at the method declaration for your event handler, you'll see a parameter called s of type object - by convention, this is the object that raised the event. So, all you need do is cast s to Button as in:
Button button = s as Button;
if (button != null)
{
}
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Thanks for the reply.
Yes, I know I can get the object that raised that event. But that object belongs to an object 'myClass' which in turn contains 'myClass.MyInt'. Is it possible to get which of the 'myClass.MyBtn' that raised the event. If I can get that I would also be able to read out the value of 'myClass.MyInt'
|
|
|
|
|
Yes. There are 5 MyClass instances and you can use one method for all events. This is better :
private List<MyButton> myButtons = new List<MyButton>();
private void CreateButtons()
{
for(int i = 0; i < 5; i++)
{
MyButton myButton = new MyButton();
myButton.MyInt = i;
myButton.Click += new EventHandler(myButton_Click);
myButtons.Add(myButton);
}
}
private void myButton_Click(object sender, EventArgs e)
{
MyButton myButton = sender as MyButton;
if(myButton != null)
{
MessageBox.Show(myButton.MyInt.ToString());
}
}
public class MyButton : Button
{
private int myInt;
public int MyInt
{
get { return myInt; }
set { myInt = value; }
}
}
|
|
|
|
|
Thanks for the reply!
I think that was exactly what I was looking for. I'll try to implement this in my real case and I get back if I don't succeed.
|
|
|
|
|
You don't even need an extra class, you could store the MyClass reference inside the Button using myClass.MyBtn.Tag=myClass; so later an event handler could convert its sender to Button to MyClass instance.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
xkrja wrote: //Is it possible to get the value of 'myClass.MyInt'
//in this event handler since 'myClass.MyBtn' belongs
//to the same object?
In your example code: yes.
Just use myClass.MyInt. The lambda expression will capture the myClass variable, so every event handler will know to which MyClass instance it belongs.
You should not capture the i variable - that would always be 5 because the loop has terminated when the event executes.
But capturing variables declared inside the loop will give you the value from the corresponding iteration.
|
|
|
|
|
how do i insert a new line character.
i want to display a sentence in next line. i selected the multiline property. i want to display the second line in next line of text box like wise \n in C lang
can any one help pls
This code was posted by me...
|
|
|
|
|
|
Just add "\r\n" to the end of your line and the next text will be on the next line.
textbox1.text = string.format("{0}\r\n{1}","this is on line 1","this is on line 2");
Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP
|
|
|
|
|
Environment.NewLine will do that.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Hi all.
I made an application for communicating with serial port.
But there is a trouble.
In the DataReceived event when I wanna fill textbox with data that given from serial port an Exception has occurred.
http://www.picfront.org/d/bV1xDokvV/u.png[^]
Could you please guide me how I can resolve it ?
|
|
|
|
|
void serialPort1_DataReceived(object sender, ...)
{
Invoke(new MethodInvoker(AddText));
}
void AddText()
{
textBox1.Text = serialPort1.ReadExisting();
}
Search in google for cross-thread-exception. You cannot change something in textbox from another thread.
|
|
|
|
|
|
This article[^] explains and solves your problem.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Hi All,
I'd like to make a separate thread in inserting of data into the Custom Collection I have and fires an event when its done so it would be bound to a grid.
Is it possible?
here is my example code.
public class Details : List<Details.Detail>
{
public delegate void _WorkComplete();
public event _WorkComplete WorkComplete;
public void AddDataSource(object value)
{
Thread worker = new Thread(new ParameterizedThreadStart(dowork));
worker.Start(value);
}
private void dowork(object value)
{
ArrayList list = (ArrayList)value;
foreach (Item item in list)
{
this.Add(new Detail { FIELD1 = item.Code1, FIELD2 = item.Code2 });
}
if (WorkComplete != null) WorkComplete();
}
public class Detail
{
private string field1;
private string field2;
public Detail()
{
field1 = string.Empty;
field2 = string.Empty;
}
public string FIELD1
{
get { return field1; }
set { field1 = value; }
}
public string FIELD2
{
get { return field2; }
set { field2 = value; }
}
}
}
so in the UI side i could do
private Details details = new Details();
protected void Page_Load(object sender, EventArgs e)
{
details.OnWorkComplete += new Details._WorkComplete(details_AddComplete);
details.AddDataSource(source1);
details.AddDataSource(source2);
}
void details_AddComplete()
{
grid1.DataSource = details;
grid1.DataBind();
}
|
|
|
|
|
Search in google for cross-thread-exception. You cannot change something in control from another thread.
"grid1.DataSource = details;" -> Cross Thread Exception
void details_AddComplete()
{
Invoke(new MethodInvoker(AddComplete));
}
void AddComplete()
{
grid1.DataSource = details;
grid1.DataBind();
}
|
|
|
|
|
that does not fire an error the "details" is created on the same thread. as the "grid1".
not the comment I expected but thanks for the reply.
modified on Wednesday, August 12, 2009 5:07 AM
|
|
|
|
|
Assuming you add all your sources in Page_Load, you could do this:
In AddDataSource, just add the source to a collection inside Details.
Add a method Details.StartProcessing() which starts the background work.
So Page_Load would look like:
details.AddDataSource( source1 );
details.AddDataSource( source2 );
details.StartProcessing();
}
As Stan said, your event will be fired on the background thread. Either use a BackgroundWorker instead of a Thread, or use Invoke before you update the grid.
Nick
----------------------------------
Be excellent to each other
|
|
|
|
|
Hi,
I want to perform an action before the beginning of an application installation.
I tried to override the event OnBeforeInstall (in the AddInCustomAction class) but I see that when that event is raised my files were already copied to the target directory.
The reason for what I want to do is:
I have a previous version of the application (without setup; just an exe) written in MFC.
Now I rewrite the application in C# .Net VS 2005, and the installation is done via a setup.
I don't want to change the name of the exe and nor the name of the Target directory.
so what I want to do is:
before the installation begin:
check that the previous verion doesn't exist.
if exists, remove the old exe
continue the installation
Any Ideas How can I do this?
Thanks,
|
|
|
|
|
Hello.
more detail:
I have a datagridview and i written save code for it ,but when i change the fied of datagridview Rows for test my save code,after i chenge field(immediately)and i press Eter key ,that row i chenged it be removed from datagridview,before i press save button .So i cann't save the changes.
But if i change the last row of datagridview this row not remove ,and i can save it exactly.
I do not know why other rows after change to remove.?
this is my save code:
private void myBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
SqlConnection objconnection = new SqlConnection(myconnection_string);
int i, idj, tedad, ghimat;
for (i = 0; i < myDataGridView.RowCount; i++)
{
idj = int.Parse((myDataGridView.Rows[i].Cells[0].Value).ToString());
tedad = int.Parse((myDataGridView.Rows[i].Cells[1].Value).ToString());
SqlCommand mycommand = new SqlCommand("UPDATE table1 SET tedad = @tedad WHERE (fid=@fid AND idj = @idj AND tedad ='0')", objconnection);
mycommand.Parameters.AddWithValue("@fid", fid);
mycommand.Parameters.AddWithValue("@idj", idj);
mycommand.Parameters.AddWithValue("@tedad", tedad);
objconnection.Open();
mycommand.ExecuteNonQuery();
objconnection.Close();
}
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
