Comments by Member 7763261 (Top 12 by date)

I have uncommented testobj.ReadData() and also used lblMessage from my testobj class to display messages but the progressbar runs only after. now do I have to declare use progressBar1Value from my testobj class to hold progress as well. because from what I have read I cannot access ui controls from dowork

Hi Richard,

Thank you for your response. Please bare with me as I am new to thing backgroundworker control. It seems like my progressbar only executes after the time consuming code of which I would like to update the progress bar to let the user know that the data is loading. how do I retrieve the result from that e object?

I also have this class to make it clear
class myWorkerClass
{

public string Employeename,status;


public int rows = 1;
public int Totrows;
public string connectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\IMAC\APP\IMACDB\FormDB.xlsx;Extended Properties='Excel 12.0;HDR=Yes;'";
public OleDbConnection cnn;
public OleDbCommand cmd;
public OleDbDataAdapter da;
public OleDbDataReader dr;
public DataSet dstResults = new DataSet();
public DataView myView = new DataView();
public DataTable dtable;
public DataColumn c;

/*Query strings*/
public string queryString = "SELECT Employee_ID,GID From [Entries$]";
public string countR = "SELECT COUNT(*) FROM [Entries$]";
public string mytables = "Entries$";


}
is there something wrong with my code? where do i set datasource to datagridview

When I run the code that using data adpater it jumps to private void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e)
{
if (e.Cancelled)
{
toolStripStatusLabel1.Text = "Cancelled by User Intentionally...";
toolStripProgressBar1.Value = 0;
}
// Check to see if an error occurred in the background process.
else if (e.Error != null)
{
toolStripStatusLabel1.Text = e.Error.Message;
}
else
{
// BackGround Task Completed with out Error
//dataGridView1.DataSource = Obj.myView;
toolStripStatusLabel1.Text = " All Records Loaded...";
}
}
This line toolStripStatusLabel1.Text = " All Records Loaded..."; Then the grid is empty and the progressbar also. I am not sure what am i doing wrong.

@Arvind Zamakia and @Graeme_Grant Thanks you so much for your assistance. I have managed to fix my query string. Actually the issue was in my Database since I am using excel. All I did was change Employee_ID to text. All is working fine now. Much thanks for assistance.

@Graeme_Grant

Thanks for your response. I have removed the extra quotes now I am getting this error "cannot perform like operation on system.double and system.string". The Employee_ID column I would like to convert to string is in a form of numbers from excel sheet as a db. am I converting the right way? Thanks for further assistance.

Yes kenneth my question is what am I doing wrong here because the ajax fuction is not posting the query to the relevant php file so that data can be processed i.e This function is not working and I cant peak up why I've tried to trace but I cant find the bug please me where I'm going wrong $.ajax({
type :"POST",
url :"inc/functions.php?action=newagent",
data : query,
success: function(data){
if (data =='Success'){
//setTimeout('proceed()',5000);
alert("Success using Jquery");
}
}});