I have 1 fact with 2 dimensions which look like this :
View Complete Post
How do you know which technique is best for retrieving data and populating a DataSet in ADO.NET?. Since the Microsoft .NET Framework offers so many choices on how to write the code, many developers are now taking a close look at the different options. See what they are.
MSDN Magazine June 2003
Am using a dataset to get different data from a table depending on options selected. Sometimes this means the database returns no matching rows. However with this particular case it seems if there are no rows to put into the dataset I get an "Arithmetic overflow error converting nvarchar to data type numeric." error.
Code looks like this :
Dim saleSelect As String = "SELECT * FROM [sales] WHERE ([affected] LIKE '%' + @affected + '%') AND ([minVal] < @price) AND ([active] = @active)" Dim saleCmd As SqlDataAdapter = New SqlDataAdapter(saleSelect, sqlConn) saleCmd.SelectCommand.Parameters.AddWithValue("@affected", "," & id & ":") saleCmd.SelectCommand.Parameters.AddWithValue("@price", price) saleCmd.SelectCommand.Parameters.AddWithValue("@active", "True") Dim saleDs As DataSet = New DataSet() saleCmd.Fill(saleDs, "saleTbl") 'Error occurs here
The error occurs when SqlDataAdapter attemps to fill the Dataset.
All fields in the table are nvarchar except ofr [id] which is 'int' and [active] which is 'bit'
This may be a little hard to explain without pictures but I need have a number of expanders stacked on top of each other in a small window. All of the expanders have varying lengths depending on their content. The last expander must fill up as much of the
window as it needs to show its content but no more than hat it needs. The other expanders above it have MaxHeights set. Each expander has its own scrollviewer around it so if it can't show its total content you can scroll through it. I also want each of the
expanders to shrink in unison the way multiple grid rows with Height="*" shrink and expand in unison.
I initially thought I could do this with a dock panel with the last child filling the remaining space.
I am trying to paint a quantity column in data grid with color red, however when I do so cell alignment changes to left.
Seems like I have to convert e.value to string in order for this to work and when I do that the cell alignment changes.
Quantity column is of type decimal.
Also I would appreciate if you can guide on how i can fill the certain columns in data grid with certain color(for ex. yellow).
if (this.dtaGridView.Columns.Index ==e.ColumnIndex && e.RowIndex >=
If you anything, please let me know
WinForms Application. C#, .NET 3.5.
I have a function with searchs data into a non RDBMS Source, collects data and Inserts each found records into DataSet and finally it returns DataSet to main module. The main module binds returned Dataset to WinForms Grid Control. When user
click on any row, it should display details of selected row.
The search takes quite long time and hence i want to use threading such that as the function find the data it returns the data to main module and main module adds the data into a DataSet object which will be already binded to Grid Control. The Grid control
should automatically refresh itself as he finds new data in its underlying databset. While search is going on the Grid control should remain responseive so that when user clicks on any row, I can call anothr function to retrieve details of the selected
I tried using BackgroundWorker still the UI freezes. I observe the grid control does not refresh itself and is non-responsive.
Please guide on how to achieve this and I would really like if there is any sample on similar lines with GridControl.
On a single page, I'd like to fill 2 hyperlink controls as well as a datalist control with table data using one call to the database. The page looks like this:
Please select the district you wish to view below.</p>
<asp:DropDownList ID="ddlDistrict" runat="server" CssClass="textbox"
DataTextField="DistrictName" DataValueField="DistrictId" AutoPostBack="True"
<p><asp:label ID="lblDistrictAbbrev" runat="server" Text="District Abbreviation: " />
<asp:hyperlink ID="hyperlinkDistrictName" runat="server"
<p><asp:label ID="lblDistrictCouncillor" runat="server" Text="District Councillor: " />
<asp:hyperlink ID="hyperlinkCouncillor" runat="server"
I'm reporting monthly sales data from a cube that has some missing months. There are several SQL solutions for joining & unioning such that you can produce a default zero in the data set.
Is there a way to do this with MDX?
I have an InfoPath form hosted in SharePoint that has some peculiar behavior. This form was previously hosted in forms services on SharePoint 2007, and worked for several years without problems, but we recently upgraded to 2010, and now I have this issue.
The form is used to request that a design project be initiated, and is fairly large - about 100k empty.
There are two different fields in the form that seemingly at random get blanked out as the form is being completed. One is a check box, which determines if a certain workflow step will be performed (create a customer quote), and the other is a rich text
field used to enter additional project information. There are no rules that point at the check box to set it's value, but it does have some rules tied to it to set another field if it is selected. And the rich text box has a rule to concatinate a file
number to the existing text if a certain button is pushed. That is all. There are no rules in place to clear these fields. In each instance there was additional activity occuring before the form was submitted (other fields were being selected, documents were
being attached, dates being entered, etc.).
I managed to duplicate the clearing of the rich text box in troubleshooting, but have not actually seen the check box get cleared. I repeated my steps to get the rich text box to clear, and the second tim
i would like to fill the textbox autocomplete stringcollection "on the fly" while typing. i don't want to fill the collection while initializing, 'cause it's too much data: the sql server-table has about 100.000+ rows. the filling takes too much time and the "autocomplete-popup-find-something-box" itself is getting too slow, too.
my configuration:.NET-Framework: 2.0.50727, System.Windows.Forms.TextBox
TextBox-Properties: AutoCompleteSource: CustomSource; AutoCompleteMode: Suggest
i tried several different things...1. i did put this code in the "TextChanged"-event, but i think it's 'too late' there: