473,508 Members | 2,079 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

name that tune

hey all,

i have a formview that contains a dropdownlist. it's datasource is coming
from a table. the selectedValue can be blank. Would it better to add a blank
in the database table or dynamically in the code-behind. And how many
routines would i need in either case? (I'm looking for the most efficient
way, am I incorrect to do so?)

Thanks,
rodchar
Jan 30 '07 #1
3 969
What would a blank entry indicate?

I have never seen a need for a blank entry in a database. Not a good idea.
(unless by blank you mean a null value?)
"rodchar" <ro*****@discussions.microsoft.comwrote in message
news:69**********************************@microsof t.com...
hey all,

i have a formview that contains a dropdownlist. it's datasource is coming
from a table. the selectedValue can be blank. Would it better to add a
blank
in the database table or dynamically in the code-behind. And how many
routines would i need in either case? (I'm looking for the most efficient
way, am I incorrect to do so?)

Thanks,
rodchar

Jan 30 '07 #2
i think that answers my question. The blank is for the dropdownlist so that
if the selection is blank it will store a null in the database. thanks, rod.

"Daniel" wrote:
What would a blank entry indicate?

I have never seen a need for a blank entry in a database. Not a good idea.
(unless by blank you mean a null value?)
"rodchar" <ro*****@discussions.microsoft.comwrote in message
news:69**********************************@microsof t.com...
hey all,

i have a formview that contains a dropdownlist. it's datasource is coming
from a table. the selectedValue can be blank. Would it better to add a
blank
in the database table or dynamically in the code-behind. And how many
routines would i need in either case? (I'm looking for the most efficient
way, am I incorrect to do so?)

Thanks,
rodchar


Jan 30 '07 #3
Ah yes in that case code checks if it is blank, if so insert a null yep.
"rodchar" <ro*****@discussions.microsoft.comwrote in message
news:04**********************************@microsof t.com...
>i think that answers my question. The blank is for the dropdownlist so that
if the selection is blank it will store a null in the database. thanks,
rod.

"Daniel" wrote:
>What would a blank entry indicate?

I have never seen a need for a blank entry in a database. Not a good
idea.
(unless by blank you mean a null value?)
"rodchar" <ro*****@discussions.microsoft.comwrote in message
news:69**********************************@microso ft.com...
hey all,

i have a formview that contains a dropdownlist. it's datasource is
coming
from a table. the selectedValue can be blank. Would it better to add a
blank
in the database table or dynamically in the code-behind. And how many
routines would i need in either case? (I'm looking for the most
efficient
way, am I incorrect to do so?)

Thanks,
rodchar



Jan 30 '07 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

23
63613
by: stewart.midwinter | last post by:
No doubt I've overlooked something obvious, but here goes: Let's say I assign a value to a var, e.g.: myPlace = 'right here' myTime = 'right now' Now let's say I want to print out the two...
3
2736
by: Jason | last post by:
Does anyone know? Thanks so much.
2
2726
by: Ravi | last post by:
My XML looks like: <abc> <def type="apple"> 1 </def> <def type="peach"> 2 </def> <def type="orange"> 3 </def> <def type="banana"> 4 </def> <def type="plum"> 5 </def> </abc>
1
2616
by: discomiller | last post by:
Mario Mueller: Hello *, radiobuttons belong to other radiobuttons by the "name="any_value"" attribut. Thats a fakt. I got the following XML:...
1
5081
by: gilgantic | last post by:
HELP!!! I am trying to fine tune or rewrite my SELECT statement which has a combination of SUM and CASE statements. The values are accurate, but the query is slow. BUSINESS RULE =============...
3
1429
by: Hans Horn | last post by:
Howdy, is there a way to speed-up or tune the database creation? On my laptop (DB2-UDB PE) it takes 2 minutes to create a virgin database. This virgin, btw. is 30MBytes heavy. Is there a way to...
6
4461
by: kvsnramesh | last post by:
hi, I have a problem asked by one of my senior person and finding the answer . What is the step by step procedure for tune a large sql query. OR how do we tune a large SQL query with somany joins
1
5984
by: ivanet | last post by:
Hello everyone, I am trying to use the following Schema but I get the error "src- resolve: Cannot resolve the name 'ValuesList' to a(n) 'element declaration' component." at line 144. I have...
8
2372
by: rshivaraman | last post by:
Hi : I have a TableA with around 10 columns with varchar and numeric datatypes It has 500 million records and its size is 999999999 KB. i believe it is kb i got this data after running...
3
1258
by: travolta001 | last post by:
Speed up your system, repair registry base, uninstall hidden windows components and get rid of boring errors with powerful tips and tricks. Very useful tips from other good sites. ...
0
7226
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7388
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7049
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5631
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5055
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4709
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3186
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1561
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
767
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.