Need Help Populating A Variable (using .Net && C#)

Mar 28, 2008

I'm trying to populate the variable "STATUS" with the BEFORE value from TABLE1 to insert into TABLE2, but not sure how to do that. Attached is a stripped down code I'm working on. Sorry, I'm new at this...

// some variable stuff
      
protected ErrorText ErrorText1;
protected System.Web.UI.WebControls.DropDownList DISP_CD;
public System.Web.UI.HtmlControls.HtmlInputText DISP_DOC;
protected System.Web.UI.HtmlControls.HtmlInputText DISP_DATE;
protected System.Web.UI.WebControls.DataList DataTagList;
protected System.Web.UI.WebControls.Button BtnUpd;

public string STATUS = string.Empty; <---- Help me.


// some update stuff

private void UpdateTable()
{
 using(DatabaseConnection conn = new DatabaseConnection())
 {    
  try
  {
   conn.OpenConnection(devSettings.junk);

   for (int i = 0; i < DataTagList.Items.Count; i++)
   {
    HtmlInputText textTag =
    (HtmlInputText)DataTagList.Items[i].FindControl("TagList");
    
     if (textTag.Value.Trim() != string.Empty)
     {
      GetOldStatus(conn, textTag.Value.Trim()); <---- Help me.
      UpdateTable1(conn, textTag.Value.Trim());
      UpdateTable2(conn, textTag.Value.Trim());
     }
    }

   }
   catch ( Exception ex )
   {
    conn.Rollback();
    throw ex;
   }
  }
}

// some sql table stuff


private string GetOldStatus(DatabaseConnection conn, string tag)

{
 StringBuilder sqlStr = new StringBuilder();
 sqlStr.Append("  SELECT  ");
 sqlStr.Append("  STATUS  AS STATUS"); <---- Help me.
 sqlStr.Append("  FROM  ");
 sqlStr.Append("  TABLE1  ");
 sqlStr.AppendFormat(" WHERE TAG in '{0}'", Functions.DBFormatUpper(tag));

 conn.Update(sqlStr.ToString());
 return sqlStr.ToString();
}


private string UpdateTable1(DatabaseConnection conn, string tag)

{
 StringBuilder sqlStr = new StringBuilder();
 sqlStr.Append(" UPDATE TABLE1 ");
 sqlStr.AppendFormat(" SET DISP_DOC = '{0}',",Functions.DBFormatUpper(this.DISP_DOC.Value));
 sqlStr.AppendFormat(" DISP_DATE = to_date('{0}', 'mm/dd/yyyy'),", DISP_DATE.Value);
 sqlStr.AppendFormat(" STATUS = '{0}',", Functions.DBFormatUpper(DISP_CD.SelectedValue));
 sqlStr.Append(" UPDT_DATE = sysdate ");
 sqlStr.AppendFormat(" WHERE TAG in '{0}'", Functions.DBFormatUpper(tag));
 sqlStr.Append(" AND STATUS in ('1','2','3')");

 conn.Update(sqlStr.ToString());
 return sqlStr.ToString();
}


private string UpdateTable2(DatabaseConnection conn, string tag)

{
 StringBuilder sqlStr = new StringBuilder();
 sqlStr.Append(" INSERT INTO TABLE2 (");
 sqlStr.Append("  TAG");
 sqlStr.Append(" ,DATE");
 sqlStr.Append(" ,FIELD1");
 sqlStr.Append(" ,FIELD2");
 sqlStr.Append(" ,BEFORE"); <---- Help me.
 sqlStr.Append(" ,AFTER");
 sqlStr.Append(" ,USER");
 sqlStr.Append("   )");
 sqlStr.Append(" VALUES (");
 sqlStr.AppendFormat("  '{0}'", Functions.DBFormatUpper(tag));
 sqlStr.Append(" ,sysdate ");
 sqlStr.Append(" ,'JUNK1'");
 sqlStr.Append(" ,'JUNK2' ");
 sqlStr.AppendFormat("  ,'{0}'", Functions.DBFormatUpper(this.STATUS)); <---- Help me.
 sqlStr.AppendFormat("  ,'{0}'", Functions.DBFormatUpper(DISP_CD.SelectedValue));
 sqlStr.AppendFormat("  ,'{0}'", Functions.DBFormatUpper(devState.UserId));
 sqlStr.Append("   )");

 conn.Update(sqlStr.ToString());
 return sqlStr.ToString();
}

View 1 Replies


ADVERTISEMENT

Populating 2 Variable At The Same Time In An SP.

Dec 3, 2001

Following is an example of a query which I use in a SP.
<BR><BR>
What I would really like to do is set both variables with one query. Can I get both data elements with one query, or do I have to run 2 queries to set 2 variables? This query is going to run over 2 servers and would like to save the extra trip.
<BR><BR>
set @int_MCID = (select top 1 iPID from customers inner join tblPersonnel on MtgConsultant = iPid where phone1 = @str_Phone and Position = 'Consultant')
<BR><BR>
set @int_LocID = (select top 1 iLocID from customers inner join tblPersonnel on MtgConsultant = iPid where phone1 = @str_Phone and Position = 'Consultant')
<BR><BR>
Select @int_LocID, @int_MCID
<BR><BR>

View 2 Replies View Related

Populating An SqlDataSource Using A Session Variable

May 29, 2008

I'm having a real problem populating my SqlDataSource and was wondering if anyone could help.  I'm sure it's something simple
First off, I created a session variable on a previous page like so Dim NewSubscribeID As Integer = Convert.ToInt32(retSubcribeID.Value)
Session("SubcribeID") = NewSubscribeID
I now want to use this session variable on another page to populate a SqlDataSource like so <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionXX %>" SelectCommand="spXX" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:SessionParameter Name="SubscribeID" SessionField="SubscribeID" Type="Int32" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
Here is the problem... Only the default value gets used.
I've tried putting the session variable into a label to test that it does actually exist lblTest.Text = Session("SubcribeID")

 and it does...What am I doing wrong?

View 2 Replies View Related

Populating DateTime Variable From Execute SQL Task

Oct 4, 2006

Please help!

I am designing an SSIS package and need to change the value of a DateTime global variable with the value returned from an Execute SQL task. The queary is as follows:



Select Versiondate = dateadd(dd,+1,Max(CreateDate)) from msdb..sysdtspackages p with(nolock)
where name = '@name'



The error message is as follows:

SSIS package "Package.dtsx" starting.

Error: 0xC002F210 at VersionDate_Set, Execute SQL Task: Executing the query "Select Versiondate = dateadd(dd,+1,Max(CreateDate)) from msdb..sysdtspackages p with(nolock)

where name = '@name'" failed with the following error: "The type of the value being assigned to variable "User::VersionDate" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.

". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Task failed: VersionDate_Set

SSIS package "Package.dtsx" finished: Success.

The variable is set to data type DateTime, but the value will not change. Any ideas?

View 1 Replies View Related

Populating Dropdownlist

Mar 23, 2006

I've got the following code and it's not really what I want. With the below code I can select in a dropdownlist a value and in the other dropdownlist the correspondending value will be selected. But when I select a value the second dropdownlist won't be filled with all the data in the database. It is filled only with the correspondending value and not with the rest of the value. When someone changes his mind and want to select a value in the dropdownlist it can't be done. Any ideas??Default.aspx:<body>    <form id="form1" runat="server">    <div>        <asp:Label            ID="Label1"            runat="server"            Text="Botanische Naam: ">        </asp:Label>        <asp:DropDownList            ID="DDL1"            AutoPostBack="True"            runat="server"            OnSelectedIndexChanged="ChangeBotanicName"            DataSourceID="SqlDataSource1"            DataTextField="Botanische_Naam"            DataValueField="Botanische_Naam">        </asp:DropDownList>        <asp:SqlDataSource            ID="SqlDataSource1"            runat="server"            ConnectionString="<%$ ConnectionStrings:BonsaiDataBaseConnectionString %>"            SelectCommand="SELECT [Botanische Naam] AS Botanische_Naam FROM [BonsaiSoorten]">        </asp:SqlDataSource>        <asp:sqldatasource           id="SqlDataSource2"           runat="server"           connectionstring="<%$ ConnectionStrings:BonsaiDataBaseConnectionString%>"           selectcommand="SELECT [Nederlandse Naam] AS Nederlandse_Naam FROM [BonsaiSoorten]WHERE [Botanische Naam] = @Title1">          <selectparameters>              <asp:controlparameter              name="Title1"              controlid="DDL1"              propertyname="SelectedValue"              />          </selectparameters>        </asp:sqldatasource>         <asp:Label            ID="Label2"            runat="server">Nederlandse Naam:</asp:Label>                <asp:DropDownList            ID="DDL2"            AutoPostBack="True"            runat="server"            OnSelectedIndexChanged="ChangeDutchName"            DataSourceID="SqlDataSource3"            DataTextField="Nederlandse_Naam"            DataValueField="Nederlandse_Naam">        </asp:DropDownList>        <asp:SqlDataSource            ID="SqlDataSource3"            runat="server"            ConnectionString="<%$ ConnectionStrings:BonsaiDataBaseConnectionString %>"            SelectCommand="SELECT [Nederlandse Naam] AS Nederlandse_Naam FROM [BonsaiSoorten]">        </asp:SqlDataSource>        <asp:sqldatasource           id="SqlDataSource4"           runat="server"           connectionstring="<%$ ConnectionStrings:BonsaiDataBaseConnectionString%>"           selectcommand="SELECT [Botanische Naam] AS Botanische_Naam FROM [BonsaiSoorten]WHERE [Nederlandse Naam] = @Title2">          <selectparameters>              <asp:controlparameter              name="Title2"              controlid="DDL2"              propertyname="SelectedValue"              />          </selectparameters>        </asp:sqldatasource>     </div>    </form></body>Default.aspx.vb:Partial Class _Default    Inherits System.Web.UI.Page    Sub ChangeBotanicName(ByVal Sender As Object, ByVal e As System.EventArgs)        DDL2.DataSourceID = "SqlDataSource2"    End Sub    Sub ChangeDutchName(ByVal Sender As Object, ByVal e As System.EventArgs)        DDL1.DataSourceID = "SqlDataSource4"    End SubEnd Class
P.S. I posted this before but can't find it anymore so here it is again

View 3 Replies View Related

Populating A Table

May 19, 2004

I have a table with a list of products,once I enter the data into the table and start using it on my web site as a drop down list,the list is sorted as an alphabetical list,is there are way to have a single drop down list but still be able to group the those products,in order words force them not to get sorted aphabetically.


Thanks

View 11 Replies View Related

Populating A Table

May 11, 2007

Hi, I have two tables:

1. RubricReportDetail with columns LocalPerf, Age
2. SppIndicator with columns Pct, Age

How can I populate the values of LocalPerf with Pct by matching

RubricReportDetail.Age = SppIndicator.Age ??

Please help me. Thanks in advance.

View 15 Replies View Related

One Of The DatSets Is Not Populating

Aug 16, 2007

Hi Guys!!

I have a DataSet (which requires 2 parameters), and for some reason even though it works in Query Analyzer and on the Data Tab of VS2003 it will not work when I choose to Preview it. Can anybody shed some light on this behaviour?

If you need to see the dataSet I can post it up!
Thanks!

View 2 Replies View Related

Populating A Table With A Dataset

Apr 17, 2007

I am running a program that populates tables on my local database by querying another database. 

View 2 Replies View Related

Populating Data Between Ranges

Oct 3, 2007

Hi All,
I have a startdate (01/11/2007) and a enddate (01/11/2008).  I need to add dates into a table for everyday between these dates.  Can anyone help?

View 1 Replies View Related

Populating Labels From A Query

Apr 22, 2008

 
I have a page that is part of a 5 page wizard.  The wizard gathers data for a claim filter.  The second page is laid out with four labels at the top
Filter Name:  <filterName>     -- filterName_LFilter Description: <filterDescription>    -- filterDescription_LFilter Data Source: <filterDataSource>    -- filterDataSource_LFilter Purpose: <filterPurpose>     -- filterPurpose_L
--I have written an sp to populate these four label.Text values. I want to populate them on page load. 
Two questions. How do I get four output values out of the sp?  Is there a better way to do this than an sp?
SET QUOTED_IDENTIFIER ON GOSET ANSI_NULLS ON GO
 
-- =============================================-- Author:  <Author,,Name>-- ALTER  date: <ALTER  Date,,>-- Description: <Description,,>-- =============================================ALTER   PROCEDURE [dbo].[a_spNewFilter_Step1_Summary] -- Add the parameters for the stored procedure here @filterID int ,
 @filtername varchar(100) OUTPUT, @filterdescription varchar(250) OUTPUT, @filterOwnerID int OUTPUT, @filterDataSourceID INT OUTPUT, @filterPurposeID int OUTPUT
ASBEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements.SET NOCOUNT ON;
--DECLARE @FilterID int
--SET @filterID = 14
SELECT   filterIsComplete, filterCreateDate, filterStep1Complete, filterName, filterDescription,  das.AuditorFirstName + ' ' + das.AuditorLastName as FilterOwner, dfds.filterDataSource, dfp.filterPurposeFROM a_factSamplingFilter_2 fsfINNER JOIN dbo.a_dimFilterDataSource dfdsON dfds.filterDataSourceID = fsf.filterDataSourceIDINNER JOIN dbo.a_dimAuditStaff dasON das.AuditorID = fsf.filterOwnerIDINNER JOIN dbo.a_dimfilterPurpose dfpON dfp.filterPurposeID = fsf.filterPurposeIDWHERE filterID = @filterIDGROUP BY  filterIsComplete, filterCreateDate, filterStep1Complete, filterName,  filterDescription,  das.AuditorFirstName, das.AuditorLastName, dfds.filterDataSource, dfp.filterPurpose
 
END
 
GOSET QUOTED_IDENTIFIER OFF GOSET ANSI_NULLS ON GO
----
protected void Page_Load(object sender, EventArgs e)    {
        int filterID = int.Parse(Request.QueryString["filterID"]);  /// grab the filterID from the URL query string
        string connectionString = WebConfigurationManager.ConnectionStrings["DDT"].ConnectionString;        SqlConnection con = new SqlConnection(connectionString);
        SqlCommand cmd = new SqlCommand("a_spNewFilter_Step1_Summary", con); // get the values from filter setup step1        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add(new SqlParameter("@FilterID", SqlDbType.Int)); // using the filterID created in step1        cmd.Parameters["@FilterID"].Value = filterID;
        cmd.Parameters.Add(new SqlParameter("@FilterName", SqlDbType.VarChar, 100));        cmd.Parameters["@FilterName"].Direction = FilterName_TB.Text;
        cmd.Parameters.Add(new SqlParameter("@FilterDescription", SqlDbType.VarChar, 255));        cmd.Parameters["@FilterDescription"].Direction = ParameterDirection.Output;
        cmd.Parameters.Add(new SqlParameter("@FilterOwner", SqlDbType.VarChar,50));        cmd.Parameters["@FilterOwner"].Direction = ParameterDirection.Output;
        cmd.Parameters.Add(new SqlParameter("@FilterDataSource", SqlDbType.VarChar,50));        cmd.Parameters["@FilterDataSource"].Direction = ParameterDirection.Output;
        cmd.Parameters.Add(new SqlParameter("@FilterPurpose", SqlDbType.VarChar,100));        cmd.Parameters["@FilterPurpose"].Direction = ParameterDirection.Output;
        con.Open();
        try        {            cmd.ExecuteNonQuery();        }        finally        {            con.Close();        }
        ///get name, description, owner, datasource, purpose
 
    }
 

View 1 Replies View Related

Populating An Array From A Sqlreader

Jun 8, 2006

I am trying to populate an array from a sqlreader.  I am getting the error "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index".  Can anyone help?  I have my code below.
        Try            sql = "...."            cmd = New SqlCommand(sql, conn)            SqlReader = cmd.ExecuteReader       'Get the data from SQL Server            Dim Counter As Integer = 0                        Do While SqlReader.Read()                    Counter += 1                    PageArray(Counter) = SqlReader("WebPageID")           Loop                    Catch ex As Exception            lblMessage.Text = ex.Message        End Try

View 5 Replies View Related

Populating A DB From 2 Tables (Dynamic)

Apr 27, 2005

Hi

I am quite new to the complexities of MS SQL and have a problem, I would like to resolve. I have 2 tables with a unique identifier in both and want to populate a new table with information from both, but the second table I would like to populate just some fields that have a DOB eg

Table 1:
uniqueId
Name
Address

Table2:
uniqueId
Type
Setting

example of content for Table 2:
uniqueId Type Setting
123 DOB 03/04/74
234 TFN 12345678
567 POA Mr Smith

So the new table needs to be populated with a ll of info in table 1 and has a new field called DOB so only the clients with a DOB should populate this field, if the client in Table 1 has a TFN reference, this record should be added to the new table but no value needs to be entered eg

123 Chris Smith 1 high street 03/04/74
234 Jon brown 2 high terrace <Null>

Cheers
pommoz

View 1 Replies View Related

Report Populating Incorrectly

Aug 29, 2004

I have a customer who is running a script that generates a custom report. IT is not populating as it should and is returning zeros for everything.

I have tested the the script in the office and it is populating as intended. I have run a debug on the script and it is executing the correct SQL commands. The debug results for the customer and for the one tested in the office are identical. For some reason, the script is not writing to file but is looking at the correct data. I suspect that it is an environment issue most likely on the SQL level.

Could this be an issue with character set? How can I check their character set and language preferences? I understand they are set during installation.

They are using the same collation as us.

What else can I check as I am running low on ideas.

I advised the client to create a new DB and restore over the top. The script was then tested and it was found to be working fine. As it was given an inappropriate name (ie test), I advised to create a new DB with a production name and restore over the top again. We have since returned back to where we started as the report is generating only zeros.

H E L P !

View 1 Replies View Related

Populating Data In A Pdf File

Jan 18, 2005

Hi

Need to populate data from SQL Server in a pdf file which is basically a government form.

Data should be fetched from the SQL server database and needs to be displayed in a pdf file.

Advice me on how to implement this.

Suggest me if there is any other idea for implementing the same.

Thanks in advance

View 1 Replies View Related

Populating Database With Timestamps...

Jan 19, 2005

Hi Everyone....

Crazy one here....

I need to populate a table with all the times that
are available in a 24 hour period, down to the 5 minute
interval.

So the table should look like....

id ds (datetime stamp)
--- --------------------------
0 1/1/2005 00:00:00
1 1/1/2005 00:05:00
2 1/1/2005 00:10:00
3 1/1/2005 00:15:00
.........
xx 1/1/2005 23:55:00



Please advise on a way to accomplish this in a script....

thanks
tony

View 14 Replies View Related

Populating Data From One SQL Database To Another

Jul 13, 2007

I have a project that entails the following:

There are two separate SQL Server databases involved that reside on two different servers. One of the depts within our building wants to have building permit data imported from Permit Database on Server "A" to their own database on Server "B".

I dont think this will be an overly complicated process. There are only a few fields they want populated (5 or 6 tops). This will have to be ran every
weeknight via some sort of scheduled task in Windows or SQL.

I was just interested in seeing if anyone has had prior experience working on data transfer like this. I would like to know what would be the best and most efficient way to approach this.

Thanks in advance.

View 9 Replies View Related

T-SQL (SS2K8) :: CTE Populating TVP Parameter

Aug 19, 2014

The stored procedure accepts a TVP table as a parameter. Will something like this work?

BEGIN
;with tree(Id) as
(
SELECT 1
UNION ALL
SELECT 2
)
EXECUTE [dbo].[Get_FooByIds] @tvpId = tree
END

View 5 Replies View Related

Error Populating Table

May 14, 2008

Hi all,

I have a table that looks something like this: -

county fname sport
------ ----- -----
surrey tara squash
surrey tara hockey
surrey tara tennis
kent tom tennis
kent tom football
kent tom rugby


I want to read through the sport table and create a distinct list of sports which can be used to create a new table that would look like: -

County fname squash hockey tennis football rugby
------ ----- ------ ------ ------ -------- -----
surrey tara YES YES YES
kent tom YES YES YES

I am using the following code: -
DECLARE @sql NVARCHAR(MAX)
SELECT @sql = 'create table ey_report_temp (county nvarchar(100),fname nvarchar(100), ' +
STUFF((SELECT DISTINCT ',[' + sport + '] nvarchar(100) '
FROM ey_report FOR XML PATH('')), 1, 1, '') + ')'

SELECT @sql
exec sp_executesql @sql

SELECT * from ey_report_temp

--------------------------------------------

DECLARE @county nvarchar(max)
DECLARE @fname nvarchar(max)
DECLARE @sport nvarchar(max)

DECLARE merge_cursor CURSOR FAST_FORWARD
FOR SELECT county, fname, sport from ey_report

OPEN merge_cursor
FETCH NEXT FROM merge_cursor INTO @county, @fname, @sport
WHILE @@FETCH_STATUS = 0
BEGIN

select @sql = N'
update ey_report_temp
set ' + @sport + ' = ''YES''
where county = ''' + @county + '''
and fname = ''' + @fname + ''''
print @sql
exec sp_executesql @sql
if @@ROWCOUNT = 0

begin
select @sql = N'
insert into ey_report_temp (
county, fname, ' + @sport + '
) values ( ' + @county + ', ' + @fname + ', ' + @sport + ')'

exec sp_executesql @sql

end
FETCH NEXT FROM merge_cursor INTO @county, @fname, @sport
END
CLOSE merge_cursor
DEALLOCATE merge_cursor
select * from ey_report_temp

drop table ey_report_temp

This creates the new table fine however, when it trys to poulate I get the following EM, can anybody help? thanks in anticipation

(1 row(s) affected)

(0 row(s) affected)

update ey_report_temp
set squash = 'YES'
where county = 'surrey'
and fname = 'tara'

(0 row(s) affected)
Msg 128, Level 15, State 1, Line 4
The name "surrey" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

update ey_report_temp
set hockey = 'YES'
where county = 'surrey'
and fname = 'tara'

(0 row(s) affected)
Msg 128, Level 15, State 1, Line 4
The name "surrey" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

update ey_report_temp
set tennis = 'YES'
where county = 'surrey'
and fname = 'tara'

(0 row(s) affected)
Msg 128, Level 15, State 1, Line 4
The name "surrey" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

update ey_report_temp
set tennis = 'YES'
where county = 'kent'
and fname = 'tom'

(0 row(s) affected)
Msg 128, Level 15, State 1, Line 4
The name "kent" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

update ey_report_temp
set football = 'YES'
where county = 'kent'
and fname = 'tom'

(0 row(s) affected)
Msg 128, Level 15, State 1, Line 4
The name "kent" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

update ey_report_temp
set rugby = 'YES'
where county = 'kent'
and fname = 'tom'

(0 row(s) affected)
Msg 128, Level 15, State 1, Line 4
The name "kent" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

(0 row(s) affected)

View 7 Replies View Related

Best Way To Handle Populating Column?

Jul 2, 2014

Have two tables: table1 and table2

Working with two main columns in both tables: D_ID and C_ID.

Table1 has D_ID populated and C_ID is not.

Table2 is a cross reference table with both D_ID and C_ID values within.

Looking for best way to populate C_ID in table1 from C_ID values in table2 where table1.D_ID = table2.D_ID.

There are too many values to do a case in stored procedure which has been my best practice. Trying to up my game with using SSIS 2012 as well.

View 1 Replies View Related

Pre-Populating Report Tables

Nov 28, 2007

Hi. I have a report which has several datasources which require a table to be populated before they read from it.
i.e. The first thing that needs to happen whenever the report is run, is a call to a stored procedure which populates the table the report datasources are based off of. The SP takes several minutes to complete and MUST complete before any of the datasources fetch their data.

How can this be achieved?

I can not find anything in the Visual Studio Report Designer which allows to me to instruct Datasource B to not execute before Datasource A has completed (or any other way to call a data population SP, before the data reader SP's execute).

Thanks.

View 2 Replies View Related

Populating A Lookup Table

Jul 9, 2006

I'm trying to do a table lookup in t-sql and runing into problems. I have two tables, City and County..



Table City:

CityID CountyID CountyName

1 3 NULL

2 2 NULL

3 1 NULL



Table County:

CountyID CountyName

1 Los Angeles

2 Contra Costs



I want to populate the NULL "CountyName" field in table City with the values from table County but I can't make it work! Any help appreciated.



Barkingdog

View 1 Replies View Related

Dataset Not Populating Table

Feb 7, 2008

Hello,

Just when I thought I was starting to understand SSRS just a little and then I encounter a strange (maybe not too strange) of an issue.

I have a DataSet which runs a stored procedure and it requires 10 parameters. When I run it in the dataset portion itself it runs fine however, it will not work when I choose to Preview it. I refreshed my dataset and even rebooted my machine. Can anybody shed some light on this?

Thanks

View 6 Replies View Related

SCD And Populating Dimensions And Facts

Mar 8, 2006

Hello,

This is my first task in attempting to populate a fact and dimension table from SSIS.
I have a Fact table Sales and dimension tables Customer and Location. The data I am getting to fill this structure is in one file. where each record contains the sales information as well the customer information and location details on the same row.

I am using the SSIS to fill this structure by using the slowly changing dimension for the Customer dimension.

I am filling the customer dimension by using the slowly changing dimension. If I have 2 records having same BusinessKey but each with a different first name, where first name is set as a changing attribute, it is creating the customer twice in the table. But shouldn't it create one record with the most recent first name? or am I miss using the SCD.

I have another conceptual question, I am not sure which is the best way to fill my fact and dimension. Should I fill the customer and location dimensions first through 2 different loops on the data and then fill the fact table and map to corresponding dimensions? Or should I do like a for each loop on each record and for each record fill the dimensions and fact simultanously?

Thanks in Advance,
Grace

View 14 Replies View Related

Help On Populating Dimension Table

Dec 30, 2007



While populating dimsnion table the requirement is that the 1st record in all dimension should be " Not Available"

and if the fact table has a null value for that dimension it shouldbe tied to " Not Available" record in dimension
Please help hwo to do both the things.
JJ

View 5 Replies View Related

Populating Variables At Run Time

Mar 11, 2008

Is it possible in SSIS to populate the package level variables at run time..meaning lets say I have a 4 variables defined with some default values..if I use a for loop iterator to read all the config files in a directory and want to read the data from each of those config files (config file has 4 rows of data corresponding to the 4 variables) into the variables.

How can I accomplush this ?

Thanks

View 4 Replies View Related

Populating 2 Tables At A Time

Oct 19, 2007



Hi,


I have a table in Sql 2005 called

Customers
CustomerId
CustomerName
CustomerAge
CustomerRank
CustomerStCode


I have to transfer the records into 2 tables


CustomerMaster
CustomerId
CustomerStCode


CustomerDetails
CustomerId
CustomerName
CustomerAge
CustomerRank


I have to pick up a row from Customers and transfer it to CustomerMaster and CustomerDetails. CustomerId of CustomerMaster will be the CustomerId of CustomerDetails while transfer. Similarly for all other rows in Customers.


How to do this?

thanks

View 5 Replies View Related

No Data In The Report After Populating DB

Oct 31, 2007



HI,

I populed my data base. But before I populate I created some reports beased on this DB. Now after I populating I can execute query and see results in Management studio or query designer. But When I change it the report to preview mode I can not see it.
Does anyone know why this is?

Thanks

View 2 Replies View Related

Populating A Blank Column Beside A Populated One

Aug 23, 2006

I have a table with two columns:
OwnerName            Owner
John;Smith
Mary;Smith
 
OwnerName is populated. Owner is not.
I want to populate the Owner column with the OwnerName in alphabetical order.  I have already created a function to do this.
Select fnGetOwner(OwnerName) from OwnerTable.  This returns:
Smith, John
Smith, Mary
How do I populate the blank Owner field beside the OwnerName in the OwnerTable?
 

View 3 Replies View Related

Populating A DataSet From A Stored Procedure

May 25, 2007

Hi all,
Im still relatively new to SQL Server & ASP.NET and I was wondering if anyone could be of any assistance. I have been googling for hours and getting nowhere.
Basically I need to access the query results from the execution of a stored procedure. I am trying to populate a DataSet with the data but I am unsure of how to go about this.
This is what I have so far:-
1    SqlDataSource dataSrc2 = new SqlDataSource();2    dataSrc2.ConnectionString = ConfigurationManager.ConnectionStrings[DatabaseConnectionString1].ConnectionString;3    dataSrc2.InsertCommandType = SqlDataSourceCommandType.StoredProcedure;4    dataSrc2.InsertCommand = "reportData";5    6    dataSrc2.InsertParameters.Add("ID", list_IDs.SelectedValue.ToString());7    8    int rowsAffected;9    10   11   try12   {13        rowsAffected = dataSrc2.Insert();14   } 
As you know this way of executing the query only returns the number of rows affected. I was wondering if there is a way of executing the procedure in a way that returns the data, so I can populate a DataSet with that data.
 Any help is greatly appreciated.
Slainte,
Sean
 
 
 

View 2 Replies View Related

Populating A Form, Dropdowns Not Working

Nov 23, 2007

Hi All,
I have literally spent the last 2 1/2 hours troubleshooting an issue where I pass a parameter to the page and based on the parameter it runs a SQL statement and fills in the fields on the form.  It is giving me the error message below but I know its not a NULL value and I know those controls are named correctly.
System.NullReferenceException: Object reference not set to an instance of an object.All of my textboxes and labels that are being populated are working fine when I comment out the dropdowns, I have this working on other pages but the only thing that is different here is I am using some AJAX (Autocomplete, Collapsable Panel and Calendar Control). 
If I add a label or a textbox field on the form and take the same value that is going to populate the dropdownlist and populate the new control it works, so i know I'm getting the data and its not null/nothing.  I also verified that the parameter is working correctly. 
Any help will be a blessing, its probably something write under my nose!Thanks in advance!Tim
Here is the codeDim conn As SqlConnectionDim comm As SqlCommandDim reader As SqlDataReaderDim connectionstring As String = ConfigurationManager.ConnectionStrings("MagicDEV").ConnectionStringDim SeqIncident As Integer = Convert.ToInt16(Request.QueryString("NAME"))
If SeqIncident > 0 Thenconn = New SqlConnection(connectionstring)comm = New SqlCommand("Select isnull(t.[Sequence],'') as SeqIncident, " & _"isnull(t.Client,'') as SeqClient, " & _"isnull(c.Client,'') as Client, " & _"isnull(t.[Open By],'') as SeqOpenBy, " & _"isnull(p.[Code],'') as OpenedBy, " & _"isnull(t.[Sent To],'') as SeqAssignedTo, " & _"isnull(p1.code,'') as AssignedTo, " & _"isnull(t.[Date Open],'') as DateOpen, " & _"isnull(t.[Closed On],''), " & _"isnull(t.[Closed By],'') as SeqClosedBy, " & _"isnull(p2.[Code],'') as ClosedBy, " & _"isnull(t.[Seq_Severity:],'') as SeqUrgency, " & _"isnull(s.[Name],'') as Urgency, " & _"isnull(t.[Seq_UdStatus:],'') as SeqStatus, " & _"isnull(u.[id],'') as Status, " & _"isnull(t.Contact_Type,'') as ContactType, " & _"isnull(t.Ctrpart,'') as SeqAsset, " & _"isnull(i.[Asset#],'') as Asset, " & _"isnull(t.seq_rpt_party,'') as SeqRptParty, " & _"isnull(c1.client,'') as RptParty, " & _"isnull(t.Whiteboard_ID,'') as SeqWhiteboard, " & _"isnull(w.Whiteboard_ID,'') as Whiteboard, " & _"isnull(t.Subject,'') as SeqSubject, " & _"isnull(s1.[Description],'') as Subject, " & _"isnull(t.[Description],'') as IncDescription, " & _"isnull(t.Resolution,'') as IncResolution, " & _"isnull(t.[FCR:],'') as FCC, " & _"isnull(t.Sent_Ack,'') as SentAck, " & _"isnull(t.Inc_Closed,'') as IncClosed, " & _"isnull(t.RC,'') as RC " & _
"From _Smdba_._Telmaste_ t " & _"inner join _Smdba_._Customer_ c on t.client = c.[Sequence] " & _
"left outer join _Smdba_._Personnel_ p on t.[open by] = p.[Sequence] " & _"left outer join _Smdba_._Personnel_ p1 on t.[Sent To] = p1.[Sequence] " & _
"left outer join _Smdba_._Personnel_ p2 on t.[Closed By] = p2.[Sequence] " & _"left outer join _Smdba_._Severity_ s on t.[Seq_Severity:] = s.[Sequence] " & _
"left outer join _Smdba_._UdStatus_ u on t.[Seq_UdStatus:] = u.[Sequence] " & _"left outer join _Smdba_._Inventor_ i on t.[Ctrpart] = i.[Sequence] " & _
"left outer join _Smdba_._Customer_ c1 on t.seq_rpt_party = c1.[Sequence] " & _"left outer join _Smdba_._Whiteboard_ w on t.Whiteboard_ID = w.[Sequence] " & _
"left outer join _Smdba_._Subjects_ s1 on t.Subject = s1.[Sequence] " & _"Where t.Sequence = @Sequence1", conn)
comm.Parameters.Add("@Sequence1", Data.SqlDbType.Int)
comm.Parameters.Item("@Sequence1").Value = SeqIncident
Try
conn.Open()
reader = comm.ExecuteReader()
reader.Read()ClientDropDown.SelectedItem.Text = reader.Item("Client")
ClientDropDown.SelectedItem.Value = reader.Item("seqclient")
Finallyconn.Close()End TryEnd If

View 2 Replies View Related

Populating A SQL Table With SmallDateTime Values

Mar 24, 2008

I have a table that I would like to update with the current dateTime of Today. The Table Field is called "DateTimeStamp" with a format of SmallDateTime -- I'm using VS 2008.
When I use the following command and then cmd.ExecuteNonQuery -- the table is correclty filled in with the exception of the DateTimeStamp field. Instead of 3/23/2008, I get the value 1/1/1900 ... 
SqlCommand cmd3 = new SqlCommand("UPDATE CameraPods SET CameraBlock1_ID = 98, CameraBlock2_ID = 99, Status = 1, DateTimeStamp = 3/3/2008");
any ideas?
    ---Jim

View 3 Replies View Related

Automating Populating Tables At A Certain Time.

Apr 21, 2000

Hi,

I am new to SQL Server7. I need to populate some tables from an SQL Server7
database at the end of the day. How can I automate this process?
I also need to export these populated tables to a text file on daily basis.
I know I can use "DTS" to do this. But is there any way to make these
automated also? Or is there any third party tool to do all these?

Thanks in advance.

Mkhan

View 1 Replies View Related







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