how to traverse through the records using sql datareader - ASP.NET Discussion Boards

Menu Control with double functionality needed....

urvipin25-Mar-09 23:57

25-Mar-09 23:57

Hi,
I am using a Master Page with Header, Footer, Left Column, Center (where Content Place Holder will be) and Right Column.

Now, my I have a SQL Database Driven Menu Control in the header like this:---

http://img403.imageshack.us/img403/8099/dddl.jpg[^]

Now it is working fine. The thing I want it, suppose the user clicks on "Forum".

The "Forum" related webpage will be loaded and corresponding page will be displayed in the center (content place holder section).

At this time, what should happen is that corresponding Menu Hierarchy should be displayed in the Left Column, something like this:---

http://img207.imageshack.us/img207/6738/dd2n.jpg

I am using C# in ASP.NET, please suggest some solution with code if possible...

thanx in advance

Re: Menu Control with double functionality needed....

annapurna.tiwari26-Mar-09 1:10

annapurna.tiwari

26-Mar-09 1:10

You want "Support" menu control on Left Column ,when user clicks header Forum ?

Re: Menu Control with double functionality needed....

urvipin26-Mar-09 1:22

urvipin

26-Mar-09 1:22

yes... same way if user clicks on ABC, ABC Menu should be there on the left hand side, and the new menu on left hand side should also offer URL features.

How could i access data from a Table through Javascript?

Subin Alex25-Mar-09 23:39

Subin Alex

25-Mar-09 23:39

Hi,
i am developing a web app. and i got a control in javascript to show images, my question is:
If the path of the image is to be dynamically given from the database table,How could i write the code for that?
Plz help.

want dynamically change the Items Control(FileUploadControl.xaml) in scrollviewer "Silver Light"

Piyush Vardhan Singh25-Mar-09 23:36

Piyush Vardhan Singh

25-Mar-09 23:36

Hi Friends
I am using silver light and i have taken ScrollViewer.Just i want dynamically change the Items Control(FileUploadControl.xaml) in scrollviewer:-

(scrollviewer x:name="filesScrollViewer" grid.row="3" horizontalscrollbarvisibility="Disabled" verticalscrollbarvisibility="Visible" background="White" xmlns:x="#unknown")

(itemscontrol x:name="fileList">
(itemscontrol.itemtemplate>
(datatemplate>
(app:fileuploadrowcontrol margin="0,2" xmlns:app="#unknown">(/app:fileuploadrowcontrol>
(/datatemplate>

(/itemscontrol.itemtemplate>

(/itemscontrol)

(/scrollviewer>)

It Possible Please Help Me....

thanks

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

Re: want dynamically change the Items Control(FileUploadControl.xaml) in scrollviewer "Silver Light"

Abhishek Sur25-Mar-09 23:38

Abhishek Sur

25-Mar-09 23:38

I think there is a special forum specific to Silverlight. Why dont you post there? Confused | :confused:

Abhishek Sur

My Latest Articles
Basics on LINQ and Lambda Expressions

Create .NET Templates

Re: want dynamically change the Items Control(FileUploadControl.xaml) in scrollviewer "Silver Light"

Piyush Vardhan Singh25-Mar-09 23:41

Piyush Vardhan Singh

25-Mar-09 23:41

Thanks Sir I am new in silverlight

Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com

how to traverse through the records using sql datareader

nerzhul8625-Mar-09 22:34

nerzhul86

25-Mar-09 22:34

We are doing a project in asp.net 2.0 with sql server 2005,we need to move to the next record at the click of a button.We are using an sql datareader,we have one button 'show',to show each record,and in the page load, the following code is there:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

regid.Text = "1"

mysql = "select que_bank.que_no,que_bank.ans,testquestions.ans from testquestions,que_bank where que_bank.que_no=testquestions.que_no and testquestions.reg_id='" & regid.Text & "'"
cmd.CommandText = mysql

myconn.Open()
objdr = cmd.ExecuteReader()
End Sub

Protected Sub show_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles show.Click
objdr.Read()
queno.Text = objdr.GetValue(0)
cans.Text = objdr.GetValue(1)
urans.Text = objdr.GetValue(2)
End Sub

Can anyone help us?

Re: how to traverse through the records using sql datareader

anilpal25-Mar-09 22:41

anilpal

25-Mar-09 22:41

Hi,

Can u use DataTable in place of DataReaader?

Regards
Anil Pal

Re: how to traverse through the records using sql datareader

logiclabz25-Mar-09 23:32

logiclabz

25-Mar-09 23:32

I hope this is a bad practice..

In your code connection is open and seems to be never closed.

Best thing to do is to use Paging in Sql server with @rowsPerPage being 1 and @pageNum being row no.

hope u understand the concept

-----------------
logiclabz

how to use capcha code

JAYRAJ GIRI25-Mar-09 22:10

JAYRAJ GIRI

25-Mar-09 22:10

hello i want code in use capcha img use and give small example
Thanx @};-

Re: how to use capcha code

Abhijit Jana25-Mar-09 22:43

Abhijit Jana

25-Mar-09 22:43

JAYRAJ GIRI wrote:
hello i want code in use capcha img use and give small example

One Excellent Article from code project
http://www.codeproject.com/KB/aspnet/CaptchaImage.aspx[^]

cheers,
Abhijit
CodeProject MVP

Re: how to use capcha code

N a v a n e e t h25-Mar-09 23:26

N a v a n e e t h

25-Mar-09 23:26

I recommend this[^]

Navaneeth

How to use google | Ask smart questions

How to get the Client Machine IP Address if Using Proxy

Robymon25-Mar-09 21:29

Robymon

25-Mar-09 21:29

How to get the Client Machine IP Address if Using Proxy and also not. I Tried the following code, but all the code is returning 127.0.0.1.

1) TextBox1.Text = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

2) if (Context.Request.ServerVariables["HTTP_VIA"] != null) // using proxy
{
TextBox1.Text = Context.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString(); // Return real client IP.
}
else// not using proxy or can't get the Client IP
{
TextBox1.Text = Context.Request.ServerVariables["REMOTE_ADDR"].ToString();
}

3) TextBox1.Text = HttpContext.Current.Request.ServerVariables["REMOTE_HOST"];

4) TextBox1.Text = HttpContext.Current.Request.UserHostAddress.ToString();

Re: How to get the Client Machine IP Address if Using Proxy

Ravindra Bisen25-Mar-09 22:12

Ravindra Bisen

25-Mar-09 22:12

Hi dear,

just try this
using System.Net;

and code :
String strHostName, IPadd;
strHostName = Dns.GetHostName();
IPAddress[] addr = Dns.GetHostAddresses(strHostName);
IPadd = addr[0].ToString();

Re: How to get the Client Machine IP Address if Using Proxy

Robymon25-Mar-09 22:50

Robymon

25-Mar-09 22:50

This is showing the private IP of the Machine, not the actual IP.

Re: How to get the Client Machine IP Address if Using Proxy

logiclabz25-Mar-09 22:55

logiclabz

25-Mar-09 22:55

I think you are running this with http://localhost/...

if upload in some live server
System.Web.HttpContext.Current.Request.UserHostAddress should work...

--------------------
logiclabz

Re: How to get the Client Machine IP Address if Using Proxy

Robymon25-Mar-09 23:09

Robymon

25-Mar-09 23:09

OK. Now am running locally. i will try ...

how to make session secure?

RajpootRohan25-Mar-09 21:20

RajpootRohan

25-Mar-09 21:20

Hi to all,

I have a issue regarding the use of sessions.

I am working on a shopping cart project. In my project I am sessions a lot in transfering data from one page to another. Sometimes even the username and passwords. I also used session for carrying the cart data from one page to another.

So I want to know, Is there anything like the session can be hacked or they are not safe?

If yes then please suggest me a method to make the sessions secure by encrypting or something like that.

Waiting for the response....

Thanks in advance.

cheers,
sneha

Re: how to make session secure?

anilpal25-Mar-09 21:28

anilpal

25-Mar-09 21:28

Hmmm... well first of all, session object will hit your application performance. Secondly it on server side so it's already secure as such as server. However if transfering this information from one system to another then u need to encrypt it first.

Feel free to ask.

Cheers!

Regards
Anil Pal

Re: how to make session secure?

RajpootRohan25-Mar-09 21:35

RajpootRohan

25-Mar-09 21:35

Hi Anil Pal,

Thanks for replying. You mean to say that it is already secured. Is there any chance that when the username and passwords are passed from one page to another through session, they can be leaked or something like that.

cheers,
sneha

Re: how to make session secure?

anilpal25-Mar-09 22:35

anilpal

25-Mar-09 22:35

Hi thats correct, they are secure. Bcz session is on server side.

So u can use session to hold the Username and password.

Regards
Anil Pal

Re: how to make session secure?

RajpootRohan25-Mar-09 22:56

RajpootRohan

25-Mar-09 22:56

Hi,

I got it.Thanks for your assistance.
Looking forward for your suggestions in future.

cheers,
sneha

Re: how to make session secure?

N a v a n e e t h25-Mar-09 23:14

N a v a n e e t h

25-Mar-09 23:14

sneha Choudhary wrote:
. Is there any chance that when the username and passwords

Wondering why you are keeping password in session? Are you storing the password as plain text in DB?

Navaneeth

How to use google | Ask smart questions

Re: how to make session secure?

RajpootRohan25-Mar-09 23:19

RajpootRohan

25-Mar-09 23:19

Hi,

N a v a n e e t h wrote:
Are you storing the password as plain text in DB?

Yes It is stored as clear text. What should I do. Should I encrypt it.
Please suggest me..

cheers,
sneha

Last Visit: 31-Dec-99 18:00 Last Update: 23-Apr-24 5:32

Refresh

ᐊ Prev 1...2170 2171 2172 217321742175 2176 2177 2178 2179 Next ᐅ

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