ASP.NET Discussion Boards

Re: Tree View

Manas Bhardwaj26-Jun-09 8:33

Manas Bhardwaj

26-Jun-09 8:33

Use this query to get the results

SELECT 
    Category.cat_id, Category.cat_name, SubCategory.Sub_cat_id, SubCategory.sub_cat_name
FROM 
    Category
INNER JOIN SubCategory ON
    Category.cat_id = SubCategory.cat_id
ORDER BY
    Category.cat_id

Now, loop through the results and while the catid is same add the subids as child nodes Rose | [Rose]

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Can some one help me answer this question?

Slow Learner26-Jun-09 7:43

Slow Learner

26-Jun-09 7:43

2).An application using cookie authentication was working fine on another server. When moved to a new server cookie authentication is not working correctly.Which one of the following is the likely explantion of the above problem?

a).The new IIS server is not configured to allow anonymous access.
b).passport authentication is not correctly configured
c).The users are not correctly entering their password
d).The IP address of the new server does not match the prior server IP address.
e).SSL is not properly configured

Thanks,

L

Re: Can some one help me answer this question?

Christian Graus26-Jun-09 9:19

Christian Graus

26-Jun-09 9:19

Have you had your job interview yet ? Some of these options are ridiculous, and if you don't know the answer, you don't deserve the job. Can you tell us which ones can't possibily be the issue, and why ?

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

Re: Can some one help me answer this question?

Slow Learner26-Jun-09 9:27

Slow Learner

26-Jun-09 9:27

I am thinking of either it could a or e. I found this some online site.

Re: Can some one help me answer this question?

Christian Graus26-Jun-09 9:33

Christian Graus

26-Jun-09 9:33

OK, I'd guess at a, and the ones in the middle, included the ones that seemed stupid. If you just found this on some site, I'm not sure why you're asking, but the question would be, why would this stop cookies from working ? I would assume that if you need cookies to login, and the site does not allow anonymous access, that neither condition can be met before the other is. But, I admit to not really knowing for sure. I could just see that some of the answers given were obviously not right.

how to tell when scroll bar is at bottom of an asp.net multiline text box

jumbojs26-Jun-09 7:04

jumbojs

26-Jun-09 7:04

Hello,

I am working on an asp.net page and I have a multiline text box that displays some text. I want the user to have to scroll all the way to the bottom before I display a checkbox for them to continue. My question is how can you tell if the scroll bar is at the bottom?

Re: how to tell when scroll bar is at bottom of an asp.net multiline text box

Not Active26-Jun-09 7:27

Not Active

26-Jun-09 7:27

Have a look here[^], maybe it will help you.

only two letters away from being an asset

Re: how to tell when scroll bar is at bottom of an asp.net multiline text box

jumbojs26-Jun-09 7:40

jumbojs

26-Jun-09 7:40

Thanks for the reply. Well, I don't think I want the position of the browser window. I need to know when a user has finished scrolling to the bottom of the textbox control. So, I think I'd need the scrolling locations inside the textbox control only. I also don't know how to trigger this.

storeduce sql

trinm198726-Jun-09 6:39

trinm1987

26-Jun-09 6:39

problem: I use 1 table book on SQL Server 2005
table book of school:
1. idBook
2.idPublish
3.idAuthor
4.tittle
5.introduction
6.price

table in the book include books have tittle as follows:

1. Văn học việt nam cận đại
2. Tự học tiếng anh
3. tự học lập trình SQL 2005
4. Văn học nước ngoài
5. phát triển website với .net 2005

requirements:

They built storeduce 1 to load data from sql on dataset

storeduce structure as follows:

...
@txtSearch nvarchar (200)

Begin

Select ...

from book

where ...

end
...

I want:
@txtSearch='Văn học cận đại'-->2 record:Văn học việt nam cận đại, Văn học nước ngoài
@txtSearch='lập trình SQl 2005'-->2 record:tự học lập trình SQL 2005,phát triển website với .net 2005

Thanks you!

Re: storeduce sql

Enver Maroshi26-Jun-09 6:52

Enver Maroshi

26-Jun-09 6:52

May i ask what is "storeduce"?

Btw, are you searching for "LIKE"?
SELECT idBook FROM Book WHERE title LIKE N'%van hoc%'

Re: storeduce sql

Not Active26-Jun-09 6:54

Not Active

26-Jun-09 6:54

I can't even make out what you're trying to ask Confused | :confused:

only two letters away from being an asset

Re: storeduce sql

Manas Bhardwaj26-Jun-09 8:40

Manas Bhardwaj

26-Jun-09 8:40

In which language Stored Procedure is called storeduce???
Anyways, Lemme give it a try. Poke tongue | ;-P

SELECT * FROM book WHERE title like @txtSearch

This is the most I(or probably anyone in this world) can do for you.
Buddy, You really need to ask your question properly. Rose | [Rose]

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

How to build a guestbook or How to send mail filled with form items

ashutosh_karna26-Jun-09 6:36

ashutosh_karna

26-Jun-09 6:36

I want to make a guestbook for users visiting my site.
I have some textboxes wherein user enters his name, email address, & a message. At the bottom there is a button called "post". As soon as a user fills up the textboxes & clicks post buuton. I want the message to be shown on my page along with their details.
Does anybody have an idea how to do this? Or How can I send a mail filled with form item details.

Re: How to build a guestbook or How to send mail filled with form items

Not Active26-Jun-09 6:51

Not Active

26-Jun-09 6:51

Posting user supplied data to a webform? Gee, I don't know, sounds rather difficult Roll eyes | :rolleyes:

Get an ASP.NET book, drop it on the floor and look at the page that is open. I bet you'll find the answer.

only two letters away from being an asset

can i implement print preview code to force print preview option before printing on all types of documents

marjanaprifti26-Jun-09 4:48

marjanaprifti

26-Jun-09 4:48

i am a 100 pc network adminstrator. i want to safe soem paper and tone so i was thinking to implement a solution to that; force print preview option before printing on all types of documents. i saw posted the "PrintPreview_scr" code but i don't know how to adopt it to my domain users.

thanks a lot for any reply

Re: can i implement print preview code to force print preview option before printing on all types of documents

ToddHileHoffer26-Jun-09 5:00

ToddHileHoffer

26-Jun-09 5:00

This is the asp.net forum. I think you meant to post this elsewhere.

I didn't get any requirements for the signature

Re: can i implement print preview code to force print preview option before printing on all types of documents

Abhijit Jana26-Jun-09 5:10

Abhijit Jana

26-Jun-09 5:10

marjanaprifti wrote:
am a 100 pc network adminstrator. i want to safe soem paper and tone so i was thinking to implement a solution to that; force print preview option before printing on all types of documents. i saw posted the "PrintPreview_scr" code but i don't know how to adopt it to my domain users.

How does it related to ASP.NET ? Confused | :confused:

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Hidden Query String

scotlandc26-Jun-09 3:45

scotlandc

26-Jun-09 3:45

Hi all,

Is it possible to get access to a query string when its hidden from view? Google's query string would be easy to do as you can capture the value of 'q' from the string, change it then set it away searching as its visible.

It doesn't matter to the application that the user can't see (or does not need to see) the query string but how can I capture it, manipulate it behind the scenes than pass it to be processed?

Cheers

Scott

Re: Hidden Query String

Manas Bhardwaj26-Jun-09 4:22

Manas Bhardwaj

26-Jun-09 4:22

You can use hidden variables.
You can also use context variable with Server.Transfer method for moving one page to another.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Hidden Query String

scotlandc26-Jun-09 4:32

scotlandc

26-Jun-09 4:32

Thanks for that, didn't know you could do that.

Will that also grant access to the query string as well? Will need to see it to extract the parameter names from the query string?

Hiding value into grid view

Bandanenilima26-Jun-09 1:56

Bandanenilima

26-Jun-09 1:56

Hello
can we hide any column into grid view where we can store any id of particular item which can be use for further operation
plz any one guide me
if any body has its samples solution plz give ge

Re: Hiding value into grid view

padmanabhan N26-Jun-09 2:00

padmanabhan N

26-Jun-09 2:00

instead of storing it in any column and hiding it you can use datakeys.....

sample code:

//in RowEditing event
int row = e.NewEditIndex;
string id = GridView1.DataKeys[row][0].ToString();

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

Re: Hiding value into grid view

Gary Stafford26-Jun-09 2:45

Gary Stafford

26-Jun-09 2:45

If I understand your question correctly, wouldn't setting the columns Visible property to false provide you with the solution you seek (Visible="false"). This is a very common technique.

Regards,

Gary

can't get multiple files when attachment through stream class.

pujafaldu26-Jun-09 1:54

pujafaldu

26-Jun-09 1:54

Hi...
here i have send mail with attachment file.
i have used stream class for sending attachment.

Here is code......

public bool SendMailToExternalUser(string strToEmail, string strbody, string strSubject, string strFileName, Stream FileStream,bool bCheck)
{
bResult = false;

MailAddress from = new MailAddress(Config.MailFrom);
MailAddress to = new MailAddress(strToEmail);

MailMessage mail = new MailMessage(from, to);
mail.Subject = strSubject;
mail.Body = strbody;
mail.IsBodyHtml = true;
mail.Sender = from;

Attachment attachFile = new Attachment(FileStream, strFileName);
mail.Attachments.Add(attachFile);

if (bCheck == true)
{
SmtpClient SmtpMail = new SmtpClient(Config.MailServerSmtp);
SmtpMail.Send(mail);
bResult = true;
}
bResult = true;
}

this works fine when there is only one file to attach.
but if i want to attach multiple files then it overwrite to first file with second.
how can i get more then one file in FileStream?

kindly help to solvethis issue.
Thanks.

Regards,
PUJA FALDU

Re: can't get multiple files when attachment through stream class.

Manas Bhardwaj26-Jun-09 2:31

Manas Bhardwaj

26-Jun-09 2:31

pujafaldu wrote:
but if i want to attach multiple files then it overwrite to first file with second.

How are you attaching multple files?
The code only seems to work as far as there is one attachment.

In fact your method should look like:

public bool SendMailToExternalUser(string strToEmail, string strbody, string strSubject, List<string> PlstFileNames, List<Stream> PlstStreams)
		{
			MailAddress from = new MailAddress(Config.MailFrom);
			MailAddress to = new MailAddress(strToEmail);

			MailMessage mail = new MailMessage(from, to);
			mail.Subject = strSubject;
			mail.Body = strbody;
			mail.IsBodyHtml = true;
			mail.Sender = from;
			
			for(int LiCount = 0; LiCount < PlstFileNames.Count; LiCount++)
			{
				Attachment attachFile = new Attachment(PlstStreams[LiCount], PlstFileNames[LiCount]);
				mail.Attachments.Add(attachFile);
			}

			SmtpClient SmtpMail = new SmtpClient(Config.MailServerSmtp);
			SmtpMail.Send(mail);
		}

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

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