How to Pass Values From Previous Page

bex · January 12th, 2009, 07:21 AM

hi there i have this code

Code:

ProtectedSub button_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles button.Click
IfNot Page.PreviousPage IsNothingThen
Dim txtName As TextBox
txtName = CType(PreviousPage.FindControl("txtName"), TextBox)
EndIf
 
Dim conn AsNew SqlConnection(ConfigurationManager.ConnectionStrings("test").ConnectionString)
Dim sql As SqlCommand
sql += "INSERT INTO " & txtName.text & "(test) VALUES(' " & Me.ListBox1.SelectedItem & "');"
Dim Cmd AsNew SqlCommand(sql, conn)
Cmd.CommandType = CommandType.Text
Cmd.ExecuteNonQuery()
conn.Close()
 
 
Cmd.Parameters.Add("@Test", Data.SqlDbType.VarChar, 50).Value = Me.ListBox1.SelectedItem
 
conn.Open()
Cmd.ExecuteNonQuery()
 
conn.Close()

but it does not work ,
txtName is not declared ?

gbianchi · January 12th, 2009, 07:48 AM

Hello.. You are trying to get txtname from previous page?? Well, you are looking for it in current page. Also in the first if clause, you are just looking if the previous page is not nothing, and you should be looking if it is nothing.

and I think you want to add txtcampaignname to the SQL.

bex · January 12th, 2009, 08:43 AM

It is not that simple as it looks? in the previous page i have declared something like this
[code]
ProtectedSub btnCreateCampaign_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles btnCreateCampaign.Click
Dim s AsString
Dim l AsString
s = txtName.Text
l = s
While InStr(l, " ")
l = Replace(l, " ", "")
EndWhile
Dim conn AsNew SqlConnection(ConfigurationManager.ConnectionStrin gs("test").ConnectionString)
conn.Open()
Dim SQL AsString = "CREATE TABLE " & l & " (Name Nvarchar (50));"
SQL += "INSERT INTO " & l & "(Name) VALUES(' " & s & "');"
Dim Cmd AsNew SqlCommand(SQL, conn)
Cmd.CommandType = CommandType.Text
Cmd.ExecuteNonQuery()
conn.Close()
[/ccode]

u see the tabel is created dinamicly and i want to insert into the
ListBox1.SelectedValue into the table that is just created.

and when i click the btnCreateCampaign i get

Code:

Cannot insert the value NULL into column 'Name', table 'test.dbo.test1'; column does not allow nulls. INSERT fails.
The statement has been terminated.

bex · January 13th, 2009, 07:24 AM

I did manage to pass the values from previous page but now i have to insert some values into the table i use this

Code:

 
ProtectedSub AssignCT_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles AssignCT.Click
Dim s AsString
Dim l AsString
s = lblCampaignName.Text
l = s
While InStr(l, " ")
l = Replace(l, " ", "")
 
EndWhile
Dim conn AsNew SqlConnection(ConfigurationManager.ConnectionStrings("test").ConnectionString)
conn.Open()
Dim SQL AsString = "CREATE TABLE " & l & " (Name Nvarchar(50),Email Nvarchar(256),ContactBy Nvarchar(50),PictureTitle Nvarchar (50),Template Nvarchar (50),CampaignName Nvarchar (50));"
SQL += "INSERT INTO " & l & "(Template) VALUES(" & s & ");"
Dim Cmd AsNew SqlCommand(SQL, conn)
Cmd.CommandType = CommandType.Text
Cmd.ExecuteNonQuery()
conn.Close()

and i get this error
The name "test" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.
lblCampaign.Text is : test test