Skip to main content

Insert EO grid view data into the database

using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Data;
using EO.Web;
using EO.Web.Internal;

public partial class _Default : System.Web.UI.Page
{
public static string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Documents and Settings\mshamanna\My Documents\Visual Studio 2010\WebSites\EOTest2\App_Data\Database.mdf;Integrated Security=True;User Instance=True";

protected void Page_Load(object sender, System.EventArgs e)
{

string sql = @"select * from Temp";
SqlConnection conn = new SqlConnection(connectionString);
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(sql, conn);
da.SelectCommand = cmd;
DataSet ds = new DataSet();
da.Fill(ds, "Temp");

Grid1.DataSource = ds.Tables[0];
Grid1.DataBind();

}

//To Save grid values into database
protected void btnSave_Click(object sender, System.EventArgs e)
{
string header3 = "";
int id = 0;

SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
int count = 0;

foreach (EO.Web.GridItem item in Grid 1.Items)
{
count++;
//Get the cell value in the second column
header3 = (string)item.Cells[2].Value;

string sql = @"UPDATE TEMP SET HEADER3='" + header3 + "' WHERE ID='" + count + "'";

SqlCommand cmd = new SqlCommand(sql, conn);

cmd.ExecuteNonQuery();

}

conn.Close()


}

Comments

Popular posts from this blog

Drawing Line Charts In asp.net

LineChart.cs import the following namespaces using System.Drawing; using System.Drawing.Drawing2D; using System.Drawing.Imaging; using System.Collections; public class LineChart { public Bitmap Bitmapb; public string strTitle = "Default Title"; public ArrayList ArrayListchartValues = new ArrayList(); public float ftXorigin = 0, ftYorigin = 0; public float ftScaleX, ftScaleY; public float ftXdivs = 2, ftYdivs = 2; private int intWidth, intHeight; private Graphics Graphicsg; private Page Pagep; struct datapoint { public float ftx; public float fty; public bool bolvalid; } //initialize public LineChart(int intmyWidth, int intmyHeight, Page myPage) { intWidth = intmyWidth; intHeight = intmyHeight; ftScaleX = intmyWidth; ftScaleY = intmyHeight; Bitmapb = new Bitmap(intmyWidth, intmyHeight); Graphicsg = Graphics.FromImage(Bitmapb); Pagep = myPage; } pu

AJAX

ASP.NET AJAX From Wikipedia, the free encyclopedia Jump to: navigation, search ASP.NET AJAX is a set of extensions to ASP.NET developed by Microsoft for implementing Ajax functionality. It is released under the Microsoft Public License. Contents [hide] • 1 Road Map • 2 Browser support • 3 ASP.NET AJAX Suite • 4 Microsoft Ajax Library • 5 The UpdatePanel Control • 6 Script Controls and Extenders • 7 Web-services and JSON • 8 See also • 9 References • 10 External links [edit] Road Map In its early development stages, ASP.NET AJAX was given the code name Atlas. Initial releases were made public to the development community in the form of CTPs (Community Technical Previews). The production version, ASP.NET AJAX 1.0 RTM; was released on January 23, 2007[1][2] as an extension to ASP.NET 2.0. Important release milestones for ASP.NET AJAX are as follows: • CTPs - October, December 2005, January, March, April, June, July 2006 • Beta - October, November 2006 • Release Candidate (RC) - December 2