.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Updating record in sql databse using data from Gridveiw or Formview

Posted By:      Posted Date: September 07, 2010    Points: 0   Category :ASP.Net
Hi Guys, I am making a message module in asp.net with database of sql. i have made a gridview and enabled selecting. and a form view is synchorised with grid view on selecting. i am writing update sql but could not get a way to take data on Gridview or Formview to compare the record in sql database.   this is my page viewImports System.Data Imports System.Data.SqlClient Partial Class homepage Inherits System.Web.UI.Page Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.SelectedIndexChanged FormView1.PageIndex = GridView1.SelectedIndex Label1.Text = FormView1.FooterText. End Sub Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load If Session("login") = False Then Response.Redirect("Login.aspx") End If End Sub Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim db As New SqlConnection db.ConnectionString = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Message_Dat.mdf;Integrated Security=True;User Instance=True" db.Open() Dim sql As String = "update into tblMessage (msg_status) values('junk') where msg_Id='" & FormView1.text & &q

View Complete Post

More Related Resource Links

FormView Manual Data Updating

I've posted this some place else but have not heard from anyone and hoping I get better luck here.   Note: Sorry about the formating, not sure what happened.I have a FormView that I user for updating a record. There is a link button that when fires should perforom the updating viaBLL and DAL. I am not using built-in ODS and I will not condsider using it. I have all my grids and formviews populated manuualy by calling methods that fetch the data from the database. For instance my details view is populated like this:  protected void DlMembers_ItemCommand(object source, DataListCommandEventArgs e) { if (e.CommandName.ToString() == "Select") { DlMembers.Visible = false; lblError.Text = string.Empty; lblError.Visible = false; fvMemberDetail.Visible = true; fvMemberDetail.ChangeMode(FormViewMode.Edit); MemberBLL getMemberInfo = new MemberBLL(); int Ident = Convert.ToInt32(e.CommandArgument.ToString()); fvMemberDetail.DataSource = getMemberInfo.GetMemberByIdent(Ident); fvMemberDetail.DataBind(); } if (e.CommandName.ToString() == "DeleteSelected") { DlMembers.Visible = true; lblError.Text = string.Empty; lblError.Visible = false; fvMemberDetail.Visible = false; fvMemberDetail.ChangeMode

Data Points: Updating Data in Linked Servers, Information Schema Views, and More


Every day a developer somewhere needs to write code to iterate through SQL ServerT system objects, query and update tables in linked servers, handle optimistic concurrency, and retrieve column and stored procedure metadata.

John Papa

MSDN Magazine November 2004

Automatically set a property value for a new record in a Dynamic Data application.


I have a SalesOrderItem table, and it has a UnitPrice column in case the salesperson wishes to override the unit price of the Product for that order item.

In an ASP.NET Dynamic Data application, what would be the best way to set that UnitPrice property on a new SalesOrderItem based on the standard UnitPrice for the product? In other words, when the user clicks New on the 'Items' screen for a sales order, the UnitPrice field should already be filled in with the normal unit price for the product.

This was originally asked by myself on StackOverflow at: http://stackoverflow.com/questions/3538234/automatically-set-a-property-value-for-a-new-record-in-a-dynamic-data-application

Linq getting data from field on record



   I would assume this is possiable but I cannot seem to find it anywhere. I just one the contents of a single field, I don't see why I have to return the how

record to get get that information, here is my current code, how can I make this better without returning the entire record, for just getting contents of one field.

var patternrecord = storedb.Patterns_Table.Single(a => a.Pattern_GUID == id);
PMEDIA.Pattern_Key = patternrecord.Pattern_Key;

[newbie] How to return a data record from a webservice (wsdl)?



vs2010, .NET 4.0

I have a webmethod which I want to return a data record (for example: name, surename, address, age, zip etc)

I wonder how to accomplish this. I think the solution is about creating an object which contains all the records serialized. And then the webmethod returns this serialized object. I'm not 100% sure how to accomplish this, if some of you good provide me with some tips, tutorial or link to an article explaining it, that would be great

Getting the data's next record, by clicking a button

Hi sorry if asked this twice, please help me understand how to get the next or before record from the database as from the below code i am only getting one record up, and please provide with code as i understand it better that way not that i am in a rush or anything.... thankyou.. please take a look at the code below private void button1_Click(object sender, RoutedEventArgs e) { NorthwindLINQDataContext mycontext = new NorthwindLINQDataContext(); var myquery = from myrow in mycontext.Orders select new { CID = myrow.CustomerID, EmpId = myrow.EmployeeID, OID = myrow.OrderID }; //This will retrieve all records from the db foreach (var valuesFromQuery in myquery) { textBox1.Text = valuesFromQuery.CID; textBox2.Text = valuesFromQuery.EmpId.ToString(); textBox3.Text = valuesFromQuery.OID.ToString(); } } private void NEXT_Click(object sender, RoutedEventArgs e) { NorthwindLINQDataContext mycontext = new NorthwindLINQDataContext(); } private void BEFORE_Click(object sender, RoutedEventArgs e) { NorthwindLINQDataContext mycontext = new NorthwindLINQDataContext(); } } D.Boy

How do I show the last record added when using FormView?

hello all, I am using FormView to display one record at a time and after I add a new record, it won't display the last recorded added.How can I force FormView to display the last record added? Thank you  

Cannot INSERT record using Asp.Net Dynamic Data Domain Service Web Applications

 Hi, I am working on a 'Asp.Net Dynamic Data Domain Service Web Application' project using just 2 tables, FAQ_Categories and FAQs. The FAQs table has a foreign key to the FAQ_Categories. The steps are straight forward. Add a new project (Asp.Net Dynamic Data Domain Service Web Applications) Add folders Model ( for Linq2Sql datacontext), Domain (for the Domain Services class) Add Linq2Slql and add the 2 tables to the designer. Build the project. Add the Domain Service Class to the Domain folder. in the wizard select the DataContext, uncheck the Enable Client & Expose ODate checkbox Check bothe table & their corresponding Enable Editing tables checbox Check the Generate Metadata class Click OK. In Global.asax set Scaffold to true and add the DomainService name. Build and run.   Pages List and Detail are working fine. But if I try to insert a new record, I get the error "FaqId is required" Faq_ID is the primary key in the database table and it is set to Identiy. The Datacontext is correct, it marked the FAQ table with <Global.System.Data.Linq.Mapping.ColumnAttribute(Storage:="_CustomerId", AutoSync:=AutoSync.OnInsert, DbType:="Int NOT NULL IDENTITY", IsPrimaryKey:=true, IsDbGenerated:=true)> _   I tried this using Linq2Sql, Entity Framework, And both in VB and C# with the same result. I am using VS20

How to fill data from a login to a Formview?

I want to fill a Formview when accessing the webpage where it's on (Page_Load). The data I have when somebody want to go to this page is his logindata.  The only code I see I can use is "User.Identity.Name". But I want his Id, so I can get to fill his UserId. I don't know how to do this. I'm using MySql as a database. My code is (a part of it):I want to fill a Formview when accessing the webpage where it's on (Page_Load).The data I have when somebody want to go to this page is his logindata. The only code I see I can use is "User.Identity.Name".But I want his Id, so I can get to fill his UserId. I don't know how to do this.I'm using MySql as a database.My code is (a part of it):<asp:FormView ID="FormView1" runat="server" DataKeyNames="UserId" DataSourceID="MySQLProfielDataSource"> <ItemTemplate> <asp:Table id="ItemTabel" runat="server"> <asp:TableRow> <asp:TableCell> UserId: </asp:TableCell> <asp:TableCell> <asp:Label ID="UserIdLabel" runat="server" Visible="false" Text='<%# Eval("UserId") %>'

Accessing master formview data from a nested detail formview?

Hi all, I would like to ask if it is possible to access data on a master FormView from a nested detail FormView. I have a main form (master) with several tabs (detail) and would like to display a label with text from main form that is hidden by the tab at the moment of editting. My asp page looks like this.<asp:FormView ID="fvwCustomer" runat="server" DataSourceID="dsCustomer" DefaultMode="Edit" DataKeyNames="CustomerID"> <EditItemTemplate> <asp:TextBox ID="CompanyTextBox" runat="server" Text='<%# Bind("Company") %>' /> <asp:FormView ID="fvwContactPerson" runat="server" DataSourceID="dsContactPerson" DefaultMode="Edit" DataKeyNames="ContactPersonID"> <EditItemTemplate> <%-- I need to get the value Company from dsCustomer --%> <asp:Label ID="CompanyTextLabel" runat="server" Text='<%# Eval("Company") %>' /> </EditItemTemplate> </asp:FormView> </EditItemTemplate> </asp:FormView>   Is it possible to get the value of the label CompanyTextLabel from CompanyTextBox using just ASP.NET expressions or something similar without writing c# code in

FormView custom data binding problem

Hi there,   I'm using VWD 2010 ASP.NET 4.0 and SQL Server 2008 Also I have login page with the ASP.NET configuration   one of my page has FormView with Update feature   Evryting works fine user login go to my FormView page and update the record.   Now I created a simple function   Protected Function GetUserName() As String        Return User.Identity.Name    End Function   and one of my coloumn call EditedBy   I replaced the Bind("EditedBy") field binding with   Custom binding GetUserName()   When user update it show the current user login name on the screen But it won't show in the table itself (it show null value when i do select statement)   I used to do this with ASP.NET 2.0 with no problem?   How do I fix that?   Thanks, Oded Dror  

Display Inserted Record After Insert Using A FormView

How do I display a record in a FormView once the record has been inserted? I'm able to get the Identity of the new record without anyproblems, but I can't figure out how I should code the _ItemCreated event. Protected Sub FormViewMessageDetail_ItemInserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.FormViewInsertedEventArgs) 'Refresh the list to show the new record RepeaterMessages.DataBind() 'Set the .SelectCommand to Select the New Record SqlDataSourceMessageDetail.SelectCommand = "SELECT * FROM Messages WHERE [Id] = " & NewId FormViewMessage.DataBind() FormViewMessage.ChangeMode(FormViewMode.Edit) test.Text = NewId.ToString End Sub Protected Sub SQLDataSourceMessageDetail_Inserted(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceStatusEventArgs) NewId = e.Command.Parameters("@NewId").Value End Sub

Updating an item in one list based on data from another

I thought I understood this fairly well, but it seems that I am missing something.  I have created a change management site that uses a calendar list to mark upcoming changes to our IT systems.  I have also created a second list to track some information about the change items that I don't want to show up on the calendar, such as what the outcome of the change was or if the change process was properly followed.  So I have the calendar list and another list called results.  I know that there needs to be a unique identifier that each list item will have in common, so in the results list I created a column called Change Number.  When a new change item is created in the Change Management calendar a workflow runs that notifies some people that a new change has been submitted, and the last step in that workflow creates a new list item in the results list and sets the Change Number field to be equal to the current item ID field.  That part is working right now.  When I create a new change item I can open the results list and see that there is a new item and it has the proper number in the Change Number field. What isn't working is when I try to take actions in other workflows that use data from both lists.  An example is notifying the creator of the change that it has been approved.  When the list item is changed a workflow starts that

unable to update data to databse from grid view


I have two tables in my database

using "innerconnect" i have show table content in grid view as      INV_NO            INV_DT        DN_NO       DN_DT   LR_NO        LR_DT .

where LR_NO is null .

I want to update it from grid view plz help


here  DN_NO  and INV_NO are primary keys

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace amar
    public partial class Form2 : Form
        SqlConnection con;
        SqlDataAdapter da1,da2;
        SqlCommandBuilder cb;

Problem getting same record when trying to populate data into texboxes when selecting a row/record f


I can't seem to get the select record from the datagrid to populate in the textboxes. I get the same record no matter what I select in the datagrid. Hopefully someone can help with this. I tried using a where clause for POPULATION_LIST_ID = '" & Me.lblPopulationID.Text & "' and I get a ORA-01722 error - invalid number. Here is the code I have so far for the grid:

  Protected Sub MHGrid_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles MHGrid.SelectedIndexChanged
Me.Table1.Visible = True
Me.MHGrid.Visible = True

Dim dvSql As DataView = DirectCast(MHFoundation.Select(DataSourceSelectArguments.Empty), DataView)

For Each drvSql As DataRowView In dvSql
Me.lblPopulationID.Text = drvSql("POPULATION_LIST_ID").ToString
Me.txtMRN.Text = drvSql("MRN1").ToString()

Best way to handle constantly updating data.


I'm building a browers-based game that will need to constantly be updating EVERYONE'S accounts regularly; what is the best way to go about doing this?  Creating a process that runs every time someone goes to a page on my site slows down the load time immensely.   Do I need to create a windows scheduled task that calls this/these process(es)?  It will need to constantly run.

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend