|
Hi,
I have exported my data in gridview to excel sheet but i have a problem to format the excel cell through my code. my gridview data has line break in some of the column
, when exported to excel, it will occupy few rows instead, I need to format the data such that each order will occupy one row for easy data auditing.
I'm using this code to export the data:
string filename = System.Configuration.ConfigurationManager.AppSettings["ExcelFilename"];
string style = " .style0 {vertical-align:top;} ";
// all roles exported turn off paging and rebind the grid before sending it to export
this.GridView1.AllowPaging = false;
this.GridView1.DataSource = (DataView)Session["OrderList"];
this.GridView1.DataBind();
DisableControls(GridView1);
Response.Clear();
Response.AddHeader("content-disposition", string.Format("attachment;filename={0}.xls", filename));
Response.Charset = "";
Response.ContentType = "application/vnd.xls";
StringWriter stringWrite = new StringWriter();
HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
this.GridView1.RenderControl(htmlWrite);
//style is added dynamically
Response.Write(style);
Response.Write(stringWrite.ToString());
Response.End();
|
|
|
|
|
I am trying to set up Database to use ASP.Net Memebership as below. There would be two DB one is SBCentral and SB.
SBCentral will be used for memebership purpose/and all app meta data where SB database will be used for all other application activites. I already compiled and created a new db as "SBCentral" by using aspnet_regsql. Now when i am trying to test this through web admin tool (website-->Asp.net configuration) i am getting error as
Provider Management
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web Site Administration tool, use the aspnet_regsql command-line utility to create and configure the database, and then return to this tool to set the provider
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="SB"
connectionString="Data Source=81080EA37F\SQLEXPRESS;Initial Catalog=SB;User ID=sa;Password=abc" providerName="System.oledb.SqlClient" />
<add name="SBCentral"
connectionString="Data Source=81080EA37F\SQLEXPRESS;Initial Catalog=SBCentral;User ID=sa;Password=abc" providerName="System.oledb.SqlClient" />
</connectionStrings>
<system.web>
<membership>
<providers>
<add connectionStringName="SBCentral" name="CustomProvider"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
Any help?
Amit
|
|
|
|
|
I chnaged the custom provider name to AspNetSqlMembershipProvider from name CustomPrvoider and now it is not throwing error.
But a new problem, evertime when i try to create user, it creates in ASPNETDB.MDF file instead of SBCentral...
I also changed my CentralDb to ASPNetDB.....But no luck....
So please guys help me....
|
|
|
|
|
I am planning to use the new feature of ASP.Net 2.0 in my one of new website and i am doing analysis to see capablities of these new features.
I have a quick query and it would be nice if you can show me some direction.
I am planning to implement memebership API for creating user, validating user, etc... but i don't want to use SQL Express Database (whiich comes with ASP.net) because of security reason. I am planning to use SQL 2005. So what i need to do....Do i need to create same tables in my SQL 2005 database (same name, same columns etc...) or i can have custom tables.
Amit
|
|
|
|
|
I need to combine columns from 3 different tables (ofcourse from a single database)in to a single DataSet...and also I need to add a Column along with the same Dataset ...So,kindly tell me how to do this..??
And also i am planning to create a crystal report for this newly created DataSet.
I need ur suggestions and help.
Kindly help me ...Pls!!
My project deadline is 27th July..With in that i need to generate 6 different reports with 6 different logics..So,kindly help this poor fresher...!!
Happy Programming!!!
|
|
|
|
|
SrividhyaS wrote: My project deadline is 27th July
You have plenty of time to look up DataSet.Merge() and DataTable.Merge() then.
only two letters away from being an asset
|
|
|
|
|
Can you tell us the tables and columns? I'm sure you can accomplish this with SQL instead of DataSet.Merge. What kind of column are you trying to add in addition to the other data?
- S
50 cups of coffee and you know it's on!
|
|
|
|
|
Hi,
You can try with following short ways.
1. Try combine required fields of different table to get single datatable.
2. Create different datatable and merge all with one dataset.
Rams.
Be simple and Be sample.
|
|
|
|
|
may be she should buy u choklats if she passes her exam 
|
|
|
|
|
Hello to every One,
i'm using one textbox1 and button1 where i'm checking the input text to be "yes" for that i'm able to use server side validation but i want to make the same using client side validation..
Suggest me.....
Thank You..
|
|
|
|
|
Use a requirefield validator control and specify the client script
only two letters away from being an asset
|
|
|
|
|
hello hemant,
just use the Javascript,it is best for the client side validation
Hemant Garg wrote: i'm checking the input text to be "yes"
write the function and check ,
function ChkInput()
{
if (document.GetElementById("TextboxName").value == "yes")
{
alert("Exist")
return false;
}
}
and call that function on click event of button
hope it helps,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
hi, I'd like to create an ad that moves across my web page then stops a while at the center of the page?? Like the ads that sometimes appear on Yahoo..Can I do that using javascript or ajax...how?? is there any code or any reference for that??
-- modified at 9:50 Sunday 1st July, 2007
|
|
|
|
|
|
I have been trying to read textfile from client side and get the data inside the file add into the
table but I have this error all the time
Anybody who know how to resolve this problem please help me.
I am just new in ASP .NET and this is the first webApplication of mine.
Thank you million for helps,
===============================================================================================
Server Error in '/' Application.
--------------------------------------------------------------------------------
Could not find a part of the path 'C:\Documents and Settings\aim\Desktop\DataFile.txt'.
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.IO.DirectoryNotFoundException: Could not find a part of the path 'C:\Documents and Settings\aim\Desktop\DataFile.txt'.
Source Error:
Line 36:
Line 37: // fileInfo = Server.MapPath("TextFiles//mydata.txt"); //Testing
Line 38: fs = new FileStream(fileInfo, FileMode.Open, FileAccess.Read);
Line 39: sr = new StreamReader(fs);
Line 40:
Source File: d:\webhost\471463016\Table2.aspx Line: 38
===============================================================================================
junior boy
|
|
|
|
|
You can't open a file on the client computer from the server. The user has to upload the file to the server for the server to access the file data.
---
single minded; short sighted; long gone;
|
|
|
|
|
what exactly you want to do...
As i belive you are trying to read a file from your virtual dir.
Provide correct relative path. because system is trying to pull the file from Desktop. I think there is no such file on the desktop.
Ravi Kant Srivastava
(System Analyst)
HandsOn Technology & Engineering
Gurgaon
(India)
e-mail:ravikant@hte.co.in
|
|
|
|
|
Now I know I need to upload the text file [data file] to the server.
Anybody know what article explain how to upload text file?
Thank you very much again.
junior boy
|
|
|
|
|
Hello Everyone,
I've designed a website it's running great on local pc but i start to run this website on laptop it don't look as it looks in local pc it widens wht should i do know.
Example:-
Default.aspx :-
-------------
I've taken a table width 80% with 4 rows and 2 columns
and also taken two usercontrol named "Header" and "Footer"
"Header" is a flash file
"Header" is also taken in a table width 80% with 1 row and 1 column
"Footer" is also taken in a table width 80% with 1 row and 1 colun
Plz try to imagine wht i want to show
Thnx in advance
|
|
|
|
|
The laptop may have a widescreen monitor, and you need to change your code so it looks good on both.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi, I've seen how data from a particular field in a database table can be retrieved and displayed based on the selection of a listitem in a listbox. However, I've never seen a listbox used in the reverse manner of what I have just described. I would like to know how one can send data to a specific field in a database table based on the selection of a listitem in the listbox. For example suppose I have a database that stores a variety of music and in it I have a table with the Jazz field, Blues field, and Rock field. In my asp.net app I would like to enable someone to browse to his/her music file, pick Rock and Roll in the listbox, and then hit the submit button. The selected music file will then be sent to the Rock field in my database table for storage. I'm not quite sure how I would do this, would I need to bind the listbox to the database after adding the listitems to the collection? Any help will be much appreciated, thank you in advance for you help.
-- modified at 21:12 Saturday 30th June, 2007
|
|
|
|
|
ASPnoob wrote: I've never seen a listbox used in the reverse manner of what I have just described.
?? This happens all the time! It's a straightforward matter of reading the postback value of the listbox and building up your SQL statement accordingly.... What's the problem?
Fred
|
|
|
|
|
I have uploaded a file in pdf format and want to open it. I have tried it throug following way
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/pdf";
SqlConnection con = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand("SELECT FileBytes FROM Files WHERE Id=@Id", con);
cmd.Parameters.AddWithValue("@Id", context.Request["Id"]);
using (con)
{
con.Open();
byte[] file = (byte[])cmd.ExecuteScalar();
context.Response.BinaryWrite(file);
}
}
when I open it blank screen appears.
Kindly Help.
Best Regards to Discussion Board
|
|
|
|
|
dear Nazir Hussain,
Response.ContentType = "application/octet-stream"
Response.AddHeader("Content-Disposition", "attachment; filename=" & filename)
you can write the file in response.writefile.
so it can be downloaded easily.
All The Best
Sathesh Pandian
|
|
|
|
|
hi,
How to Convert Sql server 2000 Data into Excel Format in ASP.NET
dfgdf dgdgdf tge tt rtertet tert
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
