I am new to .NET and I have a big problem that I couldn't find a solution for. I am not able to update the edited data from the datagrid. Please Help! What am I doing wrong? I am getting this error when trying to view the site on IE:
The IListSource does not contain any data sources. Here is my code:
sing System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace ProjectTime
{
/// <summary>
/// Summary description for DisplayStatus.
/// </summary>
public class DisplayStatus : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DGrdStatus;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
BindDGrdStatus();
DGrdStatus.EditCommand +=
new DataGridCommandEventHandler(this.DGrdStatus_Edit);
DGrdStatus.CancelCommand +=
new DataGridCommandEventHandler(this.DGrdStatus_Cancel );
DGrdStatus.UpdateCommand +=
new DataGridCommandEventHandler(this.DGrdStatus_Update );
}
public void DGrdStatus_Edit(Object sender, DataGridCommandEventArgs e)
{
DGrdStatus.EditItemIndex = e.Item.ItemIndex;
BindDGrdStatus();
}
public void DGrdStatus_Cancel(Object sender, DataGridCommandEventArgs e)
{
DGrdStatus.EditItemIndex = -1;
BindDGrdStatus();
}
public void DGrdStatus_Update(Object sender, DataGridCommandEventArgs e)
{
string ConnectionString = @"User ID=sa;Initial Catalog=ProjectStatus;Data Source=(local);";
if(ConnectionString == "")
{
ConnectionString = "Initial Catalog=ProjectStatus;Data Source=(local);Integrated Security=SSPI;";
}
SqlConnection cnn = new SqlConnection(ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Info",cnn);
DataSet ds = new DataSet();
DGrdStatus.DataSource = ds;
DGrdStatus.DataMember = "Info";
DGrdStatus.DataBind();
SqlCommand upCmd = new SqlCommand(
"UPDATE Info SET Total=@Total WHERE Num=@Num",cnn);
upCmd.Parameters.Add("@Total", SqlDbType.NChar, 18, "Total");
da.UpdateCommand = upCmd;
da.Update(ds,"Info");
DGrdStatus.EditItemIndex = -1;
BindDGrdStatus();
}
private void BindDGrdStatus()
{
string ConnectionString = @"User ID=sa;Initial Catalog=Project;Data Source=(local);";
SqlConnection cnn = new SqlConnection(ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("SELECT * FROM Info",cnn);
DataSet ds = new DataSet();
da.Fill(ds, "Info");
DGrdStatus.DataSource = ds;
DGrdStatus.DataMember = "Info";
DGrdStatus.DataBind();
}
#region Web Form Designer generated code
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
}
#endregion
}
}
*******(*)*******
Updating to a SQL Database
