How Can You View The Connection String Of An Existing Datasource? How Do You Delete Existing Dataset?

Nov 14, 2007

I went to look at the connection string previously entered for a dataset created in a new report, and am not seeing anything intuitive for bringing up the associated datasource dialog box that was used to enter name, type and connection string. I'm also noticing nothing intuitive for deleting an existing dataset. How do you do these two very simple things in an existing project? I dont see the dataset in solution explorer, I see it only in the text box on the data tab and in a limited kind of way on the dataset view where the columns show and maint is allowed mostly on the columns only. I tried hilighting the dataset here and hitting the delete key to no avail.

View 1 Replies


ADVERTISEMENT

Set Datasource To Pre-existing Dataset

Dec 6, 2007

Hi guys

Firstly, i have a solution that is made up of multiple projects. One of these projects contains the majority of the business based datasets that are used throughout the applications.



One of the front ends that I have in the solution is a web site. I am wanting to use the report viewer control to display a report in local mode. I created a new report and i am trying to set its data source to one of the pre-existing datasets that I have and can not figure out how to do this.



Also these datasets do not have adaptors I populate the datasets manually. So the second half of what i need to know is once I have told a report to use one of my existing reports when do I do the population of the dataset.



Lastly if the answer for how to do this is different in local vs. remote modes i would be interested in what the difference is in this scenario.

Thanks

Anthony

View 3 Replies View Related

Reuse Existing Connection String For TableAdapter?

Jan 25, 2008

I've added a typed DataSet and dragged a table across from the server explorer. When I click configure on the table adapter, then click previous back to the "Choose Your Data Connection" dialog. The only option is the new connection that was just created when I added the sql server to the server explorer. Is there anyway to reuse my existing web.config connection string? My goal is to have a single connection string in my web.config.
 Thanks.
 -David

View 3 Replies View Related

Power Pivot :: How To Modify Existing Workbook Data Connection String

Oct 29, 2015

Trying to modify the workbook connection string but it is greyed out and unable to change the Provider= from SQLNCL10 to SQLOLEDB.  I am able to change the PowerPivot Data Connections connection string but not the workbook connection string.  On the forum only see where people have asked the question but it seems like the people who've asked ended up recreating the data models.

View 5 Replies View Related

Tried To Add Some Existing Reports Getting Datasource Name Issues

Feb 1, 2007

I have developed a report on my local machine and after the successful test on my machine uploaded the report on a webserver, where i have a report project and added the report as an existing item to the report project, i went to data tab and tried to change the datasource name to use a datasource name which is on the webservers report project, but it still complains saying there is a datasource name referred in that report, which matches with my local machines datasource name, how to remove all the references of my localmachines datasource name's.

Please help, i even went to xml side of the report code did see datasources tag on the top and i modified that too matching with a datasource name which is on webserver, still it complains including i modied the token key......

Thank you very much for then information.... this report cotains subreports too i modfied in all places, still i don't know what am i missing....

View 1 Replies View Related

Dataset With Existing Stored Procedure

Mar 11, 2008

I am trying to use a dataset for the first time and I've run into a roadblock early.  I added the dataset to the AppCode folder, set the connection string, and selected 'use existing stored procedures' in the configuration wizard.  The problem is that there are three input parameters on this procedure and they're not showing up in the 'Set select procedure parameters' box.  I went through several of the stored procedures and this is the case for all of them.  The weird thing is that if I select the same procedure as an insert procedure then the parameters do show up.  Very frustrating, any thoughts?
Thanks in advance,
N

View 6 Replies View Related

Force To Close Existing Connections When Restoring Existing Database

Aug 13, 2007

Hi All,

I would like to restore database using RESTORE DATABASE ... REPLACE command.
If database exists already and has any open connections this command will fail.
I would like to close all existing connections to specific database before running RESTORE DATABASE ... REPLACE command.
I can do closing from Management Studio using checkbox "Close Existing Connection" when deleting database. Actually I need to do the same but from script.

Please advice me how to do it.

Thanks in advance,
Roman

View 3 Replies View Related

Retrieving Unique Fields From Table Into Existing Dataset

Jun 18, 2008

I am working on creating a report which is retrieving data from a SQL 2005 database and being displayed in a C#.net web page.  Presently, I am binding the dataset to a ASP:Gridview on the web page.
I am currently retrieving most of the needed fields using the following SQL statement:PROCEDURE [dbo].[pr_getReportTickets]  @DateCreated nvarchar(15) ASBEGIN
 -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON;
    -- Insert statements for procedure hereSELECT     tbl_Queue.num_TicketNumber AS TicketID , tbl_Users.str_Name AS Technician , tbl_Queue.str_QueueLocator AS TechNTID , tbl_Queue.dat_ReceivedRequest AS dateCreated , tbl_Queue.dat_DueDate AS DueDate , tbl_Queue.str_TaskName AS TicketTitle , tbl_Queue.str_Requestor AS RequestorNTID --, I need most current dat_TimeStamp from tbl_Notes here for this record --, I need most current int_PercentComplete from tbl_Notes here for this record --, I need to sum up all of int_MinutesWorked fields from tbl_Notes here for this record , MasterEmp.dbo.fn_FormatFullName(tbl_employee.str_fname, tbl_employee.str_lname) AS RequestorName , tbl_Queue.str_TicketType AS TicketType , tbl_Status.str_TaskStatus AS TicketStatus , tbl_Severity.str_Priority , tbl_Complexity.str_Complexity , tbl_Severity.str_Priority + N' / ' + tbl_Complexity.str_Complexity AS Priority , tbl_Queue.dat_CompleteDate as DateCompleted 
FROM          dbo.tbl_Queue LEFT OUTER JOIN MasterEmp.dbo.tbl_employee AS tbl_employee ON dbo.tbl_Queue.str_Requestor = tbl_employee.str_ntid LEFT OUTER JOIN tbl_Users ON  tbl_Queue.str_QueueLocator = tbl_Users.str_ntid LEFT OUTER JOIN tbl_Status ON  tbl_Queue.num_Status_CD = tbl_Status.num_Status_CD LEFT OUTER JOIN tbl_Severity  ON tbl_Queue.str_Severity = tbl_Severity.str_Severity LEFT OUTER JOIN tbl_Complexity  ON  tbl_Queue.int_ComplexID = tbl_Complexity.int_ComplexID
WHERE      (dbo.tbl_Queue.dat_ReceivedRequest > CONVERT(DATETIME, @DateCreated, 102))   
 ORDER BY     TicketType,     tbl_Queue.str_Severity
I also have another table called tbl_Notes.  This table contains an unlimited quantity of records for every “num_TicketNumberâ€?.  This table contains the following fields:  num_TicketNumber, str_TechRep, str_Notes, dat_TimeStamp, int_PercentComplete and int_MinutesWorked
I need to add two more fields to the query, but I do not know how to tell the SQL statement how to retrieve the data for the specfic record and inbed the fields into the Dataset being returned from the database to the web page.1) The first field I need is the most current recorded Date field from the tbl_Notes table for the each of the records returned in the above SQL statement.  Similar to:  SELECT TOP (1) dat_TimeStamp FROM tbl_Notes WHERE(num_TicketNumber = xxxx) ORDER BY dat_TimeStamp DESC2) The other field I need to return with the Dataset is the sum of the int_MinutesWorked for each of the tickets being retrieved. Similar to:  SELECT SUM(int_MinutesWorked) AS TotalMinutesFROM tbl_Notes WHERE (num_TicketNumber = 49)

View 4 Replies View Related

Can't Modify Or Delete An Existing Job

Aug 20, 2004

Folks, i have rebuilt my old server machine and i've restored the MSDB over the new machine. Now when i try to edit or delete any of the jobs that come from the RESTORE; i get the following error message:


I never setup multiserver administration.
However i can create and delete new jobs.
How do i remove these older jobs.

Howdy!

View 5 Replies View Related

Will Migrate Delete Existing Dts Packages

Jun 8, 2007

If I use the DTSMigrationWizard.exe, to migrate my existing DTS packages from SQL Server 2000 to SQL Server 2005 will it delete the DTS packages on the 2000 server?



On this one server I have 65 DTS packages and I want to migrate them all at once if possible but still keep the DTS packages on the 2000 server.



View 1 Replies View Related

Need Help~for Edit, Delete The Existing Query And Diagram In Database~

Apr 8, 2008

anyone know how to delete diagram in database that show relationship between tables?or anyone know how to open the existing relation diagram and existing query in database?wonder why my sqlexpress which come wit visual basic web developer 2005 only hav new query button and new diagram button~dont have edit exisiting diagram or edit existing query~==.=~~hope someone help me~ 

View 3 Replies View Related

How To Delete Existing Data Based On Where Clause Condition

Feb 18, 2014

I have written a merge Statement where i am facing trouble to delete the data basing on Where Clause Condition.

1) Case 1 : For example i have inserted Data from Source to Target based on Date Key Condition.Take an Instance 10 Records Inserted.
2) Case 2 : For example some changes in the records and it has been updated through the Merge Statement .
3) Case 3 : For the Same Date key based on Conditions now three records has came and need to be inserted and rest should be deleted for that Date Key.

How i need to proceed on this before 10 records are not getting deleted and new records adding for that one

My Example Code :

MERGE INTO TargetTable AS Target
USING (
SELECT DISTINCT Col1,
Col2
FROM Table1 AS cga
)
ON dad.AnchorDate = CASE

[Code] ....

View 1 Replies View Related

ı Cannot View Existing Database In Management Studio !!!

Jul 5, 2007

Hi

ı have sharepoint 2007 server and everthing is ok

it is working

ı can view database name in sharepoint central administration

but ı cannot view same database in sql management studio

what is the problem

how can i view it

Thanks

View 3 Replies View Related

Creating A Single View From 2 Existing Views

Aug 9, 2007

I have 2 views which contain the following fields:
EVENT,
WEEK,
SUBSCRIPTION,
QTY,
GROSS_AMOUNT,
SEASON

The 2 views differ by SEASON. I'm attempting to combine the 2 views in to a single view or table grouping by EVENT, WEEK and SUBSCRIPTION:

EVENT,
WEEK,
SUBSCRIPTION,
Q6 (qty of season 1),
A6 (gross_amount of season 1),
Q7 (qty of season 2),
A7 (gross_amount of season 2)


Below is my select command:

------

SELECT TOP 100 PERCENT
dbo.vw_SEASON06.EVENT,
SUM(dbo.vw_SEASON06.QTY) AS Q6, SUM(dbo.vw_SEASON06.GROSS_AMOUNT) AS A6,
SUM(dbo.vw_SEASON07.QTY) AS Q7, SUM(dbo.vw_SEASON07.GROSS_AMOUNT) AS A7,
dbo.vw_SEASON06.WEEK,
dbo.vw_SEASON06.SUBSCRIPTION

FROM dbo.vw_SEASON06 FULL OUTER JOIN
dbo.vw_SEASON07 ON dbo.vw_SEASON06.WEEK = dbo.vw_SEASON07.WEEK AND
dbo.vw_SEASON06.SUBSCRIPTION= dbo.vw_SEASON07.SUBSCRIPTION AND
dbo.vw_SEASON06.EVENT = dbo.vw_SEASON07.EVENT

GROUP BY
dbo.vw_SEASON06.EVENT,
dbo.vw_SEASON06.WEEK,
dbo.vw_SEASON06.SUBSCRIPTION

ORDER BY
dbo.vw_SEASON06.EVENT

-----

This creates the view but there are some issues. If an 'EVENT' exists in dbo.vw_SEASON07.EVENT and doesn't exist in dbo.vw_SEASON06.EVENT the value of the field 'EVENT' is set to NULL because the 'EVENT' name is returned from dbo.vw_SEASON06.EVENT. The same issue exists for 'SUBSCRIPTIONS' and 'WEEK'.

How can I create a single view/table that will include all the data from these 2 views without the NULL values in EVENT or SUBSCRIPTION?

Any help is appreciated!

View 7 Replies View Related

20 Sa Existing Connection

Sep 9, 2007



On executing the DMV dm_exec_session we got 20 connection by user sa.
On futher invetigation we got the below result for user sa


1 BACKGROUND sa . . NULL RESOURCE MONITOR
2 BACKGROUND sa . . NULL LAZY WRITER
3 SUSPENDED sa . . NULL LOG WRITER
4 BACKGROUND sa . . NULL LOCK MONITOR
5 BACKGROUND sa . . master SIGNAL HANDLER
6 sleeping sa . . master TASK MANAGER
7 BACKGROUND sa . . master TRACE QUEUE TASK

8 sleeping sa . . NULL UNKNOWN TOKEN
9 BACKGROUND sa . . master BRKR TASK
10 SUSPENDED sa . . master CHECKPOINT
11 BACKGROUND sa . . master TASK MANAGER
12 BACKGROUND sa . . master BRKR EVENT HNDLR
13 BACKGROUND sa . . master BRKR TASK
14 BACKGROUND sa . . master BRKR TASK
15 sleeping sa . . master TASK MANAGER
16 sleeping sa . . master TASK MANAGER
17 sleeping sa . . master TASK MANAGER
18 sleeping sa . . master TASK MANAGER
19 sleeping sa . . master TASK MANAGER
20 sleeping sa . . master TASK MANAGER
21 sleeping sa . . master TASK MANAGER




I do not understand why sa use to keep there connection.

Canu please help letting me know why sa keep these connections.

Regards
Sufian

View 3 Replies View Related

How Do I Add A Data Source View And Report Model To An Existing Project

Feb 22, 2007

I have an existing project with the data source and report folder with working reports. I need to create a model for other department members to use Report Builder, not Business Intelligence Developer Studio, to develop their reports from. How do I add a data source view and report model folder to the project so I can then create a view and model?

View 1 Replies View Related

An Existing Connection Was Forcibly Closed By Remote Host

Jun 26, 2007

Hi all
I have run a stranger issue:
I use ADO.NET 2.0 to access sql2000 database. during the whole process, I need stop sql server service which the program is connecting. my setup is like following:
1.Open a conection to access table and then close the connection;
2.restart sql server service ;
3.Re-open a connection to access table and then an exception was thrown out:
 A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed bythe remote host.)
4. try re-open a connection to access table and then no exception was thrown out.
I think this maybe related with connection pool. any guy know the detail, please give me a response. Thank you very much!
 

View 2 Replies View Related

An Existing Connection Was Forcibly Closed By The Remote Host

Feb 13, 2006

Hi,
I'm running a website using MSSQL 2000. Sometimes (not always) I get this error message on the website:
A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
I have also websites running with MySQL and those don't have this problem.I searched google but I couldn't find usefull information on this problem.
Someone who knows what's going on here ?

View 1 Replies View Related

TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host

Apr 29, 2006

We are getting a problem when the below error Log

Server: SQL Server 2005 and SP1.



Then, All the Web Servers will drop all connections and stop the network service. Later, the network service will start up automatically but all the before service is dropped.

We would like to know the error coming from?



Error Log

================

TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host



Event Type: Warning
Event Source: ASP.NET 2.0.50727.0
Event Category: Web Event
Event ID: 1309
Date: 4/29/2006
Time: 10:48:47 AM
User: N/A
Computer: 88DBWEB0
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 4/29/2006 10:48:47 AM
Event time (UTC): 4/29/2006 2:48:47 AM
Event ID: 77910e6688484582bb1c29808feef883
Event sequence: 128
Event occurrence: 13
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/24978983/Root/ph-3-127907437121075328
Trust level: Full
Application Virtual Path: /ph
Application Path: D:DB88ph
Machine name: 88DBWEB0

Process information:
Process ID: 1568
Process name: w3wp.exe
Account name: NT AUTHORITYNETWORK SERVICE

Exception information:
Exception type: SqlException
Exception message: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

Request information:
Request URL: http://88db.jobsdb.com/ph/Views/MediaUpload.aspx?PostID=50202&Type=I&panelid=postimagediv
Request path: /ph/Views/MediaUpload.aspx
User host address: 192.168.10.10
User: 50077
Is authenticated: True
Authentication Type: Forms
Thread account name: NT AUTHORITYNETWORK SERVICE

Thread information:
Thread ID: 15
Thread account name: NT AUTHORITYNETWORK SERVICE
Is impersonating: False
Stack trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at System.Web.SessionState.SqlSessionStateStore.DoGet(HttpContext context, String id, Boolean getExclusive, Boolean& locked, TimeSpan& lockAge, Object& lockId, SessionStateActions& actionFlags)


Custom event details:

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


View 10 Replies View Related

Framework 2.0 Changes - TCP Provider, Error: 0 - An Existing Connection Was Forcibly Closed By The Remote Host.

Nov 14, 2005

If you connect to a server and open a query in SQL Managment studio (2005) and looses connection and then regain the connection, when you try to run the query it gives me a "TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host."   This happens against both 2005 and 2000 servers.   If I re-run the query it works.   However, this happens in our VB.NET app as well for clients with Wireless connections.   So, something has changed in Framework 2.0 regarding this, does anyone know how to tell the client to not throw this error and just try connecting the server instead which will work?  

View 105 Replies View Related

An Error Occurred While Receiving Data: '10054(An Existing Connection Was Forcibly Closed By The Remote Host.)'.

Jan 3, 2006

What does this error mean? I get this in the transmission_status column of  sys.transmission_queue

An error occurred while receiving data: '10053(An established connection was aborted by the software in your host machine.)'.

Also, does the number in this message correspond to error 10053 in sys.messages?

Thanks

 

 

 

View 3 Replies View Related

Accessing A DataSet's Connection String

Dec 31, 2007

I am using Visual Studio's Report creator and I'm trying to use a custom built assembly that has business logic in it. I would like to evoke one of it's methods. One of the parameters for the constructor of MyClass is a connection string. Is there any way to access one of the report's DataSet's connection string so I can pass it on to other functions in my custom assembly? Thank you for your help.

View 2 Replies View Related

2 DataSet From Xml DataSource, And Parameter ...

Apr 5, 2007

Hi !!!
I have a problem, I don't know how to do...
I have 2 dataset from 2 differents XML dataSource...
I want the result of one dataSet to be a parameter for the second !

I try to add a parameter in param tab, with expression, I choose DataSet and
=Sum(Fields!ID.Value, "DataSetID")
but when I execute the query, the prompt for the param appear, but the value of id was <NULL>...

Someone have ideas to resolve this problem ?
thank you for your help !

View 1 Replies View Related

Can Someone Please Tell Me How To Go About Changiing A Datasource/dataset Schema?

Apr 17, 2007

I have managed to cobble up a VS2005 PPC app that has 10 or so tables in it. Of course when I started binding to the tables in my app, pretty soon I ran into an error I had made defining a datatype for a column in one table. Single instead of string. I have spent most of the day trying to modify something to change this column datatype. No luck.



1. Seems you cannot edit the schema in VS2005 to modify the datatype. After messing around, now the project will not open at all.

2. Cannot get the ADS wizard to go anymore, so cannot make .mdb schema change and pull down updated column/table.

3. Thought SQL Server 2005 had a tool you could just open up a .sdf file and change the schema. No luck. At least no intuitive way showed itself after I installed it.

4. Thought SQL Server Express Editition could open such a .sdf file and modify it so installed it. Again, could not figure out how this works either.



I suppose I could start over from scratch and create a new app datasource/dataset in VS2005, but I have done that so many times before, I am getting crabby thinking about doing it again. There must be a better way??? Isn't there?



Thank you.

View 1 Replies View Related

ER Daigrarm From Existing DB2

Feb 19, 2004

Hi,
I need to create ER diagram from Existing DB2 database into SQL Server 2000.
I'm using System Architect. Please give your advice regarding this.
Thanks,
Ravi

View 1 Replies View Related

Detaching Non-existing Db's

Jan 9, 2006

Hello all

From time to time I receive mssql server databases to export from our customers. Last time I deleted the database files without detaching them. How can I detached them, since I need to atach new ones with the same name?
I'm using MS SQL Server 2003 and the databases are 6.5.

Thank you all.

Regards.

View 7 Replies View Related

Co-Existing With MSDE

Dec 19, 2006

Can SQL Express reside on the same server as MSDE and both run at the same time (different apps)?

I have one app that runs on MSDE and a new to be developed app by a vendor that needs SQL Express.



Thanks

JB

View 1 Replies View Related

No Existing Word... How?

Jun 25, 2007

I am rendering an Association Rules on Report Services. How do I make to filter the word "Existing", just like example below? I want to show attribute name only.



Pneu ML Road = Existing, Sport-100 = Existing -> Road Tubo de Pneu = Existing



to



Pneu ML Road, Sport-100 -> Road Tubo de Pneu



By the way I am using this code:



SELECT NODE_DESCRIPTION,ROUND(NODE_PROBABILITY,2)AS Probabilidade,ROUND(MSOLAP_NODE_SCORE,2)AS Importancia
from [Association].CONTENT
where NODE_TYPE=8

View 3 Replies View Related

How To Change An Existing UID To Autonumbering?

Jul 13, 2006

Hullo!Doubt it matters too much, but I'll just start off by saying that I'm using C# ASP.NET 2.0 in Visual Studio 2005.I currently have a UID field entitled "ID", and I'd like to make it autonumbering so that users can input stuff into it through a simple web interface and not have to worry about the user's ID.Anyone know how I could go about doing this?  I can't seem to find a way through VS2005's GUI, and I can't seem to find anything on the internet about doing it through an SQL statement.Thanks!

View 1 Replies View Related

New Value To A Existing Session Problems....

Jul 26, 2006

 
Ok, I am trying to teach myself asp.net and sql server. The problem I am having now is I want to update the session that already exists.  I have a global session (I think) that is UserEmployeeID, it is inputed when a user selects the select link on the search page which will redirect to an info page. I want to change the employee to a different employee, well I am updating the database well, no that is a lie it doesn’t that is another error, but anyway I try to update it to the new EmployeeID and it will not update…
 
Partial Class Assignment
    Inherits System.Web.UI.Page
 
    Protected Sub UpdateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UpdateButton.Click
 
        Dim empID As Integer
        Dim nbrID As Integer
        Dim equid As Integer
        Dim UpdateQuery
        Dim empequipid As SqlCommand
        Dim mySQLConnection As String = System.Configuration.ConfigurationManager.ConnectionStrings("DBConnectionString").ToString
        Dim myConnection As New SqlConnection(mySQLConnection)
        myConnection.Open()
 
        empID = CType(Session("UserEmployeeID"), Integer)
        equid = CType(Session("UserEquipID"), Integer)
 
 
        If CType(empID, Integer) = Nothing Then
            empID = (DropDownList1.SelectedValue)
            Response.Write("Insert: " & empID)
            'Response.End()
            Me.SqlDataSource1.InsertCommand = "INSERT INTO [EMPLOYEES_EQUIP] ([EquipID], [EmployeeID]) VALUES " & equid & " " & empID & ""
            Me.SqlDataSource1.InsertCommand = SqlDataSourceCommandType.Text
            Me.SqlDataSource1.Insert()
        Else
            empequipid = New SqlCommand("Select EmpEquipID From EMPLOYEES_EQUIP Where EmployeeID = " & empID & "  AND EquipID = " & equid & " ", myConnection)
            empequipid.CommandType = CommandType.Text
            nbrID = empequipid.ExecuteScalar
 
            ' Response.Write("Select EmpEquipID: " & nbrID)
 
            empID = (DropDownList1.SelectedValue)
 
            'Response.Write("<br>Update EmployeeID: " & empID)
 
            Me.SqlDataSource1.UpdateCommand = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " "
            Me.SqlDataSource1.UpdateCommand = SqlDataSourceCommandType.Text
            Me.SqlDataSource1.Update()
 
            UpdateQuery = "UPDATE EMPLOYEES_EQUIP SET EmployeeID = " & empID & " WHERE EmpEquipID = " & nbrID & " "
            'Response.Write(UpdateQuery)
            'Response.End()
        End If
        Session("UserEployeeID") = (DropDownList1.SelectedValue)
        'Response.Write("<br>UserEmployeeID Session: " & Session("UserEmployeeID"))
 
 
        '-- Turn On Results Table
        resultstable.Visible = True
        '-- Hide Form by hiding table.
        maintable.Visible = False
        'clientSearch.Visible = False
 
    End Sub
End Class
 
I am also getting an error at Me.SqlDataSource1.Update() saying incorrect syntax near ‘0’ but there isn’t a 0??? I am confused…

View 1 Replies View Related

I Want To Move An Existing Table From Another

May 28, 2007

I want to move an existing table from another.
Example
B.mdf  dbo.xx   to C.mdf  dbo.xx
B.mdf dbo.xx   has records   -  I created a script and install the script for C.mdf dbo.xx  
C.mdf dbo.xx  is empty - 
All I need now is to populate the records from B.mdf dbo.xx to the empty  C.mdf  dbo.xx
I was telling I could do a cut and paste to copy the dbo.xx  
Thank you in advance.
~  Peaches ~

View 4 Replies View Related

Store Existing SQL Database Through .Net

Oct 12, 2007

 
Hi
Anyone Knows
I want to store SQL 2005 Existing Database into SQL Server Through .Net.if i give Database Name in .Net and that Database automatically stored in SQL Server 2005.P(including that Existing Database Tables and Stored Procedures).Please Help me.
 
Tamil

View 2 Replies View Related

How To Add 3 Days To The Existing Date

Oct 23, 2007

Bottom is my table structure. please some one can give me the sql code to add 3 days to the existing date.  
SemesterID intSemesterLongID varcharSemesterIdentifier charSemesterIdentifierName varcharSemesterName varcharSemesterStart datetimeSemesterEnd datetimeSemesterNameAlt varcharEnrollmentDeadline datetimeRegistrationStart datetimeRegistrationEnd datetimeLengthInWeeks varcharBulletinStartDate datetimeBulletinEndDate datetimeClassroomStartDate datetimeClassroomEndDate datetimeFacClassStartDate datetimeFacClassEndDate datetimePlanningStart datetimePlanningEnd datetimeGoToTeach datetimeTOButAppears datetimeTOButDisappears datetimeSignature datetimeTOButDue datetimeBookListDue datetimeProfAccess datetimeExamDue datetimeSCGDue datetimeGradesDue datetimeExtGradesDue datetimeTOExt datetimeSessionPlanning datetimeTODue datetimeSCGStart datetimeTOExpire datetimeSRPTOCDue datetimeSRPCopyDue datetimeSRPCCCFormDue datetimeTOID intSemesterIdentifierID intCode varcharTitleIVDescription varcharCreatedBy varcharModifiedBy varcharDateCreated datetimeDateModified datetime

View 1 Replies View Related







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