displaying a dataset in a datagrid - Database Discussion Boards

Re: SSRS 2005

pmarfleet27-Nov-07 5:26

27-Nov-07 5:26

There's 3 problems with your post.

1. Your title is too vague. Read the forum guidelines.
2. You haven't asked a specific question.
3. You've posted too much code. There's too much stuff to wade through. Again, identify what your problem specifically is and post only the code that is relevent.

Paul Marfleet

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

Re: SSRS 2005

MSinha28-Nov-07 5:00

MSinha

28-Nov-07 5:00

Hello Paul,
Can you help me please. I have modified the code. I have put one another message, please help me for that also. Please give me any clue. so that I do the required settings with my reporting server and for client pc. If any setting require with cookie management and DCOM etc. please let me know.
Regards,
Manoj Sinha

Re: SSRS 2005

pmarfleet28-Nov-07 8:28

pmarfleet

28-Nov-07 8:28

I'm not really sure what the problem is. I can see that you have lifted the code from a Microsoft sample application though. In the Microsoft sample, they use SetCookie rather than AppendCookie. However I'm not sure whether this is significant.

Is the code actually falling over on this line, or it it failing in TranslateCookie?

Paul Marfleet

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

Missing Data - Not

No-e27-Nov-07 4:46

No-e

27-Nov-07 4:46

I am installing a new server, created my database with a script, loaded my database with my data. Using Enterprise manager, right click a table return all rows works fine, everything looks normal.

Now, go to SQL Query analyzer and run a select * from the table and I get no rows.

Create and ODBC connection and link the table in Access and I see my data, run a query from a simple web page and get no data.

any ideas?

Thanks in advance....

Re: Missing Data - Not

Colin Angus Mackay27-Nov-07 5:34

Colin Angus Mackay

27-Nov-07 5:34

No-e wrote:
Now, go to SQL Query analyzer and run a select * from the table and I get no rows.

Is it running in the same security context?

Upcoming FREE developer events:
* Developer Day Scotland

My website

error in login to my sql account via query analyzer???

mr.mohsen27-Nov-07 4:27

mr.mohsen

27-Nov-07 4:27

hi i have a problem that is cause of my amfusing
i cannot login to my sql database account from query analyzer.
but my site work correctly.
the error is:
unable to connect to ??????? server:
error: msg 11,level 16,state 1
general network error,check your documentation network.
please help me

nobody help you...
you have to help you yourself
and this is success way.

Re: error in login to my sql account via query analyzer???

Vimalsoft(Pty) Ltd27-Nov-07 23:32

Vimalsoft(Pty) Ltd

27-Nov-07 23:32

hi

its Either your password is wrong , or you are Connecting to a wrong Server, that has no User that you want to Exit, remember that the useer does not roam, if you have create a user for a certain server , it will not work in other servers, i suggest you try to create a new user with the same name as the one you are saying, you have, if it says it exists, them the user does not exists in that server.

Hope it helps

Vuyiswa Maseko,

Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding

VB.NET/SQL7/2000/2005
http://vuyiswamb.007ihost.com
http://Ecadre.007ihost.com
vuyiswam@tshwane.gov.za

displaying a dataset in a datagrid

imonfiredammit27-Nov-07 3:56

imonfiredammit

27-Nov-07 3:56

Hello,
I am new to ADO and have to learn it for work so im playing aroud with it...my problem is that I have a blank datagrid on my form. I am trying to make a connection to an oracle database and create an SQL statement to retrieve the data I want and then display this in my datagrid...this is my code:

Dim dsWorkGroup As New DataSet 'New data set

'New connection string and variable to hold connection string ( i am sending the actual user name and password in the string)
Dim connectionString As String = "Data Source=PIDBDEV;User ID=######; Password=######;Unicode=True"
Dim connection1 As New OracleClient.OracleConnection(connectionString)

'Sql statement to retrieve the fields to fill the dataset
Dim selectStatement As String = "SELECT Group_Name FROM BASE_CALC_CODES"

Dim selectCommand As New OracleClient.OracleCommand(selectStatement, connection1)

Dim daWorkGroup As New OracleClient.OracleDataAdapter(selectCommand)
daWorkGroup.Fill(dsWorkGroup)

also I do have a datasourse attached to the datagrd. What am I doing wrong??? It isnt displaying the results from the query...it displays the entire table.

Erica

Re: displaying a dataset in a datagrid

Vimalsoft(Pty) Ltd27-Nov-07 23:23

Vimalsoft(Pty) Ltd

27-Nov-07 23:23

hi Erica

i have never connected to an Oracle DB, but now, you did not bind the datagrid to your dataset.

after the last line in your code, put the following line

Datagrid1.DataMember = "BASE_CALC_CODES"
Datagrid1.DataSource = dsWorkGroup

.

and i have an article, that has something like this, it might help you understand some of this and dont forget to vote.

http://www.codeproject.com/useritems/N-Tier_Application_VB.asp[^]

Hope it helps

Probably an old Insert question

ffowler27-Nov-07 3:40

ffowler

27-Nov-07 3:40

Hello All,

First, I did try to search for the answer to this one and I either didn't use the correct keywords or something because the system didn't return any hits; so here I am.

Simply, I know there is a way to insert the same data into 2 different tables but I need to do it within 2 different databases. I am using a stored procedure but I am not sure how to set it up in the procedure. I know I need to enclose it in a transaction but how do I direct the insert to populate the second table in the other database?

Any assistance would be greatly enjoyed.

Fred

Re: Probably an old Insert question

pmarfleet27-Nov-07 4:02

pmarfleet

27-Nov-07 4:02

Are your two databases on the same server? If so, you can reference tables in the other database using the syntax database.owner.mytable.

If the two databases are on different servers, you can set up one of the servers as a linked server in your other server.

Paul Marfleet

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

Re: Probably an old Insert question

ffowler27-Nov-07 4:30

ffowler

27-Nov-07 4:30

Paul,

Thanks for the quick response. I gave it a try on some test tables I created and executed the SP and had a return value of '0' which is good. The only problem is that the information I tried to insert was not in either table Confused | :confused:

Below is what I created, could you take a look and see if I am missing something.

-- Insert statements for procedure here
BEGIN TRANSACTION

INSERT INTO ff_test(TestInput, TestInputCode)
VALUES('INSERTED','1')

IF @@ERROR <> 0 BEGIN
ROLLBACK TRANSACTION
RETURN 2
END

INSERT INTO [FEDEX].[dbo].ff_test(TestInput, TestInputCode)
VALUES('INSERTED','1')

IF @@ERROR <> 0 BEGIN
ROLLBACK TRANSACTION
RETURN 3
END

COMMIT TRANSACTION
RETURN 0

Re: Probably an old Insert question

pmarfleet27-Nov-07 4:34

pmarfleet

27-Nov-07 4:34

Your code looks OK, so I'm not sure what the problem is. I would try running the SQL Profiler to determine which statements in your stored procedure are actually being executed.

Paul Marfleet

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

Re: Probably an old Insert question

ffowler27-Nov-07 4:41

ffowler

27-Nov-07 4:41

Not sure what was going on there but the information is now in the tables, and representative of each time I tried to execute the program. Weird but now ok. I will futz around some more to clean it up but again "THANKS" for the pointer. It works.

F

import HOST file into a table

solutionsville27-Nov-07 2:46

solutionsville

27-Nov-07 2:46

I would like to import my HOST file into a DB Table and the periodically run a script to verify if all the entries are the same, changed, deleted, etc.

Re: import HOST file into a table

pmarfleet27-Nov-07 3:29

pmarfleet

27-Nov-07 3:29

solutionsville wrote:
I would like to import my HOST file into a DB Table and the periodically run a script to verify if all the entries are the same, changed, deleted, etc.

Good for you.

Did you have a question that you wanted to ask?

Paul Marfleet

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

Re: import HOST file into a table

solutionsville27-Nov-07 3:34

solutionsville

27-Nov-07 3:34

Hello Paul.

I guess I was kinda vauge... Mind is elsewhere. Funeral today.

I want to write an SQL script that looks at the Windows HOSTS File and reads the IP / host name into two columns of a table.

I next want to write a SQL Script that I can run as a job and validate the entries in the hosts file and if they have changed then modify the table data.

I will also send a diff email to myself noting any changes(the email piece I have figured out).

Thanks,

Re: import HOST file into a table [modified]

pmarfleet27-Nov-07 3:57

pmarfleet

27-Nov-07 3:57

solutionsville wrote:
I guess I was kinda vauge... Mind is elsewhere. Funeral today.

Sorry to hear that.

solutionsville wrote:
I want to write an SQL script that looks at the Windows HOSTS File and reads the IP / host name into two columns of a table.

You could write a small .NET program to read the contents of your HOSTS file into SQL Server. Use the System.IO.File.ReadAllLines() to load the contents of the file into an array. Then do some string manipulation to separate the IP address and host name for each entry. Then use ADO.NET to load the data into your database.

solutionsville wrote:
I next want to write a SQL Script that I can run as a job and validate the entries in the hosts file and if they have changed then modify the table data.

You could achieve this by using SQL Server AGent to set up a job that runs periodically.

solutionsville wrote:
I will also send a diff email to myself noting any changes(the email piece I have figured out).

You can write code in T-SQL to send mail. Have a look at this article[^]. You could invoke this from your SQL Server Agent job.

Hope this helps.

-- modified at 10:12 Tuesday 27th November, 2007

I forgot to include the link to the email article. I've put it in now.

Paul Marfleet

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

Re: import HOST file into a table

solutionsville27-Nov-07 4:04

solutionsville

27-Nov-07 4:04

Thanks Paul.

update a field in a specified record in sql from asp.net

Big Ralph27-Nov-07 0:44

Big Ralph

27-Nov-07 0:44

I need to update a field in a record in a table how can I access it to change it.

ie: i have a grid view and a form view on the same page I want to put the highest value in the grid view in a field in the formview and save it to the data base.

Thank you

BiG RaLpH

BreakPoints in Stored Procedures

Zuhair Rizvi27-Nov-07 0:38

Zuhair Rizvi

27-Nov-07 0:38

How can i insert breakpoints in stored procedures(SQL SERVER 2000) using SQL Debugger in Query Analyzer.
Exec sp_sdidebug 'legacy_on' is not working.
Thanx in advance

Re: BreakPoints in Stored Procedures

Vasudevan Deepak Kumar27-Nov-07 0:43

Vasudevan Deepak Kumar

27-Nov-07 0:43

Are you sailing in the same boat as this?

http://www.velocityreviews.com/forums/t20747-debugging-sql-server-2000-stored-procedures.html[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson

Re: BreakPoints in Stored Procedures

Zuhair Rizvi27-Nov-07 0:54

Zuhair Rizvi

27-Nov-07 0:54

yes to some extent but i m not using windows or any other application.i just want to debug my sp from query analyzer.The problem is that Step Into button is disabled in my T-SQL Debugger

Restore Database from C#

tr_thorn26-Nov-07 20:23

tr_thorn

26-Nov-07 20:23

Hi ,

I can restore my db from SQL server Management with this script;
RESTORE DATABASE [LIDER] FROM DISK = N'E:\OyunTakip\database\LIDER.BAK' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO

but i cant do the same thing from C#.

SqlConnection baglantim = new SqlConnection("data source=THORN\\SQLEXPRESS; database=LIDER; integrated security=SSPI");
baglantim.Open();
string cmdText = "RESTORE DATABASE" + " LIDER" + " FROM DISK = 'E:\\OyunTakip\\database\\LIDER.BAK'" + " WITH MOVE 'LIDER' TO 'e:\\Oyuntakip\\database\\LIDER.mdf' " + ",MOVE 'LIDER_Log' TO 'E:\\Oyuntakip\\database\\LIDER_log.ldf'" + ",REPLACE";

SqlCommand komut = new SqlCommand(cmdText,baglantim);

komut.ExecuteNonQuery();

Getting this error ;
RESTORE cannot process database 'LIDER' because it is in use by this session. It is recommended that the master database be used when performing this operation.
RESTORE DATABASE is terminating abnormally.

i cant solve it help pleasEEEe ;(

Re: Restore Database from C#

SimulationofSai26-Nov-07 21:11

SimulationofSai

26-Nov-07 21:11

tr_thorn wrote:
SqlConnection baglantim = new SqlConnection("data source=THORN\\SQLEXPRESS; database=LIDER; integrated security=SSPI");

Change it to

SqlConnection baglantim = new SqlConnection("data source=THORN\\SQLEXPRESS; database=Master; integrated security=SSPI");

That should work.

SG
Cause is effect concealed. Effect is cause revealed.

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