y add null value in database in filed type date it had data ?

[wondery]

when i insert data into sqlserver i check in stringsql yet that return '' < == empty value but y it insert it return 1/1/1900 :confused: how to slove this ??

[wyrd]

Assuming I understood any of that.. try inserting the value 'NULL' instead of a blank string.

[wondery]

i try but same result

[jfackler]

I agree with Wyrds implied point about your question being hard to decipher. That being said, I assume your variable is a Date type. If you do not assign an initial value to a variable, Visual Basic .Net will initialize your varialbles for you during compilation based on the variables type.

[PlausiblyDamp]

Does the database have a default specified (or a trigger that generates a default value)?

[wondery]

PlausiblyDamp : no defaul specified

jfackler : here is my code in field first, filingDate, Issue, mailed and publish is DateTime Format

 

string strsql3 = "INSERT INTO tblTrademark(AppNo,RegNo,"
				+"StatusName,TypeName,NewOrCon,Your,"
				+"CountryName,AgentName,TrademarkName,TrademarkColor,"
				+"Notes,FirstContact,FilingDate,Issued,Mailed,"
				+"Publish,Related,Priority,Correspondens,AgentRef,ApplicantRef,"
				+"OwnerRef,Entered,Modified,UserName) "
				+"VALUES(N'" + txtAppNo.Text
				+ "',N'" + txtRegNo.Text
				+ "',N'" + ddlStatus.SelectedItem.Value 
				+ "',N'" + ddlType.SelectedItem.Value 
				+ "',N'" + ddlNew.SelectedItem.Value 
				+ "',N'" + txtYour.Text 
				+ "',N'" + ddlCountry.SelectedItem.Value 
				+ "',N'" + ddlAgent.SelectedItem.Value 
				+ "',N'" + txtTrademark.Text 
				+ "',N'" + ddlColor.SelectedItem.Value
				+ "',N'" + txtNotes.Text 
				+ "','" + txtFirst.Text 
				+ "','" + txtFiling.Text 
				+ "','" + txtIssued.Text 
				+ "','" + txtMail.Text 
				+ "','" + txtPublish.Text 
				+ "',N'" + txtRelated.Text 
				+ "',N'" + txtPriority.Text 
				+ "',N'" + txtCorespondens.Text 
				+ "',N'" + txtAgentRef.Text 
				+ "',N'" + txtAppRef.Text 
				+ "',N'" + txtOwnerRef.Text 
				+ "',N'" + DateTime.Now
				+ "',N'" + DateTime.Now
				+ "',N'" + Session["User"] + "')";