Problume With Excel sheet - ASP.NET Discussion Boards

<code><tr>
<td class="tdCRF">
<div class="divStatistics">
<b> <table cellpadding="0" cellspacing="0" width="100%" class="tblStatistics" id="tblStatistics">
<tr>
<td align="left" colspan="2">
<a id="ctl00_RightColumn_WucCRF1_aDisplayStat" title="Detailed Statistic for: HyperNet Configuration File Description" class="handPointer" onclick="callLinksPage('/doXtop/frm_statistic.aspx?pubId=4a095bf','Detailed Statistic for: HyperNet Configuration File Description','760','570');"><strong>
Complete Traffic Statistic</strong> </a>
</td>
</tr>
<tr>
<td colspan="2">

<table cellpadding="0" cellspacing="0" width="100%">
<tr>
<td style="width:100%">
<script type="text/javascript">
function LoadChart()
{
//alert(DataLink)
var myChart = new FusionCharts(ChartLink, "myChartId", "198", "135", "0", "0");
myChart.setDataURL(escape(DataLink));
myChart.render("chartdiv");

}
function getTimeForURL()
{
var dt = new Date();
var strOutput = "";
strOutput = dt.getHours() + "_" + dt.getMinutes() + "_" + dt.getSeconds() + "_" + dt.getMilliseconds();
return strOutput;
}

</script>
<div id="ctl00_RightColumn_WucCRF1_WucStatistics1_chart" class="handPointer" style="width:100%" onclick="callLinksPage('/doXtop/frm_statistic.aspx?pubId=4a095bf','Detailed Statistics for:HyperNet Configuration File Description','760','570');">
<div id="chartdiv">
The chart will appear within this DIV. This text will be replaced by the chart.
</div>
</div>
<script type="text/javascript">
LoadChart()
</script>
</td>
</tr>
</table>
</td>
</tr>
</table> </b>
</div>
</td>
</tr>
</table>
</div>
</td>
</tr>
</table></code>

ok, so i'm messing around seeing what i can do with the different controls (i started doing ASP last monday ^_^) and i think i pretty much have the basics down. problem is, i can't find any way to pass an argument from a checkbox.

Default.aspx:
     <code><asp:CheckBox runat="server" 
                  ID="chkFirst" AutoPostBack="true" 
                  OnCheckedChanged="Check_Controls(chkFirst.ID,lblFirstCheck.ID)" />
    <asp:Label runat="server"
                  ID="lblFirstCheck"
                  Text=""></asp:Label>
</code>

Default.aspx.vb
<code>
    Sub Check_Controls(ByVal sender As Object, ByVal e As String)

        Dim tmpCheck As CheckBox = Page.FindControl(sender)
        Dim tmpLabel As Label = Page.FindControl(e)


        If tmpCheck.Checked = True Then
            tmpLabel.Text = "Checked!"
        Else
            tmpLabel.Text = "Not checked :("
        End If
    End Sub
</code>

|
|
If i call a separate sub and use it declare and pass the label.id and checkbox.id into Check_Controls then it works like a champ.
If i use the code as posted above, it generates the error: "'AddressOf' operand must be the name of a method (without parentheses)" for the line with OnCheckedChanged.

I made buttons that pass in this manner without any trouble using 'commandargument' but checkboxes don't seem to have an equivalent setup.

I've googled and googled and googled but haven't found any way to do this. The only thing close is a brief mention by someone that they used the "cssClass" attribute as a workaround but they didn't expand on exactly 'how' they did it.

Any help would be appreciated. ^_^

modified on Friday, April 25, 2008 12:20 PM

What are you exactly trying to do??
Am i missing something??

Sub Check_Controls(ByVal sender As Object, ByVal e As String)
  If chkFirst.Checked = True Then
    lblFirstCheck.Text = "Checked!"        
  Else
    lblFirstCheck.Text = "Not checked "
  End If    
End Sub

the_0live wrote:
i pretty much have the basics down

If this was your question
Im sorry to tell you, But you dont have any basics down

Alexei Rodriguez

like i said, i'm trying to pass a value similar to the 'commandargument' property of a button. for instance instead of just passing checked/not checked i'd like to be able to pass a separate variable/string:

with a button i can do this:

Sub Button_Controls(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.CommandEventArgs)
    Dim tmpLabel As Label = Page.FindControl(e.CommandArgument)
    If tmpLabel.Visible = True Then
        tmpLabel.Visible = False
        tmpLabel.Text = ""
    Else
        tmpLabel.Visible = True
        tmpLabel.Text = "Now I have text!"
    End If
End Sub

in a checkbox, i can only seem to pass whether or not the box was checked. not an actual value.

my goal is to have (like the working button example above) a single sub that can handle multiple checkboxes and their corresponding labels.

anyone? anything? is there maybe another site/forum i could take this question to?

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.

Someone has explained with an example. Check it out here:

http://www.dotnetspider.com/kb/Article1320.aspx[^]

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

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

fdfgfdagdfsdfs Smile | :)

[Message Deleted]

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'>

</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