ASP.NET with VB in Connecting Database - ASP.NET Discussion Boards

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.... Cry | :((

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

Tree View[^]

Regards,

Satips.

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 | :((

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!

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.

printf("Navaneeth!!")

www.w3hearts.com

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.