Comments by paul_vin (Top 23 by date)

suppose I have put it on following path
D:\
then in following code what should be placed instead of "Product.xml"
xmlFile = XmlReader.Create("Product.xml", new XmlReaderSettings());


when I have Used as
using (XmlReader reader = XmlReader.Create(@"D:\VSTO_Vinayak\Product.xml"))
ds.ReadXml(reader);

it is giving exception as {"Could not find file 'D:\\VSTO_Vinayak\\Product.xml'.":"D:\\VSTO_Vinayak\\Product.xml"}

Its working but when I am assign list values to string variables if null then throwing exception

MSubject = iteam.Subject.ToString(); // if null throwing exception

if I put it into in if block to handle null
if(iteam.Subject.ToString()!=nuul)
{
MSubject = iteam.Subject.ToString();
}

then MSubject variable is not accessible outside
so how can handle this

ok thanks for Advice

I have written code but it is not giving Output as required above

DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX)

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(CompanyName)
from tblCompanyData
FOR XML PATH(''), TYPE
).value('.', 'NVARCHAR(MAX)')
,1,1,'')

set @query = 'SELECT Year,' + @cols + '
from
(
select [CompanyName]
,[Year]
,[Sales]
,[TradedSales]
,[TotalSales]
,[Taxes]
,[NetSales]
,[RowMaterial]
,[Power]
,[Consumables]
,[Salaries]
,[ManufacturingCost]
,[OtherExpenses]
,[TotalCost]
,[OperatingProfit]
,[Depreciation]
,[Interest]
,[Profitpostinterest]
,[IncomeTax]
,[NetProfit]
,[ID]
FROM tblCompanyData
) x
pivot
(
max(ID)
for CompanyName in (' + @cols + ')
) p '

execute(@query)

ok thanks

I want It for WebForm

Even I tried using
@mailserver_name = 'smtp.googlemail.com' its not working Same Error

I have also tried
@port = 587
@port = 465
but still error

Actually I dont know SMTP server so how can I find @mailserver_name from my PC

in My above case I have found @mailserver_name = 'google-public-dns-b.google.com'
using cmd promt
on command promt I have typed "nslookup" it had given me google-public-dns-b.google.com so for SMTP server How I can find It

where I SHOULD MENTION SMTP server address in my code

First thanks for above solution
How I should restrict to download single user at a time.
would you provide code to me and where I should integrate.
also I have used static path here but i want dynamic path so what changes I
should Do and where

Actually when user is login then fist time, it download file with no problem.
But when second time user click on download button then It giving above error Even after i have cleared data table. so for that what should I do. also I want to deploy
that solution on Live project at that time it should be download by any client on client machine in download folder so. so what path i should have to give to download on client Machine

ok thanks

[index].Value here Value showing Error i.e Red Line

Code now is

//foreach (DataColumn column in HeaderColumns.Columns)
//{
// string columnName = HeaderColumns.Rows[0][column.ColumnName].ToString();
//}
for (int index = 0; ; ++index)
{
string columnName = HeaderColumns.Rows[0][index].Value.ToString();
if (string.IsNullOrEmpty(columnName))
break;
// etc
}

Showing Error Object does not contain a definition for 'Value' accepting first argument of type object could not be found (are you missing) a using directive or an assembly reference

string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + path + ";Mode=Read;Extended Properties=Excel 12.0;Persist Security Info=False";

Even after trying Mode=Read it giving error
as
The Microsoft Access database engine cannot open or write to the file ''. It is already opened exclusively by another user, or you need permission to view and write its data.

Actually I dont Know how to share screenshot but problem is as bellow
After Click on Save Button It Display Empty Dialog Box with title as Error
And CloseButton
same for Update Button

and for Insert it is Showing "An error occured while communicating to the server".
and in developer tool It showing as Error in Developer Tool as Failed to load resource: the server responded with a status of 500 (Internal Server Error)

cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConStr"].ConnectionString);

Thanks.........!!!!