|
|
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
|
|
|
|
|
dear deepak. first of all add an template column in grid & in item template drag & drop an image control & set its image URL. this will show same image in all row. if you want show different images on different row u want to dynamically create path for different images in your stored procedure.
Thanks & Regards,
SAMir Nigam,
Software Developer,
STPL, Lucknow, India.
|
|
|
|
|
thanks samir
can u send this type of code to me?
thanks and regards
deepak chandra
deepak chandra
|
|
|
|
|
You can write a function that returns image path and call then while the grid is binding.
|
|
|
|
|
plz help
i want to create label at runtime after that i set location .but it not possible in asp.net so what to do
plz reply
deepak chandra
deepak.sringr@gmail.com
deepak chandra
|
|
|
|
|
Try the following code.
<%@ Page Language="VB" Debug="False" %>
Sub Page_Load(Sender As Object, E As EventArgs)
dim count as integer
For count = 1 To 20
Dim lbRolenamenew = New Label()
lbRolenamenew.Visible = true
lbRolenamenew.Text = "My name is - " & count
PlaceHolder1.Controls.Add(lbRolenamenew)
Next
End Sub
Regards,
Satips.
|
|
|
|
|
It,s fine but how we set its location
deepak chandra
|
|
|
|
|
No MAN. it is possible.
put a place holder on aspx page where u want to show label.
add this code in page load event.
Label lblU = new Label();
lblU.Text = "deepak chandra";
PlaceHolder1.Controls.Add(lblU);
check it
Thanks & Regards,
SAMir Nigam,
Software Developer,
STPL, Lucknow, India.
|
|
|
|
|
The same thing i said it before.
Regards,
Satips.
|
|
|
|
|
Hi,
can anyone helpme..
i want to store my ASP session values in ASP.NET Seesion
& i want assign these values in Global.asax file.
What is the BEST way to use ASP Session values in all my ASPX.page using ASp.net
i dont want use my ASP seesion in all pages.
pls suggest me..
give some sample code..
thanks & regards,
bhaskar.t
T&R,
bhaskar
|
|
|
|
|
Bhaskar,
your question is not so depictive.
Gautham
|
|
|
|
|
I have a drop down list in the *.aspx page
On the *.cs page , I have populated the dropdownlist(using droplist.items.add("name");)
I want to display the contents of my list in ascending order ..
Please help
Thanx in advance
|
|
|
|
|
What do you mean by this ? I don't think that it's the best answer
|
|
|
|
|
Hi,
There is no additional sorting property like datagrid...you have to write a code to sort drop down list...suppose you are binding dropdown from database,you can use orderby property..
thanks
kali
|
|
|
|