i am attempting to update one field; either the data field or filename from a record but not both at same time.
i am using a stored procedure like.
@id int,
[Code]....
I am facing problem in my update statement,
Dim abc As String
abc = Request.QueryString("str")
Dim userName As String = CStr(Session("user"))
Label2.Text = userName
Dim MyConnection As New OdbcConnection(ConnStr)
MyConnection.Open()
Dim MyCommand As New OdbcCommand
MyCommand.Connection = MyConnection
If MyCommand.CommandText = "Select userid from week where userid ='" & userName & "'" Then
MyCommand.CommandText = "Update week Set value = '" & abc & "' where userid ='" & userName & "'"
Else
MyCommand.CommandText = "INSERT INTO week (value, userid) VALUES('" & abc & "','" & userName & "')"
End If
MyCommand.ExecuteNonQuery()
MyConnection.Close()
i need to update one field in a tabel just to +2 and i can not find out how to do it the code i have write until now is just to find the field i has to update this i the code
[Code]....
write the last code there can +2 to a.point field in my db
I have a gridview which shows a list of data... at the end of each item I have added a button which is linked to the onclick event... when a button is clicked I want a value to update on that specific row... but I can't get it to work :( my code is below...
SqlDataSource 1 code...
UpdateCommand="UPDATE [PurchaseProduct] SET [BDConfirmSent] = 'Yes' Where [Id] = @Id">
<UpdateParameters>
<asp:Parameter Name="Id" />
<asp:Parameter Name="BDConfirmSent" />
</UpdateParameters>
Code Behind...
Protected Sub SqlDataSource1_Updating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceCommandEventArgs) Handles SqlDataSource1.Updating
e.Command.Parameters("@BDConfirmSent").Value = "Yes"
End Sub
Protected Sub Button1_Click()
SqlDataSource1.Update()
End Sub
When I click the button it just postsback the page but then the [BDConfirmSent] field is still empty instead of being "Yes"
I have detailsview with a SQLDataSource to 1 table (City) and am referencing another table (Unit) for one if it's fields.
[code]....
I changed the Unit Code (City Table) field into a template field and am using a dropdownlist item to reference the Unit Name from the (Unit Table) with the CityTable.Unit Code = UnitTable.Unit Code. However when I go into the update and change the dropdownlist item to another Unit Name it is keeping the original Unit Code value or it might even be selecting the first value from the dropdownlist item.
I am trying to update my table ARTICLES and it has a field COUNTER, Everytime a user enter this ARTICLES, the page_load event runs a LINQ to SQL query taking the QueryString as parameter, increasing the COUNTER field in 1.
[Code]....
[Code]....
Update multiple records with subquery
I'm trying to figure out how to update multiple rows in my Directory table, when a user changes their Street Number or Street Name in their profile. They can add multiple users to a directory and each user they add to the directory has this primary users UserId in it. So if the primary user changes their address, I want it to update the address for all the users they listed in the directory as well. I'm adding this to the On_Click in the Code Behind, so when they click to update their profile, it fires this function as well. This code may be way off, but here's what I have right now:
[Code]....
I wrote in subject "Is there any way to UPDATE multiple rows WHERE UserID = @UserID_ArrayList" For example I have an Arraylist like this:
Dim UserID_ArrayList As New ArrayList
UserID_ArrayList.add("100")
UserID_ArrayList.add("150"
UserID_ArrayList.add("200")
Now I have to UPDATE some columns inside those 3 records WHERE UserID = @UserID_ArrayList I'm sure it can be done somehow?
I'm trying to update a date field to the system date but it's not working. Could someone please help with the syntax?
[Code]....
I have two databases. When I am using MS Visual Web Developer, I can drag the table onto the webpage and it gives me check boxes to Insert, Update, Delete,...When I do the exact thing using the other database, it only has check boxes forpaging, sorting and selection. What is the difference? I seem to have all teh same permissions in both databases.
View 2 RepliesI have a page that is using the value from a textbox on a previous page to populate a formview. When I generate the Insert, Update and Delete Statements in Web Developer the edit brings up a blank page and the insert and delete don't work. It works if I just create the formview on a page and hardcode the value in the select statement then the Edit/Delete and Insert works.
View 3 RepliesI have a gridview in which i am retrieving data from database. There are 4 column fields :- EmpId , Name , Project Description and an image. With an image click 2 options should come Edit and Delete. I am done with delete but i m facing problems with Edit (I have already done it with AutoGenerateEditbutton="True" but I want to customize it) .
View 6 Repliesneed a connection to only write records without using sql, i need to prepare my new table records and write it to the database in a single passage, im using oledb how is it done?
View 6 Replies I have a grid which displays a set of columns and I m trying to display only those rows in grid based on the options chosen or searched.
I filter options are
1) search for (textbox) - search from (listbox with columns product, product id , userid )
2) Date filter - choose 1 checkbox out of 3 checkboxes(create Date, submit date, Approve ) and whateevr is selected for the criteria we choose between date from and to calender.
3) Status - listbox with status ID 's Basec on this three filter options I need to frame a LINQ to SQL query that gives me results in grid any option can either be choosen or can be left blank I am using 3 - tier architecture and passing all this fields as parameters in a method from UI.cs to UI.DAL where I am writing a query to generate grid view rows. I think I need to use Dynamic LInq and I have not done that before !!
I need assistance on how to bind Radiobutton to database, so that whatever selection made in Radiobutton will appear in the database
I want to produce an online quiz, that will have the following fuctionality
1. it contain database with , ID, Questions, Option A, B,C, and D, Student Answer.
2.After forming the griedview in connection with the database, i form additonal colum to include Radiobutton where students are to choose the correct option.
3. I was able to configure the gridview which successfully show all the above document but the problem now is how to bind the selected option by students to the database so that i can know wether they choose the right answer or not. i wat the student answer appear in the colum named student answer in the database.
i shall be very grateful , if u can just give simple example that i can perform which shall be able to show the click on radiobutton in database not autopostback in textbox.
I had a DetailsView control for editing records in a Access 2003 database. I transfered the database to MS SQL 2008 and using the same code does not work - after clicking edit nothing happens (no error) and the record is not updated.
[Code]....
i need record with id 1 and 3 only how do i get in sql server 2005.(means distinct empcod onl.
View 3 RepliesI wanna join all the field as a new col.
but how can i ignore the empty field because i always join the field and separate by space like the following.
select (field_1+' '+field_2+' '+field_3) as new_col from TABLEA
but if the field is empty, then there is the double space
how can i ensure all the space is one space only.
I have a 20 to 30 fields on a form. Most of them are optional. However, the users can fill out what they want. If a user dosen't fill in a field when data is sent to the database it's sent as blank, instead of NULL. Is there a way I can generically say "for all textboxes if Equals("") then DBNull.Value". Without going through each and every textbox?
View 2 RepliesYou know how the built in functions in VB.NET gives you the option to pass 1 parameter, 2, 3, or 4 all within 1 function, how do they do that? and when the intellesense comes out, there is a "1 of 4" on the top left of the intellesense and you can click to change and see what the other 4 options are.
View 5 Repliesi want to build a datagrid bound to a datatable with several columns. One column has only a dropdownlist with the number of the rows in the datatable.
Here a samplescreenshot:
[URL]
I know how to bind the columns to a grid and its no problem to create such a dropdown list with the content for me, too. But i dont know how to sort the complete datatabl after changing one value of one dropdown listbox.
So, how can i resort the values of a datatable column based on a given value and the datarow id?
im having a gridview in which im displaying records and status.....this gridview shows employee applied leave waiting for approvals..
so in gridview i have chabged the status button as radio button list and giving two choices as approve/reject ....so HOD seect relevant button and update the grid...
how to do this?
1) do i need to place a button on footer and do some write code behind?
2) or any other easier way?
I've got a single table, with project information and schedule information. To make the data easier to present, I created a tab control with two panels (a detailsview in each). The first tab is for project info, the second tab is for schedule info (again, all fields in the same table). The problem is, if i change info in both tabs, and then hit the update button, only the data from one tab is added to the table. I think this problem is simple to fix, and boils down to the way I have the page organized, but I can't quite figure it out.
I've boiled my code down to the following conceptualized structure:
[code]....
When you click the update button, you return to the listview, but with only the information from your current tab saved. How can I get it to update from both detailsviews?
I want to update multiple rows of gridview (only price field. for that i have added textbox) on click of update button which is outside of gridview.I have done following way
<asp:LinkButton ID="lnkUpdate" CssClass="BlueButton" runat="server" OnClick="lnkUpdate_Click">Update</asp:LinkButton>
[Code]....
Up to this its working fine but when no textbox updated then no need to go in for loop so i am looking for confiramtion before updating rows please help me how to do that becausei am less aware with javascript. another problem is textbox value disappear when page index changed how i can retain that values.