|
Hi,
I was wondering if it's possible to display select columns from a DataTable to the DataGrid? The code below (of course) displays all the columns in my DataTable.
//view the DataTable in a DataGrid
dataGrid1.SetDataBinding(myDataTable,"");
Thanks!
Ron
|
|
|
|
|
Add a DataGridTableStyle to your grid. Any columns in your table that do not map to a DataGridColumnStyle in your DataGridTableStyle will not be shown. Or you can add a DataGridColumnStyle for every column and set the Width property to zero for the columns you don't want shown.
DataGridTableStyle style = new DataGridTableStyle();
style.MappingName = "myDataTable";
DataGridColumnStyle colStyle = new DataGridTextBoxColumn();
colStyle.MappingName = "col1";
style.GridColumnStyles.Add(colStyle);
colStyle = new DataGridTextBoxColumn();
colStyle.MappingName = "col2";
style.GridColumnStyles.Add(colStyle);
colStyle = new DataGridTextBoxColumn();
colStyle.MappingName = "col3";
colStyle.Width = 0;
style.GridColumnStyles.Add(colStyle);
dataGrid1.TableStyles.Add(style);
Charlie
if(!curlies){ return; }
|
|
|
|
|
Thanks Charlie... I'll give it a go.
Another related question to DataTables:
I'm trying to save a DataTable to an Access DB. My search has come up with this: "Only the DataAdapter serves as a bridge between a DataSet and a data source for retrieving and saving data..."
My question is: Can I use the DataAdapter with a DataTable (not DataSet) to save to the Access db?
Ron
|
|
|
|
|
No. Your DataTable would sit inside a DataSet and be the only table in the set.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Thanks Dave!
One more question (back to DataGrid)...
Is it possible to have the DataGrid (once you have
populated it from the DataTable) to not show
the last "add" row (the row to add more rows).
I want the user to have the ability to still edit
populated rows, but not to add new rows.
Thanks,
Ron
|
|
|
|
|
How can I save a string in a text file.
I can save it in binary file with BinaryFormatter,
but I don't know how to save in a text file.
Thank you very much in advance
|
|
|
|
|
See FileStream class and its Write method. You can write each byte of your string into it with Write method.
Mazy
"One who dives deep gets the pearls,the burning desire for realization brings the goal nearer." - Babuji
|
|
|
|
|
Thank you very much for your help. Your advice helped me.
I am very happy that I solved my problem!
Thank you very much once again! ))
|
|
|
|
|
What Mazdak said isn't completely right. In order to get the bytes for your string, you need to use an Encoding class like Encoding.ASCII and call the GetBytes(string) method to get the byte[] array ("buffer") that you write to a FileStream . If you use a TextWriter derivative, like the StreamWriter someone else mentioned, it does all this for you automatically. Just make sure to specify which encoding you want to use in the constructor:
using (StreamWriter writer = new StreamWriter("file.txt", true,
Encoding.UTF8))
writer.WriteLine("This is a single line.");
} The using statement here makes sure that the StreamWriter is closed and all unmanaged resources (like file handles) are freed when the block of code is done - even in case of an exception.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
And in order to get those bytes correctly, you need to use an Encoding class and call GetBytes . Using a TextWriter derivative does all this for you and is recommended to use for text files.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
You might want to look at the StreamWriter class. It has an overloaded constructor that lets you point to a file path. Once you have the path you can use the WriteString method. Hope this helps.
|
|
|
|
|
I found where was the problem-
if I want to have carriage return
I should add not only Convert.ToChar(13)
to the string but also Convert.ToChar(10).
I will try also with StreamWriter!
Thank you very much for your advice! ))
|
|
|
|
|
Actually, you should use Environment.NewLine , which is a platform-depenent new-line character. In Windows, this is characters 13 + 10 (\r\n).
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thank you very much ))
|
|
|
|
|
"Delphi" != "C#", so this doesn't belong in this forum. Besides, if you have a question specific to an article, you should ask in the message board of that article.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
I am using the method publish(Exception ex)
throgh the static member "ExceptionManager" actully i am writing-----> ExceptionManger.publish(ex)
i wondered where i could find the file that hold all the information (Messages) about those Exceptions?
shuold i have to create it?
I dont wont to write those exceptions into my configuration file.
i want to write it into event Log something.
is it possible?
how can i do it?
Thanks in advanced
Dudi
Be Good...
Dudi
|
|
|
|
|
By default, the Exception is logged into the event log when you call ExceptionManager.Publish . So, if that's all you need to happen, you don't need to alter your application's config file.
See the documentation that ships with the EMAB if you need more information about extending the application block with custom publishers.
Charlie
if(!curlies){ return; }
|
|
|
|
|
How can i get the index of a doubleclicked item in the listbox?
|
|
|
|
|
Write an event handler for the DoubleClick event of the ListBox and there retrieve the value of its SelectedItem property.
www.troschuetz.de
|
|
|
|
|
Hi,
I'm trying to implement a textbox and a combobox in a menuitem. When the menuItem is shown, I want to have a textbox and a comboBox.
I already tried to construct a derived MenuItem and to override the onPaint, but got somehow stuck. I think I saw something like this on the net, but cann't find it again...
Any ideas/suggestions?
Dennis
|
|
|
|
|
Hello,
I have a panel object on my form in which I draw something. How can I save and then restore what I draw on that panel?
Thanks in advance for any suggestion...
Best regards,
Cristina
|
|
|
|
|
You can draw everything via a GraphicsPath or perhaps there is some other way? Would be nice to know of the alternatives
top secret xacc-ide 0.0.1
|
|
|
|
|
I wanted to know how can I save what I draw. It crossed my mind serializing the graphic context but I don't know how to mark it as serializable. Or I thought may be I can save it like a bitmap file, but I don't know how to refere to it (what exactly to save)...
If you have any suggestions... please... I'd appreciate it!
Cristina
|
|
|
|
|
Instead of painting everything in your OnPaint override for your Panel , move your drawing code to a method that takes a Graphics parameter. From the OnPaint override, pass the PaintEventArgs.Graphics property to that method. To save it to a file, create a new Bitmap and get a Graphics object from that (like Graphics.FromImage , for example). Then pass that Graphics object to your method. When the method returns, dispose your Graphics object, save the Bitmap , and dispose the Bitmap . For the OnPaint override, don't dispose anything since it will take care of it for you.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi
I want to know the difference between Directory and DirectoryInfo as well as the difference between File and FileInfo.
Thanks..
|
|
|
|