ASP.NET

Modal Dialog and Session Problem

15-May-07 21:18

Tree View[^]

Regards,

Satips.

RaviJJain15-May-07 20:53

RaviJJain

15-May-07 20:53

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

Cry | :((

ASP.NET with VB in Connecting Database

JosephWONG15-May-07 20:50

JosephWONG

15-May-07 20:50

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

Today:
16-04-07

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!

Re: ASP.NET with VB in Connecting Database

Sathesh Sakthivel15-May-07 21:08

Re: ASP.NET with VB in Connecting Database

15-May-07 21:08

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.

JosephWONG15-May-07 21:51

JosephWONG

15-May-07 21:51

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!

Freezing Header of GridView

248912815-May-07 20:48

2489128

15-May-07 20:48

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.

Urgent

jamesmani2k515-May-07 20:47

jamesmani2k5

15-May-07 20:47

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

Re: Urgent

Sathesh Sakthivel15-May-07 21:06

15-May-07 21:06

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.

Re: Urgent

Guffa15-May-07 22:05

Guffa

15-May-07 22:05

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;

very urgent

deepaksringr15-May-07 20:13

15-May-07 20:13

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

Pranav2315-May-07 20:19

Pranav23

15-May-07 20:19

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

deepaksringr15-May-07 20:21

15-May-07 20:21

i can do this thing but it not show image

deepak chandra

248912815-May-07 20:28

2489128

15-May-07 20:28

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.

deepaksringr15-May-07 21:00

15-May-07 21:00

thanks samir

can u send this type of code to me?

thanks and regards

deepak chandra

deepak chandra

N a v a n e e t h15-May-07 21:31

N a v a n e e t h

15-May-07 21:31

You can write a function that returns image path and call then while the grid is binding.

printf("Navaneeth!!")

www.w3hearts.com

urgent

deepaksringr15-May-07 20:10

15-May-07 20:10

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

Sathesh Sakthivel15-May-07 20:12

15-May-07 20:12

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.

deepaksringr15-May-07 20:22

15-May-07 20:22

It,s fine but how we set its location

deepak chandra

248912815-May-07 20:21

2489128

15-May-07 20:21

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.

Sathesh Sakthivel15-May-07 20:23