C# - What Should Be Saved (in SQL Server Database) If It Is No Data (is Null)
Mar 16, 2011
I have SQL Server database entry LastCheck of datatype DateTime.
By first save it is no value, so it is NULL. LastCheck is configured to allow nulls.
What should I insert in my statement? How to initialise LastCheck in code? Should I convert DateTime to null?? I can't do just LastCheck = null, because it is from DateTime value.
Job job = new Job();
job.LastCheck = null;
cmd.CommandText = "INSERT INTO Jobs (LastCheck)"
+ " VALUES (@LastCheck)";
cmd.Parameters.Add(new SqlParameter("@LastCheck", job.LastCheck));
we save the images in database and read the file to show on web front. The problem is some of the images fails to be shown on the page. but if we right click and choose show image, it is shown again. is it because of database timeout ?
have a button called "Confirm" which updates the datas entered in the screen. But the procress takes 1-2 minutes to update. I want to add a progress bar which automatically appears when the "confirm " button is clicked and automatically closes once the update is done.
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.
i am having two textboxes and a label in a gridview control, i am adding a javascript function to the second textbox onblur event attribute and display the result in the label, the function works fine and result is displayed in the label, but when i am saving the grid data into the database, the label is returned 0 or empty, but i am able to see the value , how to overcome this.
When I am creating a new form, I am inserting "RequestId" of particular form in Textbox as well as uploading multiple file (that comes in Gridview)and on save button click, those gridview multiple files with "RequestId" are saved in Database as below:
Now, I want that If I delete any file from the Gridview(which has all uploaded files), I want that file to be deleted from database table also.Currently on Deleting file from Gridview, files from "Folder" are deleted not from Database.
I got a table in a formview where i placed lots of textboxes and dropdownlists inside the table because I need these textboxes and dropdownlists on a background image.
the data on textboxes and dropdownlists that are inside the table is unable to be saved into the database when i pressed the "submit" button. Other textboxes and dropdownlists that are not inside the table work fine. Here are the HTML code for the table:
I am using a bound gridview in ASP.NET 2.0. The gridview has the ability to edit/update and insert rows. One of the columns holds a number which represents a percentage. What I cannot figure out is how to ensure that all the rows in the gridview total 100% before being able to send the updates or newly inserted data to the database.
For example say there are 5 rows in the gridview, each row has 20% stored in the column so it adds up to 100% which is fine, the data is updated/inserted in the database. But say each row only had 15% totalling 75%, the user should not be able to send the updated/inserted data to the database until either they add a new row with a percentage of 25 or they edit the other rows for a cumulative total of 100%
i have a folder in server for saving my images and inside database i save the image name , now the issue is i want to display the image in image control in datalist how to do that
I have a coloumn in a database table in which i am storing the candidates photo in a binary format.
now i have to show these photo in a gridview according to the candidates rollno. i am trying to use the imagefield of a gridview control to display the photo but it is not displaying the photo in a grid view
I able to successfully see all the Excel files in the given folder using the datagrid and code below. Now I would like to be able to click the link to the file, or add a button, to get a download file dialog box. [Code]....
I have a text field into which I'm saving order details, using LINQ to SQL.
Each order may have a different number of columns, depending on the type of order, so I thought I'd just create a single structure to take care of everything, and display details in tab delimited columns.
The text is created properly prior to saving to database:
[Code]....
However, when stored in the database, the spacing is no longer maintained.
I write the following code but there is an error. I just want to retrive the image which I have save into tha database from the sql server and to display in the picture Box(image)
In the following code i want to save the value selected by user from drop downlist into database. but whatever value is selected by user, first value is saved to database
used Ajax.BeginForm for form submitting.For the fields I want to show watermark if there is no data in database.But on submitting watermarks are saved in database.
I followed the following linkhttp://weblogs.asp.net/justinsaraceno/archive/2008/02/22/reorderlist-with-objectdatasource.aspxand manged to make the orderlist work fine except one thing and probably the most importent thingwhich is saving the reorder back to the databasewhat I changedfirst I'm using it as a c# web form inside a visual basic.net website. Is this OK?second I changed the connectionString to point to my database wich is in SQLEXPRESS ( NOT ATTACHED in App_Data inside the website as the example shows)third I changed the select and update statements and parameters to my needsafter all that it works but without saving the reorder back to databaseReorderClass.cs
I am currently learning vb.net with sql. I have two textboxes (txtValue and txtText) , a dropdownlist (ddl1) and save button (btnAdd). I insert value to txtValue and txtText (eg: txtValue: A and txtText: Apple). When I click button Add, The value will display in dropdownlist (like this; A - Apple) and both data will be save in the sqlserver (db).
I am having issue where when i click button Add, the data is not display in the dropdownlist. But when i refresh my browser, the data will display in dropdownlist.
Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load If Page.IsPostBack = False Then Dim rs As DataSet ddl1.Items.Clear() ddl1.Items.Add("")
I used the below link to upload video file and play it using player.In this code video file is uploaded and displaying in datalist but while play it using player i cannot see video and only audio is coming.
I have a weird thing happening. I have two identical databases installed on one virtual machine but under two different instances of SQLServer. For some reason, periodically when saving from one it will save to the other instead. Using debug, I have verified that the connection string is correct and when the item saves, it still saves to the wrong database.I use session variable, and am of the belief that it might have something to do with it...and t hat when I go from one to the other it is still getting the connection string form the other for some reason.To make sure that it isn't a problem, I make sure that I completely close out one database before opening the other in a new IE window.I assume that when I completely close out an internet explorer window that it abandons all session states. Is that true?
