|
Friends,
I hope atleast this time somebody will be able to help me...
I have to write some data in excel sheet. I am able to write other datas, but when I m trying to write a numeric value with a leading zero it is trucating it as the cell format is general.
Anyone aware how can we change the cell format to text programmatically using asp.net.
Thanks in Advance for your help
|
|
|
|
|
what I have written is not easy to understand but u have to do it on ur own I dont have that much time, Its a snippet of one of my programs. This will automatically write to the excel file regardless of the field type since it checks each field at runtime.
private void btnexp_Click(object sender, System.EventArgs e)
{
Response.Clear();
Response.Buffer= true;
Response.ContentType = "application/vnd.ms-excel";
Response.Charset = "";
this.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.ClearControls(DataGrid1);
DataGrid1.RenderControl(oHtmlTextWriter);
Response.Write(oStringWriter.ToString());
Response.End();
}
private void ClearControls(Control control)
{
for (int i=control.Controls.Count -1; i>=0; i--)
{
ClearControls(control.Controls[i]);
}
if (!(control is TableCell))
{
if (control.GetType().GetProperty("SelectedItem") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
try
{
literal.Text = (string)control.GetType().GetProperty("SelectedItem").GetValue(control,null);
}
catch
{}
control.Parent.Controls.Remove(control);
}
else
if (control.GetType().GetProperty("Text") != null)
{
LiteralControl literal = new LiteralControl();
control.Parent.Controls.Add(literal);
literal.Text = (string)control.GetType().GetProperty("Text").GetValue(control,null);
control.Parent.Controls.Remove(control);
}
}
return;
}
If only they could see what I see in my mind
|
|
|
|
|
Thanx a lot, but I am using Excel object in dot net...
I wanted to work with some property of excel object....
|
|
|
|
|
What is the best way to count my website visitors?
"I am too late but i will never give up"
|
|
|
|
|
well you can keep a counter in global.asax in session _Start event
Enjoy Coding
|
|
|
|
|
Hi..
Thank you for your respond..I know how to use the application and session state variables and i have used the following code :
protected static int m_ActiveUsers;
public static int ActiveUsers
{
get
{ return m_ActiveUsers;
}
}
protected void Application_Start(Object sender, EventArgs e)
{
Application.Lock();
m_ActiveUsers=0;
Application.UnLock();
}
protected void Session_Start(Object sender, EventArgs e)
{
Application.Lock();
++m_ActiveUsers;
Application.UnLock();
}
protected void Session_End(Object sender, EventArgs e)
{
Application.Lock();
--m_ActiveUsers;
Application.UnLock();
}
But the problem it doesnt give me the right number always.Some times this code tells me there is two visitors while there is no one except me.And some times it doesnt decrement the visitors count number when i exit.
Do any one know how to make a better way that wont be affected by application errors and will solve my problem? 
"I am too late but i will never give up"
|
|
|
|
|
In the global.aspx file
Application_start()
application("visitor")=0
Now at Webpage load
Application("c") = CType(Applicatrion("visitor") , integer) + 1
Label1.text = "You ar visitor no " & Application("c")
|
|
|
|
|
Hi..
Thank you for your respond..I think your code will count how many times the Web Form has been loaded not how many visitors are viewing my website currently!.
I am too late but i will never give up
|
|
|
|
|
hi
i am buiding a web appliaction VS 2003
i use CrystalReport Export file .doc
i want after Export file Delete that file
how will i do ???
|
|
|
|
|
I would like to call a method of my code from within XSL but it does not seem to like the presence of the '%' character inside the xsl.
Basicly the XSL loops through an XML writing url's into links on a menu...
I have a method that when passed a URL encrypts the query string portion and spits it back out as URL+encoded QueryString.
I would like to call this method using somthing akin to <%EncodeQueryString(<xsl:value-of select="url" );%=""> in the xsl for-each loop so as to output the urls with encoded queriers.
Could some one please point me in the right direction with regards getting ASP.NET script to execute from XSL?
Thank you.
|
|
|
|
|
I am working on ASP.net /VB.net v1.1.
I am opening an excel using Interop services – and this web application is
working fine on my local machine but when I put the same application on
server its giving me this error.
“Server execution failed”
**** When i call the application from my local machine and web application
is on server , i get this error
Server Specifications
==============
IIS Specifications : IIS v6.0
Server Specifications : 2003 , Enterprise Edition , Service Pack 1
**** When i call the application from my server machine and web
application is on server , i get this error
Call was rejected by callee
I searched all over MSDN and google , no help or good article , even
article given by MS is for windows application and i am working on web
application
Can you please help in regard to this ?
Thx A Lot !!!
|
|
|
|
|
I have a requirement to add one line of text automatically to the end of the all web pages in a web site in IIS (all virtual directories under the web site). I am trying to write an HttpModule using ASP.NET/VB.NET which can do this. Do anybody have some sample code to share?
Thanks in advance.
|
|
|
|
|
|
Hi guys,
I'm actually quite new to ASP.NET programming. The program that I'm building now is related to coding an ASP.NET web service for my Pocket PC.
My question is, can ASP.NET run on Pocket PC? If yes, do I need any special applications or just Visual Studio 2005 could do the job?
Another problem thats bugging me is the fact that the screen for Pocket PCs are smaller, so do I need to set a specific height and width for my website, or do all Pocket PCs auto shrink the website to fit their screens?
Thanks
|
|
|
|
|
maddict wrote: My question is, can ASP.NET run on Pocket PC?
No. ASP.NET is a server side technology and is designed to run on a server system.
maddict wrote: Another problem thats bugging me is the fact that the screen for Pocket PCs are smaller, so do I need to set a specific height and width for my website, or do all Pocket PCs auto shrink the website to fit their screens?
Try some websites on your PocketPC and see. I tend to use the low graphics version of websites if available. Some services, such as gmail, detect if it is being used via the browser on a PocketPC and adapt themselves to the smaller screen and lower bandwidth availability. Some ASP.NET controls will adapt the HTML they render to the smaller formfactor, but it still requires some work from you to get it working well on all systems.
Scottish Developers upcoming sessions include:
.NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
My: Website | Blog
|
|
|
|
|
Can you show me how to copy this dll so as i can put it in my bin directory
it has to be done from a command prompt and thats where i get stuck
-- modified at 13:23 Monday 12th June, 2006
|
|
|
|
|
Hi~
I am developing web application.
In my web app, I execute search in Oracle DBMS.
and I use iBATIS module.
I want to improve search power of my web app.
If it is possible that is asynchronous searching, I want to use that skill.
so, it is feeled by web user that searching of web app is very nice!!
Is it possible?
 help me~~~~
-- modified at 12:39 Monday 12th June, 2006
|
|
|
|
|
The Async nature of the database connection probably won't be felt by the end user because the whole web page has to be defined before it can be rendered to the client and it can't render itself until the query returns.
The alternative is to create a control that can be displayed to tell the user to wait. That is, when the user presses the button that initiates the lengthy query they are presented with a "please wait" message until the new page is available.
Scottish Developers upcoming sessions include:
.NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
My: Website | Blog
|
|
|
|
|
I have these three tables in my database - outcome (primary key:outcome_id), assessment(primary key:assessment_id) & outcome_plan(foreignkeys: outcome_id & assessment_id)
I have created a dynamic table at runtime taking the headers from the Outcome Table with dtOutcome = Outcome.GetAll(m_ConnString) and the Row headers from the Assessment Table with Assessment.GetAll(m_connString). I need to fill in the individual cells with the info from the third table with Outcome_Plan.GetAll(m_connString) - naturally I need to drop the info into the corresponding rows and columns. Can someone please start me off on this?
I understand that I need to loop through the column records first find a match for column and then loop through corresponding rows until I find the correct one and then insert the data into the right cell. Not sure of where to start with syntax in vb.net
Thx, Tammy
|
|
|
|
|
I have written the following function to validate one of my forms :-
function ValidateForm(Form)
{
var output = "";
output += CheckName(document.Form.txt_substance_name.value);
output += CheckForm(document.Form.ddl_form.selectedIndex);
output += CheckHazardGroup(document.Form.ddl_hazard_group.selectedIndex);
for(i=0, n = documentForm.rbl_hazard.length; i<n; i++)
="" {
="" if(documentform.rbl_hazard[i].checked
="" var="" checkhazardous="document.Form.rbl_hazard[i].value;
" break;
="" }
=""
="" output="" +="CheckHazardous(CheckHazardous);
" for(i="0," n="document.Form.rbl_hazardous.length;" i<n;="" if(documentform.rbl_hazardous[i].checked
="" checkhazard="document.Form.rbl_hazardous[i].value;
" if(document.form.rbl_measures[i].checked
="" checkmeasures="document.Form.rbl_measures[i].value;
" if(document.form.cbl_routes[i].checked
="" checkroutes="document.Form.cbl_routes[i].value;
" if(document.form.rbl_exposure[i].checked
="" checkexposure="document.Form.rbl_exposure[i].value;
" if(document.form.rbl_monitoring[i].checked
="" if(document.form.rbl_surveillance[i].checked
="" checksurveillance="document.Form.rbl_surveillance[i].value;
" if(output="" !="" )
="" alert(output);
="" return="" false;
="" true;
=""
function="" checkname(name)
="" error="" ;
="" if="" (name="=" "")
="" error;
="" checkform(form)
="" (form="=" 0)
="" checkhazardgroup(group)
="" (group="=" }
function="" checkhazardous(checkhazardous)
="" (!(checkhazardous))
="" checkhazard(checkhazard)
="" (!(checkhazard))
="" }="" checkmeasures(checkmeasures)
="" checktime(time)
="" (time="=" checkroutes(checkroutes)
="" (!(checkroutes))
="" checkexposure(checkexposure)
="" (!(checkexposure))
="" checkmonitoring(checkmonitoring)
="" (!(checkmonitoring))
="" checksurveillance(checksurveillance)
="" (!(checksurveillance))
="" }
this="" is="" a="" seperate="" file="" called="" 'validate.js'
i="" then="" created="" reference="" to="" the="" in="" webform="" like="" so:-
<script="" language="JavaScript" src="/javascript/validation.js">
Only problem I am having now is getting a server control to call the function and validate the form.
If anyone has any suggestions for getting this to work please help. I have been using the following code on an asp.net button control: -
<asp:button id="btn_save" runat="server" width="100px" text="Save" onsubmit="Javascript:ValidateForm(this); return false;">
|
|
|
|
|
Read rule number 4 in this[^].
You can't use a server control to call the javascript to validate the form. When the event runs to handle the server event, the form has already been posted. You have to call the function from client script.
Here is an example on how you verify a form using client script:
Javascript: Validate form[^]
---
b { font-weight: normal; }
|
|
|
|
|
hi,
I have a button column in my datagrid. after editing in my datagrid i am updating the row as usual. But i want to validate the textbox values (the textboxes are in EditItemTemplate) before updating the row. Where should i place my validation code.
thanks in advance.
Tirthadip
|
|
|
|
|
You can put a validator in edititem template. In EdititemTemplate give your textbox a ID.
YOu can do soemthign liek this:
<EditItemTemplate>
<asp:TextBox runat="server" ID="tbProjects" Width="255">
</asp:TextBox>
<asp:RequiredFieldValidator ControlToValidate="tbProjects" </asp:RequiredFieldValidator>
</EditItemTemplate>
You can replace requiredfield validator with anyother kind of validator.
Hope thisone works for you!!
-- modified at 10:16 Monday 12th June, 2006
|
|
|
|
|
Sir,
There is no click event in datagrid control.Can you please help me in creating the click event of datagrid.
Thanks and Regards
Amaneet Brar
|
|
|
|
|
hello
Actually wat do u want to know Excatly.
tell me might be possible i help u.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
