In my project i wants to display report and export it in pdf format so that i used rdlc but now my requirement is that there are some labels like name,address for it i wants to give some specific margin from left right(x,y) and i wants to give this margin by config file. "how can we set margin in rdlc from cofig file or run time?"
View 1 RepliesI'm generating the rdlc at runtime and I'm using LoadReportDefinition(memorystream) to provide the definition to report viewer. It works fine but when I export it to pdf or excel, the file extension comes in as .xls[1] or .pdf[1].
I have tried giving the DisplayName property but it doesn't work.
I'm preparing to deploy a ASP.NET web application. The target server has already a previous version of my web application with parameters specified on the web.config file.
In the new version of this web application, the web.config file contains new sections I would like they appear into the target web.config file on the server.
However I can't find the way to merge the new web.config sections into the existing web.config file ?
Does I have to do it programmatically, or is there a tool to merge the both files during installation ? (I'm using Web Setup Project).
I am using asp.net oledb to export information to excel file. I encounter problems when the information to export becomes too big, in this case the code I have given below, the excel file generated becomes an empty spreadsheet. If I changed the loop to 1123 for insertion of the rows. The generated excel file is fine, 1125 rows, and 4 columns shown. A test program in windows form is also working fine regardless of how many rows.
Code has been simplified, "information ..." in the sql insertion command represents 1803 characters.
ExcelObjConn = "Provider=Microsoft.Ace.OLEDB.12.0;" & _
"Data Source=" & fileName & ";Extended Properties=Excel 12.0 XML"
ExcelConnection = New System.Data.OleDb.OleDbConnection(ExcelObjConn)
ExcelConnection.Open()
Try
SqlCommand = "CREATE TABLE ABC ([row1] text, [row2] text, [row3] text, [row4] text)"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
For i As Integer = 0 To 1124
SqlCommand = "Insert into ABC ([row1], [row2], [row3], [row4]) Values ('information...', 'information ...', 'information ...', 'information ...')"
ExcelCommand = New OleDb.OleDbCommand(SqlCommand, ExcelConnection)
ExcelCommand.ExecuteNonQuery()
ExcelCommand.Dispose()
Next
Catch ex As Exception
Finally
If ExcelConnection IsNot Nothing Then
ExcelConnection.Close()
ExcelConnection.Dispose()
End If
End Try
I couldn't find a solution to my problem as well. What I did eventually was to run the process using another separate windows service. The code works perfectly fine running from a windows form or service program, but not asp.net, not sure why.
I have one doubt Can we access one web.config file to another web.config file in asp.net
View 6 RepliesI need a code which can export the data from XML file to the Excel file.
View 3 RepliesI have built an ASP.NET (.NET v4) application in VS 2010. It is working just fine. But when I try to create deployment package (so I can deploy it in our test IIS 7.5 Server), it gives me error like this,
Error 1 Could not open Source file: Could not find file 'C:11-2 estobjDebugCSAutoParameterize ransformedWeb.config'. 0 0 test
Thing is in past, I had deployed the SAME application using the SAME method.
I am encrypying my .NET config file using this command and it works just fine:
aspnet_regiis -pe "connectionStrings" -app "/SampleApplication"
For this to work though I have to have a virtual directory called SampleApplication pointing to the folder my web.config file is under.
Is there a way to just specify the path to the file and not have to have a virtual dir?
I tried with
aspnet_regiis -pe "connectionStrings" -location "c:FoldercontainingWebConfigFile"
but i get the error: " path attribute must be a relative virtual path". And cannot contain any of ":" "" etc...
I am looking here:
[URL]
I want to prepare dynamic pdf file using rdlc file. I will try many ways but I can't able to design below format.
User Name: string variable1
Details: string variable2
Report (in table format):
Dataset (table1)
by looking at using the XmlDocument and creating elements and attributes and then inserting them into the document. Pretty soon this looked like a massive amount of work for all the elements I have to add.What are the repercussions of treating the config file as one big long text string and doing a replace at certain points to add my entries. Something like this...
private void InsertXMLElement()
{
StringBuilder webConfig = new StringBuilder();
// get the file into a stringbuilder for manipulation
using (var sr = new StreamReader("C:web.config"))
{
webConfig.Append(sr.ReadToEnd());
Currently, I work on an ASP.NET project which is hosted under version control and is used on several developer machines, tester machine and production environment.
In three cases, configuration (Web.config) may be different. For example, developer and tester environments use testing SQL Server, whereas in production environment, another SQL Server is accessed, so the connection string is different in those cases.
We want to keep three versions of Web.config in subversion. But modifying each of three files every time we need to add, remove or change a common setting is annoying: it would be nice to have a common, master Web.config, which will be inherited by each of the three Web.config files.
How to set up an ASP.NET project which will use a master configuration file and different slave configuration files on different machines, thus sharing the same project/source code/configuration files in subversion?
I have a requirement to create a XML file from sql server data.I need to schedule this job to run at specific intervals of time.I don't know, if I could do with Reporting services.I would like to know, if it's possible with Sql server reporting services? how to do that.
View 2 RepliesWhen I open my ASP.NET site in IIS and try to open the .NET Trust Levels, I get an error message:
.NET Trust Levels There was an error while performing this operation.
Details:
Filename: ?C:inetpubwwwrootmyappweb.config
Line number: 445
Error: This configuration section cannot be used at this path. This happens when the section is locked at a parent level. Locking is either by default (overrideModeDefault="Deny"),or set explicitly by a location tag with overrideMode="Deny" or the legacy allowOverride="false".
I've checked a few places, but I haven't found anything that seems like it would be locking that setting. Is there a systematic way of determining where that setting is locked?
I'm using IIS 7.5 and .NET 3.5 sp1.
I have many Connection strings in my web.config file. I also have a "dataConfiguration" setting in the same file which specifies what database my app connects to.
How do I read the "defaultDatabase" setting / section from the, see below xml file.
<configuration>
<configSections> [code]....
I am developing web applicaiton. I want to read web.config in App.config file. I have appSettings and connectionStrings in web.config. How to read that?
View 10 Replieswhen I reference a assembly. It's reference gets added to the project file in my case ( ABC.csproj)
Also when I take a look at the web.config file there is a section called <assemblies>. And lot of assemblies are added there.
What is the difference between link to the assemblies in the Project file and the assemblies in the web.config file?
Is it possible to have separate config files for specific sections of the web.config? Specifically I'd like to move IIS 7's rewrite section out of the web.config and into it's own config file.
View 3 RepliesIt is known that we use web.config file to override the setting of machine.config file.
a) how come machine.config file knows that only changes made in web.config file are to be overwritten. I mean to say, if I use some other name for the config file say xyz.config, will it be able to work?
b) How does machine.config file know about web.config? Is there any link mentioned inside the machine.config file for that?
I have acess db where i perform a select query which communicates to the sql and pulls up the data and export it as a csv file using asp .net 2.0
View 1 RepliesI want export datatable to dbf . the following is my code. the conection dont open
SqlConnection cn = new
SqlConnection("Data
Source=(local);Initial Catalog=test;Integrated Security=True");
SqlDataAdapte da =
new
SqlDataAdapter("select
* from test", cn);
DataSet ds = new
DataSet();
da.Fill(ds, "test");
string directory =
"E://";
OleDbConnection connection =
new
OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data
Source=E:\TEST.DBF;");
connection.Open();
OleDbCommand command = connection.CreateCommand();
if (System.IO.File.Exists(directory
+ @"TEST.DBF"))
command.CommandText =
"DELETE FROM Test
else
command.CommandText =
"CREATE TABLE Test (ID int, name varchar(50),last_name varchar(50))";
command.ExecuteNonQuery();
command.CommandText =
"SELECT * FROM Test";
OleDbDataAdapter adapter =
new
OleDbDataAdapter(command);
OleDbCommand insertCommand = connection.CreateCommand();
insertCommand.CommandText = "INSERT INTO Test (ID, name,last_name) VALUES (pID,pname,plast_name)";
}
foreach (DataRow
dr in ds.Tables["test"].Rows)
{
int id =
int.Parse(dr["ID"].ToString());
string name = dr["name"].ToString();
string last_name = dr["last_name"].ToString();
insertCommand.Parameters.Add("pID",
OleDbType.Integer, 4, ID);
insertCommand.Parameters.Add("pname",
OleDbType.VarChar, 50, name);
insertCommand.Parameters.Add("plast_name",
OleDbType.VarChar, 50, last_name);
insertCommand.UpdatedRowSource =
UpdateRowSource.None;
In C# ASP.net, could someone show me how I can write entries from an Array/List to a CSV file on the server and then open the file? I think the second part would be something like - Response.Redirect("http://myserver.com/file.csv"), however not sure on how to write the file on the server.
Also if this page is accessed by many users, is it better to generate a new CSV file every time or overwrite the same file? Would there be any read/write/lock issues if both users try accessing the same CSV file etc.?
Update:
This is probably a silly question and I have searched on Google but I'm not able to find a definitive answer - how do you write a CSV file to the webserver and export it in C# ASP.net? I know how to generate it but I would like to save it to www.mysite.com/my.csv and then export it.
I've made a localised website uses resource file and I need to get the client to translate them. Can I export the resource file contents somehow?
View 1 RepliesCurrently I am facing the tedious problem of exporting complete GridView data to the pdf file so that the user can save it. I am using C# as the language in Asp.net 3. The gridview contains only text values.
View 4 Repliesi have data in sql server i want to export to data with asp.net C#
View 3 RepliesExporting DataTable data to CSV file. It is working fine as expected as long as the export records are less than 65,536. When the records are more than 65,536 , only 65,536 records are shown in CSV file (remaing records are not shown). When the export is done(with more than 65,536 records), opening the file shows below message window. File is not loaded completely. When the Ok button is selected, below text displayed...
This message can appear if: You are trying to open a file that contains more than 65,536 rows or 256 columns. To fix this problem, open the source file in a text editor such as Microsoft Word. Save the source file as several smaller files that conform to this row and column limit, and then open the smaller files in Excel. If the source data cannot be opened in a text editor, try importing the data into Microsoft Access, and then exporting subsets of the data from Access to Excel. You are trying to paste tab-delimited data into an area that is too small. To fix this problem, select an area in the worksheet large enough to accommodate every delimited item.
Notes: You can not configure Excel to exceed the limit of 65,536 rows and 256 columns. By default, Excel places three worksheets in a workbook file. Each worksheet can contain 65,536 rows and 256 columns of data, and workbooks can contain more than three worksheets if your computer has enough memory to support the additional data. Solution:- Seems like here is the suggested solution. But it takes ages to export and show data. An export is done about 15mins ago, still it is doing that. Has anyone managed to find/resolve this issue?
[Code]....