i put all my custom "update" code in the RowCommand event, it works fine, but i still get an error from my Data Source
System.NotSupportedException: Updating
is not supported by ObjectDataSource
'GetSources' unless the UpdateMethod
[code].....
This is just stupid. I've been at this for over 5 hours and can't figure out why my freaking commands aren't firing properly. The only ones that fire properly are the Built-in commands "Edit" & "Cancel"
<asp:ListView ID="NewProduct" runat="server" DataSourceID="NewProductSDS" DataKeyNames="ID">
<ItemTemplate>
<div>
<asp:LinkButton ID="accept" runat="server" CommandName="Accept" />
<asp:LinkButton ID="edit" runat="server" CommandName="Edit" />
[Code]...
I have a gridview and have modified it following this article: url...to allow bulk updates. Whenever I try to update a row in this loop:[code]
View 1 Replieshow i can take a row data in a datagrid and insert it into a table on my database?
I have the following code, but it doesnt seem to be working.
Dim conn As String = "Data Source=..."
Dim SQLString As String
Dim paramColl As SqlParameterCollection
[Code].....
What im trying to accomplish is to try to edit a gridview by using the updating event but not sure how to do this. The way im populating the datagrid is putting it into a dataSet and using that as the dataSource and doing a databind. Here is my datagrid below.
[Code]...
For some reason, when i click edit on my gridview and change a value, and hit update, it does not update the database or the gridview, and it shows no error
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
DataSourceID="SqlDataSource1" OnRowDataBound="GridView1_RowDataBound" AllowSorting="True" BackColor="White" BorderColor="#DEDFDE" BorderStyle="None" BorderWidth="1px" CellPadding="4" ForeColor="Black" GridLines="Vertical" ShowFooter="True" style="font-size: 10pt">
<Columns>
[Code]...
The following code runs successfully with no errors, but I still don't get the new data from the grid, by adding a break point, and stepping forward, the data in the variables are the original data, not the updated data.
Private Sub grvSample_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles grvSample.RowUpdating
Dim row As GridViewRow = DirectCast(grvSample.Rows(e.RowIndex), GridViewRow)
Dim passportNumber As TextBox = DirectCast(row.FindControl("txtNumber"), TextBox)
Dim expiry As TextBox = DirectCast(row.FindControl("txtExpiry"), TextBox)
[Code] .....
This is my code for update event
Protected Sub GridView1_RowUpdating(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewUpdateEventArgs) Handles GridView1.RowUpdating
Connection.Open()
[Code]....
it is deleting and fetching fine but while trying to update it shows nullreferenceexception was unhandled by user code in this line:
a = Trim(empname.Text.ToString)
Protected Sub GridView1_RowCommand _
(sender As Object, e As GridViewCommandEventArgs) _
Handles GridView1.RowCommand
If e.CommandName.CompareTo("command") = 0 Then
Dim itemID As Integer = Convert.ToInt32( _
GridView1.DataKeys(Convert.ToInt32(e.CommandArgument)).Value)
[Code]...
Basically, it doesn't work and I don't get it. I've been trying to figure this out for a few days now and I can't see what I've done wrong. As you can see I'm trying to manually update a field in my database with the value of (originalvalue)+1 when the user clicks the buttonfield of the corresponding row.
I guess what I'm asking is if anyone can point out any mistakes, please do, or if there's a better way to do this (without having to go through all the DAL/BLL BS)
I'm working on a project where users search for an item with it's unique number, which retrieves the data from a stored procedure, ordered by date in different rows.That works ok. After that, i have to select a row to update it's status, like from "open" to "close"( I'm using a command Select button to select the rows), but the problem occurs when i click the "Update" button,
<%@ Page Language="VB" MasterPageFile="~/Master Pages/edenorte.master" AutoEventWireup="false" CodeFile="SubirCierre.aspx.vb" Inherits="Edenorte_Operations_SubirCierre" title="Untitled Page" %>
[code].....
I've got my code to delete rows out of the database when the user clicks on the Delete button in my GridView, but the GridView isn't updating to reflect the new data changes.
Here's my code:
<asp:GridView runat="server" ID="grdQuestions" AutoGenerateColumns="false" Width="100%" CellSpacing="10"
PagerSettings-Visible="true">
<HeaderStyle CssClass="aspNetHeader" />
[code]....
EDIT 1:Did some stepping through the code and found that e.CommandArgument is not getting a value in grdQuestions_RowCommand
EDIT 1 (Revised):The fact that e.CommandArgument wasn't getting a value was my mistake. I'd changed the way it's value was being assigned without removing the previous method.The code runs through grdQuestions_RowCommand and then goes into grdQuestions_RowDeleting and then executes GetModuleData.I have a feeling that to view changes to the grid, a PostBack might be required, but I've removed all DataBinding to an If Not IsPostBack Then block because the alternative caused problems with the DropDownList whose selection is used as a reference to populate the grid (ddlModules selected the Module whose Questions will display in the grid).
ItemCommand Event of FormView control not firing/working in ASP.Net Page
View 1 RepliesUPDATED: Here is the SP, it doesn't match exactly because of ongoing testing, but you get the jist. Some fields are commented out because of testing...
[Code]...
Am having problem updating in gridview with vb.net, the C# version worked fine but the VB is throwing this error: Object reference not set to an instance of an object. below is my code:
[Code]....
I have a webpage with a form that is used to edit some object. This object contains a Collection of other objects defined like this: Public Overridable Property Employees As List(Of Employee)
On a form I can delete an employee, add a new one or modify existing one. When I click save new values are sent to the server. On a server I check if the user exists. If exists then I modify its values, if it does not exist then I add it. All employees that exist on the server and were not sent are marked as deleted (State changed to EntityState.Deleted). I try to use the following code (dbCollection = database entities, newCollection = collection sent from the form):
[Code]...
This code does not work, because changing to EntityState.Deleted removes the object from collection, and for each loop breaks, since the collection is modified...I know that I can overcome this problem by using a for loop or adding objects to delete to some other list first, but I hope maybe there is a pattern that would make my code nicer.
How to show pop up menu from database in gridview on each gridview row items ?Example of this is : http:[url].....Move your cursor to Departure time and arrival time...a want this type of popup in gridview items....which fetch entries from database..
View 2 RepliesIn my application,i have a gridview in which columns are created at runtime.Actually these columns are created when i am entering data in a database table.[code]where Column1,Column2,column3 may vary during runtime.i need to enter values to these columns during runtime.But i cant bind these columns because these are created during runtime.The first column "Description" will not change.It will remain constant.For each description, there will be values for each column.At last these data will be saved to the database.How to add columns in the gridview during runtime?
View 2 RepliesI am able to export a gridview to excel, my problem is that I cannot figure out how to remove the formatting from coming over from the girdview. Here is the code I am using to export the gridview: Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code]....
I have a modal popup that contains a gridview. On the click of a button inside of a grid i reload the gridview with the data that depends on the id of the row clicked in the gridview. I would have like to reload the gridview onclientclick but I couldn't find a way to do that. Is it possible to reload a gridview client-side without the user even knowing the page partially loaded?
View 2 RepliesI am using VB.net.
I need to fill a gridview(1) with data that cames from another gridview(2), ie:
(2) - All articles in the database.
(1) - Selected articles from (2)
What is the best way to do that?
I've finally got around to starting windows phone dev. I'm not very good at it yet, but anyway, I hope you guys understand what I want to do here.From what I've learnt from other programmers, an ObservableCollection can be updated in live time whilst it is databound to an object, such as a listbox. All changes to the ObservableCollection will cause the UI of the object it's databound to update it's items.
So what I'm trying to do, is download a file from my server, parse it with json, then update the ObservableCollection with the new data. However, the webclient doesn't seem to be downloading the new data until the app is re opened!
[Code]...
I am using a progressbar control in a splash screen.
In my code I am updating the progress bar value with each step -
In Form_Load of the main (hidden) form:
frmProg.UpdateProgress(10, "Checking Connection String")
CheckConnectionString()
frmProg.UpdateProgress(20, "Checking Crystal Reports OCX Files")
CheckOCXVersions()
[Code]....
Is there some event I can use to find out when the progress bar has finished redrawing?
There is something wrong with my codes. I don't know why it isn't updating the records.If I activated the line dt.Rows.Add(newrow) it will just create an error on da.update(dt) line QuoteThe changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.But if I deactivate that line, no errors will be occurred but the record won't update.
Here is my code
Dim dt As New DataTable
Dim ds As New DataSet
ds.Tables.Add(dt)
Dim da As New OleDbDataAdapter
[code]....
I have a data grid view bound to a sql server table. What I am trying to do is have changes made in the dgv update in the sql table. I tried to use the Update method of the table adapter but get the following error.[code]....
View 4 RepliesI have a datagridview with a datatable as datasource. If I add a row to the datatable, then the datagridview is not showing the contents.
grdChannel1.DataSource = CreateTable(colChannel)
Private Function CreateTable(ByVal colChannel As MyCollection(Of Channel)) As DataTable
'Create table and add collection into
[code]....
I have 2 row counts if I check the the row counts of the datagridview in the debugging mode.
I have a dictionary of key=string and value=datatable. I use a key to retrieve a datatable and assign that datatable to a new variable. Then I make some updates to the variable. However, I find that the dictionary itself is being updated even though I'm only updating the variable. This causes significant issues when I try to reference the dictionary later. How can I set up my dictionary so that it won't update when I use a value?
dim dt1 as datatable
dt1=dictionary(key)
For row=0 to dt1.rows.count
dt1.Rows(row)(4)=dt1.rows(row)(4)/2
Next row
'at this point, when I look up dictionary(key), the value I get shows all of the original values divided by 2.
I just want to add a DSN if it does not already exist. I am looking at the registry and I know the DSN exists but this code returns False consistently.If(not isnothing(My.Computer.Registry.CurrentUser.OpenSubKey("SOFTWAREODBCODBC.INISQL_Finance", True)),True, False) Once I get past this the next step is to add the DSN if needed.
View 4 RepliesI have a datagridview which i filled with this code:
Dim daProd As New SqlDataAdapter
m dsProd As New DataSet
cmd = New SqlCommand
[code].....
I'm using VS2010 (VB), Framework 4.0 and although I'm incrementing my progress bar value between steps, the progress bar only shows the initial value. I've set the minimum and maximum properties and the initial value, but no luck. Here's a brief summary:
[Code]...
I've read through the posts here and can't find any eureka answers so here's what I have.Linq to SQl not propagating a change back to the db.Here's my code. Does anything stand out?The call to dc.GetChangeSet shows 0 changes. What am I missing? I can see the new values from "setting" being set to the cs object properties. SettingID is a primary key in my table and shows as PK in the dbml so that's not an issue.
[Code]...
