DbDataReader.NextResult With Generic Lists ?

Jun 20, 2006

 Hey I'm using this DAL to populate a generic list called assetDetailList
However I'm adding a 2nd result set to my stored proc,

protected void GenerateAssetDetails<T>(DbDataReader dataReader, ref List<AssetDetails> assetDetailList)
        {
            while (dataReader.Read())
            {

                    // Create a new culture
                    AssetDetails assetDetail = new AssetDetails();
                    // Set the culture properties
                  
                    assetDetail.FileName = dataReader.GetString(dataReader.GetOrdinal("filename"));
                    assetDetail.Title = dataReader.GetString(dataReader.GetOrdinal("title"));
                    assetDetail.AltTag = dataReader.GetString(dataReader.GetOrdinal("alt_tag"));
                    assetDetailList.Add(assetDetail);

                    dataReader.NextResult();
// this is the 2nd result set

               AssetContent assetContent = new AssetContent();
               assetContent.content_id = dataReader.GetInt32(dataReader.GetOrdinal("content_id"));
             how do I creatre another  list .Add(assetContent);

            }
            // Close and dispose of the reader
            dataReader.Close();
            dataReader.Dispose();
        }

        #endregion
    }

View 2 Replies


ADVERTISEMENT

RAM - Generic ? W/ SQL Server

Nov 14, 2000

In general (I know.. lots of factors) but in general will adding more RAM to a SQL box help the performance? I'm working w/ 256MB right now, and deciding whether to add 256MB or 512MB? Any advice

Thanks and sorry so generic but this is a vendored app and they know of design issues but for now that can't be changed.

View 1 Replies View Related

Generic Date

May 26, 2006

Hi guys

I have a simple problem:

I want to be able to query with a start date(@start) and then calculate 1 year from there. I figured since the date is of type integer just add 364 and it will give me the day before 1 year.
So if its 1998-05-01, Id get 1999-04-31.


Code:


DECLARE @FinStart DATETIME
DECLARE @FinEndDATETIME

SET @FinStart = '1998-05-01' --is of type int .:. +365 is adding 1 year
SET @FinEnd = @FinStart + 364

SELECT @FinStart
SELECT @FinEnd



Problem, this doesnt cater for leap years.

Any suggestions?

The help is always appreciated!

Justin

View 2 Replies View Related

A Generic Trigger

Apr 11, 2008

Here's the scenario:
whenever a change (insert/update/delete) has occured in any of the tables, it needs to be logged by adding the changed table's name, and changed columns' names (if any) into the special ChangeLog table.
So, is it possible for me to write a generic trigger that would get the name of the table it just executed upon and names of every column affected by the UPDATE and then insert those into the Log table?
If this is not possible, how do you suggest it should be done?

I'm familiar with standard SQL but T-SQL is completely new to me, so please bear with me if my question makes no sense...

Thanks!

View 1 Replies View Related

Disappear The Generic Bar.

Dec 21, 2006

Hallo all :

How to disappear the generic bar in the report, or to disappear some options (example export). I speak about the bar which in the top of the report or there are the numbers of pages.



Thank's.

View 4 Replies View Related

Dataset To Generic List. How To Do This?

Apr 28, 2007

Hello,I have a DataSet which results from accessing an SQL database.Each row is an Article and has various columns like Title, Description, etc.I have created a Generic List as follows:Dim Articles As Generic.List(Of Article)Article is a class with various properties. Each property is the same as each column in the dataset.I want to fill the Generic List with the data from my DataSet.How can I do this?Thanks,Miguel

View 1 Replies View Related

Generic Database Design

Oct 12, 2007

Hello,
Can someone please guide me to online resources or books on how to design generic database? I mean, I can have a "Record" that can have a set of fixed fields like: ID, Title, CreatedOn, etc ... and I can add as many properties I want to that record in a vertical way.
Then based on the generic tables present, I can fit in the same table, a Record for Customer, a Record for House, a Record for Order. All share the same set of Fields, but each has its own set of proeprties.
This way, I design my database once, and customize it to fit any type of applications I need.
Is there something like that or just dreaming?
thanks

View 6 Replies View Related

Generic Stored Procedure

Jun 5, 2004

I have 24 lookup tables that contain the same columns (e.g. Rec_Id (identity field), Code, Desc) and I need to build an interface for each of these tables with Create, Update, and Delete capabilities.

I would like to create three stored procedures (create, update, delete) that would perform the task for any of the lookup tables.

For example, table AGENCY has three fields (Agency_id (identity field), Agency_Code, Agency_Desc) and I need to add a new record to AGENCY. I would like to call a stored procedure that would take the parameters @tablename, @code, @desc, and then create a new record in the table specified by @tablename.

I could then use a single "create" stored procedure for all of the lookup tables when adding a new record, rather than creating a separate "create" stored proc for each of my lookup tables.

Any help would be greatly appreciated!

View 10 Replies View Related

Generic Stored Procedure

May 11, 1999

I am attempting to create a generic stored procedure in SQL Server 6.5 which returns a record count of a specific table passed in as a parameter. The stored procedure looks like this"

CREATE PROCEDURE asp_GetRecordCount
@tablename varchar(30), @recordcount integer OUTPUT
AS
/* Generic stored procedure which returns
number of records in a table.
*/
SELECT @recordcount = COUNT(*) FROM @tablename
RETURN
GO

The problem is that when I save the stored procedure, SQL Server balks at the FROM @tablename entry. Any suggestions? Thanks.

View 3 Replies View Related

Designing A Generic Database API

Nov 22, 2005

Hi,

My current project requires me to convert a mysql based software to a more generic one. I started by designing separate db class files and separated the lower level connection queries from the business logic. By doing this, I now have mssql.class, mysql.class, sqllite.class etc..

But am not sure how to handle sql functions in queries. For instance, one of my queries need the use of a date function to add minutes to a db field.

In mysql, I accomplish this using

dbfield+interval '$arg' minute between date1 and date1


But in mssql I cannot use this type of query. It seems I'll have to use date_add() function. How do I handle this situation?

My frontend scripting language is php

Thanks d'advance
Celia

View 1 Replies View Related

Generic Statistics Syntax

May 17, 2006

I have a bunch of tables for my basketball club's d/b. I want to be able to interrogate them to build a web page showing player stats. For example, I want a table showing the top 5 scorers, top 5 3-point scorers, etc. What's got me foxed is how to join it all up and then sort it into the top 5 order. The main tables in question are T_Member, T_Fixture, T_Season and T_FixtureTeam:

T_Member:
MemberNo, FirstName, LastName, (etc)

T_Fixture:
FixtureNo, SeasonNo, MatchDate, (etc)

T_Season:
SeasoNo, SeasonDescription, SeasonStartDate, SeasonEndDate, CurrentSeason

T_FixtureTeam:
FixtureNo, MemberNo, 2Points, 3Points,Fouls,FreeShotAttempts,FreeShotsHit,Assists

Where you see the same field name, that field data is common for all tables that it appears in. In other words, for example, the T_FixtureTeam 'FixtureNo' and 'MemberNo' fields are made up of 'T_Fixture.FixtureNo' and 'T_Member.MemberNo' respectively.

Ready?
The user will select a season at the top of the page (although there's a default to the current season (CurrentSeason is a Boolean field). The query needs to:
- Find all fixtures in that season
- Find all members who played in those fixtures
- Find the top 5 3-point scorers (or whatever stat I'm gathering) for those matches
- Sort the resulting data

I figure I need a JOIN on MemberNo but, as I say, the rest of it has my head spinning.

TIA

View 1 Replies View Related

A Generic Error Occurred In Gdi+

Feb 8, 2006

I'm receiving "a generic error occurred in gdi+" processing error while
running a preview of my report inside visual studio. When this report
is opened by a client, their browser will just hang (Not Responding).

Other reports don't have error. The report will not render any chart although thousands of record will be need to output.

Hope anyone can help. Thanks!

View 5 Replies View Related

Generic Store Procedure

Apr 9, 2008



I have to make a store procedure for every table like
create proc ins_all (@alltable varchar(100),@allfields nvarchar(1024),@allvalues nvarchar(1024))

as
insert into @alltable (@allfields) values (@allvalues)

this procedure generates error, Can anyone give a good idea for the required procedure

Thanks in advance

View 6 Replies View Related

Generic Collation For Unicode

Oct 16, 2007

Hi,

We want our database to be unicode complaint and i need a generic collation that should do the work irrespective of the fact what data is entered in the database. Can someone suggest me any generic collation for that.

Thanks and regards
Salil

View 3 Replies View Related

Drop Down Lists

May 27, 2004

I'm want to be able to choose(including multiple selections) names from a drop down list that are fetched from the database(from table "Employees") and add them to table "Biotechnology".

Employees(ID,FirstName,LastName)
Biotechnology(ID,EmployeeID)

**assuming that EmployeeID in "Biotechnology" is the ID from "Employees" table

Example: We add Employees.ID(23, 33) to Biotechnology.EmployeeID

would be

Biotechnology:
[ID] [EmployeeID]
01 - 23
02 - 33

View 1 Replies View Related

Mailing Lists

Jul 20, 2005

Hi AllWe are running SQL Server & Outlook with an exchange server. We arelooking for a way to import the address book & email details into adatabase table.We have managed to do this with MS Access by using the import optionexchange(). Is there a similar way this can be done in SQLServer 2000

View 2 Replies View Related

Working With Lists

Aug 16, 2007

I'm new to SQL. I don't understand yet how to add if statements and other scripting techniques. But this is what I am trying to do...

I have a list of IDs (1, 2, 3, 4, 5, 6, 7, 8). I want to query a table and then display which of those IDs are NOT in that table. It seems like it should be easy, but I don't know how to do it.

Any help would be much appreciated.

thanks

scott

View 1 Replies View Related

Generic Query Designer Disabled

Jul 18, 2007

Hi,



This is really a Visual Studio 2005 Report Designer problem but I didn't see a good place to post this question in the Visual Studion forum.



On some reports when looking at the Data tab the Generic Query Designer is disabled. Anybody know why? The report runs. Other reports have it enabled.



I am using Visual Studio 2005 sp1.



Thanks,

Darren

View 1 Replies View Related

Using Generic Function Through Script Tasks

Apr 25, 2007

Hi everyone,

I€™ve got a few Script Task in my dtsx. Up to the moment I don€™t need have generic functions but I was wondering if it is possible to use a such functions.
I attach you a sample of I say you:

Script Task1
General()

ScriptTask2
Stuff
WritingLog()

ScriptTask3
Stuff
Call General()

Thanks for your thoughts,

View 3 Replies View Related

Generic Query Designer Issue

Jan 10, 2008

Here is my situation. I have a fairly large query that I am working on in visual studio (data tab). I am at the point where the program will NOT let me type (add SQL code) anymore. I found that clicking the Generic Query Designer (turning the query builder on) button switches the format then allows me to add more code. Well, this solves the running out of room issue, BUT now it does something to my code and it will not process it. Prior to clicking the Generic Query Designer button, everything worked w/ no errors. I did not change anything, but simply pressed the Generic Query Designer button (turning the query builder on) and now it dose not work now. Just for kicks, I have pasted my working origional code into SSMS, added code and it executed just fine in SSMS. But then I pasted back into visual studio and it gave me the same errors?

Has anyone experienced this? Is there a maximum for lines of code? Why does the Generic Query Designer (having query builder on) change my code? All comments are welcome!

-Smylie

View 6 Replies View Related

T_SQL, Lists And Arrays

Dec 30, 1999

I want to pass my stored proc a list, and either loop through it as a list or (better) turn it into an array and loop through it that way to insert it. Psuedocode would be...

Loop from 0 to ListLength
begin
INSERT Transaction_Data
end

Thanks from an SQLS7 newbie,

jE

View 4 Replies View Related

SP That Lists The Servers Online

May 3, 2001

Does anyone know which SP to use to get the list of available servers?
I want to call it from a VB app via ADO to provide the user with a choice of servers available.

View 1 Replies View Related

Arrays And Lists In SQL 2005

Mar 4, 2007

I am glad to announce that there is now a version of my article "Arrays andLists in SQL Server" for SQL 2005 available on my web site.THe URL for the article ishttp://www.sommarskog.se/arrays-in-sql-2005.html. If you are curious aboutthe performance numbers they are in an appendix athttp://www.sommarskog.se/arrays-in-sql-perftest.html.The old version of the aritlce remains, as the new article covers SQL 2005only. The old version is now athttp://www.sommarskog.se/arrays-in-sql-2000.html.The old URL, http://www.sommarskog.se/arrays-in-sql.html leads to a pagethat links to both articles.And the reason that there are two articles is simply that SQL 2005 addsso many new features: nvarchar(MAX), the CLR, the xml data type, CTE thatall can be used in the realm of arrays and lists.--Erland Sommarskog, SQL Server MVP, Join Bytes!Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/pr...oads/books.mspxBooks Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodin...ions/books.mspx

View 1 Replies View Related

Variable Arg Lists To PreparedStatements

Jul 20, 2005

Is there a way to use PreparedStatements (or bind variables) with SQLstatements that have a variable number of arguments. For example, Ihave an array of IDs for employees of a certain type and I want tohave a PreparedStatement retrieve all of them in a single SQL call.SELECT FROM employees WHERE employee_type = ? employee_id in(?,?,?,...,?)It seems at least in Java that PreparedStatements can only take afixed number of arguments?PreparedStatement pstmt = con.prepareStatement("SELECT FROMemployees WHERE employee_type = ? AND employee_id = ?");pstmt.setLong(1, employeeType);pstmt.setInt(2, employeeID);Is there a way to have a PreparedStatement for a SQL "IN" clause orsimilar variable argument length clauses? I heard that Temp tables isone option where you first insert your array of IDs into a Temp tableand then use a JOIN. But that seems to defeat the purpose as itrequires multiple queries. Is there anyway to something like this:int[] employeeIDArray = getEmployees();PreparedStatement pstmt = con.prepareStatement("SELECT FROMemployees WHERE employee_type = ? AND employee_id IN (?)");pstmt.setLong(1, employeeType);pstmt.setIntArray(2, employeeIDArray); <--- How can I do this?Thanks,- Robert

View 7 Replies View Related

Getting Data From Sharepoint Lists

May 15, 2006

Hi,

I'm trying to get data from WSS lists by web services. I think there are two ways:

- using SSIS standard components (Web Service Task) and
- creating a custom source adapter.

My problem with the Web Service Task is, that the WSS method GetListItems has some non-standard parameters (see part from wsdl-file below). Thus, after selecting the method in the editor an clicking on "Ok", I get the error message "The selected Web method contains unsupported arguments". I think the problem is the missing type-attribute.

<s:element name="GetListItems">
<s:complexType>
<s:sequence>
<s:element minOccurs="0" maxOccurs="1" name="listName" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="viewName" type="s:string" />
<s:element minOccurs="0" maxOccurs="1" name="query">
<s:complexType mixed="true">
<s:sequence>
<s:any />
</s:sequence>
</s:complexType>
</s:element>
...

My question: Is there a way to extend the Task to handle such parameters?

View 1 Replies View Related

SSIS &&amp; SharePoint Lists

Apr 7, 2006

Hi,



is there any example how to extract values from a SharePoint list? I searched in Google but I only found something about that someone failed using the web service task for it... If possible I would like to get around any custom .net code (Scripts would be OK), but if I can't get around that, I have to follow that path...

Thanks,



View 5 Replies View Related

No _vti_bin Or Lists.asmx

Apr 28, 2008

I am desperate to retrieve lists from SharePoint using Reporting Services to consolidate with other data


I got stopped before I ever started. Defined a data source using the following syntax....but then I search for vti_bin or lista.asmx if find none.

http://<server>/<path>/_vti_bin/lists.asmx.

sharepoint/SQL 2005 running in intergated mode on single machine for proof of concept.

after formulating the dataset query I receive an error that
the XmlDP query is invalid.(Microsoft.ReportingServices.DataExtensions)

Any ideas how I screwed things up?

.

View 2 Replies View Related

Generic Staging Design Of Data Warehouse

Jan 6, 2006

I have a question about staging design using SSIS. Has anyone come up with an ETL design that would read table names from a generic table and dynamically create the ETL to stage the table.

1. Have a generic table which would have table name and description and whatever else that was required.

2. Have a master ETL that would enumerate through the table and stage all the table names found in the generic table.

This way I wouldn't have to create an ETL which would hardcode the names of 300-500 tables and have the appropriate 300-500 data sources and targets listed.

Not sure if I am making sense but I hope someone understands the attempt.

thanks

View 10 Replies View Related

[SQL SERVER 2000] Generic Table Exporter

Jun 28, 2007

Hello every body.
First of all sorry for my bad english but I'm french ;-)

My internship consits into making a generic table exporter (with a table list). Export into csv files.

I have tried 2 solutions :
1 - Create a DTS with a Dynamic Properties Task. The problem is I can easily change the destination file but when I change the table source I don't know how to remap the transformations between source and destination (do you see what I mean ?). Any idea ?

2 - Use the bcp command. Very simple but how to do when tables contains the separator caracter ? for example : If a table line is "toto" | "I am , very happy" --> the csv file will look like this : toto, I am , very happy --> problem to get back the data ( to much comma ).
Does someone has a solution ?

Last point is how to export the table structure ? For the moment, using the table structure, I generate an sql query which creates a table (I write this query in a file). Isn't there any "cleaner" solution ?

Thanks in advance and have a nice day all

View 3 Replies View Related

Generic Concatenator As A User-defined Function

Feb 26, 2008

Hi-

I have a number of tables that contain data that we want to concatenate as a part of our reporting processes. Instead of building a whole series of functions that each concatenate data from only one table, I want to create a function (or functions that work together) to concatenate data from ANY specified table, since the logic is identical.
The basic logic is:




Code Snippet
DECLARE @x varchar(max)
DECLARE @theReturn varchar(max)
DECLARE theValues CURSOR FOR
SELECT DISTINCT TOP 100 PERCENT <col name to concatenate>
FROM <the table in question>
WHERE <the identity column in the table> = <a specific value>
ORDER BY <col name to concatenate>
SET @x = ''
SET @theReturn = ''
OPEN theValues
FETCH NEXT FROM theValues INTO @x
WHILE @@FETCH_STATUS = 0
BEGIN
SET @theReturn = @theReturn + '; ' + @x
FETCH NEXT FROM theValues INTO @x
END
CLOSE theValues
DEALLOCATE theValues
SET @theReturn = LEFT(@theReturn, Len(@theReturn) - 2)
RETURN @theReturn



The problem I am running into is how to create the "generic" or "abstract" version of the SELECT statement in the cursor. I can certainly pass in the values surrounded by < and > as arguments, but I cannot figure out how to insert them into the SQL and make it work. I can't create a text string and then use the EXEC statement, because in a scalar function SQL Server won't allow it.

Any thoughts, work-arounds, or solutions?

Thanks-

View 5 Replies View Related

Stored Procedure Addressing Generic Table

Oct 20, 2006

I want to use ONE stored procedure to update/insert about 300 tables in a database. I hoped this code would work but it gives me an error:

ALTER PROCEDURE [dbo].[InsertRowsTick]
@tableName varchar,
@bid float,
@ask float,
@last float,
@volume int,
@dateTimed DateTime
AS
BEGIN
SET NOCOUNT ON;
INSERT INTO tableName (
bid,
ask,
last,
volume,
dateTimed)
Values (
@bid,
@ask,
@last,
@volume,
@dateTimed)
END

When I (1) commented out @tableName parameter and (2) instead of INSERT INTO tableName wrote: INSERT INTO <realtableName> the code (C#) executed and the table was filled.

How can I use a generic table name as a parameter?

Thanks.

View 9 Replies View Related

Transact SQL :: Calculating Duration In Days For Generic From And To

Oct 7, 2015

I need the SQL to calculate the duration between a day and time, no specific date. 

For example:
Sun 00:00 > Mon 08:00 = 5.67 days

So there is no date, it's just the general duration  (in days), from a specific day and time to a specific day and time.

View 3 Replies View Related

How To Connect Generic Database Field To Report?

Jul 23, 2007

Hello,



I want to make a report where multiple users can use the same report to connect to their databases and then print out the report with information from those databases. Both databases have the exact same tables and fields but the data that is in them is different. However, I have only been able to figure out how to connect the report to one specific database, and therefore the report always prints out information from that database instead of the user specified one. So let's say I want my report to print out the name that is in the database field Name for any database I connect to, how would I do this?

View 8 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved