| Datagrid with Trigger fails to update the third? time (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| Hello! I am using a trigger to set ChangedDate and Changed by: CREATE trigger [tri tblCustomers update] on [tblCustomers] for update as declare @ID int select @ID (select [TreeID] from inserted) update [tblCustomers] set ChangedDate GetDate(), ChangedBy suser sname() where [TreeID] @ID The problem is that when I change a value (a column called CustomerName) in a datagrid or other data component ha... |
|
| datagrid.. Is 2 rows per record possible? (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| I would like my datagrid to have the following format: ID Name Phone Title Birthday email Is this possible for the header and result items? Thanks. |
|
| DataGrid.GetRowRect (VIP replies) |
| microsoft.public.dotnet.framework.windowsforms.controls |
| Hi there! Iâ ve been having some trouble using parent/child DataGrid binding. Tracking down the issue I was able to identify the exact location of it and then create a simple test case to reproduce it: Create a new Windows Forms project and modify the formâ s code to the following: using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms... |
|
| DataGrid.RowHeaderClick Event? (VIP replies) |
| microsoft.public.dotnet.languages.vb.controls |
| Can anyone tell me how can I wirte code to handle DataGrid.RowHeaderClick event or where can I get any sample code. Thanks. |
|
| DataGrid: Real-Time Updates using a DataSet (VIP replies) |
| microsoft.public.dotnet.framework.windowsforms |
| I have a SystemData class (Singleton class extends the DataSet) which has one Table (Trace: 4 Columns). I start a thread in its constructor which keeps on adding data to the table (simulating Real Time data). I have a form (Form1) in my C# project which has a DataGrid (DataGrid1). I have set the DataSource property of this grid to the "Trace" table created above. I can see the data being added to ... |
|
| datagridboolcolumn (VIP replies) |
| microsoft.public.dotnet.framework.windowsforms.databinding |
| Hi, I have a DataGrid with a DataGridBoolColumn(checkbox) column bind to a DataSet, mapping source type is a SQL bit data type. I want to save the changes(checked or unchecked) to the database. My problem is the DataGridBoolColumn does not seem to save the "1" or "0" value to the DataSet. All other columns in the same DataGrid caused the DataSet.HasChanges() to return True, except the checkbox col... |
|
| DataGridColumnCollection.Add & Update (VIP replies) |
| microsoft.public.dotnet.framework.aspnet.datagridcontrol |
| Hello, (I'm impressed there's a dedicated newsgroup for datagrids !) I am trying to build a webpage with a list showing some database table names displaying as links. Clicking on one of them will fill a datagrid with it, providing Edit and Delete functionnalitites. Displaying the datagrid went great, and deleting items is ok also. My problem is with editing. Here is the datagrid : asp:datagrid id ... |
|
| DataGridCommandEventArgs contains unexpected value (VIP replies) |
| ASPFriends.com 'aspngdatagridrepeaterdatalist' list |
| Hi I have an update method for my DataGrid. The passed DataGridCommandEventArgs parameter contains old value before the edit to a row was performed Say I had a row that contains in its second column a Name.. say John, I click edit then delete John and type Smith then I click on Update button. I put a break point at the beginning of my Update method (at the line I marked below). Now the Text Person... |
|
| Datagrids and images (VIP replies) |
| microsoft.public.dotnet.framework.aspnet |
| Happy Holidays All! I want to load a datagrid with images and text (Image, text, image, text, etc...). The data for this datagrid will be coming from sql server and the images are stored as files on the server and not in sql server, however, the name and path of the images are stored with the text in sql server. I don't have a clue on how to load the images into the grid, so can someone please adv... |
|
| Datalist and RadioButton (VIP replies) |
| microsoft.public.dotnet.framework.aspnet.webcontrols |
| Is there a way to use a RadioButton web control in a datalist template column without the button getting a unique name? It doesn't allow a single radio button to be clicked. Thanks, Rob |
|
| DataList ItemTemplate and EditItemTemplate (VIP replies) |
| microsoft.public.dotnet.framework.aspnet.datagridcontrol |
| I'm relatively new to ASP.NET and I'm having a problem editing data in a DataList. I have a DataGrid that lists fieldand I have a DataList that displays detailed information about each item. I want to use the DataList to edit the fields. When I click on the EditCommandColumn button on the first record, the DataList displays the EditItemTemplates (as it should). However, when I try to edit any othe... |
|
| Datalist remove span and br tags (VIP replies) |
| microsoft.public.dotnet.framework.aspnet.webcontrols |
| Hello, I want to create a list with ul and li tags and I want to use the selected item template. I can do this with the datalist but this also generates span and br tags. How can I remove these tags or how can I get my result? Thanks! |
|
| DataList RepeatColumns (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| Hi All, I have created a datalist using the repeatcolumns property to create multiple columns. I have tried to keep everythings width to 100% so that if the window is resized it still looks alright. However with these repeating columns it throws everything out of align because it lets you scroll horizontally but everything else on the page stops where the original right side was. Is there a way it... |
|
| DataListItem in DataList does not render attributes/Tooltips (VIP replies) |
| microsoft.public.dotnet.framework.aspnet.webcontrols |
| I've added a datalist (DataList1) to my web form. In code behind, i'm trying to render the "title" and "style" attribute on each DataListItem. But there appears to be a bug in the DataListItem because it ignores any attributes assigned to it. running on win2003 server, .Net Framework 1.1 example DataList1.RepeatLayout RepeatLayout.Table; // the datalistitem should be renderd as a tablecell //loop ... |
|
| DataRow - How To? (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| Hey Group, I wondered if somebody would be so kind as to help me? Im having trouble with DataViews and DataRows:( I just don t understand, so I wondered if somebody would be so kind enought to modify my code below to include Datarows and Dataviews and maybe explain a little aswell? Many Thanks Regards MCN CODE START Private Sub frmMainMenuPasswords Load(ByVal sender As System.Object, ByVal e As Sy... |
|
| DataRowState.Modified just by navigation? (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| I m running into a problem with a dataset where the columns are bound to text boxes on a form. By merely navigating through the records using a bindingmanagerbase, the rowstate for each row that I navigate through changes to modified even though I have not edited the data. What would cause this? I have included the relevant CODE. 'FORM DATASET DECLARED Friend dsarticlelist As New DataSet() Friend ... |
|
| datarowview (VIP replies) |
| microsoft.public.dotnet.framework |
| I have a listbox that pulls data from an access database through the OLEDBDataAdapter. In the same project I have OLEDBDataAdapter Command using SQL that's referencing the selected item in the listbox. I get an error in "Fill" command. The reason being I think is that I'm trying to convert a datarowview to a string in my SQL. Here's the SQL. "select * from '" & ListBox1.SelectedItem.ToString & "' ... |
|
| DataSet (VIP replies) |
| ASPFriends.com 'aspngfreeforall' list |
| I feel dumb posting this but I need another set of eyes. I'm getting this error: Compiler Error Message: BC30002: Type 'DataSet' is not defined. Source Error: Line 15: Sub BindData() Line 16: SqlStmt SqlStmt SqlStatement.Text Line 17: Dim myDataSet As DataSet new DataSet() 'Error here Script Runat "server" Dim SqlStatement As Label Protected SqlStmt As String "SELECT * FROM tblEvents" Sub Page Loa... |
|
| Dataset and MS Access (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| There are several issues that I need help on. According to the examples I've seen in books, MSDN, and news groups, this should be a very simple exercise. I have found often that simple exercises fail to point out a DUH! factor which makes me say DOH! 1) When I run the Data Adapter wizard, it creates the INSERT and SELECT command objects. However, it gives me an error on the generation of the UPDAT... |
|
| dataset refresh (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| I've just coded my first data grid related piece of code. I am populating a datagrid via a dataset. What I want to know is because datasets deal with disconnected data, is there a quick way to refresh your data (like a Refresh method for example). Or do you have to go through exactly the same method that you used to populate in the first place again? Thanks, Mike using System; using System.Drawing... |
|
| dataset to database not updating (VIP replies) |
| microsoft.public.dotnet.framework.adonet |
| http://support.microsoft.com/default.aspx?scid kb;EN US;815660 on this online tutorial i have thi line that i do not understand... To update the original database with all of these changes, pass the DataSet into the Update method of the DataAdapter object. However, before you can call Update, you must set the InsertCommand, UpdateCommand, and DeleteCommand properties of the DataAdapter object. You... |
|
| DataSet Update Error (VIP replies) |
| microsoft.public.dotnet.languages.vb |
| I have a very simple form that I am using to take in the information and save it to the MS Access Database using dataset. My DataAdapter is called dadConstituent and dataset is called dstConstituent I am getting a "Record Not Added 0 Microsoft Jet Database Engine Syntax Error in INSERT INTO statement 0".. Please look at the Msgbox to see the format of the error that I am printing out. I am sure th... |
|
| dataSet.HasChanges and TextChanged event (VIP replies) |
| microsoft.public.dotnet.framework.windowsforms.databinding |
| Hi all I have been trying to find out what the problem is with the dataSet.HasChanges property. It only seems to be updating the second time I change something. I have done some tests and have seen that, if you call the EndCurrentEdit for the data binding and then call the HasChanges, it will return false because I am calling the HasChanges from within the TextChanged event of the TextBox, and the... |
|
| DataTable Copy? (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| I have a datatable as a source and I need to produce a datatable which is all the rows in the original datatable except the first row, copied n times. So, if I had a datatable of: A B C 1 21 12 32 2 1 43 12 3 32 12 35 I need to output: A B C 1 1 43 12 2 32 12 35 3 1 43 12 4 32 12 35 5 1 43 12 6 32 12 35 can anyone supply sample code? thanks! |
|
| datatable relations with column expression bug (VIP replies) |
| microsoft.public.dotnet.languages.csharp |
| I have 2 tables that have a relation between them. The parent table also has an expression in a column that sums the values in the child table. Both tables are hooked up to datagrids. Everything seems to work fine as far as adding and changing rows in the child table. But if I delete a row in the child table that has a value in it, the parent table continues to have a total that includes the delet... |
|
