C# Discussion Boards - CodeProject

Re: How to insert data into a GridView from the textboxes

19-Oct-09 20:55

Hi all,

I have a Grid view on my page and I need it displayed on Page Load with only the column names. I then need to save data into the Grid view with values for the textboxes after clicking ADD button.

This is what I have but it doesn't do what I want to it to do.

Page_Load:
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
this.dgInfoProfile.DataSource = dt;
dgInfoProfile.DataBind();

}

ADD button:
protected void brtAdd_Click(object sender, EventArgs e)
{
try
{
////DataTable dt = new DataTable();
DataRow dr = dt.NewRow();
dr["Full Names"] = txtFirstName3.Text;
dr["Identifying Number"] = txtIdentityNo.Text;
dr["Passport Number"] = txtPassportNo.Text;
dt.Rows.Add(dr);

////Bind GridView Here with this Table
this.dgInfoProfile.DataSource = dt;
dgInfoProfile.DataBind();

}
catch (Exception ex)
{
Response.Write(ex.Message);
}

} Confused | :confused:

if you have any idea on how to get this done, I'd really appreciate your advise.

Thanks.

Calla19-Oct-09 21:12

Calla

19-Oct-09 21:12

Better suited in the ASP.NET forum.

Re: How to insert data into a GridView from the textboxes

Nopo19-Oct-09 21:23

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:23

I checked the ASP.Net forum first and find that someone has asked the same question and was told that it's not the right forum for such question.

I tried searching on the net but couldn't find how exactly to do it they want I want to.

I really need some help.
Confused | :confused:

nagendrathecoder19-Oct-09 21:26

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:26

Nopo wrote:
but it doesn't do what I want to it to do.

What are you getting after clicking ADD button.
Is this ASP.Net application or Windows application?

Nopo19-Oct-09 21:30

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:30

I get this error: "Column ‘Full Names’ does not belong to table". I'm using ASP.Net application.

nagendrathecoder19-Oct-09 21:38

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:38

Nopo wrote:
I'm using ASP.Net application.

Then you should have posted this on ASP.Net forum.
The guy you are talking about, is developing his application in windows forms thats why he is asked to post in windows form.

BTW, Are you definning protype of your DataTable?
Can i see that code?

Nopo19-Oct-09 21:42

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:42

Here is my code:

Page_Load:
protected void Page_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
this.dgInfoProfile.DataSource = dt;
dgInfoProfile.DataBind();

}

ADD button:
protected void brtAdd_Click(object sender, EventArgs e)
{
try
{
////DataTable dt = new DataTable();
DataRow dr = dt.NewRow();
dr["Full Names"] = txtFirstName3.Text;
dr["Identifying Number"] = txtIdentityNo.Text;
dr["Passport Number"] = txtPassportNo.Text;
dt.Rows.Add(dr);

////Bind GridView Here with this Table
this.dgInfoProfile.DataSource = dt;
dgInfoProfile.DataBind();

}
catch (Exception ex)
{
Response.Write(ex.Message);
}

}

nagendrathecoder19-Oct-09 21:45

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:45

Where are you definning columns of DataTable?

stancrm19-Oct-09 21:41

stancrm

19-Oct-09 21:41

"Page_Load" and "Response.Write" -> are ASP.NET.

First : Create your column first, you cannot write to a column, that doesn't exists.
DataTable dt = new DataTable();
dt.Columns.Add(new DataColumn("Full Names"));
dt.Columns.Add(new DataColumn("Identifying Number"));
dt.Columns.Add(new DataColumn("Passport Number"));
this.dgInfoProfile.DataSource = dt;
dgInfoProfile.DataBind();

Re: How to insert data into a GridView from the textboxes

nagendrathecoder19-Oct-09 21:42

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:42

This is what i am asking for, have you done this?

Nopo19-Oct-09 21:59

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:59

I've created the header columns in my design like this:

<asp:gridview id="dgInfoProfile" runat="server">
<columns>
<asp:boundfield headertext="Full Names">
<asp:boundfield headertext="Identifying Number">
<asp:boundfield headertext="Passort Number">

Didn't know that I have to define the columns in the code behind again.

stancrm19-Oct-09 22:01

stancrm

19-Oct-09 22:01

That's why, ask in ASP.NET forum, because what you've done is working in WinForm.

Re: How to insert data into a GridView from the textboxes

Nopo19-Oct-09 22:11

Re: How to insert data into a GridView from the textboxes

19-Oct-09 22:11

Thanks so much, really appreciate your help.
I'll ask in ASP.Net forum and also search on the net since I don't have some books at present.

nagendrathecoder19-Oct-09 22:04

Re: How to insert data into a GridView from the textboxes

19-Oct-09 22:04

Nopo wrote:
Didn't know that I have to define the columns in the code behind again.

Ofcourse you have to, these are columns of GridView, you has to define colums of DataTable then only you can create a DataRow.

I have a better suggestion.
Stop what you are doing, read a book first which will explain you about databindings with GridView or search and read some article(you'll find many on this site itself). I am sure, you don't have much knowledge about this.

nagendrathecoder19-Oct-09 21:51

Re: How to insert data into a GridView from the textboxes

19-Oct-09 21:51

Nopo wrote:
I need it displayed on Page Load with only the column names.

For this you have to use TemplateFields in GridView columns collection. Smile | :)

Nopo19-Oct-09 22:16

19-Oct-09 22:16

Thanks a lot. For more info I'll acquire in ASP.Net forum.

SSIS

Iain Wiseman19-Oct-09 20:37

Iain Wiseman

19-Oct-09 20:37

Hi all,

Hope this is in the correct forum. I have an issue with some work I am involved in. We have a flat file we are loading into an MSSQL database which is failing on the insert because the original flat file contains suspect data. Invalid dates or values etc. We are using SSIS to load this data. Can someone tell me if it is possible to exception these records easily.

requirements are
- to identify the number of records with the problem
- to identify these records
- to manage the issues which error

I am a project manager and do not want the wool pulled over my eyes. I am familar with C# and SQL server but have only seen SSIS over a shoulder of a developer.

I believe this would be a simple change and would be a matter of minutes to resolve. I am currently being led to believe it is hard.

Thanks all

J4amieC19-Oct-09 21:48

J4amieC

19-Oct-09 21:48

Its not really the right forum, this is for question to do with C# coding.

Happy to answer your question though.

Iain Wiseman wrote:
I believe this would be a simple change and would be a matter of minutes to resolve

NOTHING takes minutes to resolve - you should know that as a PM. Development, testing, deployment, bugfixing - a time estimate should take all of this (and more) into account.

Anything to do with SSIS is a royal PITA, nothing is quick and easy.

My best suggestion for this problem is to bulk load your text file into an empty table, and do the data clensing thereafter. All this can be achived easily with SSIS, but certainly not in a matter of minutes.

Iain Wiseman19-Oct-09 22:15

Iain Wiseman

19-Oct-09 22:15

Hi,

Thanks for replying. So you are saying that you cannot ignore errors easily in SSIS and count them. I C++ or java or C# this would be a try, carch cout which is a matter of minutes. I had hoped that microsoft would have made this easier.

Iain

J4amieC19-Oct-09 22:33

J4amieC

19-Oct-09 22:33

Iain Wiseman wrote:
Thanks for replying. So you are saying that you cannot ignore errors easily in SSIS and count them

Not knowing how your SSIS package is constructed makes answering this harder.

For a Data Flow task (which is the most likely thing you're using), you can often pipe errored rows to a separate file.

Its still not "minutes" work though Wink | ;)

Mycroft Holmes19-Oct-09 22:50

Mycroft Holmes

19-Oct-09 22:50

Jamie is correct, this will be a PITA to accomplish in SSIS. Anything that does the transform is bloody difficult, trapping the error rows would be a nightmare. SSIS and Biztalk are an attempt to dumb down the ETL layer so power users can do it - they FAILED.

I load my data into a table of varchar columns, the bulk copy does not care what the data is like then. I then use a stored proc to do the transorms. It is MUCH easier to manipulate the data in TSQL or C# than in SSIS.