Search results for query: *

Trying to build a dynamic "Group" table. Have the following Tables: Collateral (Table) CollID CollName Account (Table) AcctID AcctName CollateralAccount (Table) CollID AcctID Need to generate a 4th table: Group (Table) GroupID AcctID What I need to do is setup "Groups"...

My apologies if the title does not make sense, but I'm having a difficult time even trying to summarize my question. Here it is in a nutshell: I have the following table: Item pos 8529 2 8529 2 161637 2 161637 3 357346 1 357346 2 357346 2 367390 1 367390 1 393538 3 393538 3 393538 3 393538 2...

I have the following data: Region Balance NewYork 300 NewYork 400 NewYork 500 NewYork 600 NewYork 700 NewYork 800 NewYork 900 Boston 100 Boston 200 Boston 300 Boston 400 Boston 500 Boston...

I have many update fields in my application to update SQL Server data type money. I am currently using the following compare validation on each field: <asp:CompareValidator ID="vUWIncome" runat="server" ControlToValidate="txtUWIncome" ErrorMessage="CompareValidator" Operator="DataTypeCheck"...

I'm getting the following error: Arithmetic overflow error converting expression to data type datetime. Here is the UPDATE Query: Declare @record_number int, @parri_passu_debt money Set @record_number = 4792 Set @parri_passu_debt = 10 UPDATE balance SET parri_passu_debt =...

I have the following table: CustID StmtID StmtDate StmtYr Method (Rank) 29874 9 12/31/04 2004 Tax Return (6) 29874 7 12/31/03 2003 Co.Prep'd (5) 29874 8 12/31/03 2003 Tax Return (6) 29874 5 12/31/02 2002 Tax Return (6) 29874 4 12/31/01 2001 Tax Return (6) ** Note: the (Rank) is not in the...

I have query results from a table, based on ID = '27489': ID Stmt Date Stmt Yr Method 27489 2003-12-31 2003 Reviewed 27489 2004-12-31 2004 Reviewed 27489 2005-12-31 2005 Co.Prep'd 27489 2005-12-31 2005 Unqualified 27489 2005-12-31 2005 Reviewed My results need to be more narrow, selecting...

I have a Repeater on my MasterPage that acts like a menu, populated by a SiteMapDataSource. I am trying to capture the selected value (or node) from this control and use this value in another page (content) to generate dynamic content. Any ideas would be appreciated

I've created a .xsd file with a number of tables. I've also created a BLL class for each table, which get called by ObjectDataSource controls. On one of my pages, I've got a DetailsView Control where the DataSourceID changes based on which type of detail is being selected for display from a...

I have IIS installed on my local PC and I use this for development. I have: 1. VS 2005 2. SQL 2000 DB 3. ASP 2.0 4. IE 6.0.2900.2180.xpsp_sp2_gdr.050301-1519CO I recently got a new PC a couple weeks ago. For some reason, I started getting strange errors with my site yesterday, and I...

I have the following GridView, with a button column: <asp:GridView ID="GridView1" runat="server" DataSourceID="ObligorSearchResultsDataSource" <Columns> <asp:ButtonField ButtonType="Button" CommandName="GetDetails" Text="Details" /> </Columns> </asp:GridView> I'm trying to...

I have the following for each of 5 rows in a Table, which is within a FormView ItemTemplate: <tr> <td style="width: 100px; color: green;"> Exceptions:</td> <td style="width: 100px" align="center"> <asp:Label ID="lblExceptions" runat="server" Text='<%# Left(Eval("result"),1)...

I've got the following Datagrid columns: <Columns> <asp:BoundColumn DataField="h_name" HeaderText="Name"></asp:BoundColumn> <asp:BoundColumn DataField="h_exposure" HeaderText="Insur Amt"></asp:BoundColumn> <asp:BoundColumn DataField="h_ind" HeaderText="Future Ind"></asp:BoundColumn>...

I've been looking at many posts in the forum and feel like I've followed the suggestions properly, but I can't get it working. I've setup a linkbutton in my grid. When the user clicks the linkbutton, I would like the value in column 2 to be picked up and used as a parameter for another grid...

I've been able to use the xp_cmdshell to get a list of file names from a given server directory, using the following: CREATE TABLE #Files (MyFile varchar(200)) DECLARE @Path varchar(400) SET @Path = 'D:\Basel\Inquiry\' EXECUTE sp_ListFiles @Path,'#Files','%.dbf',NULL,0 SELECT * FROM #Files...

I've setup my application where I have a separate System.Data.SqlClient.SqlDataAdapter for each SQL Server Stored Procedure, all filling datasets at various points throughout the application. At the moment, I have 29 Adapters and one SQLConnection, all in Global.asax. In the Global.asax.vb, I...

I've created a custom Login.aspx page which will check ID and password in a SQL database. I've been trying to setup my application to do the following: If a user goes directly to another page, other than login.aspx, it will automatically direct the user back to login.aspx to properly login...

Currently, we have an excel template that gathers input on customer credit lines and various pieces of collateral they pledge towards these credit lines. The template then displays this information in a grid/matrix type display, in the following manner...

I've managed to get this far building a restore SP using great tips from this forum: CREATE PROCEDURE [dbo].[DBS_restore_Basel_database] AS /*restore database */ declare @file nvarchar(4000) select @file = 'D:\MSSQL\BACKUP\Basel\Basel_db_' + CONVERT(varchar(30),getdate() - 1,112) + '2030' +...

I've gotten this to work for one DataGrid DropDownList, but can't figure out how to get it working when there are two DataGrid DropDownLists in an edit row. Here is my code, which I got from a post linking to MSDN: Private Sub FacilityGrid_ItemDataBound(ByVal sender As Object, ByVal e As...