Unable To Cast Object Of Type "System.String" To Type "System.Data.DataTable"
Mar 27, 2011
what is wrong with this syntax datatable temp = (DataTable)du.Rows[0]["NAME"] I get the error message Unable to cast object of type 'System.String' to type 'System.Data.DataTable'.
View 6 Replies
Similar Messages:
Oct 1, 2010
Basically, what I did is that: I have a table in SQL database and some of data fields allow null. I built Objectdatasource through dataset. When I built update page using dataset. It generate the following error before showing the update page correctly. It seems I have issue to retrieve the null value from the database through using objectdatasource through dataset. Any suggestions?An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code
View 6 Replies
Feb 16, 2010
I have defined an ODBC Command and ODBCdatareader as follows
OdbcConnection myConnection = new OdbcConnection(connectionString);
OdbcCommand myCommand = new OdbcCommand();
myCommand.Connection = myConnection;
myCommand.CommandText = "select UOPGM from GREG.TUSROPTF";
OdbcDataReader myReader;
myConnection.Open();
myReader = myCommand.ExecuteReader();
When I try to retreive from the reader as follows:
while (myReader.Read())
{
string someString = myReader["UOPGM"];
lstNames.Items.Add(someString);
}
I get the following error
Error reading the database. Unable to cast object of type 'System.Byte[]' to type 'System.String'."
I have also tried string someString = (string)myReader["UOPGM"]; to no avail
View 4 Replies
May 28, 2010
I am trying to write a table output from SQL database to a gridview/ Data List through an Object Data Source. I am a new starter and your help will be useful.
public List<Staff> GetStaff()
cmd.CommandType =
SqlConnection con =
new
SqlConnection(connectionstring);SqlCommand cmd =
new
[code]...
View 4 Replies
Nov 10, 2010
[Code]....
Above is my code. The error I'm get is, Unable to cast object of type 'System.DateTime' to type 'System.String'.
The column "To" and column "Subject" are strings and column "Receive" is DateTime. I can't made any changes in the database, so I need to write some code to handle casting a string to datetime or if statement as a work around.
View 6 Replies
Feb 20, 2013
Unable to cast object of type 'System.String' to type 'System.Byte[]'....
on line #2
private void download(DataTable dt) { Byte[] bytes = (Byte[])dt.Rows[0]["FileData"];
Response.Buffer = true; Response.Charset = "";
View 1 Replies
Sep 17, 2010
[Code]....
System.InvalidCastException was unhandled by user code
Message=Unable to cast object of type 'System.Guid' to type 'System.String'.
Source=System.Data.Linq
System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execut
View 4 Replies
Jan 5, 2010
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'.
[code]....
View 3 Replies
Mar 24, 2010
i am using this code for send data to view
[Code]....
Controller e 'System.Collections.Generic.IEnumerable [Code]....
by this code i am render view
[Code]....
after run the application i got this error
Unable to cast object of type 'System.String' to type 'System.Collections.Generic.IEnumerable`1[BentaAccounting.Models.Repository.AllData]'.
View 5 Replies
Jan 2, 2010
I want to do paging the API Membership without using the datacontrols, but I get this error "Unable to cast object of type '<TakeIterator>d__3a`1[System.Char]' to type 'System.Collections.IList'." when I do this,
[code]....
View 1 Replies
Nov 24, 2010
Protected Sub FormView1_ItemCreated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewCommandEventArgs) Handles FormView1.ItemCreated
Causes Unable to cast object of type 'System.EventArgs' to type 'System.Web.UI.WebControls.FormViewCommandEventArgs'.
The program (asp.net/vb) works fine with FormView1_ItemCommand and FormView1_ItemInserted events but strangely objects to FormView1_ItemCreated. Is it only a VC# event?
View 2 Replies
Aug 23, 2010
Why am I getting this error on line:
sp.Price = Convert.ToDecimal(collection.GetValue("Price"));
sp is :
SPecials_Templates sp = new SPecials_Templates();
SPecials_Templates Defined:
[MetadataType(typeof(SPecials_TemplatesMetaData))]
public partial class SPecials_Templates
{
public class SPecials_TemplatesMetaData
{
[ScaffoldColumn(false)]
public object Key { get; set; }
[StringLength(50)]
public object Template_Name { get; set; }
[StringLength(12)]
public object Headline { get; set; }
[StringLength(12)]
public object headline2 { get; set; }
[StringLength(160)].......
View 2 Replies
Dec 17, 2010
I have built a dataset named Transaction_Time.I called it on Page_Load
Transaction_Time tranTme = new Transaction_Time();
put it in the session.
Session["Transaction"] = tranTme;
Then I call that session and cast to dataset.
DataSet dstTranTime = (DataSet)Session["Transaction"];
I got the following error.Unable to cast object of type 'Transaction_Time' to type 'System.Data.DataSet'.
[InvalidCastException: Unable to cast object of type 'Transaction_Time' to type 'System.Data.DataSet'.]
Transaction_Time.Page_Load(Object sender, EventArgs e) in c:InetpubwwwrootWilliam29_11_2010Transaction_Time.aspx.cs:47
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
It is OK for some other pages. But for some page, it doesn't.
View 2 Replies
Nov 12, 2010
I have a web site that is using windows authentication. 'Enable anonymous access' is unchecked. It works when I call it through Visual Studio but when I put the site on the server I get the following error:
Unable to cast object of type 'System.Security.Principal.GenericPrincipal' to type 'System.Web.Security.RolePrincipal'.
Here is the offending line:
System.Security.Principal.GenericPrincipal genericPrincipal = (System.Security.Principal.GenericPrincipal)HttpContext.Current.User;
View 3 Replies
Apr 15, 2010
I got this error and do not know how to solve it.
I've got a subweb as application. It's called ADMIN. It works fine when running locally but when deploying in the development web server, i got the error: Unable to cast object of type 'System.Web.HttpApplication' to type 'Microsoft.Practices.CompositeWeb.WebClientApplication'
I've got a App_global.asax.dll and App_global.asax.complied on the subweb folder Admin.
View 1 Replies
Mar 3, 2010
I need some help on the row updating for a gridview that i bind manually to a list, not using objectdatasource or sqldatasourcehere is my rowupdating. What i want to do for now is just get the values from the textboxes and I will store them to sting variables then I will call my update function and pass those as parameters. How do I get the data from the textboxes that the user just edited. I have the following but I am getting an error: "unable to cast object of type System.UI.LiteralControl to type System.UI.TextBox
View 5 Replies
Jan 24, 2011
I have on my page.aspx CheckBox with IDs representing the month.
<asp:CheckBox ID="January" runat="server" Text="Janvier" />
<asp:CheckBox ID="Febuary" runat="server" Text="Fevrier" />
<asp:CheckBox ID="March" runat="server" Text="Mars" />
<asp:CheckBox ID="November" runat="server" Text="Novembre" />
<asp:CheckBox ID="December" runat="server" Text="Decembre" />
The ChecBox will be selected according to the user need: 1, 2, 3 or plus... When the page is fired, I wanted to get in the code behind the box which are checked so I can build a query consequently. So in the code behin, i wrote this:
Dim MyCheckBox As CheckBox
Even if I try Dim MyCheckBox As New CheckBox I was getting the same error below.
For Each MyCheckBox In Form.Controls
For j As Integer = 1 To 12
If TypeOf MyCheckBox Is CheckBox Then
MyCheckBox.ID = MonthName(j)
If CType(MyCheckBox, CheckBox).Checked = True Then
TargetedFieldName = MyCheckBox.ID
'Build a query against tables
MyCheckBoxCollection += TargetedFieldName & ", "
End If
End If
Next
Next
I'm getting right after For Each statement this error: Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.CheckBox'.
View 3 Replies
Mar 31, 2010
I wanted to delete the record from data but I receive this error "Unable to cast object of type 'System.Data.Linq.DataQuery`1[training_eval.Course]' to type 'training_eval.Course'.
Dim eval_sure = From ev In db.Evaluates Where ev.course_id = indexcourse Select ev.course_id
Dim del_course = From c In db.Courses Where c.Course_id = indexcourse
db.Courses.DeleteOnSubmit(del_course)
db.SubmitChanges()
View 4 Replies
Jun 30, 2010
I have implemented rights based security as I describe here: http://forums.asp.net/p/1380280/2916291.aspxThis has been working well for awhile now, but I am moving the site to IIS 7 and encountering problems. I am able to reach the login screen for my app - but upon login get this error: "Unable to cast object of type 'System.Web.Security.RolePrincipal' to type 'RightsLib.RightPrincipal'."As described in the linked post, I have a "RightsLib.dll" that contains the relevant classes like "RightsHttpModule.cs", "RightPrincipal.cs" etc...My app no longer seems to be able to work with RightsLib.dll. RightsLib.dll resides in the bin directory of my app, and I have a reference to it in my project.me what I'm doing wrong, or what has changed to affect this in IIS 7?The only relevant entry in Web.config I'm aware of.
[Code]....
View 1 Replies
Nov 26, 2010
I am trying to pass a collection of Dropdown controls as a parameter to a method which takes a collection of type Control as input. While executing I get the following error:
"Unable to cast object of type 'd__a31[System.Web.UI.WebControls.DropDownList]' to type 'System.Collections.Generic.IEnumerable1[System.Web.UI.Control]'."
My code:
[code]....
View 2 Replies
Jul 7, 2010
Trying to explain this clearly. I have a dropdown listbox where user can select multiple names. These names are then selected/inserted into db table in a loop. Table is displayed in an editable gridview. I have a main sqldatasource1 on my aspx page with select/insert/update permissions, but because select command doesnt work with parameters of multiple values (or does it?), i resorted to using an alternative sql datasource in the codebehind in order to run the select query on the multiple values chosen from the dropdownlist to see if they were in my table.I now get this error when I go to select multiple names from the dropdown list
Unable to cast object of type 'System.Data.Common.DataRecordInternal' to type 'System.Data.DataRowView'.
View 2 Replies
Jan 24, 2011
This error is occuring randomly, and I can't seem to pinpoint what is causing it. For the most part, the code works fine. I'm confused why it works sometimes, but then suddently craps out on me, lol.It happens in the code when I call upon the asp.net membership provider. It only seems to happen when i use Membership.GetUser() to grab the logged in user's information.
View 9 Replies
Sep 30, 2010
I am trying to upload a picture into database using FormView insertItemTemplate. FormView is bounded by objectdatasource.To upload, I placed FileUpload control inside insertItemTemplate.In table the dataType is image.Error:Object of type 'System.Boolean' cannot be converted to type 'System.Byte[]'.
View 3 Replies
Dec 1, 2010
I'm trying to pass email addresses from an array to a stored procedure, then display the results in my gridview. I get the following error:No mapping exists from object type System.String[] to a known managed provider native type.On this line: Dim DR As SqlDataReader = MyCommand.ExecuteReader
[Code]....
View 4 Replies
Jan 4, 2010
have an issue with a list box. I populate the list box using :
listbox1.datasource = myCollectionOfCars
listbox1.databind()
When i go to retrieve the selected item from the listbox using
Car myCar = (Car)listbox1.selecteditem;
an error is generated
cannot cast expression type system.web.ui.webcontrols.listitem to type car
i have read several tutorials and many of them use the above code.
View 11 Replies