I am attempting to use SqlBulkCopy to import data from an XML document. I receive the following error when executing WriteToServer: Invalid cast from 'System.String' to 'System.Guid'
View 1 Replies[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
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]...
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 RepliesI 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]....
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 RepliesI 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
[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.
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 = "";
[Code]....
Column UserId = uniqueidentifier
Compilation Error
Description:
An error occurred during the compilation of a resource required to service
this request. Please review the following specific error details and modify your
source code appropriately. Compiler Error Message: CS0019:
Operator '==' cannot be applied to operands of type 'string' and
'System.Guid'Source Error:
[Code]....
Line 93:
Line 94: var creditcard = from c in db.tbl_Payments
Line 95: where UserID == c.UserId
Line 96: select c;
Line 97:
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.WebControls.TextBox'.
[code]....
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()
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 RepliesProtected 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?
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)].......
I am using one dropdown list using following tag
[Code]....
FYI, In databse I have stored dropdown item text, not value.
Now whenever I try to set the selected item using following code, I am getting error System.Web.UI.WebControls.ListItemCollection.FindByText(string)' has some invalid arguments.
[Code]....
An unhandled exception of type 'System.InvalidOperationException' occurred in System.Xml.dll
View 1 Repliesi 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]'.
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;
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 RepliesI added a button click event to my project as:
But since this i am getting this error saying:
Cannot implicitly convert type 'string' to 'System.Web.UI.WebControls.TextBox
There seems to be no error in my code.
I am getting error "Cannot implicitly convert type 'string' to 'System.Data.DbType".
When I am passing Stored procedure parameter it expets 'System.Data.DbType" and the Data member is declared as a string.
in my web project i got an error that i couldnt find any solution. the error says: System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. when i work in local there were no problem i put files to our server and i changed the database also. when i work in server in web application in Default.aspx i can connect db and get values without any problem using my DataLibrary
BUT the problem in my web service i also use my DataLibrary in webservice but when i try to run a method in web service it gives me the error which is : System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
my new db connection is
strConnectionString = "Data Source=OURSERVERNAME\SQLEXPRESS;Initial Catalog=DoveTR;Persist Security Info=True;User ID=sa;Password=123456789;Pooling=True";
The error that I get from this code states that the cast is invalid and that the number must be less than infinity. [Code]....
By the way, I tried to paste my code using the icon from the toolbar but it didn't work. Firefox problem maybe?
"System.FormatException was unhandled by user code - Input string was not in a correct format"
This is driving me crazy! Can anyone see what the problem is?
[Code]....