Comments by Tausif/Pintu

Tausif/Pintu 10-May-14 8:54am View

thanks

Tausif/Pintu 24-Apr-14 10:07am View

Hi,

Thanks for reply. But it's a hosted server. I am getting only above mention error.
Same application working on Windows XP.

On Windows XP we deploy same application & create virtual directory.
And we also create another virtual directory for Crystal Report. It working properly in local environment.

Tausif/Pintu 9-Oct-13 3:08am View

Thanks Adrishya, This link is useful for me..

Tausif/Pintu 1-Oct-13 7:04am View

Thanks Richard, I got solution. I just deleted this file from Bin folder and Its working.

Tausif/Pintu 30-Sep-13 8:02am View

but there is no such file in old project, I added Microsoft.Office.Excel.dll in my new project.

Tausif/Pintu 30-Sep-13 7:59am View

I just converted my application Visual Studio 2008 to 2010, after that this problem arises,
all excel files in project are closed

Tausif/Pintu 30-Sep-13 7:43am View

Deleted

Due to this problem I unable to publish my project, my project run properly but It gives error while publishing.

Tausif/Pintu 30-Sep-13 5:39am View

I rebuilt it several times but not working, This problem arises when publishing the project otherwise my project work fine.

Tausif/Pintu 23-Sep-13 3:21am View

Thanks for reply, There was problem in connection string, It required port number of hosting, I solved this problem.

Tausif/Pintu 20-Sep-13 6:23am View

This is my code
public DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText)
{
DataSet ds = new DataSet();
using (MySqlConnection cn = new MySqlConnection(connectionString))
{
MySqlCommand cmd = new MySqlCommand(commandText, cn);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);

try
{
da.Fill(ds);
}
catch (Exception ex)
{
errorDescription = ex.Message.ToString().Replace("\n", "");
string s = errorDescription.Substring(0, 6);
if (errorDescription.Substring(0, 6) == "#42000")
{
MySqlCommand cmd1 = new MySqlCommand("SET SQL_BIG_SELECTS = 1", cn);
try
{
cn.Open();
cmd1.ExecuteNonQuery();
da.Fill(ds);
}
catch (Exception)
{
errorDescription = ex.Message.ToString().Replace("\n", "");
SendToErrorPage(errorDescription);
}
finally
{
cmd1.Parameters.Clear();
cmd1.Dispose();
cn.Close();
}
}
else
{
SendToErrorPage(errorDescription);
}
}
finally
{
cmd.Parameters.Clear();
cmd.Dispose();
cn.Dispose();
}
}
replaceCorrectValues(ds);
return ds;

}

It open connection and executed the query very well but fail at time of filling data in dataset and gives posted error.

Tausif/Pintu 16-Sep-13 3:03am View

Deleted

Please Help

Comments by Tausif/Pintu (Top 11 by date)