I have a field of type smalldatetime in a sql table. through a webform, i am trying to insert a blank value(i.e. through A blank text box) but its showing an error that the" value can not be recognized as valid date time". I am using a textbox to insert value to this field. but that text box can also be blank sometimes. plz help.
View 4 Repliesi want to insert null in smalldatetime column, when user doesn't select any date from the calender control i want to insert null in the databse, i am using typed dataset in my application.
here's my code
[code]....
it gives me the exception "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM."
1. in SQL SERVER 2005 express edition - how to store 28-12-2010 in smalldatetime field
2. is any differecne exists in different versions of SQL server
3. what is the best mechanism ofor storing date in dd-mm-yyyy format sql server
How To convert String Data Type to Smalldatetime field in vb.net
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
[Code]....
I'm trying to insert few values to a table, when i press the submit button the aspx page goes blank and i don't get any error message. I'm not able to find where the error is.
The code:
Protected Sub AddMInfo_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles AddMInfo.Click
I have a 20 to 30 fields on a form. Most of them are optional. However, the users can fill out what they want. If a user dosen't fill in a field when data is sent to the database it's sent as blank, instead of NULL. Is there a way I can generically say "for all textboxes if Equals("") then DBNull.Value". Without going through each and every textbox?
View 2 RepliesI have a DataTable that's populated with Data. I'm looping through it and checking to see what the contents of the first cell of the first column are. If they have the same value on the current iteration as the previous, I want to insert a blank row into my DataTable. The problem is that the new row is being added to the end of the DataTable instead of between the two rows. How can I get it not to append the row to the end. This is what I'm doing:
[Code]....
if i select a blank field and then insert to the drowdownlist in repeater.
how can i display the text of the blank field but the insert val is empty.
SQL as below:
select '' as Field_1 union select field_1 from table.
i would like to set the value to blank and display text to "please enter".
I want to return all rows from a SQL Server 2008 database table into a SQL data source if a textBox field is blank. So I made a stored procedure with an if @date IS NULL clause.
Although the stored procedure seems to be working fine in Visual Studio 2008 the actual webpage displays no results.
I am guessing I have to send a DBNull value to the stored proc if textBox.Text == string.Empty. I tried the SqlDataSource1.SelectParameters.Add but it seems that I get a conversion error from DBNull.Value to string.
Is this the source of my problems or am I missing something else? How would I pass DBNull.Value to a stored proc if a textfield is blank?
is there a way in crystal report to remove blank space between two data field for example
Field 1 Field 2
how do i make it the distance between Field 1 and Field 2 become closer and look like this
Field 1 Field 2
without changing the position of the Field 2 in the report design... i need this cause the data in Field 1 is different for each user and i need the Field 2 to have a smaller font size than the Field 2 so i cant use formula since formula only allow 1 font size.
I have a Formview where user is selecting the date and time via dropdown values. I am trying to set the value of the field when the record is being inserted for some reason my database still displays a null value.
Protected Sub FormView1_ItemInserting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertEventArgs) Handles FormView1.ItemInserting
CType(FormView1.FindControl("txtActivityDateTime"), TextBox).Text = CType(FormView1.FindControl("ddlMonth"), DropDownList).SelectedValue + "/" + CType(FormView1.FindControl("ddlDay"), DropDownList).SelectedValue + "/" + CType(FormView1.FindControl("ddlYear"), DropDownList).SelectedValue + " " + CType(FormView1.FindControl("ddlHour"), DropDownList).SelectedValue + ":" + CType(FormView1.FindControl("ddlMinute"), DropDownList).SelectedValue + " " + CType(FormView1.FindControl("ddlAMPM"), DropDownList).SelectedValue
End Sub
I have an integer field in my sql database and I have an xsd set up with all the CRUD operations. I need to put the value in a variable into the this integer field. Sometimes the value is 'nothing'. I have option strict on so there's no conversions going on by itself. If I hard code 'nothing' into the insert query, it works fine. Here's what happens otherwise:
1) If I put a variable into the query, when I assign 'nothing' to the variable, it becomes 0 so it puts a 0 into my database.
2) If I use an iif( ) statement, it also converts 'nothing' to 0
I don't seem to have any way to get a nothing in there if I don't specifically write 'nothing'.
I'm adding a couble of fields to database but i need the primary key of the master table to add it to sub table.
The database contains 2 tables :
Question Table :questionID(primary key and identity) , questionInText
Answer table : answerID , answer1,answer2 , questionID
code used to insert to db :
[Code]....
questionID is auto increment.
The question is : How i get questionID after adding to database without using sql statment ?
i'm working on my first project on asp.net using c#.
I'm adding a couble of fields to database but i need the primary key of the master table to add it to sub table.
The database contains 2 tables :
Question Table :questionID(primary key and identity) , questionInText
Answer table : answerID , answer1,answer2 , questionID
code used to insert to db :
[code]....
I got the difference between Bind and EVal from here. Bind will do both way reading and writing. And Eval do only reading. So any function only for writing?
View 1 RepliesI creating a real Estate web application. I have a form where the admin can type price for a specific property. The price will be insert into the SQL database.
Which is the best SQl data type to store for example : �150.000 and then retrieve it from the database. It has to be any type of SQL data that store number as I have a search on the website that compare values of numbers. It cannot be for example varchar othewise I will get an error.
I have a table in sql having a numeric data type column,Now i want that whenever user left this field blank from front end aspx page, null value should be inserted in this column from stored proc.How can i achieve this? Also what kind of data type is most appropriate on front end for such taking kind of value?
View 2 RepliesI have a form which a user can fill in x times with the data they want too. The form is posted to the following Action.
[HttpPost]
public ActionResult Manage(ProductOptionModel DataToAdd)
{
if (!ModelState.IsValid)
{
return View(DataToAdd);
}
var ProdServ = new ProductService();
if (DataToAdd.ID != 0)
{
//Edit Mode.
DataToAdd = ProdServ.EditProductOption(DataToAdd);
ViewData["Message"] = "Option Changes Made";
}else
{
//Add
DataToAdd = ProdServ.AddProductOption(DataToAdd);
ViewData["Message"] = "New Option Added";
}
var RetModel = new ProductOptionModel() {ProductID = DataToAdd.ProductID};
return View(RetModel);
}
So at the bottom I blank the model (Leaving just the required field) and then return to the view. However the view holds the data from the previously submitted form. I have debugged the code and checked that the RetModel variable is empty.
I want to change smalldatetime to datetime, to a table is it posible?
because it is giving me en error that the table has to be dropped
there is 2 pages the first page include gridview its fill from xml file and there is button (Called add new student) when i click on this button its arrive me to second page and the second page inckude 5 Text box if to add new student.
** the problem with the ID of new student its can be show on the head page like this (http://localhost:57175/gridvieww/Default2.aspx?ID=8) i want head the ID number i am using query string now i want code to find the last node in xml and then increment +1.this is my code
XML code
<Students>
<Student>
<ID>1</ID>
<Name>hammad</Name>
<Email>hammad@xml</Email>
[code]....
I have a data type mismatch while inserting into a number field in an access database using a parameterized query.I think this should be pretty simple but I am still learning a lot.
[Code]....
I have some commented out as I am working one field at a time. The working fields are textboxes and the non working ones are dropdown lists. But I think it may be the field that the list is drawing from? Not sure.
I'm trying to write code for a function that checks dates in a db table and finds the ones that has passed. Example:
tbl Occasion
ID dateStart (smalldatetime) dateStop (smalldatetime)
1 2011-03-29 13:00:00 2011-03-29 14:00:00 //this one won't pass until midnight
2 2011-03-27 17:00:00 2011-03-29 18:00:00 //this one has passed
[Code]....
The formats of 'datevalue' and 'dateStart'/'dateStop' in db are the same, do I need to convert them anyway?
I am trying to update a column named td1 (smalldatetime) in a table
the sql query is :
Session("date") =
Date.Now
Dim sSql As
String = "update qa_segmentos set dt1 = '" & Session("date") &
"'"
looking in the autos window I read :sSql "update qa_segmentos set dt1 = '20/10/10 18:11:43'" String
The error that I get is:
The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
The statement has been terminated.
I have a database that has several timestamp fields. One is addTime, another is editTime, and the final one is subTime. depending on which part of the web application the user uses, it will update one of these fields. I know in a sql command in the code behind you can use the getDate() function to populate a value, but will the sql command automatically parse it to the SmallDateTime datatype in the database?
View 2 RepliesI am getting an error when attempting to call a stored proc from my asp.net page.
e.Message = "Conversion failed when converting character string to smalldatetime data type."
The stored proc is being called by:
The asp.net code that is calling the stored proc is:
[Code]....