datagrid problem! - ASP.NET Discussion Boards

How to save datagrid values in the database.

jaraldumary18-Jan-09 23:01

18-Jan-09 23:01

How to save an grid values in database (sql server 2005)at runtime..
Is there any link refer to me..

Thanx in advance..

Re: How to save datagrid values in the database.

SeMartens19-Jan-09 0:08

SeMartens

19-Jan-09 0:08

Hi,

maybe this link:

http://www.wherecanibuyit.co.uk/ASP/fully_editable_gridview.html[^]

or this one:

http://www.codeproject.com/KB/custom-controls/PSGridView.aspx[^]

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Re: How to save datagrid values in the database.

Reza Raad19-Jan-09 0:30

Reza Raad

19-Jan-09 0:30

what do you mean exactly??
did you mean you want to update/select/insert/delete data on database from datagrid??
if you mean this,don't worry this is a simple job,
just use SqlDataAdapter and set these commands for it:
SelectCommand
UpdateCommand
DeleteCommand
InsertCommand

see this sample for more details:
http://www.c-sharpcorner.com/UploadFile/raj1979/GridViewExample11232008075052AM/GridViewExample.aspx[^]

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: How to save datagrid values in the database.

jaraldumary19-Jan-09 0:49

jaraldumary

19-Jan-09 0:49

No i dont want to edit,update,select command.For example if i am loading an xml file to the project during run time.that particular file details must stored in database automatically...
help me.

Thanx in advance.

Re: How to save datagrid values in the database.

Reza Raad19-Jan-09 9:14

Reza Raad

19-Jan-09 9:14

in general you can export your xml data to sqlserver using SSIS(Integration Service)
but if you mean that your xml data binded to a grid and you want to insert these data into sqlserver from your grid, i think you can generate a datatable from your grid data, and then insert your datatable into sqlserver table completely.

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

diff. betn selection methods for XML [modified]

Member 398136618-Jan-09 20:25

Member 3981366

18-Jan-09 20:25

for asp.net 2.0 What is difference between following methods for selecting XML data. which one is better interms of performace.

1) Dataset.select
2) dataview
3) xmlDocument.SelectNodes
4) xmlNavigator.select

modified on Monday, January 19, 2009 2:41 AM

Re: diff. betn selection methods for XML

N a v a n e e t h18-Jan-09 21:09

N a v a n e e t h

18-Jan-09 21:09

Member 3981366 wrote:
Dataset.select

There is no Select method in DataSet class. Also, DataSet is not designed for XML manipulations.

Member 3981366 wrote:
dataview

What this has to do with XML?

Member 3981366 wrote:
xmlDocument.SelectNodes

XMLDocument.SelectNodes or XMLDocument.SelectSingleNode with XPath expression will be fast.

Member 3981366 wrote:
xmlNavigator.select

AFAIK, this class is no longer used.

Navaneeth

How to use google | Ask smart questions

datagrid problem!

RajpootRohan18-Jan-09 20:09

RajpootRohan

18-Jan-09 20:09

Hi to all,

I have a datagrid in which there is a checkbox and a textbox.
The user can change the value in textbox.
below there is update button.When the user presses the update button
the textbox value should be updated.

For this I have done this:

protected void BtnUpdate_Click(object sender, EventArgs e)
{
    dt = (DataTable)Session["data"];
    DataGrid2.DataSource = dt;
    DataGrid2.DataBind();

    //if I will not bind then it will not go in foreach loop.
    //as it will not find any items in the datagrid.

    CheckBox chkSelected = new CheckBox();

    foreach (DataGridItem dgItem in DataGrid2.Items)
    {
        chkSelected = (CheckBox)dgItem.FindControl("chkSelection");

        if (chkSelected.Checked != true)
        {
            TextBox TxtQTY = (TextBox)dgItem.Cells[2].FindControl("TxtQTY");
            string Txt2 = TxtQTY.Text;

        }
        else
        {
            int a = 1;
        }

    }

}

The problem is that this functionality is not taking the user input.
In the starting I have done databing because of which it is taking the previous value.But if I will not bind the data It is not going in the foreach loop to check wether any checkbox is selected or not as in debugging it is showing that the item collection in the datagrid is empty.

Please give some suggestions...
Thanks in advance.

cheers,
sneha

Re: datagrid problem!

Aman Bhullar18-Jan-09 20:38

Aman Bhullar

18-Jan-09 20:38

sneha Choudhary wrote:
dt = (DataTable)Session["data"];
DataGrid2.DataSource = dt;
DataGrid2.DataBind();

Problem is in above code.
You are rebinding DataGrid before fetching new values from textbox. This will over write all the previously entered text.

Try moving this code after you have read value from textbox

Re: datagrid problem!

_AK_18-Jan-09 21:53

_AK_

18-Jan-09 21:53

Why is the datagrid losing all the items. You may be doing something before reaching to this event.

Apurva Kaushal

Re: datagrid problem!

N a v a n e e t h18-Jan-09 22:16

N a v a n e e t h

18-Jan-09 22:16

sneha Choudhary wrote:
DataGrid2.DataSource = dt;
DataGrid2.DataBind();

This will clear the values changed in the textbox. Why do you need to rebind the grid?

sneha Choudhary wrote:
//if I will not bind then it will not go in foreach loop.
//as it will not find any items in the datagrid.

Which event are you using for binding the grid? Is viewstate enabled for this control?

Navaneeth

How to use google | Ask smart questions

Re: datagrid problem!

RajpootRohan18-Jan-09 22:53

RajpootRohan

18-Jan-09 22:53

Hi,
I got the problem.Actually It was regarding the postback.

Thanks a lot.

cheers,
sneha

indicator to show online or offline

meghamaharshi18-Jan-09 19:45

meghamaharshi

18-Jan-09 19:45

Hello everybody..in my application i have to show a indication whether i am connected to internet or not..

Re: indicator to show online or offline

Abhijit Jana18-Jan-09 20:05

Abhijit Jana

18-Jan-09 20:05

meghamaharshi wrote:
in my application i have to show a indication whether i am connected to internet or not..

You want to mean , that you need to show all the user list that are currently logged in into your application ?

cheers,
Abhijit
CodeProject MVP
My Recent Article : Exploring Session in ASP.Net

Re: indicator to show online or offline

meghamaharshi18-Jan-09 20:37

meghamaharshi

18-Jan-09 20:37

Thanks for reply..
But i just want to show the status internet is on or not...

Re: indicator to show online or offline

_AK_18-Jan-09 22:03

_AK_

18-Jan-09 22:03

If it is a web application (not intranet) then obviously the user is connected to internet. Smile | :)

Apurva Kaushal

Re: indicator to show online or offline

meghamaharshi18-Jan-09 22:19

meghamaharshi

18-Jan-09 22:19

its web application which is being run on Lan making virtual directory..

Re: indicator to show online or offline

Abhishek Sur18-Jan-09 20:40

Abhishek Sur

18-Jan-09 20:40

do you really want this in your web application. Bcos we often need this for Windows Application.
For windows use:
System.Net.NetworkInformation.NetworkChange.NetworkAvailabilityChanged += new System.Net.NetworkInformation.NetworkAvailabilityChangedEventHandler(NetWorkChangedCallback);

Abhishek Sur

Re: indicator to show online or offline

meghamaharshi18-Jan-09 20:44

meghamaharshi

18-Jan-09 20:44

yes i want it for web application..

Re: indicator to show online or offline

Christian Graus19-Jan-09 2:08

Christian Graus

19-Jan-09 2:08

This has to be the dumbest thing I have ever heard.

If you're on a LAN and you want to know if an internet connection exists or not, just ping google or microsoft and if you get a reply or not, you'll know if you're online.

Christian Graus

Driven to the arms of OSX by Vista.

Re: indicator to show online or offline

Abhishek Sur19-Jan-09 20:11

Abhishek Sur

19-Jan-09 20:11

Yes Christian is Right.
For web application, just make an object of XMLHttpRequest and do an AJAX call to any page using SetInterval, so that this ajax call will occur after a certain time. And show the status message based on the reply from the server.

Thats all is possible in WEB... Cool | :cool:

Abhishek Sur

Directory Path in webserver

C#Coudou18-Jan-09 19:09

C#Coudou

18-Jan-09 19:09

hi mates,

how would i know the full directory path of web host server. I couldn't connect to my database (Web Hosting Suite). In my local machine it is C:\Inetpub\wwwroot\mywebsite\kijun.mdb.

I tried the DSN Management in Web Space Configuration but it seems only mysql is available and my database is oledb.

Thanks in advance. Wink | ;)

C# コードMicrosoft End User
2000-2008

「「「「「「「「「「「「「「「「「「「「「「「「「「「「
The best things in life are free
」」」」」」」」」」」」」」」」」」」」」」」」」」」」

Re: Directory Path in webserver

Reza Raad18-Jan-09 20:17

Reza Raad

18-Jan-09 20:17

Try this:
Server.MapPath();

more information here:
http://msdn.microsoft.com/en-us/library/ms524632.aspx[^]

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Re: Directory Path in webserver [modified]

C#Coudou18-Jan-09 20:20

C#Coudou

18-Jan-09 20:20

Server.MapPath();

no, not this one.

what i mean is i have a free ASP.NET host. I can only access the control panel and ftp. But i don't know where they put the wwwroot directory.
I want to know where they put the directory path of wwwroot so that i can put the connection string on the webconfig file.

modified on Monday, January 19, 2009 2:41 AM

Re: Directory Path in webserver

Reza Raad18-Jan-09 23:20

Reza Raad

18-Jan-09 23:20

C#Coudou wrote:
what i mean is i have a free ASP.NET host. I can only access the control panel and ftp. But i don't know where they put the wwwroot directory.
I want to know where they put the directory path of wwwroot so that i can put the connection string on the webconfig file.

I mean this too,
try this:
create a simple aspx page with this code on page_load:

Response.Write(Server.MapPath(""));

then upload the aspx page on your free host, and browse it and see your result.

Human knowledge belongs to the world
http://www.rad.pasfu.com/index.php

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.