|
Hello...
For the moment I use something like "dataRow.ItemArray.GetValue(4).ToString();" to get the value of the 5th attribute in a DataRow of a DataGrid.
I don't seem to find a way to get the 5th value with the column name. Let's say the 5th attribute is in the column with name "Amount". How do I get this value out of the DataGrid.
Can someone help me out?
Thx in advance!
TweeZz.
|
|
|
|
|
dataRow["Amount"].ToString();
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Omg... It's that simple... I'm ashamed :s
Thx for the help Stewart (again)!
|
|
|
|
|
Hello!
How do I set the connection timeout in C#? It is default 15 sec, I want 90. I'm connecting to a sql-database.
|
|
|
|
|
Set the Connection Timeout property in the connection string, or use the ConnectionTimeout property on the SqlConnection object.
Stability. What an interesting concept. -- Chris Maunder
|
|
|
|
|
i am developin a voice enabled application and in which the IDe is controlled by voice commands..ex if i say "file" then file menu should be dropped..i can catch the commands but having problems in droppin the menu..
This can be jotted down to a simple problem like if u click a button in ur form..then file menu should be dropped..
i am doin this project using window forms in C#..
please help me out as soon as possible...
mail me at harbhanu@rediffmail.com
harbhanu@hotmail.com
|
|
|
|
|
Why don't you use TrackPopupMenu?
Declare the good old method:
[System.Runtime.InteropServices.DllImport("user32.dll")]<br />
private static extern bool TrackPopupMenuEx(IntPtr hmenu, int fuFlags, int x, int y, IntPtr hwnd, IntPtr lptpm);
Drop menus at anypoint:
<br />
public static void TrackPopupMenu(ContextMenu Menu, Point Location){<br />
TrackPopupMenu(Menu, (int)(TPM_LEFTBUTTON|TPM_LEFTALIGN|TPM_TOPALIGN), Location, new IntPtr(0));<br />
}
Or drop menus an other controls:
public static void TrackPopupMenu(ContextMenu Menu, Control DockingControl){<br />
Point menuPosition = DockingControl.PointToScreen(<br />
new Point(DockingControl.ClientRectangle.Location.X, DockingControl.ClientRectangle.Bottom) );<br />
TrackPopupMenu(Menu, (int)(TPM_LEFTBUTTON|TPM_LEFTALIGN|TPM_TOPALIGN), menuPosition, DockingControl.Handle);<br />
}
|
|
|
|
|
If you're using a ContextMenu , you can actually just call Show , which encapsulates the TrackPopupMenu API.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
i have a function that populates a combobox from a database and returns a table that i set as the datasource for the combobox, then a user select a value and on the Selection change event i populate another combobox based on the selected value, but the first combobox needs to have blank text so as the user is fprced to select a value from the first combobox but as i am populating the first combobox in the windows form LOAD it show the text of the first record from the database ie the first row of the table returned how can i add a blank row to my table and still populate the first combobox??
|
|
|
|
|
After you assign the DataSource property, do something like:
comboBox1.Items.Insert(0, string.Empty);
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
a big thank you i will try after the easter break
|
|
|
|
|
private void LScheme()
{
Customer c = new DGIBO.Customer();
DataTable list = c.getSchemes();
ddlScheme.Items.Insert(0, string.Empty);
this.ddlScheme.DataSource = list;
this.ddlScheme.DisplayMember = "SchemeName";
this.ddlScheme.ValueMember = "PhaseName";
tried my example above and it does not work, tried putting your code after datasource and got an error because the databind
|
|
|
|
|
Inserting before data binding won't work, of course, because when you data bind the control all the data-bound properties - like Items - are cleared.
The example I gave would still change the underlying data source, so you need to make sure that the data you're adding to the Items collection property doesn't violate any constraints (like a null key) in the DataTable .
Note, this isn't the case with ASP.NET and data-bound controls.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi,
I have a ClassA (extends Component) with some properties.
I have a ClassB (extends CollectionBase) that implements collection of ClassA objects.
In my main app, I use a ClassB collection, add some ClassA objects to it, and databind a property X of ClassA to a textbox:
textBox.DataBindings.Add("Text", ClassBCcollection, "PropertyX");
This works well, changes in the textbox are reflected in the collection.
EXCEPT when at startup the ClassB collection is empty, then databinding does not work.
So; databinding works when databindings are set after collection is filled with items; databinding does not work when databindings are set when collection is empty.
Do I miss something...?
Thanks!
|
|
|
|
|
lustuyck wrote:
Do I miss something...?
Nope. The reason is you read deep into the data-binding topics is because when you use a CurrencyManager to bind against a collection of unknown object types, the collection or list must contain all the same type (or base types that must come before their derivative types) and contain at least one of those types for the data-binding mechanism to discover the Type information correctly.
Even if you use typed parameters and return values, this still won't help since it uses the IList interface, which always returns and accepts the Object type. An object must be present in order to discover the actual Type information.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi, thanks for the answer.
What I do now as a 'workaround', is wait until an item is added to the collection the first time; and when that happens I add the databindings (only once).
It works now, but I don't know if this is common practice. Are there better ways to do something like this?
Kind regard,
Ludwig
|
|
|
|
|
Yes, but it's not simple. You need to extend the CurrencyManager class and override GetItemProperties to return the properties of the Type. You can do this simply by returning something like the following:
public override PropertyDescriptorCollection GetItemProperties()
{
return TypeDescriptor.GetProperties(typeof(MyClass), new Attribute[] {
new BindableAttribute(true) });
} Then, extend the Control classes that you want to data-bind and override the BindingContext property, return an instance of a derivative BindingContext that you must create. In your derivative class, override Add and when the BindingManagerBase is of type CurrencyManager , add your CurrencyManager derivative by calling base.Add with your type (which should copy information from the BindingManagerBase if available).
This should work, though it's untested.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Is there a way to preview a report as you build it? I know you can do the viewer to show it at runtime but i was wanting to preview what it would look like as i'm building so i don't have constantly make changes to get it exactly how i want it to look.
thanks
Win32newb
"Making windows programs worse than they already are"
|
|
|
|
|
win32newb wrote:
Is there a way to preview a report as you build it? I know you can do the viewer to show it at runtime but i was wanting to preview what it would look like as i'm building so i don't have constantly make changes to get it exactly how i want it to look.
thanks
I don't believe so. I think you need the full version to be able to preview during design mode.
Michael
But you know when the truth is told,
That you can get what you want or you can just get old,
Your're going to kick off before you even get halfway through.
When will you realise... Vienna waits for you? - "The Stranger," Billy Joel
|
|
|
|
|
Thanks for the reply. I guess it's like everything else its all about the money. I just figured since i paid the ungodly price for visual studio .net that EVERYTHING in it would be a full version guess not.
Win32newb
"Making windows programs worse than they already are"
|
|
|
|
|
i do not know how to write out a program that allow to import data from excel files to SQL Server
Help Me.
Thanks
Mr Duc Linh Nguyen
|
|
|
|
|
try to connect to the excel file by using ole connection the read data to a Dataset or you can read data then write it to sql database be using sql conncetion
Mhmoud Rawas
------------
Software Eng.
|
|
|
|
|
Is this programming question? If you want to do it with SQLServer you can use Import and Export Wizard , follow it and it will do it automaticlly.
Mazy
"I think that only daring speculation can lead us further and not accumulation of facts." - Albert Einstein
|
|
|
|
|
hai there,
Is it possible to a C# .exe file to contact/communicate/get & pass value to another .exe files (may or maynot created using C# language)?.
except com con:-Dcept.
hai, feel free to contact
Sreejith SS Nair
|
|
|
|
|
You can use TCP Sockets communication between the tow applications to do that
Mhmoud Rawas
------------
Software Eng.
|
|
|
|