ASP.NET Discussion Boards

SreejithAchutan8-Dec-07 0:13

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)

https to http

jithbiz00337-Dec-07 19:51

jithbiz0033

7-Dec-07 19:51

Hai Guys

In my hosting site SSL is enabled. I am able to access login page in secure(https)mode. After this page i need to convert the url from https mode to http. How to do it?

If you have any suggestions or coding, please reply.

Thanks
Jith

Re: https to http

Michael Sync7-Dec-07 20:56

Michael Sync

7-Dec-07 20:56

All you need to do is that just redirecting the https page to http page. but if you are using the ASP.NET session, you probably need to do a lib more work for that.

You can check-out the link below.
Switching Between HTTP and HTTPS Automatically: Version 2[^]

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

Create Own Drive

raushan_97-Dec-07 19:19

raushan_9

7-Dec-07 19:19

Hi....
I want to Create drive on own server..Just Like Gmail Drive

Re: Create Own Drive

Michael Sync7-Dec-07 19:45

Michael Sync

7-Dec-07 19:45

What do you mean by "creating a drive"? Virtual partition or ??

GMail Drive is the same as GMail (but with filter). So, All files that you store in GDrive is actually stored in GMail Mail Server. So, If you want to do that, just host the Email server with larger maximum attachment size. then write another client application like GDrive that fake users not to know whether they are sending a mail or transferring the file.

Anyway, I don't think this is a good idea.

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

arrays with for loop

rameshdontagani7-Dec-07 18:31

rameshdontagani

7-Dec-07 18:31

hi,

i have a dagrid..in that checkboxes are there with ids of 1,2,3;

i am passing the ids to that grid are 2,1..accordig to my logic those checkeboxes(1,2) has to be checked =true

for ids 1,2 it is working

if i pass the 3,2 then only 2nd checkbox is checking

if i pass the 3...then no checkbox is checked...
last checkbox is not checking for the last id..

i wrote the code like this in the databound event

strScheduleIds=strScheduleId.Split(',');(here the values i am getting which i passed from the otherpage .)
for(i=0;i<strScheduleIds.Length;i++)
{
foreach(DataGridItem dg in dglist.Items) {
if(dg.Cells[9].Text.ToString()==strScheduleIds[i].ToString()
) {
((CheckBox)dg.FindControl("chk1")).Checked=true; }
}
}

Re: arrays with for loop

Michael Sync7-Dec-07 19:39

Michael Sync

7-Dec-07 19:39

Have you tried to debug your code? strScheduleIds.Length - 1 in first for-loop?

Are dg.Cells[9].Text.ToString() and strScheduleIds[i].ToString() the same if you pass "3"?

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

session is not going to next page...help me

sowvin7-Dec-07 17:30

sowvin

7-Dec-07 17:30

hi...

iam not able to retrive session data in the next page...but i am able to retrive in same page what may be the problem.....plz tell me if any settings has to be change

i have used this code:
in first page in buttun click

Session["uid"]=txtuid.Text;

in next page

lblsessionview.Text=(string)Session["uid"];

plz tell me where iam doing wrong

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