ASP.NET

20-Dec-06 9:23

if you are using sql server it is so much easier to create a dts package, use the vb.net app to save the .csv file to the proper location then call the dts package from you app.

Other wise check here for a C# example that you can convert to vb.net.

Modifing web gridview control

Quecumber25620-Dec-06 8:52

Quecumber256

20-Dec-06 8:52

Hi Everyone:
I have a unique requirement. I need to display data in a gridview and be able to add, edit or delete records from a web page using the gridview control.

The web control "FormView" will do all the operations, but it only shows one record at a time. The Gridview control shows all the records and will allow the user the ability to edit and delete records, but not add new ones.

Does anyone know how to combine the viewing capibilities of a gridvierw control and the record operations of the FormView into a single control?

Thanks in advance,

Mark McCumber

ToddHileHoffer20-Dec-06 9:07

20-Dec-06 9:07

Mark, I have never used the "FormView" control. What I have done in the past is to store my gridview data as a DataTable serialized in ViewState. Then I give the user the option to add a new record and then add a new row to the datatable retreived from Viewstate and rebind it to the grid view.

Quecumber25620-Dec-06 9:29

Quecumber256

20-Dec-06 9:29

The FormView control will automatically add a new record to a SQL database if you have the sqldatasource control configured to allow edits, deletes and inserts.

The formview control was built for data entry, but it would not show all the records like a gridview. My IT manager wants the form to look something like an Excel spread sheet, but have the fields in columnar form so the person entering the data can't make mistakes.

Thanks,

Mark McCumber

ToddHileHoffer20-Dec-06 9:51

20-Dec-06 9:51

Oh well, I tried. It looks like you might have to do some programming instead of just relying on .net webcontrols.

Quecumber25620-Dec-06 10:26

Quecumber256

20-Dec-06 10:26

I was afraid of that Smile | :)

. I'm trying to create a Web based application that behaves like a Windows application. One that has a form and as you click the next button the data in the form changes.

Nothing is ever easy. I have always wondered why they call it "Rapid Development" when you still have to create code to do the required tasks.

Mark McCumber

Sort Datagrid

ADY00720-Dec-06 7:58

ADY007

20-Dec-06 7:58

Hi, I want to fill a datagrid from an ms access and i want to fill the datagrid in an ascending order. I want the last row of the database to be viewed in the first row of the datagrid. how can i do that? I have an autonumber as a primary key so that can give me some chance to make this happen. but how pls??

Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.

Re: Sort Datagrid

ToddHileHoffer20-Dec-06 8:14

20-Dec-06 8:14

If you are using a datatable, you can sort those.
Dataview dv = new Dataview(DataTable);
dv.sort = "AutoId desc";
DataTable = dv.toTable();
datagrid.datasource = DataTable;
datagrid.databind();

render values from check box and update to database on button click

Re: Sort Datagrid

ADY00720-Dec-06 10:08

ADY007

20-Dec-06 10:08

i am not using any data table. How can you use the Order by Asc?

Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.

Re: Sort Datagrid

Haissam20-Dec-06 11:09

Haissam

20-Dec-06 11:09

You have to use DataView to enable the sorting
just insert that table in dataview and call the sort property by giving the column name and ASC or DESC

example
dataView1.Sort = "Country DESC";

Happy Coding

Best Regards,
Haissam Abdul Malak
My Blog

srishree20-Dec-06 7:56

srishree

20-Dec-06 7:56

I have a gridview which contains columns retreived from the database.i have in total 12 columns,in which 4 columns have checkbox's where ever there is a null in the database.i have done tht on the rowdatabound event of gridview dynamically by calling

CheckBox cb= new CheckBox();

i also have a checkbox in the first column of the gridview created using an itemTemplate tag of gridview,so tht when we check the corresponding row's checkbox,the values in tht row shall be updated
now my question is,i want to check the boxes in the column cells and update those corresponding row values in the database on button click.and also i need the checkbox state to be maintained.......how can i do this?any responses will be appreciated.

Re: render values from check box and update to database on button click

ToddHileHoffer20-Dec-06 8:11

20-Dec-06 8:11

To make this just a bit easier. Create a template column in your gridview. Hide the checkboxe in the itembound event when the database value is null. That solves the problem of maintaining the viewstate of the grid.

Now to loop through your gridview. Here is some sample code to put behind your button (or during any event really).

CheckBox cb;
foreach (GridViewRow r in this.GridView1.Rows)
{
cb = (CheckBox)r.FindControl("cbUpdate");
if (cb.Checked)
{
//put code to update database
}
}

Re: render values from check box and update to database on button click

srishree20-Dec-06 9:34

srishree

20-Dec-06 9:34

Thanks for the reply.but it has not solved my problem completely.i have done similar to what u have replied,but in my case i need to loop through the inner cells of the gridview and as well the rows and check if there is a checkbox at any cell in the gridview,if exists,based upon my requirement i have to click the checkbox in those cells and also check the checkbox in the first column,and then update.what i want is to check the checkbox in the gridview cells and also the checkbox field created using the itemtemplate in the gridview.when i check the cells with checkboxes and then check the checkbox that is existing in the first column of the gridview and click the update button,then the data in the corresponding row should update.....

Re: render values from check box and update to database on button click

ToddHileHoffer20-Dec-06 9:52

20-Dec-06 9:52

srishree wrote:
Thanks for the reply.but it has not solved my problem completely.i have done similar to what u have replied,but in my case i need to loop through the inner cells of the gridview and as well the rows and check if there is a checkbox at any cell in the gridview,if exists,based upon my requirement i have to click the checkbox in those cells and also check the checkbox in the first column,and then update.what i want is to check the checkbox in the gridview cells and also the checkbox field created using the itemtemplate in the gridview.when i check the cells with checkboxes and then check the checkbox that is existing in the first column of the gridview and click the update button,then the data in the corresponding row should update.....

Do you have a question?

Re: render values from check box and update to database on button click

srishree20-Dec-06 10:06

srishree

20-Dec-06 10:06

yes,the question is in my previous mail,to simultaneously check the chekbox in the cells of cells[7],cells[8],cells[10],cells[11] and then click the checkbox in the itemtemplate to update it to the database.

how to do this?

DataGrid not fiiring ItemDataBound event

gems521620-Dec-06 6:21

gems5216

20-Dec-06 6:21

The Data Grid (at class level):

Protected WithEvents dgProducts As System.Web.UI.WebControls.DataGrid

Setting up the event handler (in a method called from Form_Load):

AddHandler dgProducts.ItemDataBound, AddressOf dgProducts_ItemDataBound

The event handler:

Private Sub dgProducts_ItemDataBound(ByVal sender As System.Object, ByVal e As DataGridItemEventArgs)

dgItemDataBound(sender, e, dgProducts, "ddl_4")

End Sub

The problem (VB.Net, ASP.Net v1.1):

A breakpoint set on the single line of this event handler is never hit even though this DataGrid does contain a DataBound column that does display data.

Eric

Re: DataGrid not fiiring ItemDataBound event

ToddHileHoffer20-Dec-06 7:09

20-Dec-06 7:09

I think in VB.Net you need to put the handles keyword after the method.

<br />
Private Sub dgProducts_ItemDataBound(ByVal sender As System.Object, ByVal e As DataGridItemEventArgs) handles dgProducts.ItemDataBound<br />

Re: DataGrid not fiiring ItemDataBound event

gems521620-Dec-06 7:25

gems5216

20-Dec-06 7:25

Thanks... that did the trick!

Eric

Web application on a network

MoeInsairat20-Dec-06 4:57

MoeInsairat

20-Dec-06 4:57

Hello guys

Iam building a web application and i wonder if my pc was on a LAN can other computers on the same LAN open my application using a browser... like http://Ipaddress.... mypage.aspx

cuz i was trying to open my application from another computer on the lan, and i couldn't open it.

thanks in advance

Regards

Estarta

Re: Web application on a network

ToddHileHoffer20-Dec-06 5:20

20-Dec-06 5:20

It should work just fine. It could be your machine has a firewall. Also, in IIS unchceck the allow anonymous access check box.