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
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
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 RepliesI 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.
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]....
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 RepliesHow 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";
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"
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.
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 RepliesI 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 RepliesHow 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 RepliesI 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?
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 RepliesHow 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)
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 RepliesIs 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 RepliesI'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 RepliesI 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 RepliesI 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.
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.
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]...
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?
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 Repliesi 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
