|
Merge replication
Database mirroring
SQL Notification Services
SQL Service Broker
MSMQ
Writing to a file and polling it is the least desirable solution and very amateur.
only two letters away from being an asset
|
|
|
|
|
Hi all..
I am using MS access database to store the values enterd in text boxes of a ASP.Net page. Since i am using retreiving date of birth too i have speciefied the format as Datetime (shortdate) in Access.
What my problem is whatever time I enter in the text box it is getting stored as 12/30/1899. I really dont have the idea why this is happening. Somebody please help me on this.
Here is the code segment used to store the text box values in MS Access database.
Protected Sub txtsubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtsubmit.Click
Try
Dim sconnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\154466\DW\DW.mdb;User ID=Admin; Password="
Dim sqlstatement as string
sqlstatement = "INSERT INTO dwbi values( " & txtid.Text & ",' " & txtname.Text & " ', " & txtdob.Text & " ," & txtvnet.Text & "," & txtextn.Text & "," & txtmoblie.Text & ",'" & txtpskill.Text & "','" & txtsskill.Text & "','" & txtinterest.Text & "','" & txtproject.Text & "')"
Dim dbcon As New OleDbConnection(sconnection)
Dim oCmd As New OleDbCommand(sqlstatement, dbcon)
dbcon.Open()
oCmd.ExecuteNonQuery()
dbcon.Close()
lblmesg.Text = "Details Updated Successfully!!"
Thanks in advance..
Jaysheel
|
|
|
|
|
Hi!
sqlstatement = "INSERT INTO dwbi values( " & txtid.Text & ",' " & txtname.Text & " ', " & txtdob.Text & " ," & txtvnet.Text & "," & txtextn.Text & "," & txtmoblie.Text & ",'" & txtpskill.Text & "','" & txtsskill.Text & "','" & txtinterest.Text & "','" & txtproject.Text & "')"
should be like
sqlstatement = "INSERT INTO dwbi values( " & txtid.Text & ",' " & txtname.Text & " ','" & txtdob.Text & "'," & txtvnet.Text & "," & txtextn.Text & "," & txtmoblie.Text & ",'" & txtpskill.Text & "','" & txtsskill.Text & "','" & txtinterest.Text & "','" & txtproject.Text & "')"
note the ' character for txtdob.text
Hope this helps.
|
|
|
|
|
Thanks alot Nilesh !!!!
That worked out !!!
|
|
|
|
|
Hi
While entering date into database user Datetime.Pasrse(txtdob.text) function
while saving data into database it is saved as MM/DD/YYYY format.
Rahul
|
|
|
|
|
Hi,
I was trying to open an aspx form in VS 2005, which I created in VS 2003. But its throwing exception:
"System.Web.HttpException: Cannot use a leading .. to exit above the top directory."
But when I remove the line in aspx where I link the CSS to the page, the error vanishes. The CSS link is:
<LINK href="<%=strVersionPath%>" type=text/css rel=Stylesheet>
Could anyone tell me what going wrong here?
Regards,
Blumen
|
|
|
|
|
May be this is due to different directory strucutres for 2003 and 2005. You can try checking value of strVersionPath
|
|
|
|
|
The value for that string seems fine, but when we run that page, its throwing this error. I have googled for this error, but results are confusing.
Is this the way to link a CSS in ASP.NET 2.0, or is there an alternate way to link CSS to the page in 2.0?
Regards,
Blumen
|
|
|
|
|
may be the problem with ur variable <%=strVersionPath%>.
bcoz the directory structure of 2005 is difrent than 2003.
check the value of "<%=strVersionPath%>".
i dont know this is the problem anyway check this out.
try this line of code
Sarith...
|
|
|
|
|
Can i install .net 2005 and sql server 2000 in vista basic OS
plsss help me
Sarith...
|
|
|
|
|
I don't see why not. VS2005 has it's own web server build in.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
But u should know there is ISS in Vista's Version under Vista Business
I am not a perfect programmer,but i have perfect's programmers' habits.
|
|
|
|
|
thnks for the reply
Sarith...
|
|
|
|
|
If I have the /3GB boot switch enabled, the ASP.NET worker process (Aspnet_wp.exe) does not start. If I request an ASP.NET page, i receive one of the following error messages in the browser:
HTTP 500 - Internal server error
My question is where i can locate the /3GB boot switch?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
How did you enable it/know about it without knowing where it is??
|
|
|
|
|
hi friends
I have serch option and datagrid in my page.
I have search options in top of the page and datagrid in bottom of the page.
if i give the value in search options ,the values will get from database and
display in datagrid
now i need the databind in datagrid without page refreshing
how can i achive this using AJAX with asp.net 2.0 version
if u have any code plz send me
regards
saravanan
|
|
|
|
|
Just a small trick to reduce the flickering effect (Works in IE)
just keep it in your HTML Header
If you are using master pages it does not work in child pages.
~Jagadeesh
|
|
|
|
|
And how will this help in binding the datagrid?
only two letters away from being an asset
|
|
|
|
|
saravanan05 wrote: now i need the databind in datagrid without page refreshing
Datagrid will be rendered as HTML table. When you give databind, it will create table rows and cells. So in your case you need to create these manually with javascript. I think Ajax toolkit have some controls which does this.
|
|
|
|
|
N a v a n e e t h wrote: I think Ajax toolkit have some controls which does this.
UpdatePanel
N a v a n e e t h wrote: So in your case you need to create these manually with javascript.
only two letters away from being an asset
|
|
|
|
|
What happened ? I said anything wrong ?
|
|
|
|
|
Using Microsoft AJAX extentions just place the datagrid within an UpdatePanel
only two letters away from being an asset
|
|
|
|
|
Ajax is de better option for binding control without postback.
but in the case of datagrid i dont kno how to return the value to datagrid.
if u use atlas frame work there is an option. there we will hav ajax enabled controls.
Sarith...
|
|
|
|
|
Friends,
i want to upload many images using asp.net to sql 2000 from many users all over the world. so to reduce database size i want to compresse the image size before upload and i want to display the same compresed image to front end
thanks in advance,
Be friends...
K.Dayanidy
|
|
|
|
|
If you're accepting BMP images, you should stop. If you're accepting JPEG images, the reason they are so much smaller than BMP files is that they are compressed. Take a jpeg and put it in a zip file. It's the same size, because no further compresson is possible.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|