specify a querystring to be always null when there is no value to pass?I always get an error saying NULL can't be converted to INT.The SQL datatype for this querystring is int.
View 5 RepliesThe following code works well as long as I pass a querystring value to the datalist.
Private Sub BindGrid()
Dim id As Integer = Integer.Parse(Context.Request.QueryString("id"))
Dim strConnString As String = ConfigurationManager.ConnectionStrings("Conn").ConnectionString
Using con As New SqlConnection(strConnString)
Using cmd As New SqlCommand()
cmd.CommandText = "select Id, Name from tblFiles where Id=@Id"
[Code] ......
However, the page errors with the message "Value cannot be null." if I don't pass a value. I know that DataList does not have an EmptyItem Property like a Gridview control. I do not want the page to error if I don't pass a value. Need info to deal with empty values in a datalist.
Most websites have pointed me to this code to use:
<FooterTemplate>
<asp:Label ID="lblEmpty" Text="No Result" runat="server"
Visible='<%#boolean.parse(([b]list[/b].Items.Count=0).ToString())%>'>
</asp:Label>
</FooterTemplate>
The 'list' throws an error. The error is "Too few type arguments to 'System.COllections.Generic.List". I am not sure if the code is written in C# and that is what is causing the error. It seems that it should work but I can not figure out the 'list' error.
Passing a null or nothing value to a datatime datatype database field (Access)
I've been all over the internet looking at this and I have tried dozens of methods without success.
I've read a few forums where, some say you can not assign a null value or a nothing value to a datetime datatype field. Then I see others where they say...'I got it to work'.
If this is true (that you can not pass a null value), how come I can create a record in the Access table and not assign a value to this date field? (The field is defined as not required).
Yet, once a value is in the field, I can not update that field back to a null or a nothing value.
So I'm hoping someone has the definitive answer to this.
I am using VB.Net Vs 2003 and updating an Access data base.
I have an update statement (see below) that uses parameters for updating.
what will work, so that I can put back the null or nothing value?
Or if it really can not be done, I guess I'll have to take that as truth.
[Code]....
i wanted to store image in sqlserver database image field and i did. But now in some cases i want to store null value in that image field how to do this using file uploader.
View 3 Replies i am store ms word resume to image(BLOB) data type in sql server 2005. now i want to display this resume in HTML page or in text area. and for that i use
[code]....
How to check the query string value null, if null then display the default value instead of object reference error.
View 1 Repliesconvert below datetime value which is as varchar datatype to another datetimeformat as varcharchar datatype
2010-05-19T13:05:08.6Z
I m using multiple sitemaps in my website. The providers are defined in web.config file as:
[Code]....
[Code]....
Now I m trying to modify one of my xml file in memory to dynamically populate querystring but when I use
Dim currentNode
As
SiteMapNode =
SiteMap.CurrentNode.Clone(True)
I get Null in my currentNode and I cant point to the node.
next code works with no problem at all but, isn't there a more elegant way?
What I want is to show all records when querystring is null and only those
who match the criteria when querystring is not null.
[Code]....
How can i use querystring for this-
Here in below code i have used querystring for sending imagename from this page to another page. Now i just want that with this imagename in also want to send span element's text with same querystring.How can i achieve this?
[Code]....
(This is a more narrow question)
In my asp.net MVC action, I am looking if the ReturnUrl value is in the URL.
My Url looks like this:
[URL]
In my action, I am looking if that querystring value exists, and it is returning NULL?? How can this be?
The code:
if(Request.QueryString["ReturnUrl"] != null)
{
}
Tracing through the application, it is just skipping the if statement's body i.e. it is NULL.
How can this be explained?
[URL]
I have a file, a.pdf, stored on a SharePoint server behind Windows authentication. I want to make a.pdf available through another Web app with forms authentication. Basically, link is clicked and up pops the open / save as dialog for the pdf (or other document file) I've set up my HTTPWebRequest and passed credentials, getting my data into a stream (file.GetResponseStream).
I've tried converting the stream to a byte array and then using response.write or response.output.write with no luck (stream not seekable) I've tried using a streamreader and doing a response.write(streamreader.readtoend()) and response.write(memorystream.toarray(),0,memorystream.toarray().length) with no luck (the message received from the server could not be parsed).
I have an application in which if I enter greek characters it gets diplsayed correctly till they are in cache but when I go to another webform andcome back this data is passed to database and comes back and is not right it shows something else than the greek character I entred.
What could be the problem, is it something to do with database conversion or what?
I am using System.Web.HttpUtility.UrlDecode() function to decode the url. In case if the encoded url has a '+' sign this gets converted to blank.
View 3 RepliesI am looking for any lib , or any solution. What I want to do is to email the generated results with some images on the website which for instance is something like results.aspx,I have got an email button for the clients so that they can email themselves the result page in a pdf format.
View 2 Repliesget error in the header after this
[Code]....
I have datalist bind with sql datasourceI have update command
Protected Sub DataList1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataListCommandEventArgs)
Dim ID As String = DataList1.DataKeys(e.Item.ItemIndex).ToString()
Dim title As TextBox = CType(e.Item.FindControl("textCategoryName"), TextBox)
Dim image As FileUpload = CType(e.Item.FindControl("FileUpload1"), FileUpload)
[Code] ....
It shows the error in the line
SqlDataSource1.UpdateParameters("image").DefaultValue = image.FileBytes
Value of byte can not be connverted to string
I also change the sql datasource parameters for image from object to byte
<UpdateParameters>
<asp:Parameter Name="title" Type="String" />
<asp:Parameter Name="image" Type="byte" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
I am trying to get the following code behind to store a file in a datbase using Linq (with *dbml). I am getting an intellisense error in my "For each" loop the says the following":Value of 'Byte' cannot be converted to 'System.Data.Linq.Binary'I have been searching for awhile, but I can't seem to find a solution that has worked for me yet.
[Code]....
I am getting error message: The value '31/12/2050' of the MaximumValue property of 'RangeValidator1' cannot be converted to type 'Date'
Asp.net pages were working fine before but after reinstalling the VS2008 on new machine and copied the old pages to new machine i am getting this error message.
I am using Asp.net2.0 , C#.
I am Uploading the downloaded excel file from asp.net. Now I one of the column I am getting Mix Data type that is int and varchar. But it only show int or varchar that is only one type of data. I am using connection string as
[Code]....
My website provides a facility to upload images, using the ASP.NET FileUpload control. We accept both jpeg and tiff formats but I have just decided that all tiffs should be converted to jpegs at the time of upload. If possible, I want to avoid saving the original tiff to disk. I would any sample coding for achieving this conversion prior to saving (ideally in VB.NET, though I could always run C# code through a converter).
View 4 RepliesMy website provides a facility to upload images, using the ASP.NET FileUpload control. We accept both jpeg and tiff formats but I have just decided that all tiffs should be converted to jpegs at the time of upload. If possible, I want to avoid saving the original tiff to disk.
I would appreciate any sample coding suggestions for achieving this conversion prior to saving (ideally in VB.NET, though I could always run C# code through a converter).
I have a Table in SQL Database, it only has one sell and its xml type.
I need to bind that xml to TreeView Control, and since I can't bind use sqldatasource as a datasource for the treeview and i cant use the XmlDataSource to read from the database...
I have setup my business object to have a create_date and edit_date members both datetime datatypes. My company want to display the create_date and edit_date fields in a gridview for each transaction. The problem i have is that after insterting a record it will have a valid create_date but no edit_date and when displayed in the gridview it defaults to datetime.minvalue (My default). How on earth do i show an empty field in my gridview for a null datetime field in the database?
I am using similar architecture to the Imar Spaanjaars example of a tiered solution. With a few small tweeks it has worked well for me for ages. I am passing a List<Database> to my object datasource which connects to my gridview.
can u tell me what datatype i should use for TimeIn and TimeOut of the employee in database.
In frontend i am storing TimeIn and TimeOut as object.