DataSource Controls :: Back Up To New File Every Day?

May 18, 2010

I set up a daily backup for our database, however I noticed that rather than creating a new file for each restore point, SQL server just appends to one back up file. This is an issue, IMO because what if that one back up file gets corrupted? Is there a way to back up to multiple files (one new file per day?)

View 2 Replies


Similar Messages:

DataSource Controls :: Making A Zip Of The Back File

Jan 16, 2010

i am coding fr taking databse backup frm my asp.net web application

i get the backfile in .bak form. how do i zip it. make it in zip form

View 1 Replies

AJAX :: How To Return Back Back To Code Behind File After Cascading Dropdown Calling

Aug 29, 2010

I have a cascading dropdown. After the dropdown is populated(it is in another file) i would like to return back to the original form where the control is placed. is there anyway of doing it

View 4 Replies

DataSource Controls :: SqlException Not Getting Sent Back To C# Code?

Jan 22, 2010

I have a straight forward SP that throws a divide by zero error like:

[Code]....

Note that even though I am calling RAISEERROR() its not getting returned back to my code if I use this try catch. When I remove the try catch like above it returns fine. I made sure that the severity level is >= 11 so it's not ignored. At this point I'm out of ideas because everything I can find published seems to say that this should work.

FYI my C# code is pretty straight forward I don't think it has anything to do with it as I have a wide open Exception catch and it's never getting called so I'm not posting it to keep this message brief.

View 3 Replies

Forms Data Controls :: Upload A File Using Asp:formview And Retrieve File Data Back?

Mar 1, 2011

im tryign to do an upload using an aspforview, does this mean i have to do a findcontrol for all the items to get the results?

as in the uploadfile func it cant find any of the fields, how do i do this?

also id like to get the filesize, type and name back so i can put them in a database

[Code]....

View 7 Replies

DataSource Controls :: Back End SQL Express 2008 Database

Mar 24, 2010

I have written a website in ASP.NET with a back-end database using SQL Express 2008. My database is created and put in the App_Data folder. It is ok when it runs on my local machine. However, when I upload to the web server, I got the error: An attempt to attach an auto-named database for file C:Documents and ettingsDesktopProject2_ISAM5337App_DataEvent.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share. By the way, I notice a same probelm : When I move my project to a location which is different from specific path for my database, I got the same error message .

View 1 Replies

DataSource Controls :: C# - Can Save Datatable Back To Database

Apr 25, 2010

How can i save the datatble back to my database?

First i selected some rows from database then using adp.Fill(DT) i filled datatable then i closed connection.

Then i made changes in this datatable in some rows & now i wonder how can i send this rows back to database?

NOTE:-i modified my datatble using FOR loop .and i set cells to someother values like dt.rows[2][2]="anything i want";

View 1 Replies

DataSource Controls :: Getting Dataset Back After Assigning It To GridView?

Jan 16, 2010

I have a code something like this :

MyLinqDBDatacontext db = new MyLinqDBDatacontext();
var taskname= db.my_stored_proc_get_taskName(int taskId);
gridview.datasource= taskname;
gridview.databind();
this works fine

but i when i am using LINQ it gives me result in the form ISingleResult so can anyone tell me how to get a dataset from a girdview after assigning data to gridview

I need a functionality something like :

Dataset ds= new Dataset();
ds="Here i want a dataset converted from a gridview"

View 2 Replies

DataSource Controls :: How To Update Dataset Back To Database

Jan 23, 2010

I want to reformat one column in database. So that I've used strong typed dataset by drag and drop in VS 2008. When I've already updated all data in dataset, I call method update() of table adapter to perform update my modified data of dataset into database. But it doesn't work.

Below is my code

[Code]....

The RemoveWhiteSpace(string input) is my function to remove special characters from dataset.

View 2 Replies

DataSource Controls :: Transaction Roll Back On Exceptions?

Feb 22, 2010

Does a DB transaction get automatically rolled back during exception or we should explicitily write transaction .Rollback inside the catch block to rollback a transaction...

View 3 Replies

DataSource Controls :: Use Two Table Gridview Show Up - Datatable Come Back As Empty

Nov 1, 2010

I am trying to populate a gridview using two tables. I also have a strongly typed dataset and used the method on this page: [URL] the problem is that, when i try to use two table the gridview does show up (I checked through debugging that the datatable comes back as empty).

View 2 Replies

Web Forms :: Referencing Page Controls From Code Back File?

Feb 16, 2011

How to I reference say a text box from my code back file? I am having issues with trying to execute an sql query from the click of a button and then place the result into that text box...

View 9 Replies

Forms Data Controls :: Interrogate The RBL And Set The Label So The Correct Value Is Passed Back To The Datasource?

Mar 1, 2011

I have a Gridview with a templated column that gets a True/False value from the SQL Datasource. The value displays as a string in a label in the template. I added a RadioButtonList and in the RowDataBinding event put in some logic to set the appropriate radio button based on the text value of the Label.

Now I want to be able to interrogate the RBL upon update and set the Label text accordingly. I tried the Row_Updating event but that doesn't have a handle on the row itself and the RBL is not in the NewValues or OldValues collection since it's not one of the bound fields. I tried the RBL_SelectedIndexChanged event but I can't get the current row (got a handle on the Gridview but Gridview.SelectRow and Gridview.SelectedDataKey are both null).

how to interrogate the RBL and set the Label so the correct value is passed back to the datasource for update?

View 2 Replies

Forms Data Controls :: Back Button Doesn't Go Back When Canceling / Updating Edits In Gridview?

Mar 31, 2010

I have a gridview bound to a sqldatasource with editing enabled. If I click Edit, then either Cancel or Update, the update or cancel occurs and the Edit button reappears. However, I cannot then click the browser's back button without having the Update and Cancel buttons reappear. A second click of the back button takes me to a state where the Edit button shows again, *then* another back button click will take me to the referring page (the one before the one with the gridview on it.) IOW, it looks like the postbacks are cached. How can I prevent this and have the back button go straight to the referring page?

View 4 Replies

DataSource Controls :: How To Create A Schema.ini File From A Tab Delimited File

Sep 13, 2010

How do I create a schema.ini file from a tab delimited file?

I have this so far:

[myFile.txt]
ColNameHeader=True
Format=TabDelimited
CharacterSet=ANSI

I think I need something like this after my last line from above:

Col1=first TEXT width 150

My text file has 7 columns, the first row is the header row. The data comes from a Micosoft SQL Server Database where the fields are of the following types:

int
nvarchar(MAX)
nvarchar(50)

View 1 Replies

DataSource Controls :: Importing Xml File Into Sql Server (.sdf) With Mapping File (Sql Server Compact Edition)?

May 10, 2010

I have been searching for some information on how to import my xml file into a series of tables using a mapping file (schema).

View 2 Replies

DataSource Controls :: Store Images Directly In A Database Or To Just Store The Name Of The File In The Db And Display That File?

Mar 25, 2010

Is it better to store images directly in a database or to just store the name of the file in the db and display that file? I would think that just storing the filename of the image would keep the db size low...

View 1 Replies

File Upload Post Back?

Oct 5, 2010

I'm using a asp file upload control, however, when other controls trigger some post back actions, the file upload value return to null...any sample code i can follow please?

View 2 Replies

Convert Object Back To File?

Feb 13, 2010

I want to convert an object of System.Byte[] which is actually a file, retrieved from the database, back to file and store the file in a folder. How can we convert it using ASP.Net with C# ?

View 2 Replies

DataSource Controls :: How To Convert The Sql Server 2005 File To Sql Server 2008 File

May 24, 2010

I have a problem, I have created a website that is run on local host database is make in 2005 sql server

now i am using sql 2008 and visual studio 2010 , I attach the sql 2005 mdf file in sql 2008 server and run it working correctly when we host it then it is not working

problem gives "NT NETWORK SERVICE FAILED "

how we can convert the sql 2005 mdf file to sql 2008 file.

View 2 Replies

SQL Server :: Make A Back Up File (.bak) Of Database?

Sep 26, 2010

I need to make a back up file(.bak) from my database (.mdf)

I learned that i need to use Ms SQL Server management studio express. I can't figure out how to connect to the database. looks like I need to select a server type, but nothing comes up for me to select. The databse was made using visual developer 2008 ms sql server, so i thought something like "SQl Server 2005 or 2008" comes up, but it didn't.

View 2 Replies

DataSource Controls :: How To Get File Name On "File Not Found" Exception

Feb 28, 2011

On Page_Load I create dynamically table as following:

//compose the SQL statement
string strSQL = "SELECT images.location, products.description, products.price, products.isNew ";
strSQL += "FROM images INNER JOIN products ON images.idImages = products.idImage ";
strSQL += "WHERE products.idCategory=" + str_idButtons;
strSQL += " AND products.doShow=1 ORDER BY products.isNew DESC"; //new first
MySqlConnection con = new MySqlConnection(ConfigurationManager.ConnectionStrings["????????"].ToString());
MySqlCommand command = new MySqlCommand(strSQL, con);
con.Open();
[code]...

View 3 Replies

C# - Complete The Post Back After Writing Out A File To The Response?

Jan 28, 2011

I have a button that when clicked, will generate a PDF and write it out to the response.This is the basic structure of the code:

try
{
using(Stream stream = generatePdf())
{

[code]...

Downloading the file works fine, except that it doesn't complete the postback.If I were to throw an exception above file.Transmit, the error handling would work properly and I would see the message get displayed in my browser. However, if there is an exception after the file.Transmit then nothing happens. The user saves/opens the pdf and the page does not reload.How can I make it so that the postback always completes, that way I can display an appropriate message to the user?

View 2 Replies

ADO.NET :: Bring Back The Table Deleted From Edmx File?

Dec 29, 2010

I need to add a table to a .edmx file. Earlier I had added that table, say, Table A to the edmx file. Since keys were not set, I had to delete it. Then in order to bring back the altered Table A to the file, I right clicked the file and clicked the option 'Update Model from Database'. But I couldn't find the table I deleted from the edmx file. It is there in the database. how can I bring the table back to the edmx file.

View 1 Replies

DataSource Controls :: How To Get The Password Of Sdf File

May 24, 2010

i have a sdf file. when i tried to open that file in sql server 2008, it is prompting me for a password. unfortunately, i dont have the password, what do i do ? any password reset options or password recovery options or password breaking options ?

View 9 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved