I have a gridview on a page that allows a user to edit the data. I need to be able to insert the current user's username in the database table whenever they click update on the gridview. I am new to coding and im strugling to get this project done.I am using MSSQL Server 2005 and VB in the codebehind.
View 2 Replies
I have gridview in which i had enabled edit update function. i want to insert current date when ever a user edits the row. my web is in asp.net, vb code, and database is in sql
View 1 RepliesI have grid view in ASP.Net 3.5. I need to add multiple blank rows in a gridview and then have to save them in database. How can I do that in most simplest way?
View 7 RepliesI have a MySQL database, and I'm currently creating an ASP.NET website to update data in it. I'm currently having trouble changing the data with GridView. Reading through various posts on this site, i think I've got a problem with binding the data, but I'm not sure how to accomplish this with MySQL database. My c# code is as follows:
[Code]....
My asp code is as follows:
[Code]....
At the moment I'm getting an error about the "trash" data, it's an Int32 field, but I'm not sure how to handle that.
As the subject says, i display a gridview filtered from 3 dropdownlist, wich all the items are from a local Data base, once i display this gridview i want to select a row with a button then and add, modify or delete data from it and then this new info is saved on the data base, so when i display the grid again i will see the new info. Im working on visual studio 2010, i dont use code behind, all is in asp .net.
[Code]....
I use detailview control for edit all data in page but when i save data and i need save current username it's not save.
Now 1. I'm try use <asp:Parameter Name="<%$ Page.User.Identity.Name %>" Type="String" /> but not work.
2. I'm try use find control in codebehind and fill data to label in detailview but not work.
Below is my code.
[Code]....
how to insert the gridview values to database?
View 5 RepliesI want to insert a new record into the database through gridview.New butoon in not inside the gridview it a diifrebt button.when we click new then it show a new row which is blank. another button is save when we click save it will save the data into database
View 4 RepliesI am trying to insert UserName and PageName into table using ObjectDataSource but it is not inserting into database.I get these values fine and displayed in a label but not inserted in table.Needs further guidance in the code which is as under:
[Code]....
[Code]....
I finally got membership and roles setup and seems to be working. I have setup a page to allow the creation of a user and editing of roles for a user. I would like to setup a page with a gridview that displays all users and what roles they are assigned. I remember running across someone else that was looking to do the same thing, but cant find it. Not sure if it was in this forum or online somewhere else.
But i found that i can use the aspnet_Membership_GetAllUsers procedure in my db to get all the users, but how can i add the roles to each person and possibly setup the gridview so that each role they have, is displayed on their row in the gridview So i would like to see something like this maybe more data displayed depending on the client request.
Username Email Last Login Roles
meofcourse me@hi.com 08/25/2010 X Admins X Approvers
themofcourse them@hi.com 05/25/2009 X Approvers
The X indicating a checkbox.. and have it setup so they can uncheck the role, that triggers the update and causes the list to refresh and display the new current roles for the individual users. The procedure listed about does not return the roles, so wasnt sure if i could use that procedure and union it with another to get the combined results im looking for.
I need a control to modify data from my data base tables like a GridView. Has ASP.NET the control that I need implemented? Who could I do that?
View 2 Repliesi have 103 column in database 1 column is id, 1 is user ,1 datetime, 100 button on webpage 1 textbox to input value , button1 clicked then value in textbox will insert into database with user:=user.identity.nam datetime=datetime.now colum4 will get value from textbox......button2 for colum2 and buton100 for column100, if i use dataset i need 100 datataset, some other way to solve it ??
View 2 Repliesi'm currently doing a shopping website. The customer will have to selected the item they want to buy and it will appear in the detail view when they click add in the grid view. I need the info inside the detail view to be insert into a database call Orderlist.
i've try using INSERT INTO OrderList (ProductName, Price,) VALUES (@ProductName, @Price) but it don't seems to work.
Was it because i can't insert it like this as it is detailview? This method can work if is Textbox instead of detailview.
i have a gridview of 8 columns.I need to extract the data row by row from the the first(Message) and the last(phone_no) column and to be inserted into my sql table named massMessage.I have the codes here. Apparently im able to only extract the phone_no. My message wasnt inserted.
protected void btnSave_Click(object sender, EventArgs e)
{
foreach (GridViewRow gvr in GridView2.Rows) //loop through GridView
[code]...
so i have a gridview wherein there is a linkbutton ... when i click the linkbutton it will insert data to database...
View 2 Repliesi wanted to insert the data into the database from the gridview1.
I want that row of value which the user click add in to the database.
I have added in the insert command which i have underline it but it only record in the ProductID value.
How to i insert them in the database call OrderList?
Here is my code:
[Code]....
This is the first time i'm using asp.net.
[Code]....
I'm coding my first VB web application, which allows a user to input an order number and pull up invoice and shipping data linkd to that order number.
I have the first bit down and working, where the existing data in the database is displayed in the GridViews. One of the GridViews is set up to allow data editing, and I have syntax set to make the row editable, but I'm struggling with getting the "Update" link/functionality to work. I want to assign the values in each cell to an object (ie. 'dgInvNumber' for Invoice Number), but everything I've tried (been doing a ton of Google searching for help, but no luck yet) keeps giving me an "Object reference not set
to an instance of an object" error when I click the Update link for the row of data being edited.
At this point, I don't know what syntax to use to get the edited values out of the GridView row and assigned to objects for each cell (I have a total of 10 cells that can be edited in a row).
For background info, the GridView is set up with Bound Fields. I'm using Visual Studio 2005. Alot of places I've looked talk about TextBox controls and using FindControl. Also seen some places talk about DataBoundLiteral Controls. I tried the latter with no luck (still getting error). For TextBox controls, I don't understand how to use that part, since it mentions referencing the TextBox controls declared in the EditItemTemplates of the TemplateField column fields in the GridView control. But I didn't set up anything in the EditItemTemplates (that I know of).
How to update username of current logged username?
View 10 RepliesI am using ASP.Net 4.0/Visual Studio 2010. However, I think it would be the same if it was ASP.Net/VB.Net 3.5. I am inserting three form filed values into a database table. I have placed a LoginName Control on the page and the login name is properly displaying. I am using forms Authentication and it is set up properly in the web config file. I simply want to insert the logged in username value into the database table so I can track who created the records. I am happy to be able to insert the UnserName or the UserID value. I assume both of the values are derived out of the aspnet_Users table. Being able to insert either one would be fine but I believe UserID would be better because it will always be unique.
View 8 RepliesI have a save button outside the gridview and I want to save all the values/records of gridview at once or row by row in database(sql server) .
View 1 RepliesI have a nested gridview dynamically added. It seems I resolved all issues with the loading this control on a parent page along with other controls and I can trigger the edit of the first level - the master part of the gridview. However, I cannot trigger the edit on a child gridview.
OnRowEditing="grdChildGridEdit_RowEditing"
The master and the child gridviews have objectdatasources in a markup but I have to do the additional data binding after the loading the control on the parent page (see the code below). I'm doing that additional data binding only for the master gridview that is working fine and shows the data for the master and the child gridviews. When I click the Edit button on the master gridview it shows text boxes for the editing but when I click the Edit button on the child gridview it's doing nothing and moreover the editing mode for the master gridview is going back to the initial stage (labels).
I was trying to trigger it throughuse the registering the event:
[code]....
how to check if a particular data in the database already, for example, i want to check if a username already exist in database, then the user cant choose that username.
View 6 Repliesmay i know how to add in current date into the database?i've try using INSERT INTO OrderList (Date) VALUES (DateTime.Now,"dd-MMM-yyyy")
View 3 Replieshow to insert,update,delete row in gridview without saving in database ?suppose 1 textbox,1 button and 1 gridview .textbox and button outside of gridview.
what is the coding of this project ?
in griedview how to save dropdown list value save in sql server .
View 1 Replies
