I want to block the SQL Server database, so that no data can be export using third party tools and also the specific db can't be restore from old backups
View 1 RepliesI need to create a form builder without using any of the third party tools. i.e a user shold be able to pick his choice of textbox, dropdown ..etc and create a form.
View 1 RepliesI have a web report(.aspx page). I like to have a functionality to export that report into pdf format. Is there any way I can export it to PDF format without using any third party control or product? Or any other way I can use report viewer control's export feature in web page and hiding report viewer control?
View 1 RepliesI'm trying to access an SQL Server Express database out of an ASP.NET HTTP request handler. The handler is run under ASPNET account and uses "integrated security" in the SQL connection string and so I get an error message saying that login for ASPNET account failed and so I can't access the database. This seems to be a very common problem and most answers say "grant access to you database to user ASPNET".
I only have Visual Studio 2008 and I can't find how to change access permisssions for a database. Specifically I use Tools->Server Explorer and I can see all the tables in the database but can't find how to change access permissions. How do I change access permissions to my database using tools shipped within Visual Studio 2008?
I have sql-server 2008 management studio. How can I export the databases with their data?
View 4 RepliesI have SS Enterprise running on my server and SS Express on my laptop. They are both 2008 versions. How can I export a MDF/LDF for me to attach it to the database on my laptop?
View 8 RepliesMy team working asp.net File manage project. In our project we need to export database contents to csv formats
The Database table contains 6 fields. We are using LINQ.
I have opened my database up in VS2005 and it is only showing 1 user but when I load the asp.net config web tool it says I have two. I thought the asp.net tool pointed to the database in app_data?
View 1 RepliesIm using enterprise Manager data access code block and have a table in sql server 2005 with a column type of 'bigint'
when querying against this table and adding in a parameter, there isnt a long datatype available, so is Int32 an equivalent ?
[Code].....
I'm currently trying to install the "new" Microsoft WebMatrix Beta 2 (a web programming IDE). I was trying to use Web Platform Installer for this. But it 404's on the SQL Compact 4.0 CPT2 and it's tools. I was able to get the runtime from the Microsoft downloads page but the tools I am not able to find. I can not install WebMatrix because the tools are a prerequisite.
View 2 RepliesI been googling a bit and not having a clear picture on this. I have a few database now sitting duck in Express and we planning to migrate to 2005 or 2008 enterprise version. Currently, all the sensitive and important data are stored in the Express. We wanna do the migration but we do not want to impact a single column in a table. E.g. some numbers becomes different format like 234E whatever watever. Is there any good tools out there to do the job with the least efforts ?
View 2 Repliesi have installed visual studio 2010 sp1, i have installed everything to do with compact 4 from web platform installer. yet when i try to connect to a compact 4 database, their is no choice for compact 4, there is a choice for compact 3.5 but no 4. If i try to connect using tthe 3.5 choice i get an error. i can add a compact 4 database from the new items menu. but i can not make a connection to it.you can see in this tutorial compact 4 listed in the add connectiojn box, but it is not listed in mine[URL]
View 4 RepliesCan I export my Gridview data to an Access Database (MDB), like how we will export to Excel ?
View 6 RepliesI have a web app that delivers a page at .35 seconds on development server.But on production it takes 2.79 seconds.Is there a tools that is cheap that I can use to determine why the page is being delivered so slow?
View 2 Repliesxport data from excel file to Access accdb database in c#?
View 1 RepliesI have a requirement that , i have a table of 400 columns.Here i need to Export this table to Excel sheet.And i need to upload to Open Office Sheet. I do not have MS-office.This is in ASP.NET and C#.NETI am new to this concept.And friends there is a problem , i have 400 columns , which is not possible to insert into Open Office Excel , i need to insert other columns into new sheet
View 3 RepliesI can't use Dataset.WriteXml("Path");
View 13 RepliesI need to create export to excel , i tried export gridview to excel but it haves html css with it and on opening it ask for it or showing missing style etc, how to write to excel without html.
View 1 RepliesWhen I am Exporting CSV Using Reader,Here Attached Coding for your reference,
PrecisionColumns = New String() {"Salequantity", "Salevalue", "Purchasequantity", "Purchasevalue", "Stockvalue"}
If Trim(Rdr.GetValue(I).ToString() <> "") Then
csv += Format(CDbl(Rdr.GetValue(I).ToString()), "0.00").Replace(",", ";") + ","c
End If
csv += vbCr & vbLf
Response.Write(csv)
... ...
I get precision in CSV file ,but when i open the csv file in excel Precision not showing, how to show precision on excel sheet...
i hv a upload btn on my web page . i want on upld of excel sheet data get transfr to tbl student in sqlserver 2005 hv following fields
adno primary key,
sname
smob,
semail etc.
I have page with a link button.. on click of link button I want to save my quary result into excel file with save as dilog box..(like download dilog box in mozila)
View 4 RepliesI have tried using GridView control to display the data from SqlDataSource control but there are just so many columns and one of the fields contains a lot of texts so using GridView control to display the data does not look look since it goes out of the master template. I have tried using GridView control to display my data and use the following code to export as Excel but in case, there are just so many columns.
[Code]....
What are some other better ways to export to Excel file from my web page?
I have code to export the grid to excel . i have taken it from [URL] now i want to save excel file directly without asking user to save it or open it at client side. i want to save it on server folder. how to do that .
View 2 RepliesI have menu item on my master page that has block around the text when the page is first run. I wrote in the css on the link and visited property to change the color to match the image color that it is on. When a menu item is clicked the color changes to the right color. How do I get it to the right color on when the page first opens or is there a way to get rid of the block or make it transperant?
View 1 RepliesThere are 2 tables in sql server 2008. I am updating 2nd table with 1st table data. one of the column data type in the 1st table is char(10) and the same field in other table is varchar(10).
On updation I m using bcp utility to export to txt file from table 2.
But data exported is exported with spaces at the end.
Is there any way to remove these spaces.