|
Hai all,
i had some code which is hard coded...
like
<private function="" getsmsuriforclickatellgateway()="" as="" string<br="" mode="hold"> Const strUserID As String = "zoo"
Const strpwd As String = "test"
Const strapiID As String = "301"
Const strFrom As String = "zoo"
Const strurl As String = "http://api.xyz.com/http/sen?"
Dim strUseURL As String = ""
Dim strSMSURL As String = "" >
my requirement is that hard coded data will be taken in xml file and that xml data will be swnded to another file (like sms or mail)
Thanks
Subbu.
|
|
|
|
|
check this out:
http://www.exforsys.com/tutorials/vb.net-2005/using-xml-data.html
|
|
|
|
|
Hi Please Help me,
I am generating one excel file in button click …it’s working in local system…but when I deploy in server it shows following error…..
My system contain office 2003 .but server contain 2007 …I think it is not an issue ….....
Exception from HRESULT: 0x800A03EC
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x800A03EC
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[COMException (0x800a03ec): Exception from HRESULT: 0x800A03EC]
Excel.WorkbookClass.SaveAs(Object Filename, Object FileFormat, Object Password, Object WriteResPassword, Object ReadOnlyRecommended, Object CreateBackup, XlSaveAsAccessMode AccessMode, Object ConflictResolution, Object AddToMru, Object TextCodepage, Object TextVisualLayout, Object Local) +0
CustomizeExcel.excel_view(DataSet ReportDetails, String Heading, String Filepath) +2245
Forms_frmStoreVendorEnquiry.ExportExecl() +124
Forms_frmStoreVendorEnquiry.btnMail_Click(Object sender, ImageClickEventArgs e) +450
System.Web.UI.WebControls.ImageButton.OnClick(ImageClickEventArgs e) +86
System.Web.UI.WebControls.ImageButton.RaisePostBackEvent(String eventArgument) +115
System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1746
I am using Bellow Code for generate Excel File
public static string excel_view(DataSet ReportDetails, string Heading, string Filepath)
{
Application excelApp = new ApplicationClass();
excelApp.Visible = false;
string workbookPath = Filepath;
Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, true, 5, "", "", true, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
Excel.Sheets excelSheets = excelWorkbook.Worksheets;
string currentSheet = "rigvessel";
Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);
//excelWorksheet.SaveAs("D:/APR-14-VSS/OutBound/Test12345.xls", Excel.XlFileFormat.xlExcel4Workbook, Type.Missing, Type.Missing, Type.Missing
// , Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
string strRange;
int intAscii = 65;
Range mycell = (Range)excelWorksheet.get_Range("D14", "D14");
mycell.Value2 = Heading;
mycell.Font.Bold = true;
mycell.Font.Size = 12;
for (int xlcol = 0; xlcol < ReportDetails.Tables[0].Columns.Count; xlcol++)
{
strRange = Convert.ToChar(intAscii).ToString();
Range excelCell = (Range)excelWorksheet.get_Range(strRange + 21, strRange + 21);
//excelCell.Font.Bold = true;
excelCell.ColumnWidth = 15;
excelCell.Interior.ColorIndex = 37;
excelCell.Value2 = ReportDetails.Tables[0].Columns[xlcol].ColumnName.ToString();
Range mycell1 = (Range)excelWorksheet.get_Range("D21", "D21");
mycell1.ColumnWidth = 30;
Range EnquiryNo = (Range)excelWorksheet.get_Range("F15", "G15");
Range JobId = (Range)excelWorksheet.get_Range("F16", "F16");
Range date = (Range)excelWorksheet.get_Range("F17", "F17");
Range ClientName = (Range)excelWorksheet.get_Range("A16", "A16");
Range KindAttention = (Range)excelWorksheet.get_Range("A18", "A18");
//EnquiryNo.Value2 = "EnquiryId"+ReportDetails.Tables[1].Columns[xlcol].ColumnName.ToString();
JobId.Value2 = "JOBID :" + ReportDetails.Tables[1].Rows[0]["jobId"];
date.Value2 = "DATE :" + ReportDetails.Tables[1].Rows[0]["DATEOFENQUIRY"];
ClientName.Value2 = ReportDetails.Tables[1].Rows[0]["NAME"];
KindAttention.Value2 = "Kind Attn :" + ReportDetails.Tables[1].Rows[0]["PERSONINCHARGE"];
for (int xlrow = 0; xlrow < ReportDetails.Tables[0].Rows.Count; xlrow++)
{
Range excelCell1 = (Range)excelWorksheet.get_Range(strRange + (xlrow + 21).ToString(), strRange + (xlrow + 21).ToString());
excelCell1.Application.get_Range(strRange + (xlrow + 21).ToString(), strRange + (xlrow + 21).ToString()).HorizontalAlignment = XlHAlign.xlHAlignLeft;
excelCell1.Value2 = ReportDetails.Tables[0].Rows[xlrow][xlcol].ToString();
excelCell1.WrapText = true;
}
intAscii += 1;
}
//excelApp.SaveWorkspace(@"E:\saisuneel.xls");
//excelApp.ActiveWorkbook.Close("",@"E:\saisuneel.xls","");
string savepath;
string timestamp = DateTime.Now.ToString("yyyyMMddhhmmss");
savepath = System.Web.HttpContext.Current.Request.PhysicalApplicationPath;
savepath = savepath + @"OutBound" + @"\" + ReportDetails.Tables[1].Rows[0]["jobId"].ToString() + Heading + timestamp + ".xls";
//excelWorksheet.SaveAs(savepath, Excel.XlFileFormat.xlExcel4Workbook, Type.Missing, Type.Missing, Type.Missing
//, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing);
excelWorkbook.SaveAs(savepath, Excel.XlFileFormat.xlExcel4Workbook, Type.Missing, Type.Missing, Type.Missing
, Type.Missing, Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Thread.Sleep(1000);
excelWorkbook.Close(false, Type.Missing, Type.Missing);
excelApp.Quit();
excelWorkbook = null;
excelSheets = null;
return @"\" + ReportDetails.Tables[1].Rows[0]["jobId"].ToString() + Heading + timestamp + ".xls";
}
|
|
|
|
|
Hello all,
I want to use this code
protected void Cartgrid_RowUpdating(object sender,GridViewUpdateEventArgs e)<br />
{<br />
TextBox QuantityTextBox = (TextBox)Cartgrid.Rows(e.RowIndex).cells(2).controls(0);<br />
<br />
}
Cartgrid is a shopping cart.
but it has this error :'System.Web.UI.WebControls.GridView.Rows' is a 'property' but is used like a 'method'
now what do i do?
how can use this code without this Error?
Hoda
|
|
|
|
|
Did you mess up ( with [ and its associated closing character?
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
change
(e.RowIndex)
to
[e.RowIndex]
|
|
|
|
|
At first i didnt notice the () instead of the [] until i saw your answers, im used to VB
Besides (e.RowIndex), shouldnt he also change the cells(2) and controls(0)??
Alexei Rodriguez
|
|
|
|
|
Hello...
i am using datalist. i have taken a table in Datalist.and i want to use another datalist in this table. When i use another datalist .then DataBind is not working.
So i can use one Datalist into Another Datalist?
and also I have to Fetch record in Both DataList from different tables.
|
|
|
|
|
|
now, isn't this article providing code to him...? where is the ethical issue gone of spoiling a developer..... ?
ridiculous!
i hate to comment on other's work....and also expects the same....
Ashish Sehajpal
|
|
|
|
|
Yes you can
You can get the data from 2 different tables
I would use a dataset
Bind Table1 to parent datalist
And on ItemDataBound event of parent datalist get the corresponding rows from table2 and bind them to child datalist
This way, you dont have to read from DB once for each row on table1
Alexei Rodriguez
|
|
|
|
|
modified on Friday, April 25, 2008 7:22 AM
|
|
|
|
|
No Result ! ...kuch bhe nahi hua ..( meri website hai www.rakshanllc.com/webbooking/booking.aspx)
It gave a Error !
Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.
|
|
|
|
|
Use body tag for any kind of farmatting on form level. E.g.
Arun Singh
Noida.
|
|
|
|
|
You better put you page content in a table and align that cell content to be CENTER
e.g.
<table width='100%' cellpadding='0' cellspacing='0'>
<tr>
<td align='center'>
<!-- YOUR PAGE CONTENT HERE -->
</td>
</tr>
</table>
cheers !
Ashish Sehajpal
|
|
|
|
|
i changed the Document Properties .... its working fine ..thanks for the suggestions !
Dont Get Paid for the Hours you worked, Get Paid for the Work You Have Done in an Hour.
|
|
|
|
|
Why was this message deleted?
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
Plz explain in detail how to design and develop a mail in asp.net with vb
|
|
|
|
|
Two namespaces:
1) System.Web.Mail
2) System.Net.Mail
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
google asp.net e-mail and you will quickly find lots of articles
|
|
|
|
|
dim MyMsg as new MailMessage()
MyMsg.From = new MailAddress("myadmin@domainname.com", "My Admin")
MyMsg.To.Add(new MailAddress("a.sehajpal@gmail.com"))
MyMsg.Bcc.Add(new MailAddress("ashish_sehajpal@yahoo.com"))
MyMsg.Subject = "My Reports"
MyMsg.Attachments.Add(new Attachment(Server.MapPath("folder/sendReport.doc")))
MyMsg.IsBodyHtml = true
MyMsg.Body = "<html><body>Find The Attached Reports</body></html>"
try
SmtpClient client = new SmtpClient()
client.Host = "mail.domainname.com"
client.Send(MyMsg)
catch ex as exception
' do something useful here
end try
Ashish Sehajpal
|
|
|
|
|
You went ahead and spoilt a developer from doing his homework.
Vasudevan Deepak Kumar
Personal Homepage Tech Gossips
A pessimist sees only the dark side of the clouds, and mopes; a philosopher sees both sides, and shrugs; an optimist doesn't see the clouds at all - he's walking on them. --Leonard Louis Levinson
|
|
|
|
|
then what is problem in ur stomach?
Ashish Sehajpal
|
|
|
|