Failed to convert parameter value from a Guid to a String

Posted by user320460 on Stack Overflow See other posts from Stack Overflow or by user320460
Published on 2010-04-20T12:01:59Z Indexed on 2010/04/20 12:13 UTC
Read the original article Hit count: 255

Filed under:

datatable

|

guid

|

convert

|

string

|

c#

Hello,

I am at the end of my knowledge and googled for the answer too but no luck :/

Week ago everything worked well.

I did a revert on the repository, recreated the tableadapter etc... nothing helped.

When I try to save in my application I get an SystemInvalidCastException at this point:

PersonListDataSet.cs:

partial class P_GroupTableAdapter
{
    public int Update(PersonListDataSet.P_GroupDataTable dataTable, string userId)
    {
        this.Adapter.InsertCommand.Parameters["@userId"].Value = userId;
        this.Adapter.DeleteCommand.Parameters["@userId"].Value = userId;
        this.Adapter.UpdateCommand.Parameters["@userId"].Value = userId;

        return this.Update(dataTable); **<-- Exception occurs here**
    }
}

Everything is stuck here because a Guid - and I checked the datatable preview with the magnifier tool its really a true Guid in the column of the datatable - can not be converted to a string ??? How can that happen?

© Stack Overflow or respective owner

Related posts about datatable

DataView.RowFilter Vs DataTable.Select() vs DataTable.Rows.Find()

as seen on Stack Overflow - Search for 'Stack Overflow'
Considering the code below: Dataview someView = new DataView(sometable) someView.RowFilter = someFilter; if(someView.count > 0) { …. } Quite a number of articles which say Datatable.Select() is better than using DataViews, but these are prior to VS2008. Solved: The Mystery of DataView's Poor… >>> More
How to correctly filter a datatable (datatable.select)

as seen on Stack Overflow - Search for 'Stack Overflow'
Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c) c.Open() If Not IsNothing(da) Then da.Fill(dt) dt.Select("GroupingID = 0") End If GridView1.DataSource = dt GridView1.DataBind() c.Close() When I call da.fill I am… >>> More
How to obtain a random sub-datatable from another data table

as seen on Developer IT - Search for 'Developer IT'
Introduction In this article, I’ll show how to get a random subset of data from a DataTable. This is useful when you already have queries that are filtered correctly but returns all the rows. Analysis I came across this situation when I wanted to display a random tag cloud. I already had the… >>> More
How can we copy the column data of one datatable to another,even if there is different column names

as seen on Stack Overflow - Search for 'Stack Overflow'
I have two datatables. First is DataTable NameAdressPhones = new DataTable(); with Three columns Name,Adress and PhoneNo.But I want only two columns Name and Adress data so I am copy those columns (with data) to the new datatable DataTable NameAdress = new DataTable(); For that I do … >>> More
Difference between DataTable.Load() and DataTable = dataSet.Tables[];

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All , I have a doubt i use the following piece of code get data from a SQLlite data base and Load it into a data table "SQLiteConnection cnn = new SQLiteConnection("Data Source=" + path); cnn.Open(); SQLiteCommand mycommand = new SQLiteCommand(cnn); string… >>> More

Related posts about guid

MS SQL Database with clustered GUID PKs - switch clustered index or switch to sequential (comb) GUID

as seen on Stack Overflow - Search for 'Stack Overflow'
We have a database in which all the PKs are GUIDs, and most of the PKs are also the clustered index for the table. We know that this is bad (due to the random nature of GUIDs). So, it seems there are basically two options here (short of throwing out GUIDs as PKs altogether, which we cannot do (at… >>> More
Nhibernate Guid with PK MySQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello colleagues. I've got a question. I use NHibernate with MySql. At my entities I use Id(PK) for my business-logic usage and Guid(for replication). So my BaseDomain: public class BaseDomain { public virtual int Id { get; set; } public virtual Guid Guid { get; set; } public class… >>> More
Please for efficient query

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to have efficient query to get some rows from my table. Here is I think the best presentation of my table. -Somedate is not duplicated - it is date of modifiedon -a,b,c are parent ids, let say countryCode -1,2,3,4 are subparent, let say citycode -guids are id of rows -true, false are values… >>> More
... i just avoid GUID

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Our partner was explaining to me that they are using GUID as primary key on all the tables. My immediate reaction was - why? and couple of basic doubts were: - since I can read uniqueidentifier, it does not tell me absolutely anything - if I will use my relational table, i sure will use other columns… >>> More
Convert string to GUID with sscanf

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to convert a string to GUID with sscanf: GUID guid; sscanf( "11111111-2222-3333-4455-667788995511", "%08x-%04x-%04x-%02x%02x-%02x%02x%02x%02x%02x%02x", &guid.Data1, &guid.Data2, &guid.Data3, &guid.Data4[0], &guid.Data4[1], &guid.Data4[2], … >>> More