ASP.NET

Re: how to display data in grid without sending the data in the database

9-Nov-09 18:57

In a web based application i have some textboxes and on the button click the data from the textboxes should be displayed in a gridview or some other conrol where the data can be displayed, modified such that the data be sent back to the textboxes for modifying and back into the gridview .Another button for deleting the data and finally on the click of a button that is outside the gridview the data from it should go into the database.
I was able get the data into the gridview from the textboxes to the grid and back using the
select "textbox1.text" as data1,"textbox2.text"as data2 etc.and was able to modify the data.but for deleting the row i was not able to trace which row is getting deleted and am not able to sent the data to the database on the button click outside the gridview.What should I do? is there some way i can use the gridview itself for the same or i should use some other conrol ?

Christian Graus9-Nov-09 19:02

Re: how to display data in grid without sending the data in the database

9-Nov-09 19:02

You can use a list of objects as a datasource. You don't need to use a database.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Satish Mahapatra9-Nov-09 19:44

Satish Mahapatra

9-Nov-09 19:44

Why dont u store the IDs of the deleted records and during saving the grid to DB delete the records from DB using thoseIDs.

Re: how to display data in grid without sending the data in the database

Flavia A9-Nov-09 22:19

Re: how to display data in grid without sending the data in the database

9-Nov-09 22:19

thanks for the reply..

if i used 2 link button and both have the same command name select on the selected index changed of the gridview i am not able to trace which button has been clicked if the delete or the modify.more over if i use the command name update for the delete button and call the GridView1_RowUpdating event i cannot retain the the gridview1.selectedrow.cells[1].text. for deleting where i update the delete status to be Yes.
As it is a web application on the button click outside the grid cannot retain the gridview1.SelectedRow.cells[0].text cannot be retreived and it throws an enception.
what should i do is there anything optional to a gridview.
Please reply soon

Satish Mahapatra9-Nov-09 23:38

Satish Mahapatra

9-Nov-09 23:38

I tried your case,deleting the rows by clicking the delete button in each row.then i saved the PK of each row and finally during saving delete those rows by using the IDs.

I just put a column for ID which has the commandargument set to id,on delete event i was getting the IDs by this
int rowIndex = e.RowIndex;
LinkButton lnk = (LinkButton)GridView1.Rows[rowIndex].FindControl("lnkID");

Is it the case that u are searching or anything else.

Re: how to display data in grid without sending the data in the database

Flavia A10-Nov-09 0:27

Re: how to display data in grid without retreiving data from the database and later the dat from the gridview should go into the database.

10-Nov-09 0:27

thanks i will try it and tell you.

Flavia A10-Nov-09 0:51

connection with my sql with ASP.Net

10-Nov-09 0:51

am sorry for the trouble am new to asp.net ,but as the data in the grid is not from the database but from the textboxes in the form.as the data is not actually in the database i cannot delete the row by using a query.That row has to be out of the grid as soon as i pess the delete button,add on the click of a button that is outside the gridview,i want all the data to go into the database.ie am using the gridview so that the user can modify any entry that he made in the textboxes and delete the rows that he wants and send it to the database later..

Amit Patel19859-Nov-09 18:30

9-Nov-09 18:30

Hi All,

I want to connect Asp.net application with the my sql 5.0.please help me which driver need to be installed.

when i m tring to open the connection this is giving error

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

and my connection string is

string ConnStr = "Driver={MySQL ODBC 5.0 Driver};Server=localhost;Database=testwithdotnet;uid=root;pwd=password;Port=3306;Option=3";

and i installed this MySQL Connector Net 5.1.7 diver

Thanks and regards,

Amit Patel

Christian Graus9-Nov-09 18:46

9-Nov-09 18:46

I've never seen the driver specified in the connection string, I've just installed the right classes to deal with the data source, and used them.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Gamzun9-Nov-09 20:06

Gamzun

9-Nov-09 20:06

Try this An ASP.NET Application Using a MySQL Database[^]

Please don't forget to mark 'Good Answer', if you find it really a good one!

Kashif

found solution

Amit Patel19859-Nov-09 20:21

9-Nov-09 20:21

Hi All,

Thanks all . I have solved this problem

using following way

MySqlConnection con = new MySqlConnection(("server=127.0.0.1; user id=root; password=password; database=testwithdotnet; pooling=false;"));

Thanks and regards,

Amit Patel

modified on Tuesday, November 10, 2009 2:57 AM

Re: found solution

Christian Graus9-Nov-09 21:09

9-Nov-09 21:09

Well, that's what we both told you to do, so....

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

[Message Deleted]

Amit Patel19859-Nov-09 18:30

9-Nov-09 18:30

[Message Deleted]

N a v a n e e t h9-Nov-09 18:31

N a v a n e e t h

9-Nov-09 18:31

Use the connector[^] provided by MySql folks.

Best wishes,
Navaneeth

Amit Patel19859-Nov-09 18:46

9-Nov-09 18:46

hi ,

i m using this

string ConnStr = "Driver={MySQL ODBC 6.1.2 Driver};Server=localhost;Database=testwithdotnet;uid=root;pwd=password;Port=3306;Option=3";

OdbcConnection odbcConnection = new OdbcConnection(ConnStr);
OdbcCommand cmd = new OdbcCommand("SELECT * FROM amit", odbcConnection);
odbcConnection.Open();

but this is giving following error.

ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

thanks and regards,
amit patel

Christian Graus9-Nov-09 18:47

Async updates to DB without BackgroundWorker

9-Nov-09 18:47

Amit Patel1985 wrote:
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

What makes you think this error is wrong ? What leads you to believe that the connection string is pointing to a valid driver ? Have you installed/configured one for ODBC ?

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

student_rhr9-Nov-09 12:40

student_rhr

9-Nov-09 12:40

Hi,

In my ASP.NET application, I have a situation where I am doing a lot of computing and database reads/inserts/updates.
I needed to gather statistics on the processing records. This info is actually displayed on another webpage. Processing routine looks something like this:

public void Process()
{
    int recordCount = 0;
    ProgressHelper.Start();
    while(processing)    
    {
        //Actual processing logic
        recordCount++;

        //Every 10 processed records, update the progress table
        if(recordCount % 10 == 0)
        {
           ProgressHelper.UpdateProcessedRecordCount(recordCount); 
        }
    }
    ProgressHelper.End();
}

These database calls to update the progress add additional delay.

I was wondering if there is a way to actually execute all the ProgressHelper stuff asynchronously (without using background worker)? (perhaps delegates ... but are delegates really async?)

Re: Async updates to DB without BackgroundWorker

N a v a n e e t h9-Nov-09 15:32

N a v a n e e t h

9-Nov-09 15:32

What is ProgressHelper?

BackgroundWorker is a class designed for windows applications not web applications. So using it in a web application is not a good idea. If I understood your question, you need to do a time consuming task on background and show a progress bar on another ASP.NET page, correct?

If yes, follow the below steps.

From the first page, start a thread (or better if you can use ThreadPool) and run the Process() method on that.
This method should update the progress to a session variable say Session["progress"]
Once the thread started, redirect to the page where progress will be displayed
Use AJAX and poll the Session["progress"] value and show it on the page. For creating progress bar, you can use HTML DIV tag with a background color.

You need to pass HttpContext.Current to the Process() method because it is thread specific and a worker thread won't have access to it. Use this context to access the session.

Hope that helps Smile | :)

Best wishes,
Navaneeth

Re: Async updates to DB without BackgroundWorker

student_rhr10-Nov-09 5:10

student_rhr

10-Nov-09 5:10

Thanks Navaneeth. ProgressHelper is my internal DAL responsible for udpating the progress table (sorry I should have explained). I agree with you that BackgroundWorker is a bad idea that's why I was wondering if there might be a better way to accomplish this.

Also, what are your thoughts about Async Delegates? Have you seen any adverse effects of using them in ASP.NET?

Appreciate your hlep!

Re: Async updates to DB without BackgroundWorker

N a v a n e e t h10-Nov-09 14:41

N a v a n e e t h

10-Nov-09 14:41

student_rhr wrote:
I agree with you that BackgroundWorker is a bad idea that's why I was wondering if there might be a better way to accomplish this.

See the point 1 in my first reply.

student_rhr wrote:
Also, what are your thoughts about Async Delegates? Have you seen any adverse effects of using them in ASP.NET?

Asynchronous pattern will make your code unnecessarily complicated. So I'd stay away from it unless there is a strong need for using it. As I said, work with Thread or ThreadPool directly.

Best wishes,
Navaneeth

how to connect to the pop3 server from web page

amalatsliit9-Nov-09 11:45

amalatsliit

9-Nov-09 11:45

Hi,
I need to develope web site which connect to the pop3 mail server and populate all emails in a grid.
so after user can select emails from grid and can delete unnecessary mails through grid.

i have search lot of samples most of them are windows based.does any body know or can direct me to correct path.

i'm using .net 3.5 with sql server 2008.

thankx

Re: how to connect to the pop3 server from web page

Christian Graus9-Nov-09 11:51