Hi, VB 2005 Prof, SQL server 2005, Windows application - I am using transaction scope and within this scope I am passing multiple SQL statements to the command.text On executing, all is well. But noticed that in case there is SQL server time out, then the transaction doesn't fail. S...more >>

I am attempting to data bind to a custom collection class (ReportDataRowCollection) which contains a list of custom objects (ReportDataRow) which in turn exposes a list of custom objects (ReportDataField) via an indexed property which takes a string parameter to identify the ReportDataField inst...more >>

When I double click the form icon in the solution Explorer It Opens the form with an * in its name tab (and indicates that the form has been changed since last save action) HUH ?!?!? I hadnt had even a chance to change somthing Any1 knows what is wrong and how to solve it?!?! ...more >>

I have installed a hanlder for this event: this.BindingContext[dataSetCurriculumsCourses, "TableInstitutes"].CurrentChanged ..... void FormCurriculumsCoursesInstitutes_CurrentItemChanged(object sender, EventArgs e) { this.Text += "1"; } at runtime just "11" will appeare in t...more >>

..Net v1.1 I've seen several posts on this subject but can't find a solid answer. I have a form with data bound controls. When the user chooses a menu command I would like to call dataadapter.Update( dataset ) and send the form data to the database IF NECESSARY. So I tried calling dataset....more >>

I've got a comboBox bound to an object in my code. Is there an event I can hook when the object is updated? I can break on the "set mydata = value;" but I'm not clever enough to know what event triggered that call. On my form I have a comboBox and an numericUpDown (spinbox) display. ...more >>

Hi All, Not sure if this is the right forum to post this! VB 2005 Prof, SQL server 2005, Windows application Scenario: In a winform application, using SQL server authentication method (not windows authentication), we have a text/binary file containing multiple SQL statements (insert,updat...more >>

Hello everyone, as a beginner I've encountered a problem while trying to change a value inside the DataSet. After I call dataSet.Tables["tbl"].Rows[0].ItemArray.SetValue("something", colIdx); the value in the row 0 and column colIdx of the DataTable "tbl" doesn't get changed. The thing...more >>

I'd like to bind a combo box control to an object. i.e. bind an index number for an array of display strings to my data object. I've got something that works as far as I've tested it, but it has to be an overly convoluted method. I'd really appreciate a more streamlined method to implemen...more >>

I'm trying to bind my winform controls to a BindingSource instead of a DataView and I'm setting the DataView as the BindingSource's DataSource property. My main reason for binding to the Bindingsource instead of the DataView directly is to take advantage of the RaiseListChangedEvents boolean...more >>

Hello! I have 2 tables Products (ProductID,ProductName, Del) and Sale(id, productID, qty, price) Del setted to 1 if user deletes this product. I have DataGridView and a BindingNavigator which binds to this table. How can I control the Delete Method of the productsBindingSource everytime when...more >>

I'm so lost. This has to be the 20th attempt at writing this posting. * I have a form with various controls. * I have an object with associated properties (accessible with get/set type of interface). * I'd like to have the controls manipulate the properties of the object...more >>

Hi, I tried to databind my object to the TextBox control: =20 textBox1.DataBindings.Add( new Binding("Text", new Test(), "Text")); =20 The exception message was: {"Cannot bind to the property or column Text = on the DataSource.\r\nParameter name: dataMember"} =20 My datasour...more >>

Hi All, Ref: VB 2005 Prof, SQL Server 2005 We have a bound datagridview which has a column (say colidx = 1) whose datatype is decimal. The db allows null values for this column. If a user enters a value in this cell and tries to cancel his input by using the backspace key ( meaning the ...more >>

I have a column named "ID" and its type is "uniqueidentifier" in SQL Server 2005 Express. this column is the primary key and its default value is "newid()" in SQL Server. I have generated a DataSet in C# that has this column but its default value is DBNull what can I do to make the default...more >>

I have a DataSet, let's say with two tables: one for jobs, one for employees. I want to do something like this: BindingSource bs = new BindingSource(); bs.DataSource = ds; nav.BindingSource = bs; However, when I try to do that, I get 1 of 1 records when there are around 300 records in th...more >>

I have a class that inherits from BindingList<T>. It raises the ListChanged event. When an object is removed from the list, how do I figure out which object was removed? ListChanged e.NewIndex points to the object that is now in the position where the removed one was. But I want to do so...more >>

Hey Guys&Gals my combo box is never empty it always have the text from the first member of the table... Plz help my code: this.cbo.DataSource = SearchData.Tables["Name"]; this.cbo.ValueMember = "ID"; this.cbo.DisplayMember = "Name"; this.cbo.SelectedIndex = -1; this.cb...more >>

I have a dataset (dsIntake) in the designer with a master/detail relation. The relation is marked with Relation Only and Nested Relation In the designer code it is: this.relationIntakes_vwIntakeRelatedCases = new System.Data.DataRelation("Intakes_vwIntakeRelatedCases", new System.Data.Data...more >>

Hello, I have simple databinding of textbox to bindingsource(bound to dataset), created in form constructor: public Form3(string xyz) { InitializeComponent(); Program.bindingSource.AddNew(); textBox1.DataBindings.Add("Text", Program.bindingSourc...more >>

Is it possible to add a Dataset using a control in Visual Studio 2005? I need to add a Dataset control, or some other object that will show up in the GUI as a "Data Source" for data-binding. The reason I need a DataSet is for its multiple-table capabilities - one of the custom controls I am using ...more >>

I am wondering if there is a better solution, than the one I came up with... I am binding a textbox to a nullable float (float?) and want the ability for the user to leave the textbox blank, indicating that it is null. If you do not alter the behavior of the textbox, the user, when attempting...more >>

I have a combobox (DropDownList style) that I filled with objects that have two properites Display and Value. The combobox is bound to a binding source this.cbxStaff.DataBindings.Add("SelectedValue", this.intakesBindingSource, "StaffID"); In the form load I have ComboBox_Load<int>(cbxS...more >>

I have one BindSource, one table adapter and one GridView. Everthing is working fine, my doubt is: How to read the values of the current row, for example, the row that is selected on a gridview or on a bindingnavigator? tanks ...more >>

I have a databound datagridview (VS2K5) with hundreds of rows. I'm trying to allow users to search for a given row and once selected the fields at the top of the form will populate with the rows records. This works fine when you click the gridview rows manually and I can easily programmati...more >>

What I want to do is pull a list of name/value pairs from a database and populate the display and value members of a DataGridViewComboBoxColumn with it. However, I also want to bind the DataGridView as a whole to another query from the database, which would set the selected item for the combo bo...more >>

i want to edit my previous post to give u clear clue about my problem. i am having datagridview in my windows form(vb.net 2.0),i am inserting the data(records)in the cells of the datagridview. After finishing the insertion of data into the rows of datagridview ,i finally want to save the all row...more >>

i am using datagridview in my project and try to retrieve the value of the selected row on cell leave.but it gives me null value of the cell of the selected row even though i have value in my cell.i could not find out the solution. please suggest me and suggest where my code is going wrong. ...more >>

Hi there, again a newbie question but again, I uses PowerBuilder from Sybase and with this tool we could handle a RetrieveRow event which was triggerd for each Row loaded from the Database... Can U somehow do this with ADO and C#... So i can Display a Statubar with information like "Loading...more >>

Hi, VB.NET 2.0, Visual Studio 2005, Form Data Bindings I'm using a Typed dataset with several tables on my form, and also using a BindingSource Object to bind the controls on the form to it. The Typed dataset is used as a datasource and a table from the Typed DS is used as a DataMember. ...more >>

I need to mix automatic (ErrorProvider.DataSource) and custom = (Control.Validating) error notification on my form. Unfortunately it doesn't look like they work together properly. In the minimal example below, I want to be notified if either txtString = is empty (custom error) or txtInteger does...more >>

Hi, In VB 2005, using SQL server 2005 I have a typed dataset. One of the tableadpaters, I have created a datacolumn with datatype as string and set the expression as follows: iif(Typeid = 1, [datecolumnx],[int columny]) .... Typeid -- is the field who value is being evaluated and true part...more >>

I have created a class DelimitedList<T> which inherits from BindingList<T>. I also have a custom business object that has a property defined as type DelimitedList<int>. I then created a UserControl that has a property of this same type. I added the following attribute to this property. [B...more >>

Hey Guys Alot of articles and alot of stuff still no answer. Please help me on this one. I need to get data out of a filterred selected row !!! ... this is how my code looks like.... On load: dv = SearchData.DefaultView; if (SearchData.Rows.Count >= 1) { grd.DataSource = dv; ...more >>

Hi everybody, can I somehow ( Function call or else ) set the RowState of the Row to an desired / spezific State ?? I know that .AcceptChanges() and .EndEdit() controls the State but i want to change a specific Row to an specific State..... ( e.g Insert at Runtime and than set the State to ...more >>

C#/VS2005/.NET 2.0 I have a ListBox that is using an Object as its DataSource. The Object has a method - List - that returns a List<xxx> Collection. The Object also has a method - Add - which does a List.Add(xxx) on the List. My problem is that when I add something using Object.Add(), I do n...more >>

Hi, I have a problem with datagridview which is binded to a datatable. When a datarow is added to the datatable by another thread. Datagridview doesn't show the new datarow until I call datagridview.refresh() or sort the data by clicking the column header. I guess it may be due ...more >>

Hi, unfortunately there is no DateTimePicker control available to add to a tool strip (not in the add element drop down list). Is it possible to add such a control another way? How to do that? Thanks for any help! Regards, Harald ...more >>

I find this control to be awfully slow. I throw it on a form, and then set DataSource to a data table (my test table has maybe 500 rows and 10 columns), then set Anchor to all four places. At runtime, painting is very sluggish. Resizing the form is slow. Are there some properties I can set t...more >>

Hi All, In VB 2005, typed dataset, Bound Datagridview, winforms Is it possible to add a row to a databound datagridview to show the sum of the cells for that particular column? Meaning - there are 15 columns and say 10 rows We need to have a 11th row which would show the sum of the cells f...more >>

Hi To All, I've a typed dataset and datagridview. I add a new row typed dataset but datagridview not refresh. I've unchecked datagridview "enable adding" "enable editing" on the grid when i design mode. my code is here... KeyGeneratorDataSet ds = new KeyGeneratorDataSet(); ...more >>

I have the "classic" data binding scenario. DataTable -> DataView -> DataGrid. Essentially I need to be able to iterate over the rows as displayed within the DataGrid, and to link back to the corresponding row swithin the DataTable data source. How do I link from DataGrid displayed rowm to...more >>

Dear reader, Situation I have created a Master-Detail solution which works very good (thanks to the help of this newsgroup). In the Detail section I have textboxes wherein the user can change data; this data has to be saved to the database using the update method. Problem When I debug ...more >>

Dear Reader, Situation: - customers table (bugs in code example) - order table (solutions in code example) Problem I'd like to bind the customers table with simple text boxes and navigate through them with buttons; I already build this and it works! I'd also like to bind the orders tabl...more >>

I have a form containing a MaskedTextBox and a DataGridView controls bound to two business objects. The DataGridView is bound to a read-only list of drawing categories to allow the user to see what has been previously entered. The MaskedTextBox is used to enter a new drawing category code an...more >>