|
Greetings...
I'm interested in exporting a dataset or a datagrid to excel. The hard part is formatting excel so that certain fields are colored or setting each row to have an alternating color (much like that of the datagrid itself). Can anyone assist me in better understanding how to format the excel file, mostly for color in ASP.Net for VB before it is sent to the client to download?
If anyone has some insigh I would greatly appreciate it!!!!!
Thanks, 
Shinkentb
|
|
|
|
|
this is a sampil code of my project
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:ReportsDBConnectionString %>"
="" selectcommand="SELECT [ReprotDate], [UserName], [ProjectName], [Report] FROM [Table1]">
how can make the data source read from variable tables ?
Ex:
x = TableName
SelectCommand="SELECT [ReprotDate], [UserName], [ProjectName], [Report]FROM X">
how can i do this in asp.net V 2.0 ???
Best Regards
Ahmed EL GEndy
|
|
|
|
|
x="Tablename"
Using C#
sqlcommand="Select field1,field2 from " + x + " order by field1";
Make sure that you put space after from and before order by clause.
Naveed Kamboh
Complexity kills, Write easy code for your self.
isolutionteam
|
|
|
|
|
I would NOT code it that way. Create a different stored procedures (or one with a tableName as a paramter). Use a switch statement to chose your stored procedure.
Dynamic SQL should only be done if absolutely necessary.
First of all, performance will be better if it stored procedures.
Secondly, stored procedures prevent SQL Injection.
Third, maintenance will be easier, especially if you change a table.
Fourth, if someone else sees your code, they won't think you are a complete beginner.
|
|
|
|
|
Why do you have separate tables with the same type of data in them in the first place? Why isn't the data in a single table?
---
single minded; short sighted; long gone;
|
|
|
|
|
If my Data Source is Microsoft Access Database File (OLE DB) iLL USE ALL oleDB cOMMAND
AND IF sql SERVER,sqL COMMAND LIKE sQLcONNETION IS ONE OF THE KEYWORD USED TO CONNECT TO DATABASE
iM USING SQL SERVER 2005 EXPRESS,THE COMMAND WOULD HAVE BEEN THE SAME TO SQL COMMAND LIKE sql
DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True IN THIS CONNECTION STRING CAM I ACCESS IT,IN SQK COMMAND LIKE "SQLcoNNECTION"
FOR AN ASP.NET DEVELOPER,WHAT WILL BE THE EASIEST DATA SOURCE CONTROL?
-IN ASP.NET ADMINISTRATION TOOL,ASPNETDB.MDF DATABASE CREATED INSTANTLY IN A DATABASE EXPLORER...IF IM GOING TO ACCESS MY OWN DATABASE AND NOT THE ASPNETDB.MDF,CAN I SET UP A MEMBERSHIP,ROLES AND PROFILE? CAN YOU GIVE THE HINT..CAN I ACCESS ASP.NET ADMINISTRATION TOOL AND SET UP A MY ASP.NET WEBSITE TO CREATE PROFILE,ALLOW ADMNISTRATOR AND USER, DENY ANONYMOUS USER?THAT MY WEBSITE CAN BE SECURED EVEN WITHOUT THE USING THE ASPNETDB.MDF
ONCE AGAIN THANKS FOR THE ANSWER.
|
|
|
|
|
Dear all,
I have an asp.net page which include asp table, i want to make it possible to drag and drop this table's columns
how should i do that???
Thanks
|
|
|
|
|
Maybe you can find a third party control with this functionality. Doing it yourself will be extremely difficult. You would need some serious javascript skills to write that. Even if you could write the javascript to "move" the columns you would need some AJAX to maintain the state, otherwise after a postback the grid would go back to its original state.
|
|
|
|
|
My Code does't work:
var myDate = document.getElementById("Calendar1").getAttribute("SelectedDate");
|
|
|
|
|
I don't think this is possible with the ASP.NET calendar control. You might be able to do it with the AjaxControlToolkit calendar extender.
|
|
|
|
|
Hi Friends,
I want to develop an affiliate program for a company.
Where from I should start? Any articale or prototype please.
Naveed Kamboh
Complexity kills, Write easy code for your self.
isolutionteam
|
|
|
|
|
Hello.
i have a DataSet that binds into gridview using the "databind()" method, the gridview is auto genereate colmus enabled, my question is:
the binded gridview looks awful, the headers are not equal, the cells aren't equals and the gridview itself is very very large. how can i control those things? espically the coulmns!
thanks !
|
|
|
|
|
It realy depends, I you are using autogenerate columns then you have to do it dynamically.
Otherwise use Databound columns on design time and make it beautiful as you want, control widht, data formats like currency, date etc.
Naveed Kamboh
Complexity kills, Write easy code for your self.
isolutionteam
|
|
|
|
|
hmm my question was,
if there is away that the gridview will auto warp it self to the contents of the cells and columns ?
|
|
|
|
|
Of course. If you set the width of the columns they will wrap the text.
However if there is no space for example SUPERCALIFRAGILISTICEXPIALIDOCIOUS would cause your column to expand.
If you would like to wrap a word in the header cell, use a <br/> tag.
For example, "Grid<br/>Header".
GameFly free trial
|
|
|
|
|
Thanks mate, ill try it soon 
|
|
|
|
|
Looking for a way of setting the page to have a default button to trigger when enter is pressed on the keyboard. We are currently using a third party solution but would like to move away from this if it has been built in to .net 2?
Any suggestions? Thanks
|
|
|
|
|
Many ways to do it but the simple one is
Write the line in page load event
Button3.Focus();
if you want to make default focus to Button3
Thanks and Regards
Sandeep
If you want something you never had,
do something you have never done!
|
|
|
|
|
Thats no good. When the user selects a textbox to fill in some information the focus will change surely??
|
|
|
|
|
This will work when the form has a submit button, as in:
<input type="submit" value="jonsgay" />
Not 100% sure what happens when theres more than one submit button, I assume it wouldn't matter as they'd all submit the form. This is easier when using several forms, but obviously with ASP.NET there is (usually) only one. Whatever button you want 'pressed' has to render as a submit button, not just type="button".
Of course in order for this to happen the focus must be somewhere on the form (on any element, not necessarily an input). This shouldn't be too hard as the whole page is probably a form so as soon as the user clicks anywhere or an input is selected, you'll get the expected behaviour.
|
|
|
|
|
It's not really that simple is it you c**k jockey. Sometimes there are several submit buttons on a single page. One to submit the form details, one to clear the fields, another to search for my address using a postcode and the list goes on. FF and IE react differently to this and neither of them seem to do it in an expected and reliable way.
We have a third party control which has been able to do this but since moving to .Net 2 it has failed to work and there is no update for it???
PS
Rory = Dim
|
|
|
|
|
|
I am using Visual Studio .NET 2003 to develop the application. My issue is that i had to generate a Word Report with password from an ASP.NET web application.
After much try i got the dll Microsoft Word 11.0 Object Library and with the help of which i could generate a word document with password from a trial application. When i tried to implement the same in our project, it was giving an error as
'Could not open Macro Storage'.
The error code was 2146822307.
While checked up with the windows task manager it was taking a lot of memory.
When performed a search with this, i came to know the necessity of configuring the Word application with DCOMCNFG - as setting the word to be run under interactive user mode etc. But that is very risky as listed in the links,
http://support.microsoft.com/kb/q288366/ -- (Explains how to configure with DCOMCNFG)
http://support.microsoft.com/kb/257757/
Can any body tell me how to solve this without using DCOMCNFG ?
Or at the least is there any solutions to overcome the security issues...
Your suggestions might be of great value....
If anybody comes across any link or any thing please do reply ....
I will be very grateful...
O
|
|
|
|
|
i have a problem in crystal report viewer.
it show the records in vertical way in runtime although the main reprt preview shows it horizontal in design mode.
it is very urgent please help me.
Ahmed Abo Hamer
|
|
|
|
|
could you send some snapshots of both previews
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
