How To Modify Data?

Jun 18, 2007

How do I modify data in a sqlDataSource object (like inserting records, editing, deleting) similiary to how I modify data in a GradView using a DataList or repeater? I want to be able to have my own EditTemplate and be able to edit say four fields while I'm only viewing like two of them in the datalist/repeater.

<asp:DataList ID="DataList1" runat="server" DataKeyField="GameId"

DataSourceID="SqlDataSource1" RepeatColumns="1">

<ItemTemplate>

<%# Eval("field1") %><%# Eval("field2") %>....

</ItemTemplate>

<EditTemplate>......</EditTemplate>



</asp:DataList>

 

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>"

SelectCommand="SELECT ...."></asp:Sql....>

 

When I'm trying to add a edit-button (<asp:Button runat="Server" ID="EditButton" Text="Edit" CommandName="Edit" />) and click it nothing happens....What is missing?

View 1 Replies


ADVERTISEMENT

Modify String Data Base On Data In The Table

Jun 17, 2004

I need to get rid of the first char of data in a field f1 (in sql server)

I tried to use:

update myTable
set f1= substring(f1,1,f1.Len -1)

and get error "The column prefix 'f1' does not match with a table name or alias name used in the query.

Could anyone help? Thanks.

View 2 Replies View Related

How To Modify Some Data Without Changing Everything

Oct 17, 2002

Please HELP!

I need to UPDATE a column by removing only the first occurance of $$sp;. I use the following to get an idea of what I have:

SELECT Reporting_Title_Html FROM Lab_Test Where RTRIM(Reporting_Title_Html)='$$sp;'
Reporting_Title_Html
------------------------------
$$sp;
$$sp;
$$sp;
$$sp;
$$sp;Thyroid maintenance required;$$sp..........

Get 5 Records....One record has multiple occurances of $$sp throughout the Reporting_Title_Html column.

I thought I could do:
Update Lab_Test Set Reporting_Title_Html=' ' Where RTRIM(Reporting_Title_Html)='$$sp;'

But I can't lose the trailing data from record #5. This is just a small sampling of what I'm trying to fix.

Any Ideas???

I've thought about REPLACE but that would replace all the $$sp's and I only want to change the very first one from $$sp to ' ' --> blank

View 1 Replies View Related

How To Modify One Colomn's Data On One Click?

Jan 8, 2008

Hello every body
 
i am using a view grid to display data
the viewgrid is tied to an sqldatasource control
 i want to give the user the ability of modifing data by colomn instead of by row
 how could i do ?
 
ghassan

View 2 Replies View Related

Trying To Modify Some Column Data In Some Rows

Dec 31, 2005

Trying to change some of the rows in a table specifically one column.
column type is varchar
ex. of data
current desired
$345,434.0 345434.0 (stripping out of $ & commas)
435.0 leave as is
general txt leave as is

having trouble updating data in table
tried using temp table, but update command make it so it won't see table

ex. piece of code
update currency_conversion
set currency_varchar = cast (cast (currency_varchar as money)as varchar)
select * from currency_conversion
where substring (currency_varchar from 1 for 1) = '$' ;

sql 2000
trying to do from query analyzer

thanks
glnsk8ter@yahoo.com


thanks
Glenn

View 2 Replies View Related

How To Modify A Column Without Changing Data

Feb 26, 2007

Hi,

I was wondering how to modify a column's properties, like its datatype or length.

I know I'm supposed to do something like this:
ALTER TABLE MyTable ALTER COLUMN MyColumn int(20)

My main concern is, what will the database do to all the data in the column, if the column used to be, say nvarchar(50)? Will I lose the data in the column if I change the datatype? And what if I had data in this column that was longer than 20 characters? Will the data now be truncated? What can I do to make sure that nothing happens to the data once I change the datatype?

Any help would be greatly appreciated! Thanks! =)

View 5 Replies View Related

Modify All Data Within A Specific Column

Aug 15, 2007

I have a column (PERIMAGE_PATH) in my table. The data in this column is imported from a fixed width text file and looks like the following:

07J06274
05J03254
04J11245

I need to modify the data in the column to look like this:

..images7J06274.jpg
..images5J03254.jpg
..images4J11245.jpg

How can I do this?

Thanks for all your guys' help. This is the last question for the day. I promise

View 8 Replies View Related

Modify VB6 App To Use SQL 2005 Data Instead Of Access 2003

May 19, 2007

I have an existing VB6 application which uses an Access 2003 backend datafile, however, I would now like to modify this to use an SQL 2005 datafile, but I don't know how to go about this or the implications when the application is installed on another machine.



The code I use for accessing the Access 2003 file is below, I want to convert this code to access an SQL 2005 datafile instead, can anyone give me some pointers on the best way to go about this, or code sample.



Dim rst As ADODB.Recordset
Dim dbs As ADODB.Connection

Set rst = New ADODB.Recordset
Set dbs = New ADODB.Connection

dbs.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
strNetworkLocation & "MyDB.mdb; JET OLEDBatabase Password=MyPassword"

With rst
.Open "SELECT TOP 1 * FROM tblProject WHERE pjProject = '" & _
lstProject.Text & "'", dbs, adOpenKeyset, adLockOptimistic
strDrawingRef = !pjStartupDrawing
strProject = lstProject.Text
frmMain.OpenFile
.Close
End With


Thank-you in advance for any help you may provide.



Mandy

View 4 Replies View Related

Open Table With Query To Modify Data

Jul 23, 2007

In Enterprise Manager, I would right click on the table, choose Open Table and Query where I could select specific records and (most importantly) could alter data in a record by deleting the text, adding or over-typing.



In 2005 Server Management Studio I just cannot figure how to do this. I'm guessing that I need the 'Script Table as' option but then what?



I have managed to open selected data using the New Query and then Design Query in Editor, but the results only appear in a kind of view form and I cannot seem to alter any of the data entries, I get dotted lines around the selected field.



Please help, it seemed so much easier in 2000!

View 7 Replies View Related

How Do I Modify Union Data Flow Task Property?

Apr 4, 2008

I've created a Union All data flow task which unions string fields from a couple of queries. I found that I needed to increase the length of the string field in the queries. Increasing the length causes an error in my Union All task. I can't seem to find a way to change the property of the fields in the Union All task. Most of the other data flow tasks have an advanced editor where I can change the length or type of the fields on the input and or output. I can't seem to find this for the Union All task.

Is there any way short of deleting the Output column and recreating it? (I like the order of my original output columns)

Thanks,
Bill Webster

View 6 Replies View Related

How To Access Or Modify Local Subscriptions Data In Merge Replication

Apr 3, 2007

Hello,



If I want to access or modify my local subscription data(not the configuration) how can I do that(from sql server 2005 or from asp.net)? Also can i update directly to the local subscriptions data or do I need another layer which will update from a table for example??



Thank you



Salah

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

Make Sql Function To Modify Data Like Sql Procedure To Improve Code Structure And Readability.

Aug 27, 2007

Now Sql Function can not modify data as Sql Procedure like other database, it's very troublesome at most case!
in most case, Sql Function is used to improve code structure then it can be maintanced easy! BUT only because it can not modify data, there are 2 troublesome way:

1. Make all callers in the path from Sql Functions to Sql Procedure. and the coder will cry, the code will become very
confusional , and very difficult to maintance.

2. Divide the Sql Function into a thin CLR wrapper to call a Sql Procedure, can only use another connection, BUT can not be in the same transaction context And the code is ugly and slow.

You should not give limitation to Sql Function, should just limit the using context of Sql Function!

The sql code is more difficult to read and maintance than norm code(C#), then the improving code structure and readability should be one of your most important task, that's why microsoft!


View 6 Replies View Related

Integration Services :: How To Capture Changed Data Of 2 CSV Files And Modify It In Oracle Database

May 6, 2015

I need reflecting changes of csv file in oracle DB. Suppose,  I load single csv file in oracle DB which contains 10 rows. After some time, I have loaded another CSV file which has the modified row of the previously loaded csv file. So, how can I capture the CSV changes and how it is going to get reflected in oracle DB?There is no unique column in csv file to identify particular row.

View 3 Replies View Related

How To Set User Who Can't Modify Any StoredProc And Data In Tables But Can Read Data In Tables And Any StoredProc ?

Jul 13, 2007

Please give me advise ครับ
 

View 1 Replies View Related

How To Allow Non-sa To Modify A Job?

Jan 15, 2008

Is there a way to allow non-sysadmin to modify jobs they don't own from the management studio interface?

Even the most privileged SQLAgentOperatorRole does not allow this...

Thanks

View 10 Replies View Related

Need To Modify This SQL...

Oct 22, 2007

The following was not written by me but I need to modify it and I am definitely no expert in SQL. It returns a list of files that a user is allowed to access based on whether or not they belong to a specific user group and that group has been granted access to the file.

Here is the SQL as it is currently:

SELECT a.ID, a.Title, a.Description, a.FileName, a.DateCreated, a.DateModified, u.UserName, a.UserID, COUNT(ga.AnswerFileID) AS ShareCount

FROM
User AS u INNER JOIN

AnswerFile AS a LEFT OUTER JOIN

GroupAnswerFile AS ga LEFT OUTER JOIN

GroupUser AS gu
ON ga.GroupID = gu.GroupID ON a.ID = ga.AnswerFileID ON u.ID = a.UserID

GROUP BY a.ID, a.Title, a.Description, a.FileName, a.DateCreated, a.DateModified, a.UserID, u.UserName, gu.UserID

HAVING (gu.UserID = 2)

UNION

SELECT a.ID, a.Title, a.Description, a.FileName, a.DateCreated, a.DateModified, u.UserName, a.UserID, 0 AS ShareCount

FROM AnswerFile AS a INNER JOIN User AS u ON a.UserID = u.ID

WHERE (a.UserID = 2) AND (a.ID NOT IN SELECT AnswerFileID FROM GroupAnswerFile))

I need to modify this code to add an additional check. I have added a file that allows specific users to be granted access to files. It is called AnswerFileUser and contains AnswerFileID (the file) and UserID (the user that has been given access). I need the query to return as part of the results those files where a user has been given access regardless of their group or group access. I hope this all makes sense. Thanks for your help!

Oops - this is SQL 2005...

View 1 Replies View Related

Can We Modify Views

Jan 2, 2007

give me answer and what's the difference between view and stored procedure

View 2 Replies View Related

Modify The Timeout Value

May 18, 2007

How do you change the time out value for a specific connection? I'm having problems when I connect to SQL Server from my website and I want to test if this would help.

View 2 Replies View Related

HOw To Modify DTS Package?

Jul 10, 2007

I have a DTS was created by another programmer which is for move online Database to a offline Database
and now I have to modify it
the DTS package
have 1 Source DB
and 63 distinateDB
between SourceDB and DistinateDB are "Black Line"
and almost of DistinateDB have a green line between a  Task ( excute SQL work)
 -- some of SQL work are  Delete Table and some are Truncate Table
and now I have to add some limits for the DTS
1. First, move all the  Data From online Database to Offline Database
2. to Delete Data from online DB  , Online Database will only keep Data for 6 months ( older than 6 months have to delete except table A and table B)
 can you help me? or tell me where have a reference information I can take a look... have no idea how to modify this DTS package..
 
thank you very much
 

View 3 Replies View Related

Can You Please Help Me To Modify My Sql Query?

Oct 30, 2007

my column UPdateTime , Type DateTime
 
UPdateTime
---------------------
2007-04-18 00:00:00.0002007-08-17 00:00:00.0002007-09-05 00:00:00.0002007-09-05 00:00:00.000
 
 
I write a Sql Query for select  UPdateTime between 2007/09/01~ 2007/09/30
select * from ZT_Master where TDateTime < DateAdd(Month,-1,GetDate())
the result return all the column.. why?
 
thank you

View 5 Replies View Related

Need To Modify Sql Query

Mar 12, 2008

I have the following query that produces this:
1 0 Arts & Entertainment6 1 Arts & EntertainmentDance2 1 Arts & EntertainmentMovies9 0 Automotive10 0 Business11 0 Cancer12 0 Communications3 0 Computers13 3 ComputersE-Learning4 3 ComputersHardware14 3 ComputersJava16 3 ComputersLink Popularity17 3 ComputersMicrosoft.net15 3 ComputersRSS5 3 ComputersSoftware7 0 Real Estate8 7 Real EstateFinance
 Here is the query:
SELECT tblArticleCategory.ACategoryID, tblArticleCategory.AParentID, ISNULL(Parent.ParentCategory + '', '') + ISNULL(tblArticleCategory.ACategoryname, '') AS ACategory
FROM tblArticleCategory FULL OUTER JOIN(SELECT ACategoryName AS ParentCategory, ACategoryID
FROM tblArticleCategory AS tblArticleCategory_1
WHERE (AParentID =0) AND (AActive = 1)) AS Parent ON Parent.ACategoryID = tblArticleCategory.AParentID
WHERE (tblArticleCategory.AActive = 1)
ORDER BY ACategory
How do I modify this so that just the category name is returned and not the parent cetegory.  In other words, everything shows up just once. Arts and Entertainment, once, then on the next line Dance, then Music then the next parent category which is automotive.
Here is the table:
ACategoryID int UncheckedACategoryName nvarchar(150) CheckedADescription nvarchar(300) CheckedAParentID int CheckedAActive bit Checked  Unchecked

View 6 Replies View Related

Modify The SQL Of A SQLDatasource

Apr 5, 2006

When you first come into the web page I want to exam the querystring and the modify the SQL Statement accordingly in a SQLDatasource.What is the right event of the SQLDataSource to modify the SQLDataSource.SelectCommand = MySQLString property?Thanks

View 3 Replies View Related

Modify Publication In SQL 7.0 . Please Help !!

May 14, 2002

Hello ,

I have a problem with a publication which is a transactional replication on SQL Server 7.0 .
I want to add stored procedure to the existing publication along with the tables . But the Enterprise manager does not allow to select or check the box
against the required stored procedure although it displays when i right click on the publication and select proeprties .

Can i have some help in this regard ? Does anybody knows to add a stored procedure by means of a query .

Is there any other way to modify publication in SQL Server 7.0 although it is possible in SQL Server 2000 .?

Many thanks in advance.
Sandra .

View 1 Replies View Related

Help Need To Modify Procedure

Jul 20, 2002

Have a script that should extract data if :-

1) Mothly :-
-payday is equal to @today
-pay frequency is = 1
-payday between 1-31

2) Weekly
-payday is between 1-5 ( 1 =Monday,2 =Tuesday,3=Weds,4=Thurs,5=Friday)
-payfrequency is = 2

3) Fortnightly
-after two weeks
-payfrequency =3


How do l modify this procedure to be able to extract using the listed conditions ? Need help

CREATE Procedure Collections_Cats
AS
BEGIN

Declare @today int
Set @today = (SELECT Day(GETDATE()))

DECLARE Collections_Cats_Cursor
CURSOR
FOR
SELECT distinct
n.loan_No AS Loan_No,
n.customer_No AS Customer_No,
c.first_name AS First_name,
c.second_name AS Second_name,
c.surname AS Surname,
c.initials AS Initials,
b.Bank_name AS Bank_name,
br.branch_code AS Branch_code,
d.bank_acc_type AS Bank_acc_type,
pay_sheet.pay_frequency AS Pay_Frequency,
n.monthly_Payment AS monthly_Payment,
pay_sheet.payday AS payday
FROM Transaction_Record tr

INNER JOIN
Loan n ON tr.loan_No = n.loan_No
INNER JOIN
Customer c ON n.customer_No = c.customer_no
INNER JOIN
Bank_detail d ON c.customer_no = d.customer_no
INNER JOIN
Branch br ON d.Branch = br.Branch
INNER JOIN
Bank b ON br.Bank = b.Bank
INNER JOIN
pay_sheet ON c.customer_no = pay_sheet.customer_no
WHERE Pay_sheet.Payday = @today AND pay_sheet.pay_frequency =1

Order by l.loan_No

OPEN Collections_Cats_Cursor

-- Perform the first fetch.
FETCH NEXT FROM Collections_Cats_Cursor

-- Check @@FETCH_STATUS to see if there are any more rows to fetch.
WHILE @@FETCH_STATUS = 0
BEGIN
-- This is executed as long as the previous fetch succeeds.
FETCH NEXT FROM Collections_Cats_Cursor
END

CLOSE Collections_Cats_Cursor
DEALLOCATE Collections_Cats_Cursor
END;
GO

View 1 Replies View Related

Modify Replication Job

Apr 20, 2004

Hi,
sql server 7

i have a replication job going on for one particular table from one server to another
now i have added two new columns in source and replication works fine.
once i add these two new columns in destination the replication is failing.

i went to properties of the publisher and select the filter columns where i can find all the columns checked except the two new columns when i try to select these two its not responding pls help me in this.

pls help me in modifying this replication.

TIA
hastal

View 2 Replies View Related

Object Last Modify

Apr 16, 2008

Hi Guys,

I am using Sql server 2005, i am trying to find out all the tables that modified recently. i cant find any last modified date!!.

My situation is; i have altered so many tables, usually when i do alter i save the sql file for doing the same alteration in the production database. but somehow i lost the scripts and i am not sure what are the tables that i have modified and what is new.

i dont want to overwrite the whole database.

can anybody know how to get only the difference.

thanks

View 2 Replies View Related

Modify Trigger

Jul 26, 2007

I have converted Access database to sql express. Access Database had AutoNumber FIelds for which trigger was generated by Upsizing wizard.

Now when I import data from client the autonumber field value changes because trigger is fired which distroys all links

I want to modify trigger so that it generates new number only when it is not supplied in a insert command.

Please help. Code is given below. Also suggest how to save because when I use save, it asks for a new .sql file name and a new file is generated instead of modifying the same trigger



set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[T_AcControlLimit_ITrig] ON [dbo].[AcControlLimit] FOR INSERT AS
SET NOCOUNT ON
DECLARE @randc int, @newc int /* FOR AUTONUMBER-EMULATION CODE */
/* * RANDOM AUTONUMBER EMULATION CODE FOR FIELD 'IntAcControlCode' */
SELECT @randc = (SELECT convert(int, rand() * power(2, 30)))
SELECT @newc = (SELECT IntAcControlCode FROM inserted)
UPDATE AcControlLimit SET IntAcControlCode = @randc WHERE IntAcControlCode = @newc

View 1 Replies View Related

Modify Index

Jul 20, 2005

Hi all,I have been left to modify an old unique index, which no longer works,as the two fields, which were used, are no longer unique. I’ve found twoothers that are unique. But as I’m new to this I need some advice first.What happens if one table inserts from another (the second containingthe index). However if there is a duplicate will the records which arenot duplicates be inserted? How could I insure this?ThanksSam*** Sent via Developersdex http://www.developersdex.com ***Don't just participate in USENET...get rewarded for it!

View 4 Replies View Related

Modify ID Column

May 8, 2007

I initially modified the column 'ID' from not allowing NULL to allow, and saved it. But now I will like to change it back to 'not allow'. But it gives me the following error message when I try to save my changes:

'Pages' table
- Unable to modify table.
Cannot insert the value NULL into column 'ID', table <databasename>.Tmp_Pages'; column does not allow nulls. INSERT fails.
The statement has been terminated.

Is there a way I can work around this?


Using sql 2005

View 1 Replies View Related

Modify Rdl During Runtime

May 8, 2007

Hi



I am trying to create a report with unknown number of report items. (as I dont know how many columns the stored proc is going to return).Is there a way to create these type of reports using SSRS other than creating the rdl programatically using vb.net or c#?



Let me know if I am not clear.



Thanks in advance.

View 1 Replies View Related

How To Modify Xml Content In SQL 2000

Jan 14, 2008

HiI have developed a sql procedure for updating some xml content using SQL 2005 xQuery features.For example:Declare @xmlContent = '<books><book name="asp"/>< book name = "sql"/></books>'--Now I want to add attribute "book_id" to the xml content.SET @xmlContent.modify('insert attribute book_id{"1" } into (/books/book[@name="asp"])[1] ')SET @xmlContent.modify('insert attribute book_id{"2" } into (/books/book[@name="sql"])[1] ')SELECT @xmlContent--OUTPUT will be<books><book name="asp" book_id="1"/><book name="sql" book_id="2"/></books>QUESTIONQ1. Do we have any extension or plugin such that this SQl 2005 xquery feature can be incorporated in SQL 2000?Q2. If the answer for Q1. is no (as I expect), then do we have any TSQL feature in SQL 2000 for modifying xml content?I found all examples in SQl 2000 related with "openxml" function which performs the select kind of operations only. Like selecting data in XML format OR converting xml data in to tabular format. But I couldn't find any xml modification TSQL in SQl 2000 which can add element/attributes or change values.one workaround could be to consider xml content as string and use string functions to modify the content.But is there any more sensible approach available in SQL 2000?    

View 1 Replies View Related

How To Modify My Stored Procedure So That...

Aug 2, 2004

Hi,
Below is the SP that I want to modify it such that it does another thing apart from what its doing now. I want to to delete all the records corresponding to the BpDate value before this insert happens. by meaning deleting all the records, I meant to say delete all records where BpDate = @BpDate and SiteCode = @SiteCode.


CREATE PROC CabsSchedule_Save

@JulianDate smallint,
@SiteCode smallint,
@BpDate smallint,
@CalendarDay smallint,
@BillPeriod smallint,
@WorkDay smallint,
@CalDayBillRcvd varchar(30),
@Remarks varchar(50)

AS


INSERT INTO
CabsSchedule(JulianDate, SiteCode, BpDate, CalendarDay, BillPeriod, WorkDay, CalDayBillRcvd, Remarks)
VALUES
(@JulianDate, @SiteCode, @BpDate, @CalendarDay, @BillPeriod, @WorkDay, @CalDayBillRcvd, @Remarks)
GO




Any help will be appreciated.

Thanks,

View 1 Replies View Related







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