Data Form text to gridview without using datbase

Question

0.00/5 (No votes)

See more:

i am having a dropdownlist and two text box and i have to bind the data from these to a grid on a button click. here is my code ...but the data is not displaying in grid ...but on debugging data is retrieved on corresponding data table comns ...could some one help me out
?

DataTable dt;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
dt = new DataTable();
dt.Columns.Add("Product", typeof(string));
dt.Columns.Add("Watt", typeof(string));
dt.Columns.Add("Duration", typeof(Int32));
GridView1.DataSource = dt;
GridView1.DataBind();
Session["dt"] = dt;
}
}

protected void submit_Click(object sender, EventArgs e)
{
DataTable dt2 = (DataTable)Session["dt"];
DataRow dr = dt2.NewRow();
dr["Product"] = DropDownList1.Text;
dr["Watt"] = Txtwatt.Text;
dr["Duration"] = TxtDuration.Text;

dt2.Rows.Add(dr);
GridView1.DataSource = dt2;
GridView1.DataBind();

Posted 19-Jul-13 19:16pm

MohRizwan

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zafar A khan · Answer 1 · 2013-07-19T19:41:00

Solution 1

C#

DataTable dt;
protected void Page_Load(object sender, EventArgs e)
{
if(Session["dt"]!=null)
{
  dt=(DataTable)Session["dt"];
}
else
{
  dt = new DataTable();
  dt.Columns.Add("Product", typeof(string));
  dt.Columns.Add("Watt", typeof(string));
  dt.Columns.Add("Duration", typeof(Int32));
}

GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void submit_Click(object sender, EventArgs e)
{
DataTable dt2 =new DataTable();
if(Session["dt"]!=null)
{
  dt2=(DataTable)Session["dt"];
}
DataRow dr = dt2.NewRow();
dr["Product"] = DropDownList1.Text;
dr["Watt"] = Txtwatt.Text;
dr["Duration"] = TxtDuration.Text;

dt2.Rows.Add(dr);
Session["dt"]=dt2;

}

Posted 19-Jul-13 19:41pm

Zafar A khan

Updated 19-Jul-13 21:17pm

v6

Comments

MohRizwan 20-Jul-13 1:53am

thanks mr.Zafar .. i change the code as you said but igot an error
Line 37: DataRow dr = dt2.NewRow();
Object reference not set to an instance of an object.

Zafar A khan 20-Jul-13 2:11am

just change this

protected void submit_Click(object sender, EventArgs e)
{
DataTable dt2=new DataTable();
if(Session["dt"]!=null)
{
dt2= (DataTable)Session["dt"];
}
DataRow dr = dt2.NewRow();
dr["Product"] = DropDownList1.Text;
dr["Watt"] = Txtwatt.Text;
dr["Duration"] = TxtDuration.Text;

dt2.Rows.Add(dr);
Session["dt"]=dt2;

}

MohRizwan 20-Jul-13 2:49am

thanks for your reply ..but the code is not working
dr["Watt"] = Txtwatt.Text.ToString();
error at this line :
Column 'Product' does not belong to table .

Zafar A khan 20-Jul-13 2:53am

End the session or rerun the application
because in old there is no column with name product.
or wash the history of your browsers clean the session
then restart your application this will fix the error

Bikash Prakash Dash · Answer 2 · 2013-07-19T21:13:00

Its a sample , try this as per your requirement

C#

   DataTable dtList = new DataTable();
   protected void Page_Load(object sender, EventArgs e)
   {
       if (!IsPostBack)
       {
           dtList.Columns.Add("Name");

           ViewState["Data"] = dtList;
       }

   }


 void SaveAndBindDatatable(DataTable dt)
    {
        ViewState["Data"] = dtList;
        GridView1.DataSource = dtList;
        GridView1.DataBind();
    }
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
        dtList = (DataTable)ViewState["Data"];
        dtList.Rows.Add(txtValue.Text.Trim());
        SaveAndBindDatatable(dtList);
}

Or follow this tip i've used datalist instead of gridview to make a custom auto suggestion control.
Auto Suggestion Control Like in GMail/Hotmail/Facebook[^]