|
I have a dataView and a FormView that is connected to SQL Server. When someone clik on edit a record in the Dataview or insert new record in the Formview, I want the user to choose one of the choices that is in the dropdown list. So how can I add this dropdown list to the dataview and Formview. Also, the content of the dropdown list is suppose to be taken from a store data (from a table) in the database.
Thanks a lot for your help and I wish someone to help so that I could solve this problem...
|
|
|
|
|
Hi,
I have two listboxes, first listbox is populating the data from the database and then with the help of move button ,i am moving the selscted items from listbox 1 to listbox2 but, I am not able to find any property to he data in listbox2. I want to save them to a table "A_Software" to column "soft". I used the following code. But data it is getting stored is "System.Web.UI.WebControls.ListItemCollection"
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim str As String
str = "insert into a_software (soft)values('" & ListBox2.Items.ToString() & "')"
Dim comm As New SqlCommand(str, dbconn)
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
End Sub
Chaitra N
|
|
|
|
|
Why is no-one capable of giving their variables sensible names ?
n_gchaitra wrote: ListBox2.Items.ToString()
Well, ListBox2.Items returns a listboxitemcollection. ToString on that, gives you the string you're getting. You need to iterate over the collection and build the SQL to insert the values. Of course, you're also wide open for SQL injection attacks.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
You need to iterate over the collection and build the SQL to insert the values. Of course, you're also wide open for SQL injection attacks.
Can u elaborate please?
Chaitra N
|
|
|
|
|
You are getting an error because the ListBox2.Items.ToString() function just returns the text System.Web.UI.WebControls.ListItemCollection - because that is what you are referencing....it's just a collection.
You would need to loop through each of the ListItems and get out the text value of each and run that as a seperate insert...i.e.
foreach(ListItem item in ListBox2.Items){
str = "insert into a_software (soft)values('" & item.Text & "')"
//then run the insert
}
that would be a way to do it using your current code, or build up a collection of inserts and run them all at once (not sure if you can do that with ExecuteNonQuery() though) - running everything at once would definitely be the better option.
|
|
|
|
|
I am using vb not c#. foreach(ListItem item in ListBox2.Items) will not work in vb
Chaitra N
|
|
|
|
|
|
Following is the code i have written, But it is giving the error, ExecuteNonQuery: CommandText property has not been initialized
Partial Class _Default
Inherits System.Web.UI.Page
Dim constr As String = ConfigurationSettings.AppSettings("conn")
Dim dbconn As New SqlConnection(constr)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Button1.Attributes.Add("onclick", "return fnMoveItems('ListBox1','ListBox2')")
Button2.Attributes.Add("onclick", "return fnMoveItems('ListBox2','ListBox1')")
End Sub
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim str As String
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In ListBox2.Items
str = "insert into a_software (soft)values('" & item.Text & "')"
Next
Dim comm As New SqlCommand(str, dbconn)
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
End Sub
End Class
Chaitra N
|
|
|
|
|
Hi, This function is working, But the each value is getting stored in different row of the table. I want them to get stored in a single row.
Dim str As String
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In lstselectedemployees.Items
str = "insert into a (soft)values('" & item.Text & "')"
Dim comm As New SqlCommand(str, dbconn)
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
Next
If I use the following code then, only the last item of the list box is getting stored,
Dim str As String
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In lstselectedemployees.Items
str = "insert into a (soft)values('" & item.Text & "')"
next
Dim comm As New SqlCommand(str, dbconn)
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
Chaitra N
|
|
|
|
|
Hello Chaitra..
have a try with following code..
I think u have to save the all items of ListBox2 to database ...is i am correct???
if yes then,
dim szItem as new ListBoxItem
for each szItem in Listbox2.Items
//Now fire your insert query here
str = "insert into a_software (soft)values('" & szItem.text & "')"
Next
hope it will helps....
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
koolprasad2003 wrote: str = "insert into a_software (soft)values('" & szItem.text & "')"
writing a query in your code, make u wide open to SQL Injection attack..please tell me that is only for example explanation
Kind Regards,
Tomi
|
|
|
|
|
Following is the code i have written, But it is giving the error, ExecuteNonQuery: CommandText property has not been initialized
Partial Class _Default
Inherits System.Web.UI.Page
Dim constr As String = ConfigurationSettings.AppSettings("conn")
Dim dbconn As New SqlConnection(constr)
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Button1.Attributes.Add("onclick", "return fnMoveItems('ListBox1','ListBox2')")
Button2.Attributes.Add("onclick", "return fnMoveItems('ListBox2','ListBox1')")
End Sub
Protected Sub Button3_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button3.Click
Dim str As String
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In ListBox2.Items
str = "insert into a_software (soft)values('" & item.Text & "')"
Next
Dim comm As New SqlCommand(str, dbconn)
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
End Sub
End Class
Chaitra N
|
|
|
|
|
u have to take following line in for each..Next loop
n_gchaitra wrote: comm.ExecuteNonQuery()
and the following statement move above the connection.Open()
n_gchaitra wrote: Dim comm As New SqlCommand(str, dbconn)
make the changes and First check that connection is successfully open or not
regards,
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
How is it possible, use comm.executenonquey() before declaring comm? I get the following message near the word str i.e Dim comm As New SqlCommand(str, dbconn)
var 'str' is used before it has been assigned a value. A null reference exception could result at runtime
Chaitra N
|
|
|
|
|
Hi, This function is working, But the each value is getting stored in different row of the table. I want them to get stored in a single row.
Dim str As String
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In lstselectedemployees.Items
str = "insert into a (soft)values('" & item.Text & "')"
Dim comm As New SqlCommand(str, dbconn)
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
Next
If I use the following code then, only the last item of the list box is getting stored,
Dim str As String
If dbconn.State <> ConnectionState.Open Then
dbconn.Open()
End If
For Each item As ListItem In lstselectedemployees.Items
str = "insert into a (soft)values('" & item.Text & "')"
next
Dim comm As New SqlCommand(str, dbconn)
Try
comm.ExecuteNonQuery()
Label1.ForeColor = Drawing.Color.Green
Label1.Text = "Success"
Catch ex As Exception
Label1.Text = ex.Message
End Try
Chaitra N
|
|
|
|
|
n_gchaitra wrote: str = "insert into a_software (soft)values('" & ListBox2.Items.ToString() & "')"
if u want to avoid SQL injection attack..u have to write u'r query into stored procedure
Regards,
Tomi
|
|
|
|
|
How to connect xml file in tally. I have rts.dll(link) tally version(7.2). I want aspx file code....
v.surendrakumar
|
|
|
|
|
1 - try a sensible subject, everyone here wants help
2 - what is tally ? What is rts.dll ? What are you talking about ?
You can open an XML file with the XmlDocument or XMLDataDocument classes.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Any suggestion on free asp.net cms? Thanks.
|
|
|
|
|
i have a website which is to run at the client end. currently what i am doing is installing the .net framework an then installing the application.Is there any way to integrate the .net framework with the application so that there does not occur any need to install the .net framework manually.
after the installation the code pages also appearing with the aspx pages.
Is there any way to get rid of this problem.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
You need to add .NET redestributable package with your application. Then configure your installer to install framework first and your application. It looks like Visual Studio packaging won't provide option for doing this. I used a third party installer to do this. Try Installmaker.
|
|
|
|
|
Hi,
I have two fileds in a form both are combo box ie month and year and not data bound (form1) .
from this form I am going to another page (form2)
and from form2 back to form1
I have to show the same values of the combo ie month and year(which was selected by user ) when form 1 is loaded again
what is the correct way of passing data in two web pages in asp.net ie retaining the values of the drop down list in the form1
no use of sessions or global variables please What is the correct way of doing it
thanks in advance 
Sakshi
|
|
|
|
|
It's not possible. Instead, you'd need to turn the two pages into controls, so they could both exist on one page, then viewstate will maintain the state of form1, even when it's not visible, and form2 is being shown.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi,
I am using a gridview to display user information, and one column I am trying to display the user's first name and last name together. They are 2 seperate properties in the UserInfo class.
<Columns>
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<a href='MemberDetails.aspx?MemberID=<%# DataBinder.Eval(Container.DataItem, "ID") %>'><%# GetMemberName(UserInfo)%></a>
</ItemTemplate>
<HeaderStyle CssClass="gridview_header" />
<ItemStyle CssClass="gridview_cell" />
</asp:TemplateField>
</Columns>
The GetMemberName method looks like this:
protected string GetMemberName(UserInfo info)
{
string strName = string.Empty;
// Check for a first and last name
if ((info.FirstName == string.Empty) && (info.LastName == string.Empty))
strName = "Unknown";
strName = info.FirstName + " " + info.LastName;
// Return
return strName;
}
I do not know how to call the GetMemberName method correctly from the gridview. Please can someone help me?
Regards
ma se
|
|
|
|
|
Where is the userinfo object coming from ? If it's the item stored in the datasource, pass Container.DataItem.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
