Database

Re: INSERTING TWO TABLES IN ONE GRIDVIEW

7-Sep-07 5:10

You could use a stored procedure with a temp table and use that

<br />
<br />
create proc myproc <br />
<br />
AS<br />
<br />
SELECT * INTO #TEMP<br />
FROM Table1<br />
<br />
<br />
SELECT * INTO #TEMP<br />
From * Table2 <br />
<br />
select * from #temp<br />
<br />
go<br />
<br />

or use a Union SELECT

<br />
<br />
SELECT * FROM TABLE1<br />
UNION ALL<br />
SELECT * FROM TABLE2<br />
<br />

You get the idea, use SQL to do it.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

shyne710-Sep-07 8:54

shyne7

10-Sep-07 8:54

Dim con As New OleDbConnection("Provider=Microsoft.jet.oledb.4.0; Data Source = C:\Users\--Sunshine--\Documents\thesis\Database1.mdb")
con.Open()

Dim da As New OleDbDataAdapter(sql, con)
sql = "Select * from Supplier_Information union all Select * from Products"
da.Fill(ds, "Supplier_Information and Products")
dgvSupplier.DataSource = ds.Tables("Supplier_Information and Products").DefaultView

is this right?how will i assigned in my textboxes the table name?

txtsuppID.Text = ds.Tables("which tablename??").Rows(inc).Item(0)

tnx

Can I modify ANSI_NULLS after table is created?

ckruger6-Sep-07 20:49

ckruger

6-Sep-07 20:49

I have a table that was created a few years ago (LIVE), but I need to change ANSI_NULLS from OFF to ON for this table. How can I do that without re-creating the table?

Thanks in advance!

Re: Can I modify ANSI_NULLS after table is created?

Frank Kerrigan7-Sep-07 5:11

how to know the connection is establised

7-Sep-07 5:11

Whats your database SQL Server ????????

You may have to change the value of any nulls in the table first

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

prasadbuddhika6-Sep-07 17:11

prasadbuddhika

6-Sep-07 17:11

i want to know when i log into the sql server db whether i have connected successfully, using sql login via my appilication. is there any parametre the server passes back to the applicatioin. Smile | :)

Re: how to know the connection is establised

Parwej Ahamad6-Sep-07 19:26

Parwej Ahamad

6-Sep-07 19:26

According to connection object provide the property named state which denote the connection is establish or not.

Parwej Ahamad
g.parwez@gmail.com

hide print button in reporting services

Luis Corrales6-Sep-07 9:59

Luis Corrales

6-Sep-07 9:59

hi all im using sql server reporting services, to do a report, but i want to disable or hide the print button of the report.... please somebody help me or tell me if is possible do that....

thanks

luis

pmarfleet6-Sep-07 10:31

6-Sep-07 10:31

Are you using the ReportViewer control to display the report? If so, set the value of its ShowPrintButton property to false.

Paul

Luis Corrales6-Sep-07 10:58

Luis Corrales

6-Sep-07 10:58

paul im using sql server bussines intelligence, no the reportviewer contro, thanks any way...

i found a solution check this out if someone have the same problem:
http://blogs.msdn.com/bimusings/archive/2005/07/08/436887.aspx[^]

luis

Frank Kerrigan7-Sep-07 5:15

7-Sep-07 5:15

You can modify the URL to hide all the toolbars.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Frank Kerrigan7-Sep-07 5:13

connecting a database on a lan network

7-Sep-07 5:13

See my article in there somewhere

http://www.codeproject.com/sqlrs/Reporting_Services.asp[^]

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

gautam karan singh6-Sep-07 8:33

gautam karan singh

6-Sep-07 8:33

hello friends i am third year engineering student i have created a database system using vb.net and mysql which is working fine on a standalone system but now i want this system to be on multiple machines and connected through lan network with one pc working as the server
.
I am non-geek in networking so please can any one help me on this regard.please

gautam karan singh
student

Re: connecting a database on a lan network

Frank Kerrigan7-Sep-07 5:17

How can I save the image of PictureBox to Sql Server 2000 Again

7-Sep-07 5:17

It depends on the database.

Access : needs a direct url path eg. \\server\share\db.mdb

ODBC: Need a SQL server connection string and a network compliant application

You question is a bit fluffy to answer.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

kindman_nb6-Sep-07 6:33

kindman_nb

6-Sep-07 6:33

Hi ..
thanks for all here ..
on my example .. I want to save the image of a PictureBox to the Sql server 2000 database ...
I know how cant save it from a file ...
but I want to know how save the PictureBoc's image ...

again .. any one will try

jooooo

Re: How can I save the image of PictureBox to Sql Server 2000 Again

Pete O'Hanlon6-Sep-07 11:48

Pete O'Hanlon

6-Sep-07 11:48

Convert the Picture property to a byte array and save that.

Deja View - the feeling that you've seen this post before.

Re: How can I save the image of PictureBox to Sql Server 2000 Again

kindman_nb7-Sep-07 1:34

kindman_nb

7-Sep-07 1:34

Thanks my friend >>
can you give me alink or the code of it ??
Rose | [Rose]

jooooo

Reporting Service 2005 Running Soooo Slow

Bryan Bradford6-Sep-07 4:00

Bryan Bradford

6-Sep-07 4:00

Hey guys I have some reports in SQL Reporting Services that were running in under 1 minute a couple of days ago and now they are taking hours. Its not all reports just some and when I run the individual queries for the reports they each run in between 1 and 6 seconds. Even running them all together takes less than 1 minute in SQL. Nothing has changed on the machine to cause this any ideas on what the problem might be or even how to analyze what the problem might be?

Thanks,
Bryan

pmarfleet6-Sep-07 4:03

6-Sep-07 4:03

Try restarting the Report Server and see if it makes any difference.

Paul

Bryan Bradford6-Sep-07 4:06

Bryan Bradford

6-Sep-07 4:06

No difference at all.

Thanks,
Bryan

pmarfleet6-Sep-07 4:23

6-Sep-07 4:23

Visual Studio Team System has a performance testing tool for SSRS reports.

If you don't have access to this, all I can suggest is analysing each element of your report to see where the bottleneck is. Are you doing some manipulation of the data in the report after it has been retrieved from the database that might be causing a problem?

Paul

Bryan Bradford6-Sep-07 4:33

Bryan Bradford

6-Sep-07 4:33

The only manipulation that I am doing is in a table I am summing values for a total row. Do you know if Visual Studio Developer edition has those performance tools? How are they accessed? I am great at creating the reports...just ignorant when something like this goes wrong.

Thanks,
Bryan

pmarfleet6-Sep-07 5:25

6-Sep-07 5:25

This article[^] gives you some more information. It is only a feature in Team System though.