Comments by madhusudhan.k (Top 23 by date)

exec master..xp_cmdshell 'c:\progra~1\intern~1\iexplore.exe www.sqlteam.com'


Change the path to iexplore.exe as per your machine setup

then this site is bullsh*t, it is not good as like other site

I want to write Microsoft exam, which are all the basic certification for web developers

Hi John Simmons,
Still it is throwing the same exception.
When I select the line & go to quick watch means it shows the value as 'Expression cannot contains lambda expressions'.

Regards
Madhu

Hi Al-Farooque Shubho,
thanks for ur post. But still it is showing the same exception.
When I select the line & go to quick watch means it shows the value as 'Expression cannot contains lambda expressions'.

Regards
Madhu

Hi Blesson Mathew,
Thanks a lot, the links which you have sent is useful for me.

Regards
Madhu

Frndz other than this site is there any site to download free vedio tutorial for MVC.Net

Frndz other than this site is there any site to download free vedio tutorial for MVC.Net

Frndz other than this site is there any site to download free vedio tutorial for MVC.Net

Hi ANSAI
Thanks for your post.

Regards
Madhu

Here they have written in console application, but i want in web application, Iam not getting how to read the excel sheet.
Please if you know then can help me.

Thanks
Regards
Madhusudhan

Thanks Sengupta, I have gone throw this link once before, but im not getting, please can guide me.

Regards
Madhusudhan

Hi Moshu,
This is my conection string:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;HDR=Yes;IMEX=1"

but Im gettg exception as: could not find installable ISAM.

Please can help me.

Thanks
Madhusudhan

Thanks a lot Moshu

Hi Marcus Kramer,
Thanks for ur help, but again its throwing exception as the file path is incorrect. When I give the correct file path means it will throw exception as I said u before.

Regards
Madhusudhan

This is the code what i have written in class library file(TableBS).the below method im calling in controller class using the object. Iam gettg the exception in ("SELECT * FROM [Sheet1$]", conn); as )excepted.


public string getTable()
{
XElement xml = null;
try
{
string strConnectionString ;
string filename = @"C:\Documents and Settings\madhusudhank\My Documents\Visual Studio 2008\Projects\AqumenSport\AqumenSportWeb\Content\Demo.xls";
if (Path.GetExtension(filename).ToLower() == ".xlsx")
{
strConnectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0", filename);
OleDbConnection conn = new OleDbConnection(strConnectionString);
conn.Open();
OleDbCommand dataCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);
OleDbDataAdapter da = new OleDbDataAdapter(dataCommand);
DataSet ds = new DataSet();
da.Fill(ds);
xml = new XElement("Table");
xml.Add(from data in ds.Tables[0].AsEnumerable()
select data);
}
else if (Path.GetExtension(filename).ToLower() == ".xls")
{

strConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=Excel 8.0", filename);
OleDbConnection conn = new OleDbConnection(strConnectionString);
conn.Open();
OleDbCommand dataCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", conn);
OleDbDataAdapter da = new OleDbDataAdapter(dataCommand);
DataSet ds = new DataSet();
da.Fill(ds);
xml = new XElement("Table");
xml.Add(from data in ds.Tables[0].AsEnumerable()
select data);
}




return xml.ToString();
}
catch (Exception ex)
{

Log(ex.Message.ToString(), "MenuBS", "getTable");
return "<Table/>";
}
finally
{
xml = null;
}
}

sorry to say that, actually i want to reload a particular control(DropdownList).
Iam designing the page in xslt using HTML.
Hope u understood..

Thanks
Madhusudhan