Hi.
How can I dynamicaly filter items in combo column?
I have a dataTable and I've set is as datasource for all cells in DGVcomboBox Column, but in response to cellClick event I want to limit the displayed items to some fraction of the dataTable.
How can I do this?
Kermit
Last Activity: Feb 25 '08, 10:14 AM
Joined: Aug 9 '07
Location:
-
[C# .NET 2.0] DataGridViewComboColumn dynamic data display
-
progressBar + Label
Hi.
I've searched the forum for answer, but haven't found one.
The problem is with displaying the label.
When the progressBar is incremented I change the text of the Label, but it doesn't update.
I called invalidate on the label, and on it's parent, but it didn't change the text.
I also tried to do that using ToolStripProgre ssBar and ToolStripLabel, but they also don't work :(
An... -
Another question on the topic:
How can I check for any difference between data stored in dataset, and in the database.
For example: I have dataset that has data retrieved from the database.
I add a row, and then remove it. The data is still the same. Now, on closing the application I'd like to inform the user, that the dataset and the database contain different information, but only when they really do.
... -
C# DataSet and AutoNumber
Hi!
I have another problem. This time with AutoNumbers.
I insert a new row to a dataset (ds.Tables["Name"].Rows). How can I get it's id (which is an autonumber) without commiting changes to the database? -
Ok, but this ^ in front of \d means that you don't accept digits, right?...Leave a comment:
-
use varchar with an input mask (something like ie. 000\-000\-000;0;)Leave a comment:
-
It worked, thanks. I haven't thought about that. But is there another way to do that using only one data adapter?...Leave a comment:
-
The SqlDBType.Bit may store 0, 1, or Null values to the database (see tooltip). Basicly it is the same, but maybe sql stores true/false as 0's or 1's?Leave a comment:
-
I may be wrong, as I don't get the notation, but the first code does not allow digits. Try...Code:^(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[0-9]).{4,8}$Leave a comment:
-
if using OleDB OleDbType.Boole an should work :)
for SQL try SqlDbType.BitLeave a comment:
-
use DataAdapter.Upd ate(DataSet) method.
use SqlCommandBuild er mySqlCommandBui lder = new SqlCommandBuild er(mySqlDataAda pter);
to create InsertCommand, UpdateCommand and DeleteCommand for you (if you don't have to complicated SQL queries) and then call
mySqlDataAdapte r.Update(dataSe t, "name of the table");Leave a comment:
-
[C#, MSAccess] Update DB using DataAdapter
Hi,
I have the following problem. I load 3 tables to a dataset aaco, and then perform some operations on two tables (insert 1 row in the first table, update one field in the second), and try to call dataAdapter.Upd ate method, and I get an exception.
Tables:
- audits (id, object id, ...)
- controlledObjet cs (id, ...)
[c# code]
OleDbCommandBui lder myCommandBuilde r = new OleDbCommandBui lder(aacoDataAd apter);... -
data is a array of objects. I'm casting object to int.
I was trying to get id's of all rows that contain certain data, and order them by date.Leave a comment:
-
Data type mismatch in criteria expression [C#, MSAccess]
Hi.
Here's the problem.
I use C# application [forms] to access MSAccess database.
I want to get id's of all records containing some phrase and order results by date (a field in the table).
here's the code:
OleDbCommand cmd = new OleDbCommand("s elect id, endDate from audits where objectId ='" + (int)data[0] + "' order by endDate DESC", conn);
try
... -
In response to MouseHover event of the label create/display the tooltipLeave a comment:
-
Using MSAccess db inC# application
Hi.
I looked through few pages of threads here, but didn't find the answer to my questions.
I'm writting a C# application (Windows Forms) that uses MSAccess database, and I have the following questions:
1. how can I check in what group the current user's is?
I created a login dialog box, and use the standard connection string to connect:
"Provider=Micro soft.Jet.OLEDB. 4.0;Data Source=" + database + ";Jet...
No activity results to display
Leave a comment: