Database Discussion Boards

bambo123414-Apr-06 20:55

14-Apr-06 20:55

What I need is a simple way to add a new record to my database based on the data collected in my web site.

I have create an aspx form (vb) (vwd express) with several text boxes and a button.

I'd like that clicking the button will create a new record in my database (mdb) with the text entered in the texts box as the new record fields values.

(this was posted also on asp.net forum)

Re: asp .net add a record to my database

Jerry Hammond15-Apr-06 17:16

Jerry Hammond

15-Apr-06 17:16

So using ADO.NET is out of the question?

Pictures of the menu available at the drive-thru

Re: asp .net add a record to my database

bambo123415-Apr-06 21:18

bambo1234

15-Apr-06 21:18

I've created a form view and change its mode from read-only to insert. now get an error that i need to use an insercommand.

where should I put the insert command and in what syntax?

Select

kirthikirthi14-Apr-06 20:11

kirthikirthi

14-Apr-06 20:11

Hi
I have a table in remote sql server

I am trying to display records in sql query anylazer

It is not display the records

It is giving Error
"Invalid object name 'ext'"

But it is working in sql Enterprice Manager

I try with "select * from dbo.ext"

It is also not working

Can any one help me

asdfasdfasdfasdfasdfasdfasdfasdfasdfasdf

Re: Select

Michael P Butler14-Apr-06 20:47

Michael P Butler

14-Apr-06 20:47

Is the correct database active for the query window?

type use databasename or select the database from the drop-down first.

Michael

CP Blog [^] Development Blog [^]

using sql server 2005 express

kani9814-Apr-06 7:40

kani98

14-Apr-06 7:40

I have recently installed sql server 2005 express, but don't know how to use it to create tables that contain data to work with. I would appreciate it if someone could point me to some article or guide to setup and use sql server 2005.

Re: using sql server 2005 express

Paul Conrad14-Apr-06 15:56

Paul Conrad

14-Apr-06 15:56

Download SQL Server Management Studio Express CTP from Microsoft's website so you can create databases, tables, and do other dba type of tasks.

PC

Re: using sql server 2005 express

Jerry Hammond14-Apr-06 18:13

Jerry Hammond

14-Apr-06 18:13

http://blogs.msdn.com/sqlexpress/[^]

http://www.amazon.com/exec/obidos/search-handle-url/104-8947653-8219932?url=index%3Dstripbooks%3Arelevance-above&field-keywords=sql+express[^]

and the best for last

http://msdn2.microsoft.com/en-us/library/ms165706(en-us,sql.90).aspx[^]

Pictures of the menu available at the drive-thru

Re: using sql server 2005 express

Paul Conrad15-Apr-06 4:06

Paul Conrad

15-Apr-06 4:06

And don't forget articles here at CP. Though a majority of them are for SQL 2000, they still can apply to 2005 Big Grin | :-D

Re: using sql server 2005 express

Jerry Hammond15-Apr-06 4:51

Jerry Hammond

15-Apr-06 4:51

Absolutely.

Pictures of the menu available at the drive-thru

C# 2.0 Table Adapter Times Out at 30 Sec

GTWebb14-Apr-06 7:25

GTWebb

14-Apr-06 7:25

I just switched to Visual Studio 2005 so the answer to this maybe easy. I am working on a web application that retrieves Data from a SQL 2000 server. The sql statement takes between 25 and 40 seconds to execute and runs fine in SQL Analyzer. However, it times out in the application until you do a preview Data from the table adapter. Once you successfully get the data to retrieve by testing the table adapter the application works for a while. I have the connection timeout set for 900 in the connection string. Under Tools > Options > Database Tools > I have the cancel long query selection unchecked. It seems that the connection times out at 30 seconds no matter what you set it for.

In Visual Studio 2003 you could set the SQLDataAdapter connection time. In VS 2005 there does not seem to be a setting for that.

Data Source=PSY133;Initial Catalog=WindoPath;Integrated Security=True;Connect Timeout=900

GTWebb
IT System Manager
gtwebb@coastalpath.com

Re: C# 2.0 Table Adapter Times Out at 30 Sec

Colin Angus Mackay15-Apr-06 12:59

Colin Angus Mackay

15-Apr-06 12:59

There are two timeouts. The Connection Timeout is the length of time that you are prepared to wait for it to connect to the database (not do any work). You are looking for the Command Timeout which defines the length of time that the command can take. By default it is set at 30 seconds. You need to change the CommandTimeout on the SqlCommand object you are using.

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

Re: C# 2.0 Table Adapter Times Out at 30 Sec

GTWebb17-Apr-06 5:44

GTWebb

17-Apr-06 5:44

Thanks for guiding me in the right direction. I still have another problem. When I create a partial class to adjust the command timeout.

The _commandCollection and _adapter are always null.

namespace mdsTableAdapters
{
public partial class MedDiagTableTableAdapter
{

public int SelectCommandTimeout
{

get
{
return (this._commandCollection[0].CommandTimeout);
}

set
{
for (int i = 0; i < this._commandCollection.Length; i++)
{
if ((this._commandCollection[i] != null))
{
((System.Data.SqlClient.SqlCommand)
(this._commandCollection[i])).CommandTimeout = value;
}
}
}

}
}
}

Re: C# 2.0 Table Adapter Times Out at 30 Sec

Colin Angus Mackay17-Apr-06 5:50

Colin Angus Mackay

17-Apr-06 5:50

What benefits are you getting from using a partial class in this instance?

GTWebb wrote:
The _commandCollection and _adapter are always null.

Do you ever initialise them somewhere? You don't show that code so I can't see what could be wrong.

Re: C# 2.0 Table Adapter Times Out at 30 Sec

GTWebb18-Apr-06 3:04

GTWebb

18-Apr-06 3:04

I'm using a partial class because that is the only way to get to the CommandTimeout property. The _commandCollection and _adapter are already incorportated into the TableAdapter Class. From everything that I have read they do not need to be initialized.

Here is the project I was basing this from.

http://www.codeproject.com/csharp/TableAdaptrCommandTimeout.asp

Re: C# 2.0 Table Adapter Times Out at 30 Sec

GTWebb18-Apr-06 8:59

GTWebb

18-Apr-06 8:59

To answer my own question. Although all the examples online use _commandCollection I used CommandCollection and it works mooooe butter.

How to restor database

papa198013-Apr-06 21:41

papa1980

13-Apr-06 21:41

Hello everybody could tell me how to restore my db after windows reinstallation?When i try it give me errore "RESTORE DATA BASE MUST BE USED IN SINGLE USER MODE WHEN tring to restor to master database.Restore datebase is terminating abnormally" how to solve it ??????????????
pleas help me Frown | :(

(

-- modified at 3:42 Friday 14th April, 2006

Re: How to restor database

albCode13-Apr-06 21:50

albCode

13-Apr-06 21:50

check this

Create Table from Trigger

Guinness4Strength13-Apr-06 12:20

Guinness4Strength

13-Apr-06 12:20

I'm attempting to create a new table from and INSERT trigger on MSSQL Server.
I've tried the following with no luck...any help out there /

ALTER   TRIGGER [TRG_INS_CLIENTS] ON [dbo].[Clients] 
FOR INSERT
AS
DECLARE @ClientName VARCHAR(50)
SELECT @ClientName = ClientName+'_ParseTable' FROM inserted

CREATE TABLE @ClientName (
	[PrimaryKey] [decimal](18, 0) IDENTITY (1, 1) NOT NULL PRIMARY KEY CLUSTERED,
	[FieldName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Source] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Target] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Steps] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL 
)

Re: Create Table from Trigger

Eric Dahlvang14-Apr-06 10:53

Eric Dahlvang

14-Apr-06 10:53

One possible solution:

CREATE TRIGGER TRG_INS_CLIENTS ON [dbo].[Clients] 
FOR INSERT 
AS
DECLARE @ClientName VARCHAR(50)
SELECT @ClientName = ClientName FROM inserted

EXEC('CREATE TABLE ' + @ClientName + '(
	[PrimaryKey] [decimal](18, 0) IDENTITY (1, 1) NOT NULL PRIMARY KEY CLUSTERED,
	[FieldName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Source] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Target] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[Steps] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL )')

I'm assuming that your field name is ClientName. I'm not sure what +'_ParseTable' is. If it is the field name, then just put ClientName_ParseTable in the select.

Be careful with EXEC() - it opens a door to malicious code.

----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin

Re: Create Table from Trigger

Guinness4Strength16-Apr-06 13:55

Guinness4Strength

16-Apr-06 13:55

Thanks ! I found another solution using sp_sqlexecute() but this one is more elligant.

Re: Create Table from Trigger

Eric Dahlvang17-Apr-06 3:26

Eric Dahlvang

17-Apr-06 3:26

Glad it helped. Here is some info on sp_sqlexec.

SQL Books Online

SQL Server 6.x
sp_sqlexec provided a convenient way for SQL Server database clients and servers to send a language statement of any format to an Open Data Services server application.

SQL Server 2000
Removed; no longer available. Remove all references to sp_sqlexec.

----------
There go my people. I must find out where they are going so I can lead them.
- Alexander Ledru-Rollin

SQL Newbie question

martin_hughes13-Apr-06 7:32

martin_hughes

13-Apr-06 7:32

Hi all,

In a test database I have two tables, which are joined on a primary key. In the first table, this key is an auto-incrementing field.

Can anyone tell me a SQL (ie generic) way of being able to insert records into the primary table, retrieve the Primary Key value and be able to use that in the secondary table to create a related record?

I have thought about using a second query to return the last record entered, hwoever this seems a bit ugly, and would be prone to error in a multi-user environment.

Thanks,

Martin.

Re: SQL Newbie question

mastjabs13-Apr-06 9:38

mastjabs

13-Apr-06 9:38

Is the database SQL server 2000..?U can use the "@@identity" to retrieve the primary key of the last record entered..

Re: SQL Newbie question

martin_hughes13-Apr-06 11:25

martin_hughes

13-Apr-06 11:25

At the moment it's Access - but it could be SQL Server, Oracle OR DB2 in the future

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