|
|
You're in the
vb.net controls
group:DataGrid bound to numeric values (SQL Server 2005)
vb.net controls:
values, some of them are percentages. The format is set to p on these dataGrid values. Thought I would capture the cellParsing event and change the value, but it doesn't stick! Private Sub DataGrid_CellParsing(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellParsingEventArgs) Handles DataGrid.CellParsing If e.ColumnIndex = 8 Then If String.IsNullOrEmpty(e.Value.ToString) Then e.Value = DBNull.Value e.ParsingApplied = True Else e.Value = e.Value / 100 e.ParsingApplied = True End If End If End Sub The following works, but would rather have a solution at the Form/DataGrid level. Months from now, when someone is having issues with this app, they should not have to look at the dataSet level to see whats happening: Partial Class ProcureDataSet Partial Class DistPricingDataTable Private Sub DistPricingDataTable_ColumnChanging(ByVal sender As System.Object, ByVal e As System.Data.DataColumnChangeEventArgs) Handles Me.ColumnChanging If (e.Column.ColumnName = Me.Fee_PercentColumn.ColumnName) Then 'Add user code here If IsDBNull(e.ProposedValue.ToString) Or e.ProposedValue.ToString = "" Then Return Else e.ProposedValue = e.ProposedValue / 100 End If End If End Sub End Class Have spent several hours trying to post this query on MSDN in Visual Studio 2005, but they say my internet connection is down, so I will post it here instead. HELP
Here are some givens jimBob:
1. The quickest response to your issue will occur when you post in the wrong usenet. 2. You will never get a response to a really technical question. Microsoft wants you to call them for technical Support. 3. Even though you have paid top dollar for a MSDN subscription this year, you will not receive any special support, and probably not even an upgrade to the product; Visual Studio 2005. Exactly what am I getting for my top dollar subscription? Posting questions in that thing they call 'Community, Ask a Question' is a joke, right? The navigation through this forum is insane. Do people at Microsoft actually get paid to come up with this? 4. I would love to be able to call Microsoft when I am having issues like: a) Change the values in a tabControl page without having to select the tabControl and letting the user not see all this tabControl page flopping. b) Allowing a user to remove the values in a dataGrid that are bound to a numeric value; you know Numeric 9.4 kinda stuff. Try deleting this value and see the hoops you have to go through to get this update to work correctly. I am not dealing with money or float here! Don't get me wrong, I thing Visual Studio 2005 is a great product; it just needs to be better! I base these development systems on the tools I used to use, like any Borland product. [quoted text, click to view] "jim" <jimBob@msn.com> wrote in message news:Y8mdnU9IuLCUVMXbnZ2dnUVZ_g-dnZ2d@giganews.com... > Not sure why this is so difficult. Bound dataGrid is bound to numeric > values, some of them are percentages. The format is set to p on these > dataGrid values. > > Thought I would capture the cellParsing event and change the value, but it > doesn't stick! > > Private Sub DataGrid_CellParsing(ByVal sender As System.Object, ByVal e As > System.Windows.Forms.DataGridViewCellParsingEventArgs) Handles > DataGrid.CellParsing > > If e.ColumnIndex = 8 Then > If String.IsNullOrEmpty(e.Value.ToString) Then > e.Value = DBNull.Value > e.ParsingApplied = True > Else > e.Value = e.Value / 100 > e.ParsingApplied = True > End If > End If > > End Sub > > The following works, but would rather have a solution at the Form/DataGrid > level. Months from now, when someone is having issues with this app, they > should not have to look at the dataSet level to see whats happening: > > Partial Class ProcureDataSet > Partial Class DistPricingDataTable > > Private Sub DistPricingDataTable_ColumnChanging(ByVal sender As > System.Object, ByVal e As System.Data.DataColumnChangeEventArgs) Handles > Me.ColumnChanging > > If (e.Column.ColumnName = Me.Fee_PercentColumn.ColumnName) Then > 'Add user code here > If IsDBNull(e.ProposedValue.ToString) Or e.ProposedValue.ToString = > "" Then > Return > Else > e.ProposedValue = e.ProposedValue / 100 > End If > End If > > End Sub > > End Class > > Have spent several hours trying to post this query on MSDN in Visual > Studio 2005, but they say my internet connection is down, so I will post > it here instead. > > HELP > >
I agree. I have tons of issues, and no support. If VS2005 controls worked
as intended, it would not be an issue. Seems I am continually searching for a work-a-round. Add a new control, and spend the entire day trying to figure out how to get it to work! [quoted text, click to view] "tim" <tj@tjinternet.com> wrote in message news:R9adnYV3uMWsTv3bnZ2dnUVZ_r2onZ2d@giganews.com... > Here are some givens jimBob: > > 1. The quickest response to your issue will occur when you post in the > wrong usenet. > > 2. You will never get a response to a really technical question. > Microsoft wants you to call them for technical Support. > > 3. Even though you have paid top dollar for a MSDN subscription this year, > you will not receive any special support, and probably not even an upgrade > to the product; Visual Studio 2005. Exactly what am I getting for my top > dollar subscription? Posting questions in that thing they call > 'Community, Ask a Question' is a joke, right? The navigation through this > forum is insane. Do people at Microsoft actually get paid to come up with > this? > > 4. I would love to be able to call Microsoft when I am having issues like: > a) Change the values in a tabControl page without having to select the > tabControl and letting the user not see all this tabControl page flopping. > b) Allowing a user to remove the values in a dataGrid that are bound to a > numeric value; you know Numeric 9.4 kinda stuff. Try deleting this value > and see the hoops you have to go through to get this update to work > correctly. I am not dealing with money or float here! > > Don't get me wrong, I thing Visual Studio 2005 is a great product; it just > needs to be better! I base these development systems on the tools I used > to use, like any Borland product. > > > > > "jim" <jimBob@msn.com> wrote in message > news:Y8mdnU9IuLCUVMXbnZ2dnUVZ_g-dnZ2d@giganews.com... >> Not sure why this is so difficult. Bound dataGrid is bound to numeric >> values, some of them are percentages. The format is set to p on these >> dataGrid values. >> >> Thought I would capture the cellParsing event and change the value, but >> it doesn't stick! >> >> Private Sub DataGrid_CellParsing(ByVal sender As System.Object, ByVal e >> As System.Windows.Forms.DataGridViewCellParsingEventArgs) Handles >> DataGrid.CellParsing >> >> If e.ColumnIndex = 8 Then >> If String.IsNullOrEmpty(e.Value.ToString) Then >> e.Value = DBNull.Value >> e.ParsingApplied = True >> Else >> e.Value = e.Value / 100 >> e.ParsingApplied = True >> End If >> End If >> >> End Sub >> >> The following works, but would rather have a solution at the >> Form/DataGrid level. Months from now, when someone is having issues with >> this app, they should not have to look at the dataSet level to see whats >> happening: >> >> Partial Class ProcureDataSet >> Partial Class DistPricingDataTable >> >> Private Sub DistPricingDataTable_ColumnChanging(ByVal sender As >> System.Object, ByVal e As System.Data.DataColumnChangeEventArgs) Handles >> Me.ColumnChanging >> >> If (e.Column.ColumnName = Me.Fee_PercentColumn.ColumnName) Then >> 'Add user code here >> If IsDBNull(e.ProposedValue.ToString) Or e.ProposedValue.ToString >> = "" Then >> Return >> Else >> e.ProposedValue = e.ProposedValue / 100 >> End If >> End If >> >> End Sub >> >> End Class >> >> Have spent several hours trying to post this query on MSDN in Visual >> Studio 2005, but they say my internet connection is down, so I will post >> it here instead. >> >> HELP >> >> > >
Yeah me too! In the good old days, we received a book with our product,
that included everything this product ever did. Stuff was indexed, and now, you have to search through an on-line help that usually doesn't even come close to what your looking for. Whats wrong with a book? [quoted text, click to view] "jim" <jimBob@msn.com> wrote in message news:Y8mdnU9IuLCUVMXbnZ2dnUVZ_g-dnZ2d@giganews.com... > Not sure why this is so difficult. Bound dataGrid is bound to numeric > values, some of them are percentages. The format is set to p on these > dataGrid values. > > Thought I would capture the cellParsing event and change the value, but it > doesn't stick! > > Private Sub DataGrid_CellParsing(ByVal sender As System.Object, ByVal e As > System.Windows.Forms.DataGridViewCellParsingEventArgs) Handles > DataGrid.CellParsing > > If e.ColumnIndex = 8 Then > If String.IsNullOrEmpty(e.Value.ToString) Then > e.Value = DBNull.Value > e.ParsingApplied = True > Else > e.Value = e.Value / 100 > e.ParsingApplied = True > End If > End If > > End Sub > > The following works, but would rather have a solution at the Form/DataGrid > level. Months from now, when someone is having issues with this app, they > should not have to look at the dataSet level to see whats happening: > > Partial Class ProcureDataSet > Partial Class DistPricingDataTable > > Private Sub DistPricingDataTable_ColumnChanging(ByVal sender As > System.Object, ByVal e As System.Data.DataColumnChangeEventArgs) Handles > Me.ColumnChanging > > If (e.Column.ColumnName = Me.Fee_PercentColumn.ColumnName) Then > 'Add user code here > If IsDBNull(e.ProposedValue.ToString) Or e.ProposedValue.ToString = > "" Then > Return > Else > e.ProposedValue = e.ProposedValue / 100 > End If > End If > > End Sub > > End Class > > Have spent several hours trying to post this query on MSDN in Visual > Studio 2005, but they say my internet connection is down, so I will post > it here instead. > > HELP > >
Don't see what you're looking for? Try a search.
|
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |