|
Hi
I am using ASP.NET and VB as code behind. My database is Sybase. and sql. Now my problem is i want to use a select query where one fields name is date(this is keyword in Sybase).
when i used sql i hve given this like
"Select * from mytab where [date]='04/30/2007'"
but this doesnt work for sybase . Can anybody pls help me how to use the keywords in query's
Thanks in advance
with regards
Anitha
|
|
|
|
|
What is the field type you given in sybase ?
|
|
|
|
|
See i want to retrieve data from mytab according to the date.
Like "Select * FROM mytab WHERE date='01/30/2005'"
see while using sql i hve given the keywords in brackets like,[date],[user] etc. But i want to know how this is to be done if i use Sybase database.Please
help me
With Regards
Micydon
|
|
|
|
|
Dear all!
(In advance. Sorry for my bad English).
I’m facing a problem with my ASP application when attempting to browse it in IE6(it works fine in Firefox, IE7 and Opera). After exactly 45 sec it starts to hang, and it hangs for 15 sec. This is going on and on. I have timed it with a stopwatch, and it works fine in exactly 45 sec and then it hangs exactly 15 sec. The rare part is that it starts hanging after 45 sec even though I’m active using the web application or just wait for 45 sec. I have tried it browse the web application from another computer, but the problem still appears. I also tried to install the web solution on another IIS with no improvements.
I hope someone can help me understand this problem!
Regards
Jan Erik Aarethun,
Software Developer
|
|
|
|
|
Is this happening for a single page all for whole website ?
|
|
|
|
|
I will try to explain how the web application works. It includes a Master page with a tree-view control located left, and a contentPlaceHolder in the right position. The first asp page in the contentPlaceHolder holds a gridview control. The gridview control has links on each row that leads to an asp page that holds an asp menu like this:
<table>
<tr>
<td>
<asp:Menu
id="Menu1"
Orientation="Horizontal"
StaticMenuItemStyle-CssClass="tab"
StaticSelectedStyle-CssClass="selectedTab"
CssClass="tabs"
OnMenuItemClick="Menu1_MenuItemClick"
Runat="server">
<Items>
<asp:MenuItem Text="Generelt" Value="0"/>
<asp:MenuItem Text="Pris" Value="1" />
<asp:MenuItem Text="Biler" Value="2" />
<asp:MenuItem Text="Avtale" Value="3" />
<asp:MenuItem Text="Utbetal oppdrag" Value="4" />
<asp:MenuItem Text="Rapporter" Value="5" />
</Items>
<StaticMenuItemStyle CssClass="tab" />
<StaticSelectedStyle CssClass="selectedTab" />
</asp:Menu>
<div class="tabContents">
<asp:MultiView
id="MultiView1"
ActiveViewIndex="0"
Runat="server">
<asp:View ID="ViewDetails" runat="server">
<table cellpadding="0" cellspacing="0" border="1">
<tr id="rowDetails" style="display:none;">
<td id="rowCellDetails" >
</td>
</tr>
</table>
</asp:View>
<asp:View ID="ViewPrice" runat="server">
<table cellpadding="0" cellspacing="0" border="1" >
<tr id="rowPrice" style="display:none;">
<td id="rowCellPrice" >
</td>
</tr>
</table>
</asp:View>
<asp:View ID="ViewCars" runat="server">
<table cellpadding="0" cellspacing="0" border="1">
<tr id="rowCars" style="display:none;">
<td id="rowCellCars" >
</td>
</tr>
</table>
</asp:View>
<asp:View ID="ViewAgreement" runat="server">
<table cellpadding="0" cellspacing="0" border="1">
<tr id="rowAgreement" style="display:none;">
<td id="rowCellAgreement" >
</td>
</tr>
</table>
</asp:View>
<asp:View ID="ViewAssignment" runat="server">
<table cellpadding="0" cellspacing="0" border="1">
<tr id="rowAssignment" style="display:none;">
<td id="rowCellAssignment" >
</td>
</tr>
</table>
</asp:View>
<asp:View ID="ViewReports" runat="server">
<table cellpadding="0" cellspacing="0" border="1">
<tr id="rowReports" style="display:none; width:500">
<td id="rowCellReports">
</td>
</tr>
</table>
</asp:View>
</asp:MultiView>
</div>
</td>
</tr>
</table>
The codebehind activate what view to point out. Like this:
protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
int index = Int32.Parse(e.Item.Value);
MultiView1.ActiveViewIndex = index;
if (index == 0)
{
String Url = String.Format("stationdetails.aspx?id={0}", id);
ClientScript.RegisterStartupScript(GetType(), "", "<script language=JavaScript> " +
" document.getElementById('rowDetails').style.display=''; " +
" document.getElementById('rowCellDetails').innerHTML='<iframe src=\"" + Url + "\" height=460 width=700 frameborder=0 style=\"border:1px #d4d0c8 solid;\"></iframe>'" +
"</script> ");
}
if (index == 1)
{
String Url = String.Format("editPrice.aspx?id={0}", id);
ClientScript.RegisterStartupScript(GetType(), "", "<script language=JavaScript> " +
" document.getElementById('rowPrice').style.display=''; " +
" document.getElementById('rowCellPrice').innerHTML='<iframe src=\"" + Url + "\" height=460 width=700 frameborder=0 style=\"border:1px #d4d0c8 solid;\"></iframe>'" +
"</script> ");
}
if (index == 2)
{
String Url = String.Format("cars.aspx?id={0}", id);
ClientScript.RegisterStartupScript(GetType(), "", "<script language=JavaScript> " +
" document.getElementById('rowCars').style.display=''; " +
" document.getElementById('rowCellCars').innerHTML='<iframe src=\"" + Url + "\" height=460 width=700 frameborder=0 style=\"border:1px #d4d0c8 solid;\"></iframe>'" +
"</script> ");
}
if (index == 3)
{
String Url = String.Format("agreement.aspx?id={0}", id);
ClientScript.RegisterStartupScript(GetType(), "", "<script language=JavaScript> " +
" document.getElementById('rowAgreement').style.display=''; " +
" document.getElementById('rowCellAgreement').innerHTML='<iframe src=\"" + Url + "\" height=460 width=700 frameborder=0 \"border:1px #d4d0c8 solid;\"></iframe>'" +
"</script> ");
}
if (index == 4)
{
String Url = String.Format("assignment.aspx");
ClientScript.RegisterStartupScript(GetType(), "", "<script language=JavaScript> " +
" document.getElementById('rowAssignment').style.display=''; " +
" document.getElementById('rowCellAssignment').innerHTML='<iframe src=\"" + Url + "\" height=460 width=700 frameborder=0 style=\"border:1px #d4d0c8 solid;\"></iframe>'" +
"</script> ");
}
if (index == 5)
{
String Url = String.Format("chooseReport.aspx");
ClientScript.RegisterStartupScript(GetType(), "", "<script language=JavaScript> " +
" document.getElementById('rowReports').style.display=''; " +
" document.getElementById('rowCellReports').innerHTML='<iframe src=\"" + Url + "\" height=460 width=700 frameborder=0 style=\"border:1px #d4d0c8 solid;\"></iframe>'" +
"</script> ");
}}
|
|
|
|
|
I've just upgraded our WIndows 2003 (with SBS server) web server to .Net framework 2.0
(it had 1.1 before)
As I have been working on a web parts page on my laptop, hosting it there, working perfectly. I want to transfer it now, so I upgraded it. Created a new application pool for .net2.0 stuff, then used Visual Studio 2005 from my laptop to connect to Http://blahblah/ProjectPoint and make a new website. assume http://blahblah/ is our intranet at the moment.
It created it, I dragged the files across into it, then went to that address in the browswer and I get
Quote:
Server Error in '/ProjectPoint' Application.
--------------------------------------------------------------------------------
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist.
If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database.
Sql Server Express must be installed on the machine.
The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
I know this has to do with the app_data directory which has a data base that stores all the customizations people make. Its an intranet website, I want people to be able to customize by windows account.
I've checked permissions on the directory and gave full control to all the groups there.
On my laptop, I can go to Visual Studio, click website and go to ASP.net configuration and it comes up with a web based web.config editing, when I open the website I made remotely, I can't see htat option, why is it gone? Is that where I can fix the error ?
Help is appreciated! I've googled but everyone just says to turn off the login, but I need that for web parts.
|
|
|
|
|
i alread submit my problem .but main thing is this
image and data are in same database
and image save binary form so it cannot convert it
so how we bind data??
if any body have a code plz send me?
deepak chandra
|
|
|
|
|
One Post is enough man. BTW why are yoou creating a new Post for the Same topic.
This is not the Good Practice.
Please continue with the the already posted post itself.
Regards,
Satips.
|
|
|
|
|
Hi,
Instead of giving the subject as "Urgent" or "Very Urgent", give clear title so that you will get the response quick and also it wil help others. If you are going to use these words only, you will not get accurate solutions.
Meeram395
|
|
|
|
|
In one day, you have posted four URGENT message titles. Please read the forum guidelines.
__________________
Bob is my homeboy.
|
|
|
|
|
hi actually i m facing problem while i was creating acive x in .net. i hav made one control in classliberary of windows.and than embed it in the web form.first time it will show the right output.bt if i made any updation in window,s control the changes were not reflected in browser.i m getting confuse.plzzzz help me out....
|
|
|
|
|
i want show some information in runtime at treeview. so data show in runtime time.and also show image so what i do??
ex
a
/ \
b c
| |
d f
| |
g h
how we create this thing at runtime
if any code plz send me
deepak chandra
|
|
|
|
|
|
i m opening a modal dialog page and from that modal dialog again opening a simple popup page
now in the simple popup page i m not getting my Session (session gets expired)
please help
urgent
|
|
|
|
|
Dear all,
While I try to compile the follwing code, I found a error message occurred. Can anyone help me to solve the problem??
Thanks!
Error Message:
System.Data.OleDb.OleDbException: UPDATE syntex error
Code As below:
<%@ Import Namespace="System.Data"%>
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Page Language="VB" AutoEventWireup="True"%>
<title>Welcome to School Adaptable Management System
Edit Announcement
<asp:datagrid id="dgEditAnnounce" runat="server" cssclass="Normal" cellpadding="2"
="" gridlines="Horizontal" autogeneratecolumns="False" oneditcommand="EditCmd" oncancelcommand="CancelCmd" onupdatecommand="UpdateCmd">
<columns>
<asp:editcommandcolumn buttontype="LinkButton"
="" updatetext="Save" canceltext="Cancel" edittext="Edit" headertext="Edit">
<asp:boundcolumn datafield="Help_ID" headertext="ID" readonly="True">
<asp:boundcolumn datafield="Help_Type" headertext="Type">
<asp:boundcolumn datafield="Help_Desc" headertext="Content">
<asp:boundcolumn datafield="Help_Reply" headertext="Reply">
<asp:boundcolumn datafield="Help_Date" headertext="Date</br>(YYYY/MM/DD)">
<asp:boundcolumn datafield="Help_Del" headertext="Status</br>(0=Post/ 1=Not Post)">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
If Not Page.IsPostBack Then
Me.BindGrid()
End If
End Sub
Private Sub BindGrid()
Dim tbAnnounce As New DataTable
Dim strConnection As String ="provider=Microsoft.Jet.OLEDB.4.0; data source=C:\Inetpub\wwwroot\SAMS2\quiz.mdb"
Dim objConnection As New OleDbConnection(strConnection)
Dim strSQL As String="Select * From tb_Help'"
Dim dtAnnouce As New OleDbDataAdapter(strSQL, objConnection)
dtAnnouce.Fill(tbAnnounce)
dgEditAnnounce.DataSource=tbAnnounce
dgEditAnnounce.DataBind()
End Sub
Private Sub EditCmd (ByVal sender As System.Object, ByVal e As DataGridCommandEventArgs)
dgEditAnnounce.EditItemIndex = e.Item.ItemIndex
Me.BindGrid()
End Sub
Private Sub UpdateCmd (ByVal sender As System.Object, ByVal e As DataGridCommandEventArgs)
Dim sbSQL As New System.Text.StringBuilder
sbSQL.Append("UPDATE tb_Help SET ")
sbSQL.Append("Help_Type = @Help_Type, ")
sbSQL.Append("Help_Desc = @Help_Desc, ")
sbSQL.Append("Help_Reply= @Help_Reply, ")
sbSQL.Append("Help_Date = @Help_Date, ")
sbSQL.Append("Help_Del = @Help_Del, ")
sbSQL.Append("WHERE Help_ID = @Help_ID")
Dim iHelp_ID As Int32 = Convert.ToInt32(e.Item.Cells(1).Text)
Dim sHelp_Type As String = CType(e.Item.Cells(2).Controls(0), TextBox).Text
Dim sHelp_Desc As String = CType(e.Item.Cells(3).Controls(0), TextBox).Text
Dim sHelp_Reply As String = CType(e.Item.Cells(4).Controls(0), TextBox).Text
Dim sHelp_Date As String = CType(e.Item.Cells(5).Controls(0),TextBox).Text
Dim sHelp_Del As String = CType(e.Item.Cells(6).Controls(0),TextBox).Text
Dim strConnection As String ="provider=Microsoft.Jet.OLEDB.4.0; data source=C:\Inetpub\wwwroot\SAMS2\quiz.mdb"
Dim con As New OleDbConnection(strConnection)
Dim cmd As New OleDbCommand(sbSQL.ToString(), con)
With cmd.Parameters
.Add("@Help_Type", sHelp_Type)
.Add("@Help_Desc", sHelp_Desc)
.Add("@Help_Reply", sHelp_Reply)
.Add("@Help_Date", sHelp_Date)
.Add("@Help_Del", sHelp_Del)
End With
Try
con.Open()
If cmd.ExecuteNonQuery() < 1 Then
Throw New System.Exception("The record was not update")
End If
Finally
If Not con Is Nothing AndAlso con.State = ConnectionState.Open Then
con.Close()
End If
End Try
dgEditAnnounce.EditItemIndex = -1
Me.BindGrid()
End Sub
Private Sub CancelCmd (ByVal sender As System.Object, ByVal e As DataGridCommandEventArgs)
dgEditAnnounce.EditItemIndex = -1
Me.BindGrid()
End Sub
Finally, I hope my message can assist or takle your problem.
God Bless You!
|
|
|
|
|
While you were Posting this Message there you get a warning did you read it.
Why are you posting such a long message? did you notice that?
So what is your actual Problem?
Tell us we are here to solve your problem.
Regards,
Satips.
|
|
|
|
|
Dear Satips
Thank for your reply.
I cannot not update the data while I am writing some data in to dataGrid. After pressing the Save Button, a error message prompt to me.
The Message:
Exception Details: System.Data.OleDb.OleDbException: UPDATE syntex error
I would like to post the code for you, please tell me what shoud I do??
Finally, I hope my message can assist or takle your problem.
God Bless You!
|
|
|
|
|
Hi! To freez header in GridView, i am using following style in style="position:relative;". it works in IE but not other browsers. please help me.
Thanks & Regards,
SAMir Nigam,
Software Engineer,
STPL, Lucknow, India.
|
|
|
|
|
This is the Data i have
Time interval = 30 min
starting Time = 9:30 am
End Time = 9:30 pm
I have to get the Time intervals as follows
9:30 am to 10:00 am
10:00 am to 10:30 am
10:30 am to 11:00 am
.
.
.
.9:00 pm to 9:30 pm
How can v get this in asp.net
thank u
|
|
|
|
|
manikandan_be2005 wrote: Time interval = 30 min
starting Time = 9:30 am
End Time = 9:30 pm
There is no time interval.
If you want to get the time interval for 30 minutes go for javascript
Regards,
Satips.
|
|
|
|
|
Create TimeSpan values for the values, then you can simply do arithmetic with them. Example:
TimeSpan start = new TimeSpane(9, 30, 0);
TimeSpan stop = new TimeSpan(21, 30, 0);
TimeSpan interval = new TimeSpan(0, 30, 0);
for (TimeSpan s = start; s <= stop; s += interval) {
Console.WriteLine(s.ToString());
}
---
single minded; short sighted; long gone;
|
|
|
|
|
i want to show somw image in grid ..so what to do perform these thing
becasue in that grid also show some other information
deepak chandra
|
|
|
|
|
You can add image control in grid by selecting edit temlate on smart link and add image control on it.
Set image's data bindinig on smart link. you can hav it from database or from disk.
pranav23
|
|
|
|
|
i can do this thing but it not show image
deepak chandra
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
