Re: [newbie] Cannot insert null value to SQL Server identity column - ASP.NET Discussion Boards

how does it evaluates the LOC - when you try to debug the line below
if (webctrl.ImageUrl.Equals("") == false)

Hallo,

I have a DataSet from 2 DB tables, and i want to databind some textboxes(say N, created dynamically) at runtime.
Is it possible to have 2-way databinding without using gridview or reapeater etc.
That is, i have a set of textboxes and labels in a table. The textboxes should implement 2-way databinding.
Thanks

Hi,

Can anyone help me with the following problem please;

I need to drop the 'www' part of a url whenever it is entered by a visitor. So for example if they type 'www.domain.com/' it goes to 'domain.com/'. Likewise it should do the same for specific files and folders eg 'www.domain.com/files/test.jpg' should redirect to 'domain.com/files/test.jpg'.

The updated domain name should be shown in the url.

I am running this on IIS on a dedicated machine over the web. I using the 'redirect' function in IIS i can only get it to redirect to a specific url rather than the exact corresponding file / domain location.

WOuld it be better to do this with a .Net config file?

Help greatly appreciated.

Thanks!!!

I googled and found
http://www.samburdge.co.uk/wordpress/wp-plugin-remove-www-from-url[^]

Check it out

You may try like following code snippet

//Extract relative URL by chopping www. from begining
private string newUrl = System.Text.RegularExpressions.Regex.Replace("www.domain.com/files/test.jpg",
"^www\.", String.Empty);

//Redirect to new URL
Server.Transfer(newUrl);

Hope I answered you correctly Smile | :)

dnpro
"Very bad programmer"

My Latest Articles
RichTextBox Control with Find functionality
LogViewer - A Simple Log Listening Utility

I'm trying to pass values within an insert statement, however, I'm not sure what is the best way to pass the most appropriate value to the taskID_PK column bigint identity. The identity column is normally filled in automatically.

An insert statement to the table returns the following error:
Cannot insert the value NULL into column 'taskID_PK', table 'teamwiki.dbo.task'; column does not allow nulls. INSERT fails.\rThe statement has been terminated."

VS 2005 / ASP.NET 2.0
SQL Server 2005 Express

Related links:
Understanding identity columns

Jon

How does the insert-statement look like? Do you set the identity column explicit?

Regards
Sebastian

p.S: Are you sure that the primary key is generated automatically?

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Well the insert statement excludes this key, because I assumed Smile | :)

, that the behavior would be similar to that as when I update the table manually, for example:

"INSERT INTO [teamwiki].[dbo].[task]\r
([category_FK1]\r 
,[sub_category_FK2]\r                         
,[ideal_delivery_date]\r                                       
,[latest_delivery_date]\r                                       
,[task_deadline]\r                                       
,[request_date]\r                                       
,[requesting_user]\r                                       
,[assigned_to]\r                                       
,[managed_by]\r                                       
,[implementor_notes]\r                                       
,[attachment] \r                                       
,[last_update]\r                                       
,[in_use])\r            
VALUES   (@category, \r                                       
@sub_category,\r                                       
@task_description,\r                                       
@priority,\r                                      
@status, \r                                       
@ideal_delivery_date,\r                                       
@latest_delivery_date,\r                                       
NULL,\r                                       
GETDATE(),\r                                       
@requesting_user,\r                                       
NULL,\r                                       
NULL,\r                                       
NULL,\r                                       
NULL,\r                                       
@in_use,\r                                       
@product)"  string

In my case, the primary key is named taskID_PK, as previously posted.

2. When I update data manually (e.g. through SQL Management Studio > right click on the table > Open table), the key is automatically incremented.

3. I created the table with an identity trigger simply using SQL Management Studio:

3.1 Taking a copy of the CREATE TABLE. Right click on table name > Script Table As > CREATE TO > New Query Window.
3.2 Dropping the table. Right click on the table name > delete.
3.3 Altering the CREATE TABLE statement to include identity:

GO
/****** Object:  Table [dbo].[task]    Script Date: 01/27/2009 19:42:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[task](
	[taskID] [numeric] (2, 0) identity NOT NULL,
	[task_description] [nvarchar](50) NULL,
	[date_entered] [datetime] NULL,
	[productID_FK1] [numeric](2, 0) NULL,
 CONSTRAINT [PK_task_1] PRIMARY KEY CLUSTERED 
(
	[taskID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[task]  WITH CHECK ADD  CONSTRAINT [FK_task_product] FOREIGN KEY([productID_FK1])
REFERENCES [dbo].[product] ([productID])
GO
ALTER TABLE [dbo].[task] CHECK CONSTRAINT [FK_task_product]

Attempted solutions
-------------------
Since the key is a primary key, it doesn't accept any NULL values; it was recommended to use identity columns as opposed to a trigger that alters the table upon insert, because "it would be a computational suicide".

Related links
--------------
Forum post[^]

Jon

Hmmm, sounds difficult. Maybe you have to activate the Identity_Insert property explicit. Run this query before you insert a line:

SET IDENTITY_INSERT taskID_PK OFF

Could you provide a snippt of the code, executing the command?

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

I have created a windows control project. The control contains a datagridview. Now I'm trying to get it to work on an asp .net page. I have put the following code in the page:

<object id="myControl1" name="myControl1" classid="MyClientControl.dll#MyClientControl.AuthorsControl" style="width: 505px; height: 145px></object><br mode=" hold=" /><br mode=">

You know this means your users need .NET installed and need to fully trust your site over IE's warnings, right ?

Christian Graus

Driven to the arms of OSX by Vista.

Yes I know.

Hi
Error updating JScript IntelliSense: Client-side script IntelliSense information was not generated due to an error in an external script reference.

How can I fix it ?

I follow this step from :

- Step 1: Install VS 2008 SP1

VS 2008 SP1 adds richer JavaScript intellisense support to Visual Studio, and adds code completion support for a broad range of JavaScript libraries.

You can download VS 2008 SP1 and Visual Web Developer 2008 Express SP1 here.

- Step 2: Install VS 2008 Patch KB958502 to Support "-vsdoc.js" Intellisense Files

But nothing still receive this error in visual studio.

Please help

Thanks

how to fetch stock market values in asp.net application,is there any script available,please let me know

hi this is rakesh

First of all you have to find a service that will give you this information. They will tell you how to retrieve the information in the format that they deliver it in (probably some XML structure these days)

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

Wow - do you have any idea what ASP.NET is, and does ? I doubt it.

Christian Graus

Driven to the arms of OSX by Vista.

Hi Rakesh,

I am not sure why you need stock quotes in your ASP.NET site. Although I would like to share that it is not legal , Please check http://www.bseindia.com/about/faq.htm#TERCOD[^]

dnpro
"Very bad programmer"

My Latest Articles
RichTextBox Control with Find functionality
LogViewer - A Simple Log Listening Utility

Hi,

I cannot find a visual studio forums section in this site and so i have posted my question here..

When i try to build my Business Logic Module Of My Applicatio, It takes a long time to build for a very small change.. say(if i change int i to int j), it takes nearly 10 mins to build the BL module alone..

What could be the reason behind it ..

Thanks in advance.. and Sorry for the inconvenience for posting this qn in ASP.NET forum.. Smile | :)

jchandramouli wrote:
I cannot find a visual studio forums section in this site

Here[^].

jchandramouli wrote:
When i try to build my Business Logic Module Of My Applicatio, It takes a long time to build for a very small change.

How many projects are there in solution?

Navaneeth

How to use google | Ask smart questions

I imagine that lots of things depend on your business logic "module" and so when you change that all the dependencies have to ensure they still compile against the new "module".

* Developer Day Scotland 2 - Free community conference
* The Blog of Colin Angus Mackay

Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.

May be this can help you Your application takes a long time to build and a keystroke delay occurs when you edit code in Visual Studio .NET or Visual Studio 2005[^]

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

I have a treeview control which mostly displays pdf's. Currently when i left click on the pdf it goes to new page and opens the pdf. How can i have the pdf open in same window and be able to see both the treeview and the pdf on the same screen

Split your page with HTML frames.

Navaneeth

How to use google | Ask smart questions

Is there a better way for VS 2005? or is this the only way?

and how to tell it to open the pdf in the other frame?

Civic06 wrote:
Is there a better way for VS 2005?

VS2005 is an IDE and how it can control where PDF is opened?

Civic06 wrote:
and how to tell it to open the pdf in the other frame?

By setting the target[^] attribute to the hyperlink.

Navaneeth

How to use google | Ask smart questions