I need to make data export/import from sql enterprise server to local sql compact. It has to be automatically, so I can't use programms like SQL Management Studio. how to make such export/import?
View 2 Replies
I wanna know how can i generate PDf file on the fly from the data available in my Database.
View 3 RepliesI have a website that occasionally needs to have a handful of the tables in its database updated. The updates come from another system that exports to comma delimited text files. I can then either FTP the text files to the web server, send them in through an admin upload page, or manually log in to Remote Desktop to download the text files. I have all my C# code written to parse the files, check the database contents, and decide what to do.
Should I code the sync logic to be part of a file upload page, protected in the admin section of the site or should I create a Windows Service that constantly looks for files to process in a particular directory that I can drop files in through FTP?
I have used Windows Services in the past and they have worked great, but if I ever have to make a change to the code it can take longer than it would if I just had to modify an ASPX.
Are their security benefits one way or another?
Performance benefits?
ASPX page wins the "ease of maintenance" category.
I am trying to generate a Grid view from database, in one of my database columns the values are 'y' and 'N'. and i need to show this values in a check box .I tried to keep a check box in item template and tried to bind it, but could get much success.
[Code]....
I have an application I am trying to write that generates a text file conforming to a file specification, and the file could contain thousands of lines. This part is easy. The more challenging part for me is the user interface. It needs to be a web interface with various options to affect what data gets on the file; this part is no problem. The process for generating the file, though, could take a little time depending on the amount of data , and I would think the web page would time out.
What options do I have for the UI? Could I create some sort of service that the page calls and runs in the background? When the process errors or is finished, I'm thinking there could be an email sent out, or even messages displayed on the page.
I have a couple of super simple databases. Basically they all consist of single tables that saves tracking/logging data etc.
Now I want to list this data but I'd like to find a solution that's applicable to all the different tables in all the databses. SO basically I'm looking for some way/some pattern of pointing a solution to a database, generate code and GUI and the publish the site. The tables can have huge amount of rows so I need functionally like paging etc but otherwise a simple list is all I'm looking for as a first step. I've been looking at Dynamic Data from MS - could this work? Other options? I'd really like the web sites to me ASP.NET MVC ...
As a seconds step I'd also like to have the possibility to change/add and delete data from the rows via the GUI.
I would like to generate a dynamic sitemap to my website.It should be updated daily. Depends up on database user i have to generate.I am in initial stage of my website development.What are the things i have to take care. And how to develop a sitemap according to my requirement. I am using TeamSys 2008
View 3 RepliesI want to generate PDF files from Word Documents(.doc, .docx) or excel documents(.xls,.xlsx).
I tried using ITextSharp but with that I am not able to render the images/tables etc of word document into the pdf.
how could i dynamically generate few thumbnail of my site's home page and shows them in another page.
View 1 RepliesI am triyng to generate a report that analyzes what people are searching for on my website.I've managed to generate a report on exactly what people are searching for (full phrase), and another report that lists the appearance count of each word.The final report I need to create involves analyzing the occurances of two words.I have an SearchLog object, which I can load into a List<SearchLog>, each record containing information on a search performed on my website. The SearchLog object obviously contains a property for the search phrase, amoung other properties.Lets say there are 2 search logs I pull from my database:
1. Trash Bag Liners
2. Garbage Bag Liners
My query would need to return the following:
Bag Liners: 2
Trash Bag: 1
Garbage Bag: 1
Currently I am attempting to create an RSS feed for a blog website I build using ASP.Net MVC with C#. Currently I am simply creating a controller and index page on /feed of the site which does dynamically generate an RSS file but it doesn't work well since the document itself isn't actually an xml file but just a htm file made to look like an xml file.[URL] I attached the code I use to do this but is there a way to instead create an actual XML file so google and feedburner will treat it like a standard rss feed?
[Code]....
I have table with data
[code]...
This table has data about all pages with sub sections and tab column indicates that it is tab on that page but not a new page I want to generate xml and generate a breadcrumb using this data, how can i achieve that using this data?
i want to generate the xml file from edm schema for indivual tables data
View 1 RepliesActually I'm not a professional in ASP.NET. I'm going a project that needs to support two languages (Russian and English).I've already completed the main parts and the site is now 95% functional.However, now I need to enable language selection on the site.
I'm going to do it with DropDownList, where a user chooses one language from DropDownList, the content must change to particular language.
All texts are displayed using server controls like Labels and Literals. Links are in Hyperlink or LinkButton.
I did some research to handle with my condition, but no-one suits on my condition, because I've almost completed the application. How to generate Global Recourse files for controls on the page?
how can i generate treeview from database using jquery. I have table with column ID,Name,ParentID. I am new in MVC.
View 3 RepliesURLs are stored in a database, example:
home/page1
gallery/image1
info/IT/contact
home/page2
home/page3
gallery/image2
info/IT/map
and so on.
I would like to arrange the above urls into a tree fashion as shown below (each item will be a url link). The final output would be a simple HTML List (plus any sub list(s))
thus:
home gallery info
page1 image1 IT
page2 image2 contact
page3 map
Programming Language is C# , platform is asp.net
EDIT 1:
In the above example, we end up with Three Lists because in our example there is three main 'groups' eg: home, gallery, info.
Anyone know of a simple tool to quickly create POCO classes based on an existing database?
I am just looking to create the POCO classes that could be used with any ORM that supports it so my interface and model can remain independent.
How do I generate a unique number in c# without the database? (max 17 digits). EDIT: digits only.
View 2 RepliesI'm looking for guidance of how to do some things for my application, I cannot resolve how to do the following:I have users and categories in a database, then I have a Master Table where these users combine with the categories creating rows, in this table there are other columns too.So for instance,
Master Table
User1 | Category2 | Date | Cost
john mainteinance nov1988 5000
along with more columns.
I managed to create the other tables so my application can capture this data, can add or erase users or categories, and everything still works great.The problem is that I need to generate reports from this Master Table, so for instance if I select john from a dropdownlist, I need to generate a report with all of its sells totals separated in categories, the thing is, I could just make a query asking for that, but the problem is that like I said you can add new users, new categories, or erase etc... so I just cannot get the logic to build something like a gridview and get what I want just passing the user name selected, and automatically getting me the total of all categories, no matter if later they add one, still comes back with the total of the new one, or if they erase one it will not display it etc...
If you could give me some general info of how to do it it would be appreciated, I'm thinking computed columns but I just don't know how to calculate ti.
Ok my website I built for fun effeduptxt.com I am trying to take all the posts that are displayed and have the keywords for the page be auto generated at page load.
Now I know how to add keywords from code behind I just never tried to scrape the data in the database for what would be the best keywords to use.
Has anyone ever done this and or know where something like this is on the web.
I can create the SQL Query and the C# code how to determine what is a bogus word that should not be included such as I could count how many times each word is shown and go for the most common words as the keywords but that would include words like "And", "Or", "It" etc... and that would not be good.
I have no problem with studying more detail about it and expect to do so I just need to get set onto the right path....
Site.Master file contains
<ul id="nav">
<% Html.RenderAction("Menu", "ShoppingCart"); %>
</ul>
[ChildActionOnly]
public ActionResult Menu()
{
// for to geenrate menu ?
return ????
}
How to generate hierarchical menu below in Menu method from database data ? Should I use stringbuilder or is there better way ?
Resulting html shoudl look like:
[Code]....
Is there any existing software for generating a UserControl from a table of a database?
For example, my table contain 3 fields : name , last name , age.
The software generates a user control that has 3 labels and textboxes with validation and submit button and a gridview for displaying information , etc..
I have a small web application based on asp.net 2010 that manages invoices.
After the invoice is saved, it should automatically generate a pdf file.
which of the following solutions would be fast and easy to incorporate?
Use Sql Server 2008 Reports
Use Crystal Reports 2008 and Crystal Reports 2008 for VS 2010
Use itextsharp to create the pdf file
Use XSLFO to create the pdf file
The point here is I dont know any of the above. Which one is easy and quick to learn and implement. Are there any other solution to achieve this functionality?
I'm new to c# programming..I'm using windows form application c# .netI have been given a .resources file. it contains 2 columns 1) key and 2) values.I have brought the contents of this file into a datagrid using dynamic table in between and using resource manager.Now i have to edit the value column in the datagrid and if i click on a GENERATE button i should create a new resource file and it has to be stored as a file. In the same way i should create many sucj resource file.
View 1 RepliesI would like to generate a static URL based on a few parameters.The page serve the file for downloading is called CertificateDownload.aspx ,I am generating the download link in Report.aspx.These 2 files reside on the same physical folder.I do not like the replace method ,but I could not think of another way of doing it.How can I improve my code or what is a better way of doing it.
I need the absolute url to be displayed as text in the web browser.
Dim downLoadUrl As String = HttpContext.Current.Request.Url.ToString.Replace("Report.aspx", "CertificateDownload.aspx") + "?CertificateID=" + CertificateName
HyperLinkDownloadLink.Visible = True
HyperLinkDownloadLink.Text = downLoadUrl
HyperLinkDownloadLink.NavigateUrl = downLoadUrl
