Need ID going into Database

  • Thread starter Thread starter JJ297
  • Start date Start date
J

JJ297

Could someone assist me. I have the selected value from a tree view
going to another page with this code:

Response.Redirect("RequestForm.aspx?TitleID=" &
TreeView1.SelectedValue)

On the RequestForm.aspx page load section I have this:

TitleTxt.Text = Request.QueryString("TitleID")


I have this for my button click:
..CommandText = "AddLoanRequest" '

..Parameters.AddWithValue("@RequestorEmail", EmailAdd.Text)

..Parameters.AddWithValue("@TitleID", TitleTxt.Text)

How do I get just the title ID to go into the database. Right now
it's going in as the title ("name") but I only want the Title ID

Here's AddLoanRequest Stored Procedure

@RequestorEmail varchar (75),
@TitleID varchar(255),

AS


INSERT INTO Requestors(RequestorEmail,TitleID)

values

(@RequestorEmail,
@TitleID)


Thanks for your help
 
Could someone assist me. I have the selected value from a tree view
going to another page with this code:

Response.Redirect("RequestForm.aspx?TitleID=" &
TreeView1.SelectedValue)

On the RequestForm.aspx page load section I have this:

TitleTxt.Text = Request.QueryString("TitleID")

I have this for my button click:
.CommandText = "AddLoanRequest" '

.Parameters.AddWithValue("@RequestorEmail", EmailAdd.Text)

.Parameters.AddWithValue("@TitleID", TitleTxt.Text)

How do I get just the title ID to go into the database. Right now
it's going in as the title ("name") but I only want the Title ID

Here's AddLoanRequest Stored Procedure

@RequestorEmail varchar (75),
@TitleID varchar(255),

AS

INSERT INTO Requestors(RequestorEmail,TitleID)

values

(@RequestorEmail,
@TitleID)

Thanks for your help
Click to expand...

If understand you correct, you would need to tell to the TreeView the
id for each node in the tree.

I think you have right now something like this

TreeNode newNode = new TreeNode(Name);
TreeView1.Nodes.Add(newNode);

Add an ID as a second parameter

TreeNode newNode = new TreeNode(Name, Id);
 
If understand you correct, you would need to tell to the TreeView the
id for each node in the tree.

I think you have right now something like this

TreeNode newNode = new TreeNode(Name);
TreeView1.Nodes.Add(newNode);

Add an ID as a second parameter

TreeNode newNode = new TreeNode(Name, Id);- Hide quoted text -

- Show quoted text -
Click to expand...

Actually I got it I needed to add the value of the tree node to the
tree node. Thanks for your help!
 
Back
Top