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


Top 5 Contributors of the Month
david stephan
Asad Ali
Post New Web Links

unable to update data to databse from grid view

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net
 

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




TABLES









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;
    &nb


View Complete Post


More Related Resource Links

Unable to store combo box value to data grid view control

  
Hello,         I am using fw 3.5 SP1 with VS2008. I have bind my object collection with data grid view. I can see different values in combo box inside data grid view. But when I select any one value from combo box the selected value is changed to first value of combo box as soos as user leave the cell of the gird. Can anyone tell me where should I look for this problem so that my selected value remains same as user did select it.   Nilkanth Desai  

show data in grid view error Arithmetic operation resulted in an overflow.

  

sir

i have a table there is 17 columns in 17 column 3 are number and other are varchar . when i try to display all data of that column error occures.

one more intersting think is when i try to display 6 column then grid show there data an no more error occures. 

when i run my project this error occures in grid view

Arithmetic operation resulted in an overflow. 


Grid view update error

  
Server Error in '/WebSite6' Application. Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:1. Add a "Debug=true" directive at the top of the file that generated the error. Example:   <%@ Page Language="C#" Debug="true" %>or:2) Add the following section to the configuration file of your application:<configuration>    <system.web>        <compilation debug="true"/>    </system.web></configuration> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.Important: Running applicatio

Unable to export data to an excel file in grid format!!!

  
I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines. I think I'm missing to set some property or somethnig ehwn exporting.   Any help would be really appriciated.

Problem of data grid view of xml file

  
Dear Friends I have a problem with XML View Data Grid. Earlier I create .xml file, then type first set of data tags then Right Click on it and select View Data Grid and Visual Studio 2005 gives me nice data grid view where I can able to enter data. But in Visual Studio 2008 I am not able to find that option. So friends kindly tell me how to enter data with data grid in xml file? I am using ASP.net with  C#, Visual Studio 2008, XML file for createing data source. Thank you.

how to update a Grid view using Ajex

  

how to update a Grid view using Ajex



my query is select * From erp where emp>10;


then update the grdi view using ajex if any button Click


Need help on Select button column in Data Grid to populate fields in Form View

  

 When I have a select a row in a Data Grid that when I click on it I want it to show the info for the person I selected in a form view on the same page as the Data Grid. Here are the columns for the Data Grid that I have set up, the column is highlighted:

<asp:DataGrid ID="MHGrid" AutoGenerateColumns="False"  
        DataSourceID="MHFoundation" DataKeyField="POPULATION_LIST_ID" 
        AllowPaging="True" AllowSorting="True" BorderStyle="Solid" 
        BorderColor="#999999" BorderWidth="3px" CellPadding="4" PageSize="4" 
        CellSpacing="2" runat="server" BackColor="Gray" Font-Bold="False" 
        Font-Italic="False" Font-Overline="False" Font-Strikeout="False" 
        Font-Underline="False">
        <SelectedItemStyle BackColor="#FF9900" Font-Bold="False" Font-Italic="False" 
            Font-Overline="False" Font-Strikeout="False" Font-Underline="False" />
        <Columns>
            <asp:ButtonColumn CommandName="Select"  Text="Select"></asp:ButtonColumn>
            
            <asp:BoundColumn D

How to Disable Specific Column in Data Grid View and write something in Cell and load data in anothe

  

Hello All  ,

i have data grid view and i want to disable specific column from writing in it and in another column 

i want to write something like item code and load the item name automatically in the corresponding cell in the disabled column 

i hope that i write my problem correctly and you can understand what i want :)

thanks in advance ,


Kareem Naguib

Unable to view data on list views

  
I have two lists. A List item in one list will be inserted to the other list based on the actions. This is easily achieved on the event receiver by adding the list item to the target list. Though I adds the list item to the target list; i am only able to view those data when i click on "Modify View" and simply click on "OK" button. Basically its a view refresh / commit. Has anyone came across such issue?

Grid view update problem in asp.net c#

  

Here is my complete code.....please tel where is the problem as i want to update the row in gridview.....and my textbox txtBox1,txtBox2,txtBox3 are having null .........and i'm getting error on the line SqlCommand cmd = new SqlCommand("update product set prodname = '" + txtBox2.Text + "' , proddesc = '" + txtBox3.Text + "' where prodid = " + txtBox1.Text + "", conn); saying that 

 

Object reference not set to an instance of an object.



public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void btnadd_Click(object sender, EventArgs e)
    {
        
        string pname=txtprodname.Text;
        string pdesc=txtdesc.Text;
        SqlConnection conn = new SqlConnection("Data Source=ABC-59236A7CB6F;Initial Catalog=practical2;Integrated Security=True");
        conn.Open();
         SqlCo

update two tables from single grid view using stored procedure PLZ help

  

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 INV_DN
{
    public partial class Form1 : Form
    {
        SqlConnection con;
        SqlDataAdapter da1;
        SqlCommand cmd;
        //  SqlCommandBuilder cb;
        DataSet ds;
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            con = new SqlConnection("User Id=sa;Password=123;database=amar");
            cmd = new SqlCommand("getdata", con);

Can a Dynamic Data page update a View?

  

Hi,

I just started working with Dynamic Data (asp.net 4, VS 2010 express, C#) and have tried to simplify the displaying/not displaying of columns by using a simple, single table, updatable SQL view.  Adding and displaying the view work and the in-line edit and update controls are there and seem functional but I can't access any of the columns.

Does DD not support updatable views or have I missed something?

Thanks, 


Data View Web Part, update to Data Source / adding new list to existing data source

  

Hi all,

I have four Lists with identical columns :

List 1
List 2
List 3
List 4

I had to merge them, hence i created a data source ( Linked Source ) and merged these lists in SPD. I have used a data view webpart to display some columns from the merged lists data source and everything was working fine.

But now i have a new List : List 5 which also has the same columns like the other four lists and i need to update the data soure such that it is merged list of 5 lists not 4.

i updated the datasource property of the linked source to merge this new list as well. However the contents of List 5 dont appear in the data view webpart. 

Am i missing something here ? 

I dont want recreate the data view web part from scratch eachtime , because in future there might be List 6 , List 7 as well ... 


How to save the Entire Grid view data into sharepoint List using Visual Webparts ?

  

Hai Friends,

        I am Ali, I want to retrive the Entire Grid View data in to Sharepoint List using visual webparts. Present i am using FOR EACH condition for grid view, but it doest support for saving information into list items.

        and also i want to save the information that who has selected radio button in Grid View(Ex: If user select 'Present' or 'Absent' or 'OnDuty' or 'Leave' in these any one) that should be save in sharepoint list.

Please anybody help me,

Thanks

Ali.


How to retrive Data from SharePoint List to Data Grid View in Visual WebParts based on the Condition

  
Hi Friends... 
Here i write this Code for Retrieving Data Form SharePoint List to Data Grid view (st_attendance) in Visual Web parts....  But it doesn't work Properly....


SPWeb web = SPContext.Current.Web;
            SPList list = web.Lists["Student Profile"];
            
                string caml = string.Format(@"<Where><Eq><FieldRef Name='Academic Year' /><Value Type='Text'>{0}</Value></Eq></Where>",DropDownList2.Text );
                SPQuery query = new SPQuery(list.DefaultView);
                query.Query = caml;
                SPListItemCollection items = list.GetItems(query);
                st_attendence.DataSource = items;
                st_attendence.DataBind();
                Controls.Add(st_attendence );

How to retrive Data from SharePoint List to Data Grid View in Visual WebParts based on the Condition

  
Hello Friends,

I am Srinivas, I want to know the How to retrive the Data from SharePoint List to Data Grid View in Visual WebParts based on the Condition.

Example: I want to retrive Students information from Lists to Grid View based on the Condition(based on 'Academic year' or 'Class' and 'Section'). In Student Status Page Grid view should be show the Student Details in their Status.

please any body help me

Thanks

MO(LA)DDU

How to retrive Data from SharePoint List to Data Grid View in Visual WebParts based on the Condition

  

Hello Friends,

     I am Ali, I want to know How to retrive the Data from SharePoint List to Data Grid View in Visual WebParts based on the Condition.

Example: I want to retrive Students information from Lists to Grid View based on the Condition(based on 'Academic year' or 'Class' and 'Section').         In Student Status Page Grid view should be show the Student Details in their Status.

please any body help me

Thanks

Ali.


Categories: 
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