ASP.NET

Problem regarding dropdownlist unable to explain

7-Jul-07 6:53

I am preparing a site for a school, where student can see answers posted by teacher(s). Page looks (only for this page) will be very much similar to code project, where we can have chain of answers.....

Can i use repeater control for this? I am not sure how i will bind the replies with question if i used repeater control....

But obvious Questions will be display in ItemTemplate...

Any one with any suggestion.....

Thanks,
Amit

rahul.net117-Jul-07 4:24

rahul.net11

7-Jul-07 4:24

Hi
i have a problem.In one of my application i am maintaining all control
values on a page in session using AJAX.i have done it.My page contain two dropdownlist.Data value field of items in dropdownlist is nothing but the id
of items,i am retriving an selected item name from database using its id from
database.once i got name the problem is that how can i give selected item of ddlist
is the item name. i am tried
ddlist.SelectedValue=session("name")\\it gives null
ddlist.SelectedItem.Text=session("name")\\\it gives object reference not set to instance of object error.

How can i do this.Please guide me.

Thanks.

Re: Problem regarding dropdownlist unable to explain

Sathesh Sakthivel7-Jul-07 4:32

Re: Problem regarding dropdownlist unable to explain

7-Jul-07 4:32

rahul.net11 wrote:
object reference not set to instance of object error.

To resolve this problem, register the Adodb.dll file in the global assembly cache (GAC). On a computer where only the .NET Framework is installed, the file Gacutil.exe does not exist.. Either obtain the gacutil file by installing Microsoft .NET Framework SDK, or create a Visual Studio.NET setup project that uses the installer to install the correct components.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

rahul.net117-Jul-07 5:01

rahul.net11

7-Jul-07 5:01

Hi Satips
Is there any other solution another that.I think this is not due to that.

Thanks.
Rahul

Re: Problem regarding dropdownlist unable to explain

Venkatesh Mookkan8-Jul-07 20:38

Venkatesh Mookkan

8-Jul-07 20:38

rahul.net11 wrote:
ddlist.SelectedValue=session("name")\\it gives null
ddlist.SelectedItem.Text=session("name")\\\it gives object reference not set to instance of object error.

Both are read-only properties. How are you able to assign the values???

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Re: Problem regarding dropdownlist unable to explain

sidbaruah8-Jul-07 23:10

sidbaruah

8-Jul-07 23:10

if the item is already existing then check whether whether u are calling these lines

ddlist.SelectedValue=session("name")\\it gives null
ddlist.SelectedItem.Text=session("name")\\\it gives object reference not set to instance of object error.

before the dropdownlist is populated or after!!!

if you are running it before the population then it cannot find the dropdownlist and it will give a null reference exception!!!

I was born dumb!!
Laugh | :laugh:

Programming made me laugh Laugh | :laugh:

!!!
--sid--

SQL Data Reader

Amit Kumar G7-Jul-07 3:46

7-Jul-07 3:46

What is wrong with this....I don't know this morning what is happening with me..Is it because of 07/07/07....

My dtrCat (data reader) is getting -1 record affected.........Conenction is fine.............Pl help me from 07/07/07 devil.....

---------------------
SqlConnection conDotNet;
SqlCommand cmd;
SqlDataReader dtrCat;

conDotNet=new SqlConnection();
conDotNet.ConnectionString="Server=SBServer;User=sa;Password=;database=SB;";
cmd=new SqlCommand();
cmd.CommandText="Select * from dbo.TB_QueryMaster";
cmd.CommandType=CommandType.Text;
cmd.Connection=conDotNet;

cmd.Connection.Open();
dtrCat=cmd.ExecuteReader(CommandBehavior.CloseConnection);

catlist.DataSource = dtrCat;
catlist.DataBind();
cmd.Dispose();
conDotNet.Dispose();

Amit

Sathesh Sakthivel7-Jul-07 4:04

7-Jul-07 4:04

Amit Kumar G wrote:
Is it because of 07/07/07

LOL.

Please ask it in the Correct Forum.

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Amit Kumar G7-Jul-07 4:11

7-Jul-07 4:11

This is ASP.Net forum and my query is related to the same.....

Regards
Amit

Sathesh Sakthivel7-Jul-07 4:16

7-Jul-07 4:16

What problem you are having ?

it is getting one record affected means?

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Amit Kumar G7-Jul-07 4:19

7-Jul-07 4:19

My query only returns -1 which means no record affected.....I checked the database table and data is there, connection is fine ..........

Satips...Please help me, i have seen lot of replies from your side....

Thanks!!
Amit

Sathesh Sakthivel7-Jul-07 4:29

7-Jul-07 4:29

Amit Kumar G wrote:
My query only returns -1 which means no record affected

True.

Amit Kumar G wrote:
I checked the database table and data is there, connection is fine

Ok.

Then what problem?

Regards,

Satips. Rose | [Rose]

Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus

Not Active7-Jul-07 12:30

Not Active

7-Jul-07 12:30

Satips wrote:
Ok.

Then what problem?

I believe that is what his original question was WTF | :WTF:

Thanks for your valuable contribution in asking him the same question he has asked you. Roll eyes | :rolleyes:

only two letters away from being an asset

Guffa7-Jul-07 6:19

Guffa

7-Jul-07 6:19

Amit Kumar G wrote:
My dtrCat (data reader) is getting -1 record affected

Yes, of course. A select query does not change any data.

From MSDN library:

"SqlDataReader.RecordsAffected Property
Gets the number of rows changed, inserted, or deleted by execution of the Transact-SQL statement."

---
single minded; short sighted; long gone;

eggsovereasy7-Jul-07 19:04

eggsovereasy

7-Jul-07 19:04

I always thought it should return 0 rather than -1.

Guffa8-Jul-07 1:06

Guffa

8-Jul-07 1:06

It's all in the documentation, plain to read: Smile | :)

"Property Value
The number of rows changed, inserted, or deleted; 0 if no rows were affected or the statement failed; and -1 for SELECT statements."

---
single minded; short sighted; long gone;

eggsovereasy8-Jul-07 7:14

eggsovereasy

8-Jul-07 7:14

Well I know that is what it does, but logically it seems 0 would be more appropriate. I'm questioning someones design decision not you answer Smile | :)

Guffa8-Jul-07 8:51

Guffa

8-Jul-07 8:51

Well, a zero would mean that there were zero records uppdated. As there shouldn't be any updated records, there shouldn't be any count of them either, so I can see how a value representing a non-count would be more appropriate than a count of zero.

---
single minded; short sighted; long gone;

eggsovereasy8-Jul-07 9:50

eggsovereasy

8-Jul-07 9:50

That makes sense I suppose.

Repeater Control

Amit Kumar G7-Jul-07 2:41