I am workining in vb.net and sql. In DB have a uniqueidentifier field and want to insert in it,
When try to send data, some thing parameter: ByVal value as GUID
In the query : '"& Value &"' then errors occurs " Operator & not define or supporting and System.GUID "
If do like that : '"& CAST(Value as uniqueidentifier) &"' then Says CAST undefined same with Convert.
I'm trying to insert userid that is a System.Guid into an additional table into the same userid field that is uniqueidentifier. It seems as it cannot insert the System.Guid type there wether I'm passing it directly as the System.Guid or as a String then converting.
<System.ComponentModel.DataObjectMethodAttribute _
(System.ComponentModel.DataObjectMethodType.Insert, True)> _
Public Function InsertUserInterests( _
ByVal strUserId As String, ByVal strCode As String) _
As Boolean
Dim userInter As New DS1.tblUserInterestsDataTable
Dim userInterRow As DS1.tblUserInterestsRow = userInter.NewtblUserInterestsRow
Dim ug As System.Guid = New Guid(strUserId)
userInterRow.UserId = ug ' This didn't go through I beleive
userInterRow.InterestCode = strCode
userInter.AddtblUserInterestsRow(userInterRow)
Dim rowsAffected As Integer = Adapter.Update(userInter)
Return rowsAffected = 1
End Function
Page1 contains GridView1 which displays info from Table1.GridView1 contains a CommandButton which, when clicked inserts the values of all columns, plus a calculated value which goes into an extra column into Table2 handled in the RowCommand event handler of GridView1.Page2 contains GridView2 which displays info from Table2.GridView2 allows the user to alter the value of one of the columns in Table2 using the standard Edit/Update link.All this worked well until...I added UserId and SessionId fields to Table2 (uniqueidentifier and varchar(MAX) respectively,I added the following code to Page1 Code Behind to insert these values from the RowCommand handler:
[Code]....
All of this works beautifully. But... I then added this code to GridView2's RowUpdating event handler:
[Code]....
[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
When a user creates an account for my web application using the create user wizard additional steps have been added to take more details and store them in another table. Now this tables primary key is set to uniqueidentifier, is it possible to have that unique identifier automatically generated when the query is run to insert a new row for a new user?
View 1 RepliesI am a newbie in ASP.NET. I am facing this problem. I need to insert data into my database, where is primary key uniqueidentifier. I am using FormView and if I insert data there is an error. In asp:Parameter there is no datatype, which is support uniqueidentifier.
View 5 RepliesI'm using ASP.Net/C# and I have a form that allows people to add information into a table and along with it I want to collect the Current Users GUID and insert it.
I have a field setup (UserID) as a unique identifier and I have the following code:
protected void Page_Load(object sender, EventArgs e)
{
MembershipUser currentUser = Membership.GetUser();
Guid temp = (Guid)(Membership.GetUser(User.Identity.Name).ProviderUserKey);
Guid @currentUserID = temp;
}
SqlConnection con = new SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ASPNETDB.MDF;Integrated Security=True;User Instance=True");
SqlCommand cmd;
protected void Button1_Click(object sender, EventArgs e)
{
con.Open();
cmd = new SqlCommand("insert into Accom (UserID) values('" + @currentUserID + "')", con);
cmd.ExecuteNonQuery();
}
I basically want to link the variable to the Database how as the above gives errors.
[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:
I'm creating a web project for one of my uni modules using Visual studio 2010. I'm using asp.net membership and have all of my sql-server tables set up correctly (I'm pretty sure).
I have a form that I have created myself that inserts into the database using sqlDataSource.insert(). I had some problems initially with not being able to insert any data into the table at all, but I have cleared that up.
My problem now is that I need to insert the currently logged in user's userID into one of the columns of the table. But every time I hit the submit button, I am told I cannot insert null values in the userID column.
I can retrieve the userID using this snippet:
[Code]....
This is the code behind for the page:
[Code]....
As you can see it is a bit of a mess, I've been frantically trying different variations, as I need to catch up a little with other uni modules.
Here is my SQLDataSource from the .aspx page, The controlparameters work fine for the other data I am inserting. maybe the <asp:parameter name="userID" /> is wrong?
[Code]....
I'm relatively new to vb, and I come from a html & css background.
I have a page with a gridview that is populated depending upon the value of the querystring passed to it - there is a one-to-many relationship between Jobs and Locations respectively (one job can have many locations), and the gridview is a list of Locations that are associated with a particular Job. So far so good.
I have a DetailsView below whose DefaultMode is Insert to add a new location, though I can't seem to capture the JobId (guid) from the querystring. I've tried the following code on the Datasource's Inserting event:
[Code]....
but on both occasions I get the same error: Foreign Key constraint broken on JobId field. It seems that the querystring is not being passed to the datasource for inclusion in the insert.
I use a ntext data type for all kind of data save in one field, but when i save byte (that converted from image) follwing message is shown "Operand type clash: varbinary(max) is incompatible with ntext". Is ntext suitable for all kind of data type or what will be compatible for all data type support?
View 2 RepliesHow to i convert the data type in the address field? i keep getting an error
here is my code:
[Code]....
I have an asp.net mvc 2 application with a SQL Server database accessed by the Entity Framework ORM. Now I found out I had used the wrong datatype for one of the fields in the database - int instead of double.
Now, this is not a big commercial application, but it is nevertheless already in use internally in my company. It works fine, but the users would need to be able to enter decimal values rather than just integers...
So my question is, can I change the type of the field after the fact so to speak, and not lose the data already entered? Of course I would have to change the references to this field in the model and everything that references it, but is it possible at all without losing the data?
Can we get the doc type and contenttype of a file from the filestream field?
View 2 RepliesI am trying to retrieve the ID (auto incremented) form a Table after I do an insert. I have tried using one of the Variable I used to insert with no success. I am inserting a record with Todays Date (if one does not allready exsist) then trying to read that record to get the AutoInc number (DailyTimeRecordID). Where am I going wrong?
Here is my code
[Code]....
what is the uniqueidentifier data type equivalent in mysql
View 1 RepliesHow To convert String Data Type to Smalldatetime field in vb.net
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[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'm using a stored procedure to dump some data into a sql 2008 db. The sp calls a couple of other sp's and it is one of these that is throwing the error 'Operand type clash: uniqueidentifier is incompatible with int'I've stepped through the sp in enterprised studio and entered the values mannually and the last table updates as desired.I've also stepped through the aspx page and all values are passed in ok.
[CODE]...
The detailsview is used for logged users to add a new item to a table in my sql database. The detailsview default mode is set to "insert".
The UserID is a field in the table in which the user enter the new record.
How can I get the UserID Guid value assigned automatically on pageload to the specific bound field in my detailsview
I have the following problem: I need to store in MS SQL Server 2005 a vary large text in to one field of type nvarchar(MAX), In spite of the configuration is apparently correct I keep receiving the following message in the exception: "string or binary data would be truncated".
View 1 Replieshave a table that keeps track of customer data that is beyond the scope of the Membership Class, this table I am also using the Membership.CreateUser() generated user ID.When I use my INSERT statement however to create a new row in my table I keep getting the Specified cast is not valid error.This is my SQL Command (The ...refer to other fields)
Dim mySqlCommand As String = "INSERT INTO Customers (UserID, ...) VALUES (@UserID, ...)"
I send it to my Write_Database(mySqlCommand, Membership.GetUser(txtUserName.Text).ProviderUserKey, ...) function which then
I also tried sending he UserID as: CType(Membership.GetUser(txtUserName.Text).ProviderUserKey, SqlGuid)
Neither Works...both cause errors...My Write_Database Function is declared as follows:
Public Function Write_Database(ByVal MysqlQuery As String, ByVal UserID As System.Data.SqlTypes.SqlGuid, ...)
However Visual Studio shows that the error originates in the function calling code...
I want to read date field from Excel sheet and insert it into SQL Server2005.When I read date field it gives me a number say '40160' when the date feild is "08/01/2010"
How should to Read a date field from Excel Sheet Cells?
I have 2 table's
Table 1: Daily_item
Fields: Key_Guid Drescription Count
1 test 3
3 new item 2
I want to insert records form table 1 into table 2 but using the count field to duplicate the Key_guid record the new table.
New table example:
Table 2
Key_guid
1
1
1
3
3
how I can get around the following error with the following code?
[Code]....
Error: Msg 8169, Level 16, State 2, Line 1 Conversion failed when converting from a character string to uniqueidentifier. As you can probably tell, the datatypes are: m.UserId = uniqueidentifier l.System_User_ID = varchar(256) I was hoping the casting of one to the other would solve the issue, but it doesn't. How can I re-code this? I see from other forums it would probably be best to set all these fields to uniqueidentifier, but would prefer not to at this stage as it will involve changing quite a bit throughout the whole site!