Checking The null condition - ASP.NET Discussion Boards

Re: how to we implement function keys in asp.net

Sathesh Sakthivel8-Dec-07 2:12

8-Dec-07 2:12

<input type="text" name="txtPostalCode" onkeypress="if(!isNS4){if(event.keyCode < 45 || event.keyCode > 57) event.returnValue = false;}else{if(event.which < 45 || event.which > 57) returnfalse;}" />

use this and call that javascript function from this so it will call that function when ever u click mouse or when ever use tab, its client too...

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Re: how to we implement function keys in asp.net

Pushpendra patwal8-Dec-07 2:17

Pushpendra patwal

8-Dec-07 2:17

try event.keyCode in i.e.
for mozilla it's event.which

P.S.

Re: how to we implement function keys in asp.net

M.Ramesh8-Dec-07 2:36

M.Ramesh

8-Dec-07 2:36

thanks, i will check it and inform to all..

how the data table values remains untill the application is closed

jagan1238-Dec-07 1:23

jagan123

8-Dec-07 1:23

iam getting data from a database and iam storing that data in a datatable ..now i want this data to retain its values for every event calling how and if any updation is made to the table in any event then it should got effected to that data table..and also even the page is post back also it should retains its value untill the application closed.

Re: how the data table values remains untill the application is closed

Pushpendra patwal8-Dec-07 2:09

Pushpendra patwal

8-Dec-07 2:09

Jagdeesh since you are on ASP.NET you will have to expicitly "maintain the state" of the DataTable.
heck out topic for state maintainance in ASP.NET

P.S.

Re: how the data table values remains untill the application is closed

Sathesh Sakthivel8-Dec-07 2:16

Sathesh Sakthivel

8-Dec-07 2:16

The three session state options for ASP.NET are:

In-Process
Out-Of-Process with a Windows Service
Out-Of-Process with SQL Server

Use this to maintain the state sesion. More more details Get it

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Crystal Reprot problem

Raza Hussain8-Dec-07 0:36

Raza Hussain

8-Dec-07 0:36

Hi! All
I m trying to creating crystal reports with push method (via Dataset);
but when it runs it displays a form that "The reprot you requested requires further information.
then has four textboxes Server name & Database name are uneditable,and other two are userID & password. ";
it never displays report.
But all works when i use to create crystal reprots with pull method (except dataset); it pop up same form over there but all fields are editable.
I set Crystaldecisions.share.connectionInfo at pageload event but it all in vain.
so how i solve this. any suggestion regarding this will be anticipated.

Thanks in advance.

Checking The null condition

SreejithAchutan8-Dec-07 0:13

SreejithAchutan

8-Dec-07 0:13

How i check if a cloumn value is null when already a search condition is avilable.I want to put a cloumn value from the database.Getting the value on a serch condition,also if the returned value is null thn an error occurs in sql.I want to chk if the value is null or not ,if the value is not null return the value..How the query is wriiten for that.

sqlstatement = "SELECT UnitId FROM user_UnitRoles WHERE UserId='"+UserId+"' ";
object s=dbtObj.GetColumnValue(sqlstatement, "UnitId");
return s.GetType().ToString();

I attach the query with this mail .Plz tell what changes i want to do

Re: Checking The null condition

Pushpendra patwal8-Dec-07 2:14

Pushpendra patwal

8-Dec-07 2:14

I am not sure what you asking but i feel you should try to compare returned value to
System.DBNull in .NET CLR.

P.S.

Re: Checking The null condition

Gamzun9-Dec-07 0:02

Gamzun

9-Dec-07 0:02

change your logic, if your GetUnitId method doesn't have any record then it should return something which shows that it's null.

Push your brain and it will work out for you

Differences

John.L.Ponratnam7-Dec-07 22:44

John.L.Ponratnam

7-Dec-07 22:44

what is the difference between Server.HtmlDecode and Server.HtmlEncode

Regards,
LEE

Re: Differences

Christian Graus7-Dec-07 23:21

Christian Graus

7-Dec-07 23:21

I'd have thought that was obvious. What does MSDN say ?

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Differences

Sathesh Sakthivel8-Dec-07 0:26

Sathesh Sakthivel

8-Dec-07 0:26

Server.HtmlEncode encodes data and should be performed anytime that you are allowing for free text in an input field. Server.HtmlDecode decodes data that have been encoded with Server.HtmlEncode.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

how to clear a seesion

jagan1237-Dec-07 22:11

jagan123

7-Dec-07 22:11

hi iam using session("varname");now i want to clear this session how it wiil be possible plz

Re: how to clear a seesion

John.L.Ponratnam7-Dec-07 22:46

John.L.Ponratnam

7-Dec-07 22:46

You can use session("varname")=null; to clear the session

Regards,
LEE

Re: how to clear a seesion

Pushpendra patwal8-Dec-07 2:26

Pushpendra patwal

8-Dec-07 2:26

Hi
Session object in ASP.NET implements ICollection interface
So Session has a method
Session.Remove("entityName") ;

to remove all the items in Session collection one may use
Session.RemoveAll();
Session.Clear();

P.S.

Re: how to clear a seesion

Paul Conrad9-Dec-07 12:48

Paul Conrad

9-Dec-07 12:48

By using Session("varname").Remove

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

spam filter

Member 45325047-Dec-07 21:22

Member 4532504

7-Dec-07 21:22

how to develop spam filter application using asp.net with c#.net
plz help me

Re: spam filter

Michael Sync7-Dec-07 22:10

Michael Sync

7-Dec-07 22:10

You probably need to have the list of spammer ip addresses in your database or need to use the third-party service for that..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

Re: spam filter

Christian Graus7-Dec-07 23:23

Christian Graus

7-Dec-07 23:23

ASP.NET is not an appropriate technology to use here, unless you're writing an app that reads mail online. Otherwise, why do you need web pages to filter spam ?

Re: spam filter

Michael Sync7-Dec-07 23:31

Michael Sync

7-Dec-07 23:31

maybe... he is writing the blogging engine or something. and no wish to use CAPTCHA. Smile | :)

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

help me

manoj_kumar25117-Dec-07 21:19

manoj_kumar2511

7-Dec-07 21:19

any one help me,

i am developing an application in asp.net having Mysql as backend.my problem is that my .aspx pages are present in iis in one computer and my mysql database runing in linux machine. i am passing a query like

SELECT * INTO OUTFILE 'd/temp/backup.sql' FIELDS TERMINATED BY ',' FROM cris_cdr WHERE DATE_FORMAT(myDate,'%Y-%m-%d') >= '2007-06-24' and DATE_FORMAT(myDate,'%Y-%m-%d') <= '2007-12-06'

but it is throwing error as

Error Code : 1
Can't create/write to file 'd\temp\backup.sql' (Errcode: 2)
(78 ms taken)

i kwnow that the above query try to writting in the same machine(linux).

can you help me how i can write .sql file in iis machine.

thanks
manoj kumar

Re: help me

Christian Graus7-Dec-07 23:25

Christian Graus

7-Dec-07 23:25

Seems to me that you're just asking for grief. Why not install MySQL on the Windows machine ?

Create own asseblies and custom controls for asp.net

Member 38798817-Dec-07 19:51

Member 3879881

7-Dec-07 19:51

Hi i am using vs2003...,
I like to know how to create our own assemblies for our project...,
And i like to know custom controls for asp.net,
I have searched in google but i didnt get some good articles abt that,
Plz u guys if u know, suggest me some good sites with sample codes..,

Thanks & Regards,
Mageshh,
please don't forget to vote on the post

Re: Create own asseblies and custom controls for asp.net

Michael Sync7-Dec-07 21:04

Michael Sync

7-Dec-07 21:04

Have you checked Authoring Custom Controls - Quick Start[^] and Building ASP.NET User and Server Controls -- Part 1[^] which are shown in the first result of Google?

Here is the list of custom control articles that we have on CP.
http://www.codeproject.com/KB/custom-controls/[^]

My advice is that don't spend too much time for finding the good resource and thinking too much.. Just make a search on Google. Read one or two articles that you got from Google.. and start writing your own very basic control.. then, you will get more idea..

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

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