DataReader throws exception - ASP.NET Discussion Boards

Your issue is at design time, or run time ? Do people actually use the designer to create web forms ?

Michael Smit wrote:
"Cannot create an object of type 'Savitar.Web.UI.WebControls.ListBox" from it's string representation

This makes me think you need to support serialisation for your control.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

The problem is at design time.

And ye... People definitely use the designer. We code in directly in the markup too, but only when necessary.

Hi,

I have a webpage that has a remove button and everything works fine in it. But I want too add a simple(Are you sure[Yes, No]) alert to the button in the client side script for the button.

I searched in google but most things were about implementing client-side scripting for HTML server controls and I am a little bit confused on how to do a conditional postback for the page.

How can I implement a conditional Postback of the page using an alert?? Confused | :confused:

Thanks

And ever has it been that love knows not its own depth until the hour of separation

If you add an OnClientCLick method to a button, the postback will only occur if the client side method returns true.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

Thank you very much, it worked perfectly Smile | :)

And ever has it been that love knows not its own depth until the hour of separation

Hello Friends.
I'm Arunvijay .. have to Upload a file into DataBase using FileUpload control .
can anyone help me...

ArunVijay

Second result when you search google for "asp.net fileupload".

http://www.codeproject.com/KB/aspnet/fileupload.aspx[^]

Mark's blog: developMENTALmadness.blogspot.com

Funniest variable name:
lLongDong - spotted in legacy code, was used to determine how long a beep should be. - Dave Bacher

Hi, I was wondering if anyone could help me with a DataTable problem. I am working in ASP.NET C#, The code that I have written is listed below. The moSqlDataReader can be viewed when in debug mode and the record that is asked for is seen, but when the reader is called into the DataTable using the .Load() function the DataReader shows a thrown exception of System.InvalidOperationException in the Depth and FieldCount properties when viewed in Debug mode

Code:

<br />
<small>msUserName = Request.QueryString.Get("username");<br />
            <br />
LabelUserName.Text = msUserName;<br />
UserName.Value = msUserName;<br />
moMembershipUser = Membership.GetUser(msUserName);<br />
<br />
msEmailAddress = moMembershipUser.Email;<br />
            <br />
moSqlConnection = new SqlConnection();<br />
moSqlConnection.ConnectionString = ConfigurationManager.ConnectionStrings["AppSqlServer"].ConnectionString;<br />
<br />
moSqlCommand = new SqlCommand();<br />
moSqlCommand.CommandText = "SELECT * From tblUserInfo WHERE UserID = @UserID ";<br />
moSqlCommand.CommandType = CommandType.Text;<br />
moSqlCommand.Connection = moSqlConnection;<br />
            <br />
// UserID Parameter<br />
moSqlParameterUser = new SqlParameter();<br />
moSqlParameterUser.ParameterName = "@UserID";<br />
moSqlParameterUser.SqlDbType = SqlDbType.UniqueIdentifier;<br />
moSqlParameterUser.Direction = ParameterDirection.Input;<br />
moSqlParameterUser.Value = new Guid(moMembershipUser.ProviderUserKey.ToString());<br />
            <br />
moSqlCommand.Parameters.Add(moSqlParameterUser);<br />
moSqlCommand.Connection.Open();<br />
<br />
moSqlDataReader = moSqlCommand.ExecuteReader(CommandBehavior.CloseConnection);<br />
<br />
moDataTable = new DataTable();<br />
moDataTable.Load(moSqlDataReader);<br />
<br />
if (moDataTable.Rows.Count == 0){<br />
      msFirstName = "";<br />
      msLastName = "";<br />
}else{<br />
      moDataTable.PrimaryKey = new DataColumn[] { moDataTable.Columns["UserID"] };<br />
      msFirstName = moDataTable.Rows.Find("FirstName");<br />
      msLastName = moDataTable.Rows.Find("LastName");<br />
}<br />
<br />
FirstName.Text = msFirstName;<br />
LastName.Text = msLastName;<br />
EmailAddress.Text = msEmailAddress;<br />
            <br />
moDataTable.Dispose();<br />
moSqlCommand.Dispose();<br />
moSqlConnection.Dispose();</small>

I dont understand why the application is returning this, I have checked the internet and several books but have found no reason for this error. I would appreciate if anyone could help fix this.

Thanks

modified on Monday, April 14, 2008 9:44 AM

Hi,

did you run a DEBUG over this part of code?
Can you place this code in a try...catch?

it will tell you where something goes wrong.

Hi, Thanks for replying.

Yes I have Debugged the code in order to find out what exactly is wrong but everything seems fine up until the DataTable uses the Load function again it displays the exception of System.InvalidOperationException in the Depth and FieldCount properties when in Debug mode.

I have not looked at trying the Try Catch methods yet. I will try these and see what l can find.

Thanks

Got the Error:

You us e a DataReader object instead of a DataTable object.
The reader will give up data per row until there is no more to give.
After loading a datareader you ask 2 things
if (moSqlDataReader.HasRows)
{
WHILE (moSqlDataReader.Read())
{
// your code here
}
}

in your case it is better to do a
DataSet dSet = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter("Query", con);
adapter.SelectCommand.CommandType = CommandType.Text;
etc ..
adapter.Fill(dSet);

Double check your query is correct and maybe try another simple query and load that
this will eliminate the possibility that it is your query which is the problem
or it will highlight what the problem is

Have you declared moSqlDataReader ?

anybody knows a complete article about "Membership and Role Management" in asp .net 2 or 3.5 for “MS SQL Server”?
an article that describes the whole process completely?

i already searched for it but they were confusing!

thank you

http://aspnet.4guysfromrolla.com/articles/120705-1.aspx

Hi..
im using session variables to store the login information of the user..
When user login and logout he cant review the pages he visited, its working fine ...

but if another user login's he can see all the pages visited by the previous user by clicking back button. Since session ID is not null it allows the page to appear..

Can u tell me how to remove all browser list on Logout..

thanks in advance

I dont think you can delete the browser history, you can delete sessions when you logout, is this what you mean?

Edit your posts, don't double post.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

Try preventing the page from being cached. Use the following at the top of the aspx page.

<%
Response.CacheControl = "no-cache";
Response.AppendHeader("Pragma", "no-cache");
Response.Expires = -1;
%>

Hi..
im using session variables to store the login information of the user..
When user login and logout he cant review the pages he visited, its working fine ...

but if another user login's he can see all the pages visited by the previous user by clicking back button. Since session ID is not null it allows the page to appear..

Can u tell me how to remove all browser list on Logout..

thanks in advance

If you're using session variables, I don't see how that is possible.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

Hello friends,

I want to give a message to the user in a alert format that your data has been saved successfully after saving data.

But i am unable to do this........
Please help me i am also using ajax updatepanel......

Thanks in advance........

Deepak Nigam

Tis is a web app, so message boxes need to me javascript, namely the alert command. You can emit script using the RegisterClientScriptBlock metod from you code behind, or write client side code to show it in response to AJAX calls

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )

Hello Christian,

I am getting the following error "The Message recived from the server could not be parsed. Common causes for this error are the response is modifiyed ba calls to response.write(), response details , HttpModule, OR server trace is enabled.

As i am using the this inside a updatepanel.

I got this solution but confused that how to use this

ScriptManager.RegisterStartupScript(Me, Me.GetType, "key", "open('" + filename + "');", True)

I have a MessageBox Class that is working well with the simple forms......

Deepak Nigam

OK, perhaps you need to write client side script to handle this, if you are using the ASP.NET AJAX library as well, I don't know, I don't really use it.

Christian Graus

Please read this if you don't understand the answer I've given you

"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 )