|
Alright. Thanks for the help James.
- monrobot13
|
|
|
|
|
Hi James,
Sorry to bother you again, but I actually just tried this and there is no Assembly Resource File type that I'm allowed to add. I am using MC++ so do you think that has something to do with it?
Thanks again
- monrobot13
|
|
|
|
|
Hello guys,
I have a DataGrid bound to an MS Access View.
On the Grid I have a "DataGridTextBoxColumn", coresponding to a boolean in the DataBase.
A dataAdapter is connected to the DataBase, and populates the typed DataSet responsible for the DataGrid.
The only field that can be editted is the one containing the ChackBox. The Update method of the Adapter is supposed to set to the selected records' boolean Field the value "True" depending whether the checkbox is checked or not. (Also another field will be modified... not relevant)
The ugly part is that I can not verify wether the state of the checkbox, and update only those "checked". It happens that I check, and than uncheck a CheckBox, and the DataGrid considders that row as being editted, and takes it also into considerations when updating the DataSet...
Can U teell mee how to create a SQL Update Command Text which will take into consideration only the checked rows ?
Thanks in advance.
I can post the whole application if you are interested in some triks I found during this month about Grids.
|
|
|
|
|
On the Grid I have a "DataGridBoolColumn", coresponding to a boolean in the DataBase, not a DataGridTextBoxColumn...
Sorry
|
|
|
|
|
if you have an oledbdataadapter to update the dataset is nothing you can do to do what you have said. if you want to do the update manually you can say
foreach(System.data.datarow a in mainset.table["tablename"].rows)
{
if (a["columnname"]==true) update.....
}
but i don't see why you want to do it that way if you allready have a dataadapter that works, if it is for the speed you can optimize the code i wrote that way. Since you want only the changes anyway you can do this:
foreach(System.data.datarow a in mainset.table["tablename"].Getchanges().rows)
{
if (a["columnname"]==true) update.....
}
tricky code!! isn't it? 
From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com
|
|
|
|
|
Thanks very much. I will try to use the code you gave me.
Here is the reason I came here. I have a "Stock" application. (Inputs, Outputs and Materials).An input contains more materials (1 to many relation). An Output is also a collection of materials. (1 to many again).
To create such an Output I must select from a DataGrid (containing the Materials) those Materials that I need. I do that by means of a CheckBox column.
The Update method of the DataAdapter (that fills the DataSet Materials-Table) should set the value for the Foreign Key in the Materials Table, but only in those that have been checked, and set a boolean value saying that the Material is out of stock since it belongs to an Output (so only 2 fields are Updated).
Nothing fancy. But when the Update method is executed, and by accident I have checked and after that unchecked a row in the DataGrid... surprise: a fuuny error arises
"System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records"
No multi user environment, no data changed during my DataSet experience to explain the Concurency Error.
Thanks again
|
|
|
|
|
if you create a user control and add a vertical and horizontal scrollbar. You set the tabstop of both scrollbars to false and set the tabstop of the usercontrol to true. If you hit any arrow keys or pageup/down then the scrollbars flash forever. Even if you force the focus back to the usercontrol (which goes back and forth like 9 times till it gives up) then you still have the arrow key stuck to whatever scrollbar you affected first.
what I am trying to figure out is how do you force the scrollbars to %100 ignore the keybaord %100 of the time. I never want the scrollbars to react to the keyboard at all no matter what. However, I want all keys to be handled in the user control. Anyone know how to go about doing this?
|
|
|
|
|
Look into the Autoscroll stuff in .NET. I know it's limited, but it's much easier than trying to make your own scrollable control using scrollbar controls (rather than the built-in window scrollbars).
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
sorry I wasn't clear on my original question. Its not a matter of auto scrolling, its a matter of I need the arrow keys for other things. The fact that scrollbars exist on the usercontrol doesn't mean I want those scrollbars to own the arrow keys.
|
|
|
|
|
how do you make a datagrid catch returns (new paragraphs).
Da Intern
|
|
|
|
|
how do you make a datagrid catch returns.
Da Intern
|
|
|
|
|
What do you want the datagrid to do exactly, if you want to see when the "enter" key is pressed you can use the KeyPress event?
if not write exactly what the app you want to do so we can come up with something!!
From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com
|
|
|
|
|
okay this is what i'm doing im writing a program to make a webpage newsletter i have created a form to input information into a datagrid then i have binded that to xml then use xsl to create the html page but i can't make the information look like a paragraph because the datagrid dosen't read paragraphs as a straight line. also im uploading images to a web server to allow him access to any image on the server......................alot isn't..............if you can help with the two last problems i would greatly appreciate it
Da Intern
|
|
|
|
|
i just want to know how you can a form that you already created in a form that created before.
Da Intern
|
|
|
|
|
Please explain yourself better. 
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
i have a windows app that runs fine i want to call another app from a menu button i don't know how.................. please help
Da Intern
|
|
|
|
|
If you are wanting to start another process, use Process.Start().
"Blessed are the peacemakers, for they shall be called sons of God." - Jesus
"You must be the change you wish to see in the world." - Mahatma Gandhi
|
|
|
|
|
Process.start() i good if you want to start another app, but you cannot interact with this app after it in an easy way.
You should better create a dll with the functionality from the other program and use it in the new program. .NET remotin is another solution if you want to collabarate with another app. If you want only to start another app use Process.start(), it's the easiest
From Greece:
Dimitris Iliopoulos
dimilio@yahoo.com
|
|
|
|
|
dll im not really famaliar with them so could you help me
Da Intern
|
|
|
|
|
I'm doing some database in C# using MS SQL.
Problem #1:
Everytime i do a connection to my database, i have to copy and paste the code over and over. I heard of a way to put these code in the configuration file, but i don't know how to.
Problem #2:
I also heard of someway(interface, object) allowing me to do SQL query indirectly instead of passing the query string directly into the SqlCommand object. And, again, I don't know how to.
Problem #3:
Is there anyway i can pass in my sql query dynamically(ie, as a varible)?
I just learn C# on my own, and having problem searching for things like this
Please help me out!
THANKS A BUNCH!!!
|
|
|
|
|
You should only need one IDbConnection instance to one database, and you can just reuse it every time (just open and close it).
I am not sure what you mean by indirect query; however I think its good practice to use the interfaces rather than the specific providers as much as possible, as your provider might change. (i.e. IDbCommand cmd = new OldDbCommand("S...).
As for the queries, I keep mine as strings, not as string literals, and have them in a config file. That way I don't need to recompile every time i change a query. It also makes it easy to add on constraints on the query ( cmd.CommandText = selectString + "WHERE Cust = " + custId.ToString()).
|
|
|
|
|
FYI,
Problem #1
Where are you connecting from? Are you connecting from a web service? Windows Form? Asp.net?
Problem #2
Problem #3
Read on on the .NET Documentation. Specifically with the SqlCommandBuilder.. It will automatically generate the SQL queries you require.. Its not as fast, to my understanding, as your own
- danny
|
|
|
|
|
Hi,
I have been building my gui's by hand in my most recent project, and have consistently ran into trouble when trying to size controls. I mimic the form designer code with an InitComponent() method that is run from the constructor, where i create all my controls. In this method, when i try sizing the controls through controls such as:
textBox.Size = new Size(100,30);
or:
textBox.Width = 100;
textBox.Height = 30;
the controls will not be sized. Any thoughts on why they are not sizing properly, or is there another way to do it?
Thanks,
Nikolaj Baer
|
|
|
|
|
Hi,
thanks for the advice. Actaully ResizeRedraw is a protected property, something i can't apply to an instance. However, i kept searching, and found that SuspendLayout() and ResumeLayout() is the proper way to do it.
|
|
|
|
|
Hello,
I am building an application that requires data to be entered into a control that looks like the Data Grid. Basically, it should mimic the functionality of entering data into MS Excel. I know the Data Grid is primarily used to display data binded to a data source, such as a DataSet. Is there any way to display a blank data grid and use it for data entry? If not, what do you experts suggest that I do to get the results I'm looking for?
One possible solution that I came up with was to bind the data grid to the table that the data is destined for. Next, I would add one row of text boxes that would represent each column below the grid. The user could then add the record to the data grid (and underlying table) by typing the details into the the textboxes below the grid, followed by clicking the "Add" button. However, a grid will not appear unless there is data in the underlying table to be displayed. The empty data grid control does not look attractive on a form.
I remember building an application in vb 6.0 where I got around this by placing textboxes over the cells of the data grid control. However, I can't remember exactly how I did this, or if it would even work with the .NET data grid control.
Any help would be greatly appreciated
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
