ASP.NET

4-Jul-06 22:48

I want to display recrod from access that detail information about user to TextBox, please help me
Thanks

................

mnaveed4-Jul-06 23:00

4-Jul-06 23:00

can you please explain lit bit more wot you want exactly....
if u explain properly then more chances that you will get your answer...

Thanks

Nav.

Socheat.Net4-Jul-06 23:11

4-Jul-06 23:11

I mention that, in my web site i have many users, If they signin I want to show them about their datail that they can edit it in TextBox

................

mnaveed5-Jul-06 0:00

5-Jul-06 0:00

its prety basic stuff can you pls pin point where you getting problem for this
here is code sample which tell you how to connect to db file and get data

OleDbConnection con;<br />
        OleDbDataAdapter da ;<br />
        DataSet ds = new DataSet();<br />
        string sSQL;<br />
        sSQL = "select * from Products";<br />
<br />
<br />
        string sConStr = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\Northwind.mdb; User Id=admin; Password=";<br />
<br />
        con = new OleDbConnection(sConStr);<br />
        da = new OleDbDataAdapter(sSQL,con);<br />
<br />
        da.Fill(ds, "Products");<br />
<br />
        return ds;

Nav.

Socheat.Net5-Jul-06 21:21

5-Jul-06 21:21

Yes i get it, but I want to retrive to it to TextBox that user can change their information.
Socheat

................

Tirthadip5-Jul-06 0:05

Tirthadip

5-Jul-06 0:05

hi,
keep the user id in the session variable.go to another page(where you want to show the detail information).extract the user id from session.run a query against the user id and display the details on that page.

hope you got it.

tirthadip

Live life to the fullest

Socheat.Net5-Jul-06 21:22

How to include ASP file in .aspx page

5-Jul-06 21:22

Can you give me full example?

Socheat

................

ypsyong4-Jul-06 22:25

ypsyong

4-Jul-06 22:25

I'm using the vb script to write the page. May I know how to include the ASP file into my .aspx page? Did anyone try this before? Can you giv me a guide or sample code to continue my development process? I will appreciate upon your help. Thanks.. Smile | :)

Socheat.Net4-Jul-06 22:49

4-Jul-06 22:49

For ASP

For ASP.NET may not

Hope can help you

................

ypsyong4-Jul-06 23:12

ypsyong

4-Jul-06 23:12

Socheat.Net wrote:
For ASP

For ASP.NET may not

Thanks..

but is there any way to include the .asp page in ASP.net?

Best Regards,
Pei Sun

Socheat.Net4-Jul-06 23:37

4-Jul-06 23:37

I have tried but get nothing, I hope i can get in future.

Socheat

................

Enter key Press Event on textbox

Guffa5-Jul-06 1:03

Guffa

5-Jul-06 1:03

You can't mix ASP and ASP.NET in the same page.

If you register the file type to be handled by both engines, you might be able to make one engine output code that will be executed by the next. I don't know if this is even possible, and if it is, it's hardly advisable.

If you want to show the content of an ASP page as part of an ASPX page, you can place an iframe on the ASPX page and show the ASP page in it.

Also, you could make the ASPX page request the ASP page from the server, and incorporate the response as part of the page.

---
b { font-weight: normal; }

nabeelkhan4-Jul-06 21:42

4-Jul-06 21:42

HI
i hv textbox ,and in this textbox the student enter the rollno,after entering the rollno the student press the enter key,,whn the student press the enter key i wnt to capture the Enter Event on the textbox and getvalues from the textbox,how can i capture the enter event ..,and after getting the value from the text box i fill the droopdwnlist on the behave of rollno.
tell me how can i get the enterkey Press ,and on this Enter key i wnt to take the value from the textbox

mnaveed4-Jul-06 22:55

Re: Enter key Press Event on textbox [modified]

4-Jul-06 22:55

you can use script to call the onkeypress function and from there call any event in your code to fill your list like this

in page load event write this line
TextBox.Attributes.Add("onkeydown", "FillList()");
write this script in aspx page

function FillList()<br />
    {<br />
      if(event.keyCode == 13)<br />
      {<br />
       document.getElementById("Buttion2").click();<br />
      }<br />
    }

you must have a Button2 click event in your code file to fill list.
Hope this will help

hope this will help you Smile | :)

Nav.

nabeelkhan4-Jul-06 23:57

4-Jul-06 23:57

i have no button in my from,i have a dropdownlist that i wnt to fill whn a uere press the enter key in the textbox,i want to load the dropdownlist when user press the Enter key in the textbox..would i write the
document.getElementById("Dropdownlist").click();
or tell me abt click event ,how can i write this event in the ,i mean to say can i write this event in code,how?
i shall be thkfull

-- modified at 6:02 Wednesday 5th July, 2006

mnaveed5-Jul-06 0:31

5-Jul-06 0:31

you can add a button to your page and make it invisible and handle list fill on button click event.

Nav.

nabeelkhan5-Jul-06 0:44

5-Jul-06 0:44

this i call in the page load event
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here

'Fill Drop Down List with Years
'conConnection.Open()
If Not Page.IsPostBack Then
txtrollno.Attributes.Add("onkeydown", "fill_list();")
bt_hidden.Visible = False
End If
End Sub

this is my javascript
function fill_list()
{
if(event.keycode==13)
{
document.getElementById("bt_hidden").click;
}
}

this is my hidden button that id is btn_hidden
"""<asp:button id="bt_hidden" runat="server" ""onclick="loads" visible="False" ""height="19px" width="56px" text="Button">"""

this is my load fuction that i call onClick bt_hidden event
Sub loads(ByVal sender As System.Object, ByVal e As System.EventArgs)
Session.Add("Rollno", Trim(txtrollno.Text))
Try
Dim ds As DataSet
Dim ad As New OleDbDataAdapter
Dim conn_string As String = ConfigurationSettings.AppSettings.Item("DBSettings")
conConnection = New OleDbConnection(conn_string)
conConnection.Open()
Dim dr As OleDbDataReader
Dim cmd As New OleDbCommand
cmd.Connection = conConnection
cmd.CommandText = "SELECT DISTINCT Setup_Session.Description " & _
"FROM Course_Result LEFT OUTER JOIN " & _
"Setup_Session ON Course_Result.Session_id = Setup_Session.Session_ID " & _
"WHERE (Course_Result.Rollno = 'b-00250')"
'"WHERE (Course_Result.Rollno = '" & Session.Item("Rollno") & "')"
'ds = New DataSet
cmd.CommandType = CommandType.Text
dr = cmd.ExecuteReader
While dr.Read
ddlSession.Items.Add(dr.Item("Description"))
End While
conConnection.Close()
Catch ex As Exception
lblMsg.Text = "Db Server is Down"
lblMsg.Visible = True
End Try
End Sub
bt my dropdownlist is nt filled
tell me either i can fill the dropdoenlist in this clickevent
'Private Sub bt_hidden_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles bt_hidden.Click

tell me where i got wrong ..plz

mnaveed5-Jul-06 1:03

5-Jul-06 1:03

can you pls try by setting visible property to true and button width to zero
and write a test function which add on or two items in list like this

FillList()<br />
{<br />
 ddlSession.Items.Add("A");<br />
 ddlSession.Items.Add("B");<br />
}

and call this function from button click to check that flow is working.
if its working then you need to check your load function.

Nav.

nabeelkhan5-Jul-06 1:32

5-Jul-06 1:32

the problem is exist in the javascript,javascript function not call the click event of the button server control.......tell how can i call the click event of the server control
thks

mnaveed5-Jul-06 2:08