Help combing rows to columns - Database Discussion Boards

First Prev Next

Re: reporting services sql server 2000

NewSilence23-Apr-05 13:35

NewSilence

23-Apr-05 13:35

http://msdn.microsoft.com/library/en-us/RSPROG/htm/rsp_ref_clr_dataproc_8p85.asp?frame=true[^]

check that

there is also the data processing ext. sample http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_8spu.asp[^]

from vb6 to vbnet

cyrusmila6-Apr-05 22:49

cyrusmila

6-Apr-05 22:49

greetings
i did alot of work inb vb6 as frontent and sqlserver as backend, as with rapid change in technology, i've decided to swing to vb.net...and started some few job on it, but, i did find myself stuck in the area of using SQl, it seems it takes alot more than i thought in connecting database, viewing, editing, delete and update, unfortunately i cant find a good book that has samples and will realy give me the idea on how to make things easier.
hope u can direct me to anything that would be very usefull for me in understanding record connectivity in VB.net
thanks
cyrus

DataSet properties - Global - Local

WindSailor6-Apr-05 11:59

WindSailor

6-Apr-05 11:59

How do you make or set a DataSet to have LOCAL properties instead of GLOBAL?

Does it have to be in an exclusive Namespace?

For instance, if I create a new form, new adapter and dataset by design the wizard will give the default beginning name of the new dataset as dataset (which will be dataset1). All of my other forms with their dataset1 will have their properties changed to the last forms properties. All of them.
It is acting like the dataset name is global and adjusts all previous datasets with that particular name accordingly.
And if I create dataset11 or dataset111 or dataset112 it will see it as a subset(?) of dataset1 and all datasets that start with dataset1 or dataset1**** will be changed.
Nothing is changed inside of the SelectCommand just the DataSet.
Solutions?

Any comments would be grateful.

Rick

Re: DataSet properties - Global - Local

WindSailor8-Apr-05 6:35

WindSailor

8-Apr-05 6:35

By hard coding it into your form.
If you create the DataSet by the wizard or using your toolbox, you create a globally named dataset for your project.

Master Detail Relationship in Strongly Typed Dataset

C_Simpkins6-Apr-05 5:15

C_Simpkins

6-Apr-05 5:15

Hello all,

I'm populating a strongly typed dataset from a local XML file and I would like to establish a master-detail relationship between an element and a table of grandchild elements (and their attributes) which will be bound to a datagrid. Is it possible to do this without clicking through the child element on the datagrid? The XML file will be populated with multiple grandchild elements for each grandparent. Any help would be much appreciated (in C# if possible). Thanks.

-CS

SQl -simple SP

Anonymous6-Apr-05 4:48

Anonymous

6-Apr-05 4:48

This Stored Procedure YtdSales requires an input variable @title and the result of the query is returned in another variable @ytd_sales. Notice that the OUTPUT variable is clearly marked in the Stored Procedure. Also note the ParameterDirection attribute.
QES: How to run the Stored Procedure in Sql Query analizer,Pl give a
detail answer of how to get the output parameter value
Create Procedure YtdSales
@title varchar(50), @ytd_sales int OUTPUT
as
Select @ytd_sales=ytd_sales
from titles
where title=@title
return

Re: SQl -simple SP

Scott Serl6-Apr-05 9:11

Scott Serl

6-Apr-05 9:11

DECLARE @MyTitle varchar(50),
@ytd int
SET @MyTitle = 'Some Title'
EXEC dbo.YtdSales @MyTitle, @ytd OUTPUT
SELECT @ytd

All you have to do is specify (again) that the parameter in the stored proc you are calling is an output parameter.

Help combing rows to columns

BrockVnm6-Apr-05 3:59

BrockVnm

6-Apr-05 3:59

I am not sure if this is going to work but figure I mine as well try. I have a query that returns 2 columns and x rows. What I want to do is join simalar rows into the columns but not sure how I can get it done....

Example

Id Price
7812 25
7812 34
7813 67
7813 32

What I want to do is have the rows with the same Id show the 2 prices in the same row. Is this at all possible?

Thanks for all of your help!
Big Grin | :-D

There are 10 kinds of people in this world. Those who understand binary and those who don't.

We shouldn't assume something's debugged just because everyone in the whole world has access to the source code.

Re: Help combing rows to columns

A.Wegierski7-Apr-05 1:57

A.Wegierski

7-Apr-05 1:57

Only manually. Add prices as strings with separator ... use hashtable as intermediate

Hashtable ht=new Hashtable(1);
foreach(DataRow dr in myTable.Rows)
if(ht.Contains(dr["id"])
ht[dr["id"]]=ht[dr["id"]].ToString()+","+dr["price"].ToString();
else
ht.Add(dr["id"],dr["price"].ToString();

Next, clear DataTable and copy Hashtable into it. Not tested

Hi,
AW

Need Connectivity Help !

Jethro636-Apr-05 3:22

Jethro63

6-Apr-05 3:22

I've been trying to cut my teeth on writing applications that read/write/query databases for some time now. In the past, I have used MS-Access to learn the basics of database theory and I have a pretty good handle on it: Tables, keys, normalization, joins, queries, etc - all using the SQL command window that Access provides. I don't have any problem with any of that.

However, when I attempt to use C# or MFC to get at my Access file, all hell breaks loose. My immediate problem is:

What must I do to gain access to my Access database file from an MFC or C# program? What drivers and connections must I set up - and how? I'm using Windows XP-Pro. I have found the ODBC Data Sources icon under the Administration Tools in Control Panel but I am absolutely stupified by the complexity of this and the bottom line is that I can't get it to work.

My problem in broader terms is that I can never find an explanation - for humans - that de-mystifies all of this database technology. It seems I have seveal database drivers installed on my system and I have no idea how they got there and I have no idea what to do with them. Invariably, when I consult somebody that understands databases, they start spouting all kinds of abbreviations, acronyms, jargon and terms that really make no sense to somebody who is starting out. I have done a thorough search of internet resources, books, etc... I find nothing helpful.

Some advice to solve my immediate problem would be appreciated. Some advise to solve my broader difficulties would earn a place in my will.

Thank you,
Jethro

pCommand.CreateInstance(__uuidof (Command)) fails in 98

kumarbp6-Apr-05 0:49

kumarbp

6-Apr-05 0:49

Hi there,

I'm trying to modify data in SQL Server usin ADO

The followin code fails in windows 98

_CommandPtr pCommand;
pCommand.CreateInstance(__uuidof (Command))

Any idea why?

Thanks kumar

Compare record in Visual Studio 2003.NET

sukasukabo6-Apr-05 0:32

sukasukabo

6-Apr-05 0:32

In Visual Studio.Net2003 on Report Layout
after execute my store procedure , we have data like this :

Sample Data Chart Of Account (COA) Code and Description.

'100000' -> Header | '100000' INCOME
'110000' -> sub Header | '110000' OTHER INCOME
'110001' ---> detail | '110001' Other Income Branch 15750
----> there is Sub Total | Sub Total Other Income 15750
'120000' -> sub Header | '120000' INTEREST
'120001' ---> detail | '120001' Interest from Bank 12500
'121001' ---> detail | '121001' Interest from Stock Market 07500
----> there is Sub Total | Sub Total Interest 20000
'200000' -> Header | '200000' EXPENSE
'210000' -> sub Header | '210000' Expense from Allowance 10550
'210001' ---> detail | '210001' Expense from Overtime 08450
----> there is Sub Total | Sub Total Expense 19000
-finally there is Grand Total | Grand Total (15750+20000-19000) 16750
(INCOME - EXPENSE)

in PowerBuilder if we want to compare data record we can use llike this :
if name1 <> name1 (-1) then..... --> this mean we compare current recorod with previous record

i tried this :
=iif(Fields!COA.code.value.sbstring(0,1) <> Fields!COA.code.value.sbstring(0,1)(-1), '...', '<else>'
but it doesn't correct

how do i compare between COA code 100000 with 1100000 in Visual Studio.Net 2003 with or without using Grouping Function ? (especially between first digit and the second digit)
and what is the correct syntax ?

email : sukasukabo@hotmail.com

Insert Rows into a datatable in ado.net

Madhu.A5-Apr-05 23:30

Madhu.A

5-Apr-05 23:30

I Prepared One Table with Selected Rows from another Table.
These Two tables have same schema. But Problem is i do Some
modifications in this Table. i want send this rows back to the original datatable.but that table already contains these
rows. so i have to update these rows. can anyone help me with a simple solution. Thanks in advance. Cry | :((

Re: Insert Rows into a datatable in ado.net

Ritesh12346-Apr-05 20:46

Ritesh1234

6-Apr-05 20:46

Hi,
u can merge two table using Dataset's Merge method as...........
Let ur original table is dtTable and ur filtered table is dtTemp.

dsNewData = New DataSet()
dsNewData.Tables.Add(pi_dtTable)

Dim dcCol(0) As DataColumn
dcCol(0) = pi_dtTable.Columns("emp_id")
pi_dtTable.PrimaryKey = dcCol

Dim dcCol1(0) As DataColumn
dcCol1(0) = dtTemp.Columns("emp_id")
dtTemp.PrimaryKey = dcCol1

dtTemp.TableName = pi_dtTable.TableName

dsNewData.Merge(dtTemp, False, MissingSchemaAction.Ignore)

I hope this will help u..............:->

Regards,
Ritesh

indexing service - problem with read html meta tag

a_r_215-Apr-05 6:19

a_r_21

5-Apr-05 6:19

hye

i'm tring to read meta tag that contains name="KeyWords" content="something"

the query is : select DocKeyWords from scope()

the result = " " ....

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

i have in the same html file title tag , and when i read DocTitle -> the result are correct !

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

so why i can't read the meta tag ???

tnx a.r

Reporting Services - Custom Rendering Extension

blue-ice4-Apr-05 22:56

blue-ice

4-Apr-05 22:56

Hi,
I want to create a custom rendering extension based on a existing rendering,
I have seen in the MSDN that it is possible but the documentation is not
complete
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_extend_security_87oi.asp

If somebody know how i can do ...

Thanks in advance...

Re: Reporting Services - Custom Rendering Extension

JeyKey5-Apr-05 18:51

JeyKey

5-Apr-05 18:51

Have you generated report in HTML format, If so before writing Binary converted data to Response, make the Content type as

"application/PDF" for PDF or "application/vnd.ms-excel" for EXCEL

Don't forget to pass the report format as desired type(PDF or EXCEL ) when you are Rendering the report to binary format.

For EXCEL to work Excel 10 or above is required.

Hope this helps.

Regards
JK

Should i use SqlConnection or SqlDataAdapter Only ?

kakarato4-Apr-05 21:57

kakarato

4-Apr-05 21:57

Should i use SqlConnection to connect to server before i use SqlDataAdapter to to fill the dataset ?

Example :
=============

<br />
string ConStr = "server=(local);uid=sa;pwd=password;database=NorthWind";<br />
string cmdString = "select top 3 last name, firstname, title from employees";<br />
SqlConnection conn = new SqlConnection(ConStr);<br />
SqlCommand com = new SqlCommand(cmdString,con);<br />
SqlDataAdapter da = new SqlDataAdapter(com);<br />
DataSet ds = new DataSet();<br />
<br />
conn.open(); // Even without conn.open i stll able to fill the da.<br />
<br />
da.Fill(ds);<br />

I try code above and i found that even without manuall open the connection i still able to fill up the dataadapter (da).

So what is the best method to fill the dataadapter with out connection first out without using connection?

Re: Should i use SqlConnection or SqlDataAdapter Only ?

Colin Angus Mackay4-Apr-05 23:49

Colin Angus Mackay

4-Apr-05 23:49

If your connection is closed already - the DataAdapter will open the connection, perform the query, and close the connection again. If you do not need the connection open for anything else then I recommend you let the DataAdapter do the clean up for you.

[ADDITIONAL] I should add that if the connection is already open the DataAdapter will not close it [/ADDITIONAL]

If you are going to perform a series of queries one-after-the-other then I would recommend that you open the connection, perform your queries, then close the connection.

Does this help?

My: Blog | Photos | Next SQL Presentation
WDevs.com - Open Source Code Hosting, Blogs, FTP, Mail and More

Re: Should i use SqlConnection or SqlDataAdapter Only ?

kakarato5-Apr-05 15:33

kakarato

5-Apr-05 15:33

Thanks it really help and clear all my doubt. Big Grin | :-D

can we set foreign key from another database

BSRK4-Apr-05 19:08

BSRK

4-Apr-05 19:08

here is my problem, please help.

I am having 2 databases namely employees and projects.
employees database contains a table emp (with fields like empname, etc).
projects database contains a table prj (with fields like prjname, prj_leader, etc).
but i want to ensure that ALL the prj_leader entries MUST be existing empnames of emp table in employees database.

i know that if both the tables are in the same database, it is simple. but i have no idea whether we can set such foreign key constraints across databases.
kindly suggest.

Re: can we set foreign key from another database

Nazmul Hassan5-Apr-05 5:02

Nazmul Hassan

5-Apr-05 5:02

I’m afraid, its not possible. But,you can use Procedure to ensure this.

With regards,
Nazmul Hassan Hirok

DataAdapter.Fill

Drew Stainton4-Apr-05 18:19

Drew Stainton

4-Apr-05 18:19

I've been working on this little Windows Forms app. that manages data using a DataGrid. Up until now I've only tested it with small datasets (it connects to an Access Database (and yes, there is a reason for not using MSDE)). Everything has been fine until I finally got the real, official data put together (it was comprised of 5 spreadsheets, all in different formats, with no validation Cry | :((

) and plugged it in for the first time.

I cannot believe how slow it is now Sigh | :sigh:

. The DataAdapter's Fill method is taking anywhere from 20 to 40 seconds to load the dataset with the 26000 records. Obviously the solution is to only grab the data I need to fill the current view and then intercept the applicable scroll events and re-fill the data as necessary (similar to paging with the web version). I'm about to embark on that but I'm wondering: is this all really necessary? It seems like something that should be built into the framework. Needless to say I don't want to reinvent the wheel so if someone knows what I'm missing, could you enlighten me please?

I've looked at virtually every example I can find and they all say that the Fill method is slow and offer a couple of tips for speeding it up: using the overridden Fill method that accepts a start and row count is one. Nobody bothers to go into any more detail than just mentioning it, however.

Thanks in advance.

Cheers,
Drew.

Re: DataAdapter.Fill

Albert Pascual5-Apr-05 5:53

Albert Pascual

5-Apr-05 5:53

Did you try SqlDataReader?

If you are using DataGrids should be the fastest way.

Cheers
Al

Can multiple ds's be in a array?

DEWright_CA4-Apr-05 11:52

DEWright_CA

4-Apr-05 11:52

I have a need to pack 8 seperate datasets into one of 9 arrays for population in a tree control. Is this possible? if not what would be the best way to accomplish this? I am accessing 5-6 fields from seperate tables for each ds and need to aggregate them at a later point!

My end goal will have 9 nodes in a tree, using the first ds as one node and branch the the rest in sequential order.

Thought / Suggestions?

Thanks;
David @ Premier

You are only as good as your last project.

Last Visit: 31-Dec-99 18:00 Last Update: 25-Apr-24 5:36

Refresh

ᐊ Prev 1...2122 2123 2124 212521262127 2128 2129 2130 2131 Next ᐅ

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.