|
Mysql has another format for storing date,named TIMESTAMP
if you want store date into mysql you must use this.
TIMESTAMP format store the seconds number from 1970/1/1 until your date
you can use this mysql methods for working with TIMESTAMP:
SELECT UNIX_TIMESTAMP( '2006/2/2' )
SELECT date_format( from_unixtime( '1138825800' ) , '%Y/%m/%d' )
|
|
|
|
|
what should be datatype for storing datatype in mysql..will these work in asp.net 1.1.
|
|
|
|
|
i worked this myself using mysql from aspnet1.1
you must work with functions above that i said.
one of them convert your date to TIMESTAMP format
another one convert form TIMESTAMP to normal date format
see sample in above that i said.
you must use these commands on your Queries.
-- modified at 7:41 Wednesday 28th June, 2006
|
|
|
|
|
hello thanx for it
i will check it.
could u tell me one thing more.
i have to show some data (which is in database ) in pdf format.
i have used datalist control,label & image control to show that data.
now how to convert in pdf format.
thanx
|
|
|
|
|
Hi
i don't work with PDF tools in .net .
but i found this for you : see this:
http://www.411asp.net/func/goto?id=6928010
http://www.411asp.net/home/assembly/document/pdf?rid=
http://www.devdirect.com/ALL/PDFCREATE_PCAT_1876.aspx
|
|
|
|
|
Format the date in ISO 8601 format, and it will work just fine.
string dateString = theDate.ToString("yyyy-MM-dd HH:mm:ss")
---
b { font-weight: normal; }
|
|
|
|
|
Hi,
After i have installed .Net 2005,SQL Server 2005 & IIS, i have tried to access all application i have deployed in localhost(Eg. http://localhost/test/test.aspx, http://localhost). But its showing the error "You are not authorized to view this page.You do not have permission to view this directory or page using the credentials you supplied." I have checked the IIS->Properties->Directory Security->Allow Anonymous Access but its not working. I have logged into my machine using admin login.
Can any one help me what are the security settings i have check also if you could send me some links where i can get the relevent information it could be helpful for me.
Thanks in Advance,
Shans.......
|
|
|
|
|
Hi,
I am not sure , but just give it a try.
Check in the IIS properties which framework is running.
For the projects developed in .NET 1.1 , change it to .Framework 1.1
Thanks
Sushant Duggal.
|
|
|
|
|
Many thanks for your reply.
The paalication was developed using .Net Framework 2.0 and the IIS is currently using 2.0 but still its not working 
|
|
|
|
|
try to give permission to folders for "aspnet" user mouse right click share and security, on share tab there is a permission button clik it ,add->advanced->find now after do this you will see a user list find aspnet user in the list and click ok
openup your heart and let the sun shine in
|
|
|
|
|
Many thanks for your reply.
I gave the ASP.Net permission for that directory still its not working.
|
|
|
|
|
Hiya all.
It seems the asp:panel "transforms" to a table when viewed in FireFox, does anybody have any idea as to why this occurs? I've never used asp:panel much, but was tasked with debugging some code somebody else had made, when I found out it was because the images were positioned in a table, which ... originated from asp:panel, and FireFox.
When rendered in IE it displays "right", however I can not find any indications as to why this difference exists?
Exampel:
<asp:Panel ID="something" Runat="server">
<div>hello</div>
<span>goodbye</span>
</asp:Panel>
(The div+span were just stuff I used to testing)
This renders to the following html source in FireFox:
<table id="something" cellpadding="0" cellspacing="0" border="0" width="100%"><tr><td>
<div>hello</div>
<span>goodbye</span>
</td></tr></table>
but to this in IE:
<div id="something">
<div>hello</div>
<span>goodbye</span>
</div>
Anybody got some idea as to why this happens? (edit:whops forgot to ignore html tags)
---------------------------
127.0.0.1 - Sweet 127.0.0.1
-- modified at 6:08 Wednesday 28th June, 2006
|
|
|
|
|
I guess that the ASP.NET is running on the 1.x version. In the version 1.x, the ASP.NET treats non-Microsoft browsers like FF as down-level browsers and IE as up-level browser. And depending on which client browser is being used, the ASP.NET control renders differently with the specified writer object (either HtmlTextWriter or Html32TextWriter). In the version 2.0, the ASP.NET treats non-Microsoft browsers as IE, so this thing won't happen. For more information, you can see Adaptive Rendering[^]
|
|
|
|
|
Thanks for the reply. I'll be sure to read the linky when I have a little spare time
---------------------------
127.0.0.1 - Sweet 127.0.0.1
|
|
|
|
|
If you are using .Net 1.1, you can read about BrowserCap[^] configuration that will let your ASP.Net render the same HTML in different browsers.
"Democracy is two wolves and a sheep voting on what to have for dinner" - Ross
Edbert
Sydney, Australia
|
|
|
|
|
I have used transactions in my application.so while i am operating or debugging a form and if i abort debugging or close browser before the transaction could commit or rollback,the application hangs up on other pcs i.e it hangs up if there is a database operation involved . there is a common server through which we access our application using VSS.the application is still in development phase.please suggest me a solution to get rid of this performance issue.
simply , i just want a solution which would allow simultaneous transactions with database and avoid the hang-up.the database is SQL SERVER 2000
Amit More(TATA CMC)
-- modified at 5:44 Wednesday 28th June, 2006
|
|
|
|
|
I have windows application in which i use Datagrid to populate values .datas in each cell inturn contains more information . so i like to display data in each cell as tree structure which on collapsing displays the related information.
Suggest a way to acheive this ......
Thanking you
Mani
Mani
|
|
|
|
|
I'd like to put images in gridview but i am constructing my gridview using DataTable and i do not know how to do this. I tried ResolveURL but it only writes the path of the file to the grid. Please help me...
|
|
|
|
|
Use templatefield like follows:
<asp:TemplateField><br />
<ItemTemplate><br />
<img src='<%# Eval("imagepath") %>' alt=''> <br />
</ItemTemplate><br />
</asp:TemplateField>
Regards
R.Arockiapathinathan
|
|
|
|
|
Hallo,
I have DataGrid (with hyperlinkcolumn) on "parent" page, and when click on the data in it want to open "child" page with data in another DataGrid, but just for the data I clicked before.
I have (in the "parent" DataGrid):
<asp:HyperLinkColumn DataNavigateUrlField="Ime" DataNavigateUrlFormatString="prikaz_komentar.aspx?Ime={0}"
DataTextField="Ime" HeaderText="Ime"></asp:HyperLinkColumn>
But, it opens me the new page (prikaz_komentar.aspx)with datagrid with all datas, not just for the one I clicked (choosen Ime).
Thank You
Katarina
-- modified at 7:01 Wednesday 28th June, 2006
|
|
|
|
|
HI Katarina,
Not clear with the thing u want.
Please mention the code and the problem.(elaborate)
Thanks,
Sushant Duggal.
|
|
|
|
|
HI Katarina,
Dear I am still not clear with your code. But If u want to send some data from datagrid to other page, you can do it like this.
You have used hyperlinkColumn, but I always prefer template column as it is much more flexible.
<asp:TemplateColumn>
<ItemTemplate>
<a href="pageWhereUWantToGo.aspx?valueThatYouWantTOPass=<%#DataBinder.Eval(Container.DataItem,"Value")%>">Text</a>
</ItemTemplate>
</asp:TemplateColumn>
In the other page you can get the value from Request.QueryString["valueThatYouWantTOPass"]
I hope it helps u
Thanks
Sushant Duggal.
-- modified at 8:20 Wednesday 28th June, 2006
|
|
|
|
|
Hi again,
I have a page with datagrid like this
Ime Prezime Grad Adresa
Gruja Kostadinovic Beograd Bul. Umetnosti 11
Borko Milojevic Beograd Nemanjina 6
Goca Stankovic Nis Vozdova 4
„Ime“ is hyperlinkcolumn, because I want ot click on, for example, „Borko“, and then open another page with datagrid with data for Borko from same table in database.
Other page has to be like this:
Ime Godine Skola
Borko 29 VSS
Found somewhere that this is the code in first page:
<asp:HyperLinkColumn DataNavigateUrlField="Ime" DataNavigateUrlFormatString="prikaz_komentar.aspx?Ime={0}"
DataTextField="Ime" HeaderText="Ime"></asp:HyperLinkColumn>
But, it doesn’t give me the data for „Borko“ in datagrid another page, but for all (Gruja, Borko, Goca). What I have to do, to get data only for one „Ime“ ("Borko")I clicked on the previous page?
Thanks for your trouble
KatarinaYU
-- modified at 5:11 Thursday 29th June, 2006
|
|
|
|
|
Hi Katrina,
If you have to display the contents of only one row in the next page , then y r u using dataGrid on the second page?
Show me the code of the second page also.
I think the trouble is in the second page.
Thanks,
Sushant Duggal.
|
|
|
|
|
Hi Sushant,
yes, I am using datagrid (dgLista2)on the second page. Here is the code:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
If Not Page.IsPostBack Then
Prikazi()
End If
End Sub
Sub Prikazi()
Dim ds As New DataSet
Dim veza As New DBKonekcija
Dim adpLista As New OleDbDataAdapter
adpLista = New OleDbDataAdapter("Select Ime, Komentar from TDatum", veza.Konekcija)
Try
adpLista.Fill(ds, "Lista")
If ds.Tables("Lista").Rows.Count Then
dgLista2.DataSource = ds.Tables("Lista")
dgLista2.DataBind()
End If
Catch ex As Exception
End Try
veza.Konekcija.Close()
End Sub
Here is what I want: when click on the choosen Ime (first page), get data Ime and Komentar in datagrid second page (from table TDatum in database), but just for Ime I clicked on the first page.
Thank you very much
KatarinaYU
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
