I am binding gridivew with custom datasource. I have 3 columns and I want two columns to be editable. right now grid showing the data but i want it to delete and update as well.
View 3 Repliesupdate the data in sqldatasource without gridview. how to do that?
View 3 Repliesinsert update delete in gridview using sqldatasource in asp.net
View 1 RepliesHere is the code for my page:
[Code]....
For some reason I seem to be unable to update my DB through the datasource. Is there anything obvious as to why this wouldn't be working?
I even added static values to the update string to see if this works but it still has an issue.
I'm designing a website that should have horizontal menus (main menu, and sub menus) underneath each other like:
Home | **Categories** | Contact Us VBScript | VB.NET | ASP.NET
(** indicates the selected main menu item) Where VBScript, VB.NET, and ASP.NET are menu items in the Categories main menu item.
Initially, I tried using a separate sitemap file, but came across an error that forced me to write a custom xml document for the sub menu (code below)
[Code]....
I've created an asp:Menu control to use for the sub menu (it's blank until a main menu item that has child items is selected), and I'm databinding it on MainMenuItemClick (code below)
[Code]....
MainMenu has it's items hard coded into the html, but I'm going to move that over a sitemap later, what I'm struggling with, is how do I get the SubMenu items to navigate to the URLs I'm specifying?
i've created a webform with one gridview having connected with the database using datasource. i.e password database with three colomn .
now want to insert the custom dropdown button using server control for each column.
when i select the dropdown list the list should display the value as required.
e.g if i click the uname dropdownlist then it should show the list of names.
if i click on pwd dropdownlist then it should show the list of numbers.
if i select any one of the value in the dropdown list then it should insert into the
database.
can i get code on this type of question...?
This is my code and i am only able to edit the one data under the category school.But what i nd is to edit the other categories like the name,email...etc..how do i modify my code in the update command.Another thing is to delete the data how do i do that?
[Code]....
There is a field called school which is a dropdown menu, I manually edit items and made it like these: select school, name of 6 elementaries and 2 middle schools, and a high school.I have another field called grade level, which is a drop down menu too, i manually entered the grade items for it: select grade, Kindergarten, 1, 2, 3......12.
I would like after user selects a school in the drop down menu, the field called grade level dropdown box' data source will be updated according to school. For example, if it is a middle school selected, the data source of grade level will be updated to 6, 7 8 grade, if it is elementary the grade will be updated to 1, 2, 3, 4 5 etc. In this way later, when user goes to select grade it will show appropriate grade level lists according to schools.
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.
[Code]....
How to edit gridview row when not using sqldatasource and autogeneratecolumn property is set to true.I have a dropdownlist where table is selected on which gridview is populated (through sp from oracle) which is working but edit command is not working.Do i have to generate template myself or what ever solution?
View 1 RepliesI have a gridview with daatsource from MembershipUserCollection. When my collection doesn't contain any records the gridview just disappears. I want to display the empty gridview indicating no records exist rather than the grid just become invisible.
How to make gridview always visible ?
I have a gridview and I have an edit template for one control. I have a drop down box in this edit template so that you can select a value from it and then when you hit 'Update' the value from the drop down box is committed to the updated record. Unfortunately when I do hit the update button I get a fault that the "Status" field cannot be null.
Here is the code that picks the value from the drop down value and assigns it to the new values list:
[Code]....
I'm using a GridView to output some information regarding an account, specifically account balances. Problem is, if there is no balance linked to the account, I need for the grid to simply display 0 for each column. EmptyDataText isn't sufficient as the columns still need to be listed, but just have the value 0.
After researching it seems like I will need to add a dummy row to the gridview if it is empty, but how do I do this using C# and ASP? Quick note as well, not sure if it's relevant but the grid will only ever contain one row.
i am working on a website,As i am new to coding i got a problem in it. It was,I hav a gridview in which i am adding the details about a college, and in that i had a buton ("btnReservation") on clicking it another grid will be appeared in which, i hav to enter the reservation details so, till this step it is working fine, but if i enter one college details and clicking on the btnReservetion the grid is being dispalyed and i am able to enter and save the data, But if i enter the details of another college and clicking on the btnReservation, the rows which i hav already entered in the Reservation grid for the previous record are not being Refreshed and are remaining the same,So now i hav to make the gridview datasource null.
[code]...
I have the web page that meet the problem. There exists a gridview and filtering. When Select all by using function A, it is OK. when Filter by using function B, it cannot filter and return no rows. When Select all again, it is OK. I have tested that function B can return the corrected filtered rows. But when databind in the web page, it cannot show and no error?
<ContentTemplate>
<asp:GridView ID="gvwBOM" runat="server" DataKeyNames="ProductID"
AutoGenerateColumns="False" DataSourceID="objBOM" AllowPaging="True"
AllowSorting="True" BorderWidth="0px" CellPadding="3" CellSpacing="1" CssClass="grid-view"
OnRowCreated="gvwBOM_RowCreated"
OnRowCommand="gvwBOM_RowCommand"
OnDataBound="gvwBOM_DataBound" >
.........
<asp:ObjectDataSource ID="objBOM" runat="server"
SelectMethod="GetALTBOMs"
SelectCountMethod="GetALTBOMsCount"
EnablePaging="true"
SortParameterName="SortExpression"
TypeName="QI.BLL.WMS.ALTBOM" >
private void FillGridView(string filter)
{
if(filter == "0")
{
objDataSourceSelect="Afunction";
this.objBOM.SelectParameters.Clear();
}
else
{
objDataSourceSelect="Bfunction";
this.objBOM.SelectParameters.Clear();
this.objBOM.SelectParameters.Add("productSupplimentID", ddlTmp.SelectedValue);
}
this.objBOM.SelectMethod = objDataSourceSelect;
this.objBOM.SelectCountMethod = objDataSourceSelect + "Count";
this.gvwBOM.DataBind();
}
I have a gridview in a user control which I'm using to display a list of items. The data source is a list of objects (not using ObjectDataSource). I have paging enabled on my gridView. The trouble is that I am forced to rebind my grid in my paging method, otherwise the grid loses all it's data when a user clicks a page button. Is there a good way of binding to an enumerable list such that the values are reused on postback?
[Code]....
protected void gridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
BindGrid(); //Not Good. Removing gives me an empty grid.
((GridView)sender).PageIndex = e.NewPageIndex;
((GridView)sender).DataBind();
}
I'm sure it was discussed hundred of times, but maybe this time will elucidate some new points )
The question is: do I need to limit number of selected rows in data source for GridView?
When I use paging in GridView does limiting selected rows make GridView work faster?
Now I use ObjectDataSource with Linq in functions.
[Code]....
Does this make sense or I can just use LinqDataSource without thinking of selected rows?
When i try to update a row using the update functionality of Gridview it updates all the rows rather then updating that specific row which is in edit mode.
[Code]....
Is it possible to use dynamic query filters with a gridview using a stored procedure as a data source? What I'm thinking of is a search page where there are multiple controls to enter in a search string and a radio button for the AND/OR query filters between the various controls. If not, what would be the best way to allow a user to select an AND / OR with a group of different query controls?
Here is the page I have created thus far using a view and no AND/OR option. I but I can't get it to work with my SP, also listed below:
[code]....
I having problem binding web service result into a gridview. I using Word Dictionary Web Service for my project. Below is part of my code.
Web References I using is :
[URL]
Protected void Button1_Click(object sender,
EventArgs e) {
DictService ds = new DictService();
ds.DefineAsync(TextBox1.Text);
ds.DefineCompleted += new DefineCompletedEventHandler(ds_DefineCompleted); }
void ds_DefineCompleted(object sender, DefineCompletedEventArgs e){
GridView1.DataSource = e.Result;
GridView1.DataBind();}
The Error i get is : Data source is an invalid type. It must be either an IListSource, IEnumerable, or IDataSource.
I put a sql statement into the textbox,then the result will be bound to the gridview in the page. first time,sql statement is "selecte * from A(B)",and the gridview is ok. second time,sql statement is "selecte * from B(A)",then the gridview will throw a exception the exception is "A field or property with the name 'aa' was not found on the selected data source. i have two tables A and B."
View 5 RepliesWorking on a site where a user does a search, it takes the input from the user and then runs an SQL command to return the data in a gridview for the user to see. I also have a button where the user can see all the results from the DB (this will be taken out later but for now the DB is pretty small) This is all working fine, but the problem I am having is that when you look at the page source the gridview populates everything in tables on the page. This makes it really easy to just copy and paste and get everything from my database. How can I go about displaying the information to the user in a gridview, but hiding the table information in the html page source?
View 6 RepliesI am tryting to reach controls in the gridview rows by RowCommand event. I can take values of controls which are binded to gridview source successfully . But for all other controls which is not binded to gridview returns NULL value. All controls run at server. Why is that?
View 7 RepliesI need to do a custom update for a form view (I think/know), as some of the parameters that are required for updating values should not be updated by the users, such as userid of the person performing the action which is passed back to the database for auditing purposes.
Additionally, there are some fields, such as LastUpdatedBy, LastUpdatedDate that need to be seen, but not edited. The stored procedure on the backend takes care of this, and these are not parameters for the Update method. The FormView by default is trying to pass all these values back to the database.
Lasty, the select query of the object datasource is a stored procedure that performs several joins based on PF/FK relationships to bring back more meaningful information than just a FK, so some columns are just the joined value, and can not be updated directly. Again, formview is trying to pass these parameters
So given that, I have defined the following even handler for a simple form view:
(not sure if this is the way to proceed given the above, but...)
protected void FormView1_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
ProjectDetailsDataSource.UpdateParameters.Clear();
ProjectDetailsDataSource.UpdateParameters.Add("projectID", ((Guid)e.Keys["ProjectID"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("projectName", (string)e.NewValues["ProjectName"]);
ProjectDetailsDataSource.UpdateParameters.Add("description", (string)e.NewValues["Description"]);
ProjectDetailsDataSource.UpdateParameters.Add("projectTypeID", "1");
ProjectDetailsDataSource.UpdateParameters.Add("statusID", "1");
ProjectDetailsDataSource.UpdateParameters.Add("productID", null);
ProjectDetailsDataSource.UpdateParameters.Add("isComplete", ((bool)e.NewValues["IsComplete"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("isActive", ((bool)e.NewValues["IsActive"]).ToString());
ProjectDetailsDataSource.UpdateParameters.Add("userid", Membership.GetUser().ProviderUserKey.ToString());
ProjectDetailsDataSource.Update();
FormView1.ChangeMode(FormViewMode.ReadOnly);
e.Cancel = true;
}
My questions are as follows:
1) Is this the right approach?
2) Is so, when I cancel the edit (because I did the update myself), and change mode, the FormView returns to read only mode as inteneded (good so far). However, when I hit F5 (refresh), the ItemUpdating method is called again, and updates the database.