Database Discussion Boards

oceanexplorer10-Nov-07 7:33

10-Nov-07 7:33

I didn't. This particular issue falls under two topics, it may well be an ADO.NET issue, or a C Sharp issue, so hence my post in both forums.

Paul

Re: Cross Post

pmarfleet10-Nov-07 7:39

pmarfleet

10-Nov-07 7:39

oceanexplorer wrote:
I didn't. This particular issue falls under two topics, it may well be an ADO.NET issue, or a C Sharp issue, so hence my post in both forums.

Yes you did. You posted the same question in 2 forums. This is called cross-posting and is frowned upon because it makes it difficult for people to collaborate on a solution.

In future, try and be more considerate. Choose the most appropriate forum for your question and post there only.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Guaranteed stumper...truncating last 3 characters on a string...

new_phoenix9-Nov-07 7:14

new_phoenix

9-Nov-07 7:14

Hi, guys. I have a string that represents a path to a file. However, the file is the wrong type and needs to be converted to a different file type. I need the file to be a .CSV file instead of a .XLS file type.

If I had a string representing the entire path to the file, including the .XLS, how would I truncate the .XLS and replace it with .CSV?

Confused | :confused:

-- modified at 14:19 Friday 9th November, 2007

Re: Guaranteed stumper...truncating last 3 characters on a string...

andyharman9-Nov-07 8:40

andyharman

9-Nov-07 8:40

select reverse(substring(reverse('C://hello/world.txt'), 5, 100))

Re: Guaranteed stumper...truncating last 3 characters on a string...

Pete O'Hanlon9-Nov-07 10:52

Pete O'Hanlon

9-Nov-07 10:52

So - not stumped by the guaranteed stumper then.;)

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

DataSets

#realJSOP9-Nov-07 5:19

#realJSOP

9-Nov-07 5:19

I'm creating a dataset with the following code:

DataSet m_xmlData = new Dataset("Modules");
m_xmlData.Clear();
m_xmlData.ReadXml("thisfile.xml");

I've got this much code written to retrieve the data from the dataset:

int tableCount = m_xmlData.Tables.Count;
for (int i = 0; i < tableCount; i++)
{
    DataTable dt = m_xmlData.Tables[i];
    if (dt.TableName != "Module")
    {
        continue;
    }
    int rowCount = dt.Rows.Count;
    for (int j = 0; j < rowCount; j++)
    {
        DataRow row = dt.Rows[j];

    }
}

At this point, I'm kinda stuck I've looked around on CP but I've not been able to find any references to READING data from the dataset. I tried tracing in with the debugger to try to find out where to drill down, but I guess I'm just missing it.

Any help?

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Re: DataSets

pmarfleet9-Nov-07 6:23

pmarfleet

9-Nov-07 6:23

Use

myrow[int] to read the value of a field based on its ordinal position

and

myrow[string] to read the value of a field based on its name

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: DataSets

#realJSOP9-Nov-07 6:24

#realJSOP

9-Nov-07 6:24

Yup - I was allowing intellisense to lead me astray.

Re: DataSets

Pete O'Hanlon9-Nov-07 10:49

Pete O'Hanlon

9-Nov-07 10:49

John Simmons / outlaw programmer wrote:
I was allowing intellisense to lead me astray

And there was the problem - intellisense. There's no sense in intellisense.

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

SQL Database sharing

Abbhie9-Nov-07 3:47

Abbhie

9-Nov-07 3:47

Hi,

I have made a vb.net project and I used SQL Server Express for my database..

The project (when built and installed) can't be used remotely. But it can be installed, for example, on 2 computers. But what I need to do is to just share the database on my SQL server from the 1st computer to the 2nd.

This is because if I change the information inside the database from the 1st computer, the 2nd computer can also view the same database as the 1st one for them to acquire the same information from the database.

My question is.. Can I share my Database even if I'm using SQL Server 2005 Express Edition?

How will it be possible?

Vista Issue [modified]

Brady Kelly9-Nov-07 2:03

Brady Kelly

9-Nov-07 2:03

Any know why I can't log on to a SQL Server on a Windows 2003 machine, using Windows authentication, from my Vista machine. If I remote desktop onto the server I can, so I know my account is valid in SQL.

MY BLOG

-- modified at 9:18 Friday 9th November, 2007

Re: Vista Issue

_Zorro_9-Nov-07 2:40

_Zorro_

9-Nov-07 2:40

I have Vista, Sql management studio, and I can connecto to my win2003 / Sql Server. Sure its not another problem? Maybe Remote Connections not allowed on the server, this is maybe why you can login in remote?

Re: Vista Issue

Brady Kelly9-Nov-07 2:43

Brady Kelly

9-Nov-07 2:43

I can log in remotely using SQL Server authentication.

MY BLOG

Re: Vista Issue

_Zorro_9-Nov-07 3:17

_Zorro_

9-Nov-07 3:17

Brady Kelly wrote:
remotely

Brady Kelly wrote:
If I remote desktop onto the server I can

Remote connections or remote desktop? Did you enabled remote connections on the server?

Re: Vista Issue

KarstenK9-Nov-07 3:16

KarstenK

9-Nov-07 3:16

Try a XP machine insteed of the Vista to clear it depends on Vista.

I guess Vista is "to secure" to allow you to connect (Firewall, networking, Rights). Blush | :O

Greetings from Germany

Re: Vista Issue

Michael Potter9-Nov-07 3:31

Michael Potter

9-Nov-07 3:31

Verify that you have logged onto the domain and not just onto the Vista machine.

global variable

SVb.net9-Nov-07 1:36

SVb.net

9-Nov-07 1:36

how i make a gloabl Variable As @@language?

123

Re: global variable

pmarfleet9-Nov-07 3:49

pmarfleet

9-Nov-07 3:49

AFAIK, you can't define your own global variables.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Re: global variable

Pete O'Hanlon9-Nov-07 10:51

Pete O'Hanlon

9-Nov-07 10:51

SVb.net wrote:
how i make a gloabl Variable As @@language?

Nope. You can't do it. These variables are defined by Microsoft.

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

How to secure Data sources in browser ???

QPun8-Nov-07 22:36

QPun

8-Nov-07 22:36

Hi all,
I got a security problem here,
let's say I got a SQL Report Server, with browser URL : //rptserver/reports
I have datasource1 as datasource
I also have provide a model (RptModel1) that created from datasource1 using Visual Studio
I want to enable users to use Report Builder , using available model(RptModel1) but restrict them from regenerate model from datasource1.
So, how to secure that datasource?
I need your help,Please...
Thanks in advance

Re: How to secure Data sources in browser ???

QPun11-Nov-07 14:04

QPun

11-Nov-07 14:04

Is there something wrong in my question so no one understand it? Or maybe there's no solution for my problem? :->

Equivalent of Sequence

M. J. Jaya Chitra8-Nov-07 21:48

M. J. Jaya Chitra

8-Nov-07 21:48

Is there any command which is equivalent to sequence in Oracle.

Or some thing to no the rows.

Best Regards,
M. J. Jaya Chitra

Re: Equivalent of Sequence

andyharman9-Nov-07 3:20

andyharman

9-Nov-07 3:20

It depends on the type of database. Under SQL-Server you can use:

create table MyTable (
   Id integer identity(1,1),
   OtherData varchar(10)
   )
go
insert into MyTable (OtherData)
   values ('hello')
select SCOPE_IDENTITY() as AllocatedNumber
go

Regards
Andy

sub query in create table command

M. J. Jaya Chitra8-Nov-07 18:33

M. J. Jaya Chitra

8-Nov-07 18:33

In Oracle , we can use the following statement
Create table MyTestTable (Select * from OriginalTable)

Such that a new table will be created from the original table and the values will be inserted to it.

But what is the equivalent for the same in SQL Server.

Can any one suggest me.

Best Regards,
M. J. Jaya Chitra

Re: sub query in create table command

Giorgi Dalakishvili8-Nov-07 20:14

Giorgi Dalakishvili

8-Nov-07 20:14

You can use select with into clause to copy data from one table into another. Have a look here:
SQL SELECT INTO Statement[^]

INTO Clause [^]

#region signature
my articles
#endregion

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