Problem in insert (UniqueIdentifier) in Table

Aktham Mahmoud

5y1.1k.NET

Greeting

I created my own database and used this method by Ankush Agnihotri (Create And Install ASP.NET Membership Database)to create users asnd membership and roles in my web application projects. see link below which method I used:

https://www.c-sharpcorner.com/blogs/create-install-asp-net-membership-database

I designed form to admin site to create an emplyee account in three steps :

First step :create employee account by (Registeration tool) to create user account which will store emplyee account in Users Table.

Second Step: redirect admin to next page to complet an emplyee form information.

Untile this moment a last two steps working correctly.

Third step: an confirmiation appears to admin to catch a ROLE ID and USER ID which represented as (UniqueIdentifier) value to store its in USERSINROLE table as figures below:

A last two steps (one and tow) working correctly, but a confimation catch this problem:

So How to solve this problem thanks

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Aktham Mahmoud5y ago
Hi Sachin Singh Amit Mohanty

My problem taked long time and I find this comment labled under solution 1 :

There is no way to reverse a hash operation (retrieve the original string from the hash). That is by intention and usually a requirement. you can find it at link below

https://www.codeproject.com/Questions/1175454/Convert-string-to-GUID-and-GUID-to-old-string-Vise

so I tryed more more solution, a last one is:
sqlcmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier,32).Value =(FormView1.FindControl("l1") as Label).Text;

sqlcmd.Parameters.Add("@RoleId", SqlDbType.UniqueIdentifier, 32).Value = ((FormView1.FindControl("L2") as Label).Text);
but when I execute I catch an error :
Message=Failed to convert parameter value from a String to a Guid.
two days to find a solution to convert it impossible, so is that related with last comment which I indecated to it above.

Thanks.
Aktham Mahmoud5y ago
Thanks Mr. for your intresting
actually all my coding with "AddwithValue" but when a problem apeared ama searching to find a key of solution, and trying many methods but none of them working
see my code below with all methods tests
using (SqlConnection sqlcon = new SqlConnection(connString))
           {

               sqlcon.Open();
               string query = "INSERT INTO UsersInRoles(UserId,RoleId) VALUES  (@UserId,@RoleId)";
               SqlCommand sqlcmd = new SqlCommand(query, sqlcon);
               //====first solution ::Your attention here
               //sqlcmd.Parameters.AddWithValue("@UserId",(FormView1.FindControl("l1") as Label).Text);
               //sqlcmd.Parameters.AddWithValue("@RoleId", (FormView1.FindControl("L2") as Label).Text);
               //====Finished first solution

               //Second Solution begining
               //sqlcmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value=(FormView1.FindControl("l1") as Label).Text;
              // sqlcmd.Parameters.Add("@RoleId", SqlDbType.UniqueIdentifier).Value=(FormView1.FindControl("L2") as Label).Text;
               //End Secod Solution

               sqlcmd.Parameters.Add("@UserId", SqlDbType.UniqueIdentifier).Value = new System.Data.SqlTypes.SqlGuid((FormView1.FindControl("l1")as Label).Text);
               sqlcmd.Parameters.Add("@RoleId", SqlDbType.UniqueIdentifier).Value = new System.Data.SqlTypes.SqlGuid((FormView1.FindControl("L2") as Label).Text);
               sqlcmd.ExecuteNonQuery();
               FormView1.DataBind();
               sqlcmd.Connection.Close();
           }
Sooo, this problem will bombing my head.
Sachin Singh5y ago
Test with AddWithValue
Sqlcmd.Parameters.AddWithValue("@UserId",(FormView1.FindControl("l1") as Label).Text);
Sqlcmd.Parameters.AddWithValue("@RoleId",(FormView1.FindControl("l2") as Label).Text);
Sqlcmd.ExecuteNonQuery();
Aktham Mahmoud5y ago
Thanks Mr.
Actually I recreate new employee to test as you said lastly (if USERID and ROLEID ) as same as in print table
see a fig. below

and rechecking my code in in sql sentence to see if am I have a mistake in insert,but everything correct
So why can not able to insert?
I checked a sqlDataSource :
"SDS_setuserinrole" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" InsertCommand="INSERT INTO [UsersInRoles] ([UserId], [RoleId]) VALUES (@UserId, @RoleId)" SelectCommand="SELECT [UserId], [RoleId] FROM [UsersInRoles]">

           "UserId" Type="Object" />
           "RoleId" Type="Object" />



I change from (Object) to (string ) but a problem still as it

    "UserId" Type="String" />
    "RoleId" Type="String" />
Sooooo what's wrong?
Thanks
Amit Mohanty5y ago
Hey, please check that your UserId and RoleId also present in the Roles and Users table.