Search results for query: *

Hi We have BT2002 with Bt sql server adapters, that uses a database on a other server. But it happens every week that we got RFSQL error and we have to restart the adapters. And then they start working again. The adapters seem to work and is started, but they got RFSQL error. Is there any...

I found a nice lib that you can download on http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E434024B-62C8-48F6-BE8A-F20EF90BB586

I found the solution of my problem. I was missing a Receive Handler under my SQL adapter, so I added a new one with a connection to the new host

Hi -- I've a problem in Bts2004. I've added a new host with the administration tools, but when I try too connect it with my receive locations I can't find the new host in the dropdownlist over available hosts.

Here is a walk-through example from MSDN how to add a CheckBox to a DataGrid with the designer. http://support.microsoft.com/default.aspx?scid=kb;en-us;306227

You can also do it in the designer, I always working in the designer when I work with ASN.NET, then you can drag different tools from the toolbox into the different items in the designer...

But you can use the same if you create a new BindingContext() for each ListBox Here it's done with ComboBoxes but I think it is the same for ListBoxex. Some of the ComboBoxes uses the same table in DataHolder (that is a DataSet UserControl) private void loadCombobox(ComboBox cb, string...

When you working with DataSet and DataAdapters, you have to set Delete, Insert, Select and Update commands in the DataAdapter for every table you want to update. Example: I'm working with several tables and I make a DataAdapter for each Table. I hope you understand the code it is just copied...

You can also do it with MouseUp Event on DataGrid Globals.ReporterUpdate.getUsers(); this.dgUsers.TableStyles.Clear(); this.dgUsers.TableStyles.Add(createStyles()); DataTable dtUsers = Globals.DataHolder.Tables[DataHolder.TableNameUsers]; dtUsers.Columns["ReporterUpdate"].DefaultValue = 0...

try with refresh in solution view

I'm using DataAdapter, when I working along with a DataGrid. When I init the program I set up one DataAdapter to each Table used by the DataGrid, with select, insert and update commands. Then when the user edit the Grid, I have a button for update of the edited rows, I also have a button to...

I'm sorry Keypreview = True

If you are working with Windows, you've to set Keypress = True in Form properties

You can't see the problem, if you not debug the code with. But DataHolder also has a other function. That is to switch between production and test tables. I you only work in production is no problem, but if you work with test, the constructor of DataHolder going to switch to production tables...

Here is an example from Msdn on HasChanges and GetChanges if(ds.HasChanges(DataRowState.Modified | DataRowState.Added)& ds.HasErrors){ // Use GetChanges to extract subset. xSet = ds.GetChanges(DataRowState.Modified|DataRowState.Added); PrintValues(xSet, "Subset values")...

I have a DataSet called DataHolder, that holdes several tables. The DataHolder class is a UserControl, that also holds the connection to the database. When the Dataholder starts it fills in different SqlDataAdapters with commands used for selects, deletes and updates of different tables. Here is...

Hi again --------- Here is the solution DataGridTableStyle dgtStyle = dataGrid.TableStyles[0]; foreach(DataGridColumnStyle gcs in dgtStyle.GridColumnStyles) { colIndex++; excel.Cells[rowIndex,colIndex]=gcs.HeaderText; } DataView dataView = (DataView)...

And you can set the PreferedColumnWidth on the tablestyle

Here are an example which I have to make columns from a dataset to Excel. int colIndex = 0; foreach(DataColumn col in dataSet.Tables["Result"].Columns) { colIndex++; excel.Cells[1,colIndex]=col.ColumnName; }

Gracias