|
Hi! Just a basic question but I don't know the answer =)
Please help
So I have a stored procedure with 2 select query
SELECT A,B FROM table1
SEleCT C,D FROM table2
In my typed dataset, how do I retrieve values in table2 using da.Fill() or should I be using another code for this?
da.Fill(dt);
when I can't use somethign like da.Fill(dt2);
Thank you very much.
Gerri
|
|
|
|
|
you need to fill a dataset with the output from the stored procedure
so:
dim ds as dataset
da.fill(ds)
then the dataset will have 2 tables in it (normally)
and you can select the 2 tables by there index
dim dt1 as datatable = ds.tables(0)
dim dt2 as datatable = ds.tables(1)
sorry for the vb.net code but should be easly translated
hope this helps
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
Thank you. I would just like to ask. I have a Report.xsd file and uses this:
DataAccess.dsReportManagementTableAdapters.rpt_RetrieveTableAdapter da = new DataAccess.dsReportManagementTableAdapters.rpt_RetrieveTableAdapter();
DataAccess.dsReportManagement.rpt_RetrieveDataTable dt = new DataAccess.dsReportManagement.rpt_RetrieveDataTable();
da.Fill(dt);
How come my Fill() doesn't take a DataSet as a parameter?
Thank you.
Gerri
|
|
|
|
|
because you don't use a dataadapter but a tableadapter
from the looks of it you are trying to extract data from a xml file (on a side note xml isn't the ideal way for datastorage) I have never tryed this before but look of you cant find a xmldataadapter (or somthing like that) normally that should accept a dataset as parameter
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
|
|
|
|
|
Please assist me in inserting special characters into a sql table whose column datatype is set to varchar. I actually developed a VB script which extracts data from xml file and inserts into sql database. In the xml file i have data where description of a field has text like phone ® (i.e text representation of registered trademark symbol). This is causing error when parsing the xml file and it says ERROR: Reference to undefined entity 'reg'. Any help would be appreciated.
|
|
|
|
|
why don't u change column DB type to nvarchar !! 
|
|
|
|
|
I have a sql statement wich gets the columnnames from several table by simply selecting nothing and putting that into a datatable (vb.net) off wich I read the columns
it works fine with one exception
when I have the same columnname more than once an number is added behind the column name
for instance if I have the columnname 'country' twice I will get 'country' and 'country1'
is there anyway to force it to display 'project_country' and 'client_country' or something like that so that I know from wich table the column is comming.
I use select * so giving the columns a unique name in the select statement is impossible. I use the select * because there is the posibilaty that a column is added after deployment of the main programme. Not using the select * would mean I would have to alter the sqlstatement to include this column and that would defeat the whole purpose of the programme I'm currently creating.
any help would be appriciated
after further investigation I found out that this is a vb.net problem so could an admin please move this post there, thank you
If my help was helpfull let me know, if not let me know why.
The only way we learn is by making mistakes.
modified on Wednesday, January 09, 2008 10:37:55 AM
|
|
|
|
|
Follows are the query which returns Budget, FortheMonth, YeartoDate, ProjectToDate column through subQuery....Which i use column in subQuery it will not sum/Calculate the amount when i hard code values which are in VW_FN_ANASTUDYSETUP.RootIDs column then it calculate....please guide me in my query...thanks
SELECT ANA_ID, RootIDs, ANA_PARENT_ID, DESCRIPTION, BUD, FORTHEMONTH, YEARTODATE, PRJTODATE, ISNULL(BUD, 0) - ISNULL(PRJTODATE, 0) AS BLCOMP
FROM (SELECT ANA_ID, RootIDs, ANA_PARENT_ID, DESCRIPTION,
(SELECT VW_FN_ANASTUDYSETUP.Formula * SUM(b.bamnt) AS BUDGET
FROM FN_ANASTUDYSETUPLINEITEMS a INNER JOIN
VW_FN_gldbud b ON a.MAINCODE = b.MAIN AND a.DETAILCODE = b.Detail AND a.CCTRCODE = b.CCTR
WHERE (a.ANA_ID IN (VW_FN_ANASTUDYSETUP.RootIDs))) AS BUD,
(SELECT VW_FN_ANASTUDYSETUP.Formula * SUM(CASE WHEN b.credit = 1 THEN - b.glamnt ELSE b.glamnt END) AS FORTHEMONTH
FROM FN_ANASTUDYSETUPLINEITEMS a INNER JOIN
VW_FN_glacnt b ON a.MAINCODE = b.MAIN AND a.DETAILCODE = b.Detail AND a.CCTRCODE = b.CCTR
WHERE (a.ANA_ID IN (VW_FN_ANASTUDYSETUP.RootIDs))) AS FORTHEMONTH,
(SELECT VW_FN_ANASTUDYSETUP.Formula * SUM(CASE WHEN b.credit = 1 THEN - b.glamnt ELSE b.glamnt END) AS YEARTODATE
FROM FN_ANASTUDYSETUPLINEITEMS a INNER JOIN
VW_FN_glacnt b ON a.MAINCODE = b.MAIN AND a.DETAILCODE = b.Detail AND a.CCTRCODE = b.CCTR
WHERE (a.ANA_ID IN (VW_FN_ANASTUDYSETUP.RootIDs))) AS YEARTODATE,
(SELECT VW_FN_ANASTUDYSETUP.Formula * SUM(CASE WHEN b.credit = 1 THEN - b.glamnt ELSE b.glamnt END) AS PRJTODATE
FROM FN_ANASTUDYSETUPLINEITEMS a INNER JOIN
VW_FN_glacnt b ON a.MAINCODE = b.MAIN AND a.DETAILCODE = b.Detail AND a.CCTRCODE = b.CCTR
WHERE (a.ANA_ID IN (VW_FN_ANASTUDYSETUP.RootIDs))) AS PRJTODATE
--(a.ANA_ID IN (0000000012,0000000013,0000000014,0000000015))) AS PRJTODATE
FROM VW_FN_ANASTUDYSETUP
WHERE (LEVEL_ID = '3') AND (BA_ID = '5')) Q_Main
|
|
|
|
|
how to define a result for accessing the select statement from the sp;
|
|
|
|
|
jagadeeshkumar2106 wrote: how to define a result for accessing the select statement from the sp;
What do you mean 
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Are you talking about storing the records to a dataset?
|
|
|
|
|
Hi,
I am using two temp tables of same name e.g. #temp in two diffrent sored procedures of diffrent name e.g sp1 and sp2, in SQL server 2005. I am just not sure whether there will any problem when users will be accessing the two stored procedures simultanously.
Please help.
Kalam.
|
|
|
|
|
y u can simultaneously bt not concurrently........
manoj Kumar Jha
"Learn to smile at every situation. See it as an opportunity to prove your strength and ability."
|
|
|
|
|
Temp tables only have scope within a particular session. If a stored procedure is invoked by 2 different processes, each process will have its own temp tables.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
Hi,
You can use as many temp table you want.But after doing transaction you have to delete those temp table.
Regard's
Veeresh
i want to join this group
|
|
|
|
|
Hello,
I have created database with name say XYZ in Microsoft SQL Server. My client uses same database, to avoid development phase reflection on database, i created exact replica of database and did the required modification. After finalising the changes i want that changes to be reflected in original database(XYZ).
Please tell me how can i replace existing databse with some other databse?
I tried usin script but table data is not getting copied.
I want to know how can i replace the exact copy of one database with another???
Thank you very much.
|
|
|
|
|
Restore the new copy of the database over the existing one.
Paul Marfleet
"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush
|
|
|
|
|
|
Seconded. SQL Compare is very good.
|
|
|
|
|
CREATE PROCEDURE [dbo].[spa]
@a image
AS
insert into a(a) values(@a)
GO
table
column name = a
datatype = image
p[0] = objclsdb.Parameter("@a", DbType.Byte, buffer, ParameterDirection.Input);
The above code is right to insert the image in sql server 2000?
|
|
|
|
|
It looks okay. Does it work?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
Hi
how to install sqsh[^] on Windows after cygwin installed? In fact where do you even download[^] binary for Windows?
Thanks!
devy
|
|
|
|
|
Hello Everyone,
I am new to code project. Recently i had downloaded and installed oracle 9. but i could not be able to log on to sql plus. it displays the error "could not resolve service name"(error tns:12154). i went through several lot links online and tried to resolve. but none of them work. i had created the new port,checked the tnsnames.ora file, updated the necessary information from the net manager option. i am really worried about my problem. could anyone please help me regarding this. I appreciate your help.
|
|
|
|
|
You might want to look on the Oracle forums.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
I'm starting out with database programming in C# (using System.Data.Odbc). I have an SQL command, using the UPDATE command. I'm trying to update a memo field (in an .mdb file) with contents that have multiple lines of text. However, I keep getting an error. I can see what the error is saying (that it doesn't like me starting a line without an SQL command). How do I modify the following example so that it will work?
UPDATE mytable
SET pagecontents = 'first line of text
second line of text
third line of text'
WHERE id = 3
The error basically says:
ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "second line of text
thirdline of text'
-Daniel
Typing too fast fro my owngood
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
