I'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]...
Following Query giving error, Please let me know whats prevent from getting this error.
declare @EmployeeID int
set @EmployeeID = 454655
DECLARE @XMLCONTENT XML
SET @XMLCONTENT = N'<EmployeeID> <Data ID="'+ CONVERT(nvarchar(100),@EmployeeID) +'"/> </EmployeeID>'
print @XMLCONTENT
My table contains a column named visitorimage with image as the datatype. I have a stored procedure to insert an image but whenever I try to create the sp an error occurs saying"Operand type clash: nvarchar is incompatible with image". What's the problem and how to fix this?
ALTER PROCEDURE [dbo].[usp_addvisitor] @lastname nvarchar(50), @firstname nvarchar(50), @visitorimage image, @gender char(6), @personalid nvarchar(50), @vehicleno nvarchar(20), @company nvarchar(50), @represent nvarchar(100), @phonenumber bigint, @mobilenumber
bigint, @address nvarchar(100), @remarks nvarchar(200) AS INSERT INTO tblVisitor VALUES (@lastname, @firstname, @visitorimage, @gender, @personalid, @vehicleno, @company, @represent, @phonenumber, @mobilenumber, @address, @remarks)
I usually use WebMatrix to manage my database (sdf file). I wonder if it can be possible to manage this database with SQL Management Studio 2008? When I try to open it with SQL Management Studio 2008 I get the error:
Incompatible database version. What's wrong?
BUT When I create a new sdf database with SQL Management Studio 2008, I have no problem for open it again with SQL Management Studio 2008 but if I try to open it with WebMatrix it doesn't work...(server not found?)
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.
have 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...
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!
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]....
I am trying to match a username to a userid which are in 2 different sql tables. Here is my select statement:
SELECT aspnet_Users.UserName
FROM aspnet_Users INNER JOIN
aspnet_starterkits_Projects ON aspnet_Users.UserName = aspnet_starterkits_Projects.ProjectManagerId
When I run this i get an error message: "Conversion failed when converting from a character string to uniqueidentifier" Is there anyway around this? Or a different select statement etc?
I see two means of working with session data in ASP.NET MVC:
System.Web.SessionState.HttpSessionState, available on HttpApplication
System.Web.HttpSessionStateBase, available on Controller
Data stored in one seems to be available in the other. Unfortunately the only common ancestor of these two types is System.Object, meaning that I can't create reusable utility code for the abstraction of either.Why is the API this way? Is there an important difference between the two that I am missing?
I'm building an ASP.Net MVC 2 application with a component architecture. There are two different types of components: Elementary Components, which have an associated controller action rendering a partial view, and Layout Components, which render all their child components (Elementary Components or again Layouts) in a certain layout.Here is my generic RenderComponent() action method, which takes a component ID and renders the appropriate view:
[Code]....
Is my hierarchical component architecture incompatible with ASP.Net MVC? How would you build such a system in ASP.Net MVC?
A ModalPopupExtender works fine with a panel as the target control and the panel has an AsyncFileUpload control.
However as soon as AsyncFileUpload.OnClientUploadComplete is set to something (e.g. onclientuploadcomplete="alert('hello');"), the panel is not hidden on page load.
Is there any compatibility issue here?
I am encountering an error when attempting to log into a web app (via a login page) on one of my servers. The web app is an IMAP4 client under development that should connect to the mail server currently running on the same machine. I am successful at connecting to the mail server from my development workstation running an IMAP4 desktop client under similar development.The error is... An address incompatible with the requested protocol was usedThe login page works fine in my development environment on my local workstation (connecting to the local mail server). A little research suggests the error has something to do with IPv4 vs IPv6 addressing, but I'm not sure. I have 2 network adapters in this server, for each of which IPv6 is not enabled. I have successfully reset the TCP/IP stack on the server (netsh Winsock reset) but still the error returns. Only one of the adapters is enabled and being used.
View 4 RepliesI'm working on a DotNetNuke module in C#, and in order to cut down on the amount of complexity I have elected to try and keep the configuration of the module in one page (other than the standard Settings module). I now wonder how wise of an idea that is.My module is a simple image gallery, with one or many images. Each image has a title, an image source (url) and a destination (another url). Therefore, I figured that for my admin interface, I could have a simple 'grid' of data where you can edit all of the existing entries or add a new one, all on the same page, sort of like this:
Title Image URL Anchor HREF
[A Picture! ] [http://www.example.com/image.jpg ] [http://www.example.com]
[Another Picture!] [http://www.example.com/image2.jpg] [http://www.example.net]
[ ] [ ] [ ]
Looking through WebControls, I found the GridView, which at first blush seemed like the sort of thing I was looking for. However, taking a closer gander at it, I found that it needed to be bound directly to a data source, while it seems like the DotNetNuke standard of doing things in the Data Access Layer is to create a collection of data objects like so:
// EditDiscovery.ascx.cs
DiscoveryController objDiscoverys = new DiscoveryController();
List<DiscoveryInfo> lstDiscoveries = objDiscoverys.GetDiscoverys(ModuleId);[code]....
Is there something I'm missing with the GridView, or should I be changing the GetDiscoverys function to return a DataSet as opposed to a List of DiscoveryInfo objects? Or is there a better approach that does things that align better with DotNetNuke's DAL?
Here is the code:
Code:
Dim intusercount As Integer = 0
Using connection As New SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True")
Using command As New SqlCommand("SELECT [ID] FROM [Members] WHERE [Username]=@Username AND [Password]=@Password", connection)
command.Parameters.Add("@Username", Data.SqlDbType.VarChar).Value = TextBox1.Text
command.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = TextBox2.Text
connection.Open()
intusercount = command.ExecuteScalar
connection.Close()
If intusercount > 0 Then
MsgBox("Good")
Else
MsgBox("Bad")
End If
End Using
End Using
Error:
The data types text and varchar are incompatible in the equal to operator.
Source Error:
Quote:
Line 11: command.Parameters.Add("@Password", Data.SqlDbType.VarChar).Value = TextBox2.Text
Line 12: connection.Open()
Line 13: intusercount = command.ExecuteScalar
Line 14: connection.Close()
Line 15: If intusercount > 0 Then
Stack:
Code:
[SqlException (0x80131904): The data types text and varchar are incompatible in the equal to operator.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2030802
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5009584
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +86
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteScalar() +139
_Default.Button1_Click(Object sender, EventArgs e) in C:UsersUserDocumentsVisual Studio 2010WebSitesWebSite13Default.aspx.vb:13
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
Database:
I have a website that's developed in ASP.NET and uses the AJAX Toolkit (asp:ToolkitScriptManager) for a couple of extenders. The AJAX effects (e.g. ) work perfectly across IE 7, IE8, FF3.5, Safari, and Chrome. However, I embedded my site in a desktop Flex-AdobeAir application using the component which is able to run the entire site including javascript except where the AJAX is used.
I narrowed the source of the problem down to the difference between using asp:ToolkitScriptManager and asp:ScriptManager. Here's an example page that will display "Safari" in the embedded flex browser as the result of document.write(Sys.Browser.name):
<%@ Page Language="C#" %>
<%@ Register assembly="AjaxControlToolkit" namespace="AjaxControlToolkit" tagprefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">[code]...
However, if you change
<asp:ScriptManager ID="TheScriptManager" runat="server"></asp:ScriptManager>
to
<asp:ToolkitScriptManager ID="TheScriptManager" runat="server"></asp:ToolkitScriptManager>
it suddenly does not display anything on the flex browser.
there is eny way to convert a string type to uniqueidentifier type .... when i insert or update data , i can give string as a parameter or i must to convert to uniqueidentifier type.?
View 4 RepliesSo admitingly I am fairly new at .NET...I have been a PHP guy for rather long time...
Heres my code:
[code]....
Essentially what I am trying to do is query the SQL database by the username. This above code is a method within the user respository for fetching a user by their username. The variable "username" is passed in as a string.
When the method is called a recieve the following error:
The data types text and varchar are incompatible in the equal to operator.
This to me is rather confusing since the field in the database, user_username, is a text and the variable passed in, as said, is a string. They should be synonomous for all practical purposes.
Ideas? Thoughts? Fixes?
I had build field on table as uniqueidentifier but while in programmind how do i manage i don't have idea as i am new in .net.how to get the and set the value of uniqueidentifier.
View 2 Repliesi'm using SQL queries from visual studio 08, and want to input uniqueidentifier.when i put some random code at text box as alternative uniqueidentifier (or i will short this word to UId), it show me information that the text must be converted to UId via SQL query.this my query for input the data to database
[Code]....
I've been searching on the internet about this issue but all studies returns a ID value that is integer. However, in my system primary key field is a GUID, I mean uniqueidentifier. How can I get this value? Should I use SELECT SCOPE_IDENTITY() which is integer ?
View 2 RepliesI'm just curious, why its not bigint or int ? is that because GUID is easy to generate ?
View 8 RepliesI've found a lot of similar topics but none of them solves my problem.
I have table structure like that
[Code]....
Everyone suggests to change ntext type to nvarchar(MAX) and life will be beautyfull. But... First, I need
ntext, simply because there should be text in this field.
nvarchar(MAX) equals 4096 bytes which is to small for large text. Second, I already have table with
ntext field, which does not cause this error.
I get the following error: The data types text and varchar are incompatible in the equal to operator.here's my code (PageName is a string Parameter) :
SqlConnection sql = SQLconnection();
en();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select title, text, postdate, sticky from articles where pagename = @pagename;";
[code]...
i am trying to edit aspnet_memberships table in detailsview but without using applicationid field. i dont want to be visible applicationid field and some other fields that cannot be null. when i take applicationid visible to false and try to edit some field i get message Cannot insert the value NULL intocolumn 'ApplicationId' because applicationid field dont have any value. this value should be its own value.
View 2 Replies