Issues with getting selecteditem.text from a web form

I am attempting to make a list box where users can be added to the database.  I have created two list boxes and I have managed to transfer the values across.  However I am having difficulty in getting the selected index value of the item, which has been selected.  I need the selected item to add the user ID of the selected user into the database.  Any help would be great.

The first part binds the data to the lstproducts listbox
the second parts writes data to the database

Sub list()
Dim Conn As OracleConnection
Dim cmdselect As OracleCommand
Dim dtrusers As OracleDataReader
Conn = New OracleConnection("server=cwe.**;user=**; password=**;")
Conn.Open()
cmdselect = New OracleCommand("Select * from PTUSERS", Conn)
dtrusers = cmdselect.ExecuteReader
lstproducts.DataSource = dtrusers
lstproducts.DataTextField = "Name"
lstproducts.DataValueField = "Object_Id"
lstproducts.DataBind()
dtrusers.Close()
Conn.Close()
End Sub
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Dim OracleConn As OracleConnection
Dim cmdupdate As OracleCommand
Dim SQLQuery As String
Dim SQLQuery2 As String
Dim strid As String
Dim str As String
strid = Request.QueryString("id")
str = lstproducts.SelectedValue.Text
OracleConn = New OracleConnection("server=***;user=**; password=**;")
SQLQuery = "INSERT INTO REPORT_USER_ACCESS(RUA_ID,REP_ID,Object_ID)"
SQLQuery2 = SQLQuery & "VALUES ('" & rowid & "','" & strid & "','" & str & "')"
cmdupdate = New OracleCommand(SQLQuery2, OracleConn)
OracleConn.Open()
cmdupdate.ExecuteNonQuery()
OracleConn.Close()
0
Stig
9/5/2003 10:44:37 AM
asp.net.web-forms 93655 articles. 6 followers. Follow

1 Replies
705 Views

Similar Articles

[PageSpeed] 30

Does not matter as I have fixed it
0
Stig
9/5/2003 12:48:53 PM
Reply:

Similar Artilces:

How to Make Web Forms from other Web Forms
In putting together an ASP.NET application for a biz application, we have come to the point where there are three different types of basic forms which have, for the most part, been perfected. Now its is a matter of cloning those forms for various uses and modifying or adding code to suit the particular need. Copy and paste works OK, but there is a lot of changing of certain words, etc. Is there a way in ASP.NET to take these basic forms, turn them into classes or templates, create forms from them, then add or overwrite code? ? (Anybody who is a Vis Fox Pro programmer would know imme...

Web forms and mobile web forms
Hey everyone, I am looking to develope a web site that depending on the device connecting to it, it will display a certain page. In this case im looking to create a web and wap version of the same project. I have the Web forms version finished using ASP.NET and C# and I am wondering how to create the mobile web form and incorporate it in the project. In the project folder, can I just add a mobile web??? But what about displaying device specific pages?? Cheers -Dudach Yes, you can add mobile web forms and controls to your Web Application project. No problem. For device/br...

For interrupting.web form Resized by position of the div : if div can't dispaly all (such as only top part , then web form heithten the heght),resize the web form
Web Form Resized by position of the div : if div can't dispaly all (such as only top part , then web form heithten the heght),resize the web form ! Because of my pool English, if you can't see , I will explain more ! ThanksGambler is the real life I guess you mean when form grows it also grow parent div element. This is normal. If you want div to stay fixed size and rather clip the form and maybe show a scrollbar, look at overflow property in CSS.Thanks------------------------------------------------------------This posting is provided "AS IS" with no warranties, and confers no ...

Web Form embedded in another Web Form
Hi,  I have programmed a Web Form which acts like a scientific calculator. I would like to embedd this calculator in the upper left hand corner of another accounting Web Form. I don't want to host the calculator on the same server as the accounting page. I.e. I want them to have distinct URLs. Classically, I would do this using frames, but is there a better way using ASP? Is there some sort of Panel which can display the webpage at a specific URL which I can just drag onto my accounting Web Form? Thanks,  P1000   Frames are the only way to embed a webform inside ano...

calling a web form from another web form
I would like to know what is the best way to open a web form from another web form. I would like to call it from a button control. Thanks Well, if I've grasped your question right, there are many methods to do that: 1)Response.Redirect > To navigate to another page from code and is equal to clicking a hyperlink. I suggest this as I think it's closer to your question. 2)Server.Transfer > This ends the current web form and begins a new web form. It's usable when you want to pass some variables i.e (Label1.Text) to the next immediate page. It's not safe though and not used to send p...

How to fire events in other web form from other web form ?
Suppose that I have A and B web form. I want to trigger B web form's Page_Load event from A web form. How can I do that ? Thanks in advanced WilbertWilbert Bujn Create a public method in B that call the load method : public void Load(object sender, System.EventArgs e) { Page_Load(sender, e) ; } In the page_load of A, instanciate a B object and then call the function B myB = new B() ; myB.Load() ; Quicky Thank you quicky, it works fine. WilbertWilbert Bujn...

Include web form inside web form
I tried to include an aspx file in a asp.net web form. However, all the web controls (textbox, button) in the included page are not displayed when called. <Form id="Form1" method="post" runat="server"> <%   Response.writeFile("subPage.aspx"); %> <asp:button id="btnPrev" runat="server" text="Previous"></asp:button> </Form> There are some <asp:textbox> controls in the subPage.aspx file, the file itself works fine, but when it is included in the main page, all the controls are not displayed. Please assist. Thanks   u should u...

Web Form vs. Web Content Form
If you don't mind, I would like to know what is the difference between those two items, when I go to add a new item I see both of those and I don't know what the difference is.  A content form is for use with a masterpage. A web form is a standalone web page. If you select web content form, you will then have to specify a masterpage for it. and what is a master page used for?  Hi, a master page is used to give a constant look and theme to a site, without having to duplicate code. So basically you can put your header, menu, nav and footer on a master page. Then a...

Load Text box of one web form with selected list item of list box of another web form
one help please Problem is i have two web forms  1.  ForiegnkeyTest.aspx  2. foroginkeytable.aspx   step 1 1 ForiegnkeyTest.aspx one web form <head runat="server"><script language="javascript" type="text/javascript">   function popWin()   {         var confirmWin = null;      confirmWin = window.open('foroginkeytable.aspx','anycontent',   'width=455,height=435,status');   }  </script> &...

VB .net Web Form will not get contents of Text Box
I have created a web form with text boxes that are bound to a DataSet/DataView.  I have created button to navigate up and down the recordset.  That all works fine. I need to have the ability to edit/add text in any of the boxes and then when clicking "Save" button, it would build an UPDATE query to send to the database. When the Save button is clicked, I have coded to DIM a string var (strSQL) to use to build the SQL command.  For some reason, it will only get the text from a text box if the data was pulled the database.  If I add/edit data, then the SQL command will ha...

Implementing .Net Form into an APS.net web form, can this be done
I am new here, but have been searching for a while, and may not have the correct lingo to find what I am looking for.  I am tasked with implementing a .exe application that was writen vb6 then converted to .net into a new website my team is developing. The idea is to put each of the 3 different forms in this .exe application of 3 different .aspx pages. I have attempted multiple things to get this into the page and even started to just rewrite it as an ASP.net web form, but even then I can't reuse any of the code since the System.Web.UI.Page doesn't inherit the sa...

Accessing two web forms in a single web form
  Hi. I am developing a website in VS 2005 with Ajax & SQL Server. I am having 5 forms in my application. 1) Login Form 2) Main form 3) Form "A" 4) Form "B" I need to show the main form after the User login. I need to show all the contents of form A or form B (Ex: Form "A" user or form "B" user) in the Main Page. Can I show a single page having Main Form controls as well as Form "A" and Form "B" controls? I should access all the controls including Form A/B in the Main Page. Thanks ...

How to access a control on a web form from anoter web form
hi all I have this scenarios i have two web forms, one called form1 and the other called form2 form1 has a label with id "lbl1" is it possible to access lbl1 from form2, change its text permenantly? thanks.   refer: http://dotnetslackers.com/Community/blogs/haissam/archive/2007/11/26/ways-to-pass-data-between-webforms.aspxSSNPlease remember to click "Mark as Answer" on the post that helps you. MinaSamy: hi all I have this scenarios i have two web forms, one called form1 and the other called form2 form1 has a label with id "lbl1" is it p...

Strange output in web form after web form is displayed.
   I have been using a web user control for over a week now with no problems. I am now getting strange output in my web form after my controls display on the page. Below is the strange output. Can anyone tell me what is wrong here? Note I did not include it all because it is quite large.   Request Details Session Id: l5b5vkazucfatba4oliaw1vi Request Type: POST Time of Request: 9/10/2007 4:59:59 PM Status Code: 200 Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8) Trace Information Category Message From First(s) F...

Web resources about - Issues with getting selecteditem.text from a web form - asp.net.web-forms

GridView SelectedItem Binding Gotcha in WinRT
... this template will create a bunch to boiler plate code for you and I was taking this code and extending it. When I was setting up my SelectedItem ...

User Anna Lear - Stack Overflow
current community chat blog Stack Overflow Meta Stack Overflow Stack Overflow Careers your communities Sign up or log in to customize your list. ...

Index - 2,000 Things You Should Know About WPF
Below is a list of all posts created so far for the 2,000 Things You Should Know About WPF blog. Total number of posts = 1,077 Animation #7 - ...

Authorities eye retirement accounts as possible tax dodges - World News
{atrb}”,”template_name”:”sm_thmb_play_ttle_atrb”,”i18n”:{“end_of_gallery_header”:”End of Gallery”,”end_of_gallery_next”:”View Again”},”metad ...

Giftly
A Giftly is not a gift card, it's better. Give a Giftly for any item or experience, at any business. Giftly is the fastest and easiest way to ...

ChuckHays.net
A user on the expression forums asked a question about how they could activate a specific tab item on a screen being navigated to. Below is a ...

Cheap Event Tickets – bringing u the cheapest event ticket deals daily!
‘},”otherParams”:{“t_e”:1,”.intl”:”US”},”events”:{“fetch”:{lv:2,”sp”:”2146252129″,”ps”:”LREC,N,NT1,RICH”,”npv”:true,”bg”:”#FFFFFF”,”em”:esca ...

Silverlight Toolkit - Download: Silverlight for Windows Phone Toolkit - Feb 2011
... various null check improvements. Refactoring of much of the code, improvements to item recycling, conforming with ListBox with respect to SelectedItem ...

MetroStore
MetroStore

Welcome to Surface
Welcome to Surface 2.0

Resources last updated: 12/5/2015 10:16:44 AM