Problem with Casting from XML to Varchar(max)

I am facing problem with casting from XML to varchar(max). I declared one variable as XML and that variable contains data in XML format and it contains more than 8000 chars (in our application some times it may contains nearly 100000 also).

Now, I am trying to cast that XML type variable to varchar(max), on that time varchar(max) variable taking 8000 chars only. I need all chars what XML variable contains into varchar(max) variable.

More Related Resource Links

I'm developing a Windows Forms app using VS 2008 with a SQL Server 2005 database.
I've got search form where users can search for data by entering one or
two criteria. One of these is a date which corresponds to a date field
in my database. The user clicks on a button, which feeds the criteria
into a stored procedure. The results are displayed in a datagridview
control.
While the functionality works well with the non-date criteria, whenever a
date criteria is used on it's own a cast error is raised ('Conversion
failed when converting datetime from character string.')
I've tried lots of ways of casting the date (formatting using left,
right and mid finctions, using the substring function etc) but still
can't get it to work. Code and SQL are shown below. Does someone know
where I've gone wrong? 'DateAssayRequested' is the date in question.
<vb>
'set up and initialise connection
conn = New SqlConnection(etc)
comm = New SqlCommand
comm.Connection = conn
comm.CommandText = "SPSearch"
comm.CommandType = CommandType.StoredProcedure
'create input parameters, set types and values
param = comm.CreateParameter
param.ParameterName = "@assayid"
param.Direction = ParameterDirection.Input
param.Value = txtLabNo.Text

I've got an SQL-2008 database containing our network inventory (it's from LanSweeper - a low-end and very recommendable network management tool). In a table are all logins with the IP-address of that moment, where the IP-address is defined as VARCHAR(15).

I need to compare IP addresses with those in the table defining the IP segments, where the segment addresses are also defined as VARCHAR(15).

In order to be able to compare reliably, I need to convert the addresses to numeric format. I cooked up the following SELECT statement for that:

In general no one can easily group or make a single selection from radio button list inside gridview rows. There are a lot of way to make a single or unique selection from list. Here i want to share how i can address this problem in the most easiest way. Googling the problem most of the cases i saw the grouping in horizontal way. Thats why i tried to group the radio buttons in vertical manner. Let i have a requirement like below:

we'er uploading photos to a file on the server everything works fine the photo is resized renamed and sent to the folder

the upload page returns the thumbnail and the full size photo it's there all the photos have to be approved by an admin

twice now after they have been approved they disapear I checked the folder they are not there could there be anywhere

on the server they could get hung up before they go into the folder I have it setup so when you delete the data base entry it deletes the photo from the folder othe than that you need to open the folder and delete the photo this has hapened twice now I tried to recreate it with no luck

I'm having a problem with an asp.net 3.0 application using a gridview to display data. The problem seems to be that despite a brand new .selectCommand being sent to the sqlDataSource, the gridview starts displaying data from *someone else's* query. For example, user A is logged in and will be working fine until a few page submissions later when the gridview data starts suddenly showing information that belongs to another user.

This is my first asp.net application, though I've been working with classic asp and ADO for years so I'm used to sending a SQL string and getting back the results from that string. Apparently there is a complex caching system which is interferring which I do not at all understand so at this point I just want to stop the server from caching any data whatsoever. Is this possible?

I want to make Rolebase menu in MVC such that if user doesnot have permission for some action then that Action name shouldnot be shown in the Menu.

I have used the code in the url(http://forums.asp.net/t/1566328.aspx) in my MVC application.My application is a Discussion Forum(in MVC) same functionality as in this forum forums.asp.net

I have used Controllers for post, thread etc.In each controller there are some actions that are using [Authorize(Roles)] attribute

but this coding does not count those Actions in Controllers having Authorize attribute according to the url http://forums.asp.net/t/1566328.aspx

In the code, Authorize attribute is applied to Controller class, but my requirement is of Applying Authorize attribute to some actions in controller so that some are available for all users and some links are available rolewise.Now what is the solution for that?

Error1The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)C:\Users\spencer\Desktop\weblauncher\Common\MVCConfig.cs418Common

The type or namespace name 'Routing' does not exist in the namespace 'System.Web' (are you missing an assembly reference?)

I do have the System.Web.Routing in my references for the project.

BUT - when I try to view System.Web.Routing in the OBJECT BROWSER, nothing is inside! The System.Web.Routing namespace is not in there - the entire thing is empty! Could it that the dll is corrupted? I tried to reinstall the .NET 4 and MVC 3 stuff, but its still empty!

I am trying to make a page inspired from http://login.qlikview.com/help.aspx

here I have made a dropdownlist and on clicking I am able to dynamically add the textboxes and radio buttons using placeholders. My problem is I am not able to use a dynamic number of submit buttons. In the page (link above) I need to make the submit button available for two choices and invisible for one. But the option dynamicbutton is not available alike dynamicTextboxes etc. What could I do? Is there any other way I could figure out to implement this.

i am binding images dynamically(back end)for a datalist .iam applying a slideshow for it .I am getting a problem to apply slideshow for dyanmically binded images.If the define in a div statically it working perfectly