DataSource Controls :: Making A Zip Of The Back File
Jan 16, 2010i 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 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 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 RepliesI accept both C# and VB.NET
If you visit this [URL] and then click on the link like the image below you'll see in-line pop-up DIV which displays a busy status of Ajax callback before it displays the information. So, the information is not there yet until you click on the link.
I'd like to do the same but ASP.NET and jQuery.
I have a searchbox where i ask for information to a table, but i want to rewrite the code so i can search from several tables.
Here is my temporary select command which works great when using only one table:
[Code]....
HDSK_AUTO HDSK_ID HDSK_CASEDESC
1 TC1 pc spoil
2 TC2 problem
Action table:
ACT_AUTO ACT_HDSK_ID ACT_DATE ACT_TIMEIN
ACT_TIMEOUT ACT_ACTIONS ACT_STATUS
[code]...
How do I go about doing this in SQL? I need to return 3 columns: ID, the stuff combined into a single field, and the latest status of each ID. (by latest I mean the most recent entered record's ACT_STATUS. this could be based on the ACT_AUTO I think, which is the auto-increment number)
i am making a quiz system in asp.net using C# vs 2008.having one equestion per page,with previous and back button.each question have four options with only one correct answer.The options are in a radio button list.I have a database which has two columns as QuestionID,CorrectAnswer.
For viewing previous answer the user can click on previous button,so that he can see his previous marked answer and if feel he had marked the wrong option then he can mark the other one.
Some Problems:-when clicking the previous button the option which was marked in radio button list got unchecked!!So,the user is unable to know which he/she had marked before.I want that the option remains checked so that the user knows what he/she had marked previously.After completing the quiz how can the answers selected by the user be compared with the CorrectAnswer stored in database and can be displayed in the result page having four columns as QuestionID,CorrectAnswer,UserAnswer,Right/Wrong in a grid view. Though i am able to display the QuestionID and the CorrectAnswer in a grid view in the result page.
I am using "ASP .Net 2.0" with "SQL Server 2005". What is better and preffered approach towards making a sqlconnection to interect with database?
1. To open new connection each time we need to interact with DB and then close the connection
2. Or to make a shared database connection for whole web application.
I have a database table column consisting of text URLs [URL] In my LINQ-to-SQL-driven gridview, I want to make this a clickable link programmatically, with differing link text (e.g. "Link text"). I'm getting close but am missing some key concept. Here's the core of the .vb codebehind:
Dim dctx As New ResourceMod.ResourceModDALDataContext
Dim eleResObj = From eleRes In dctx.Resources Where eleRes.Type = "url" Select siteurl = eleRes.Website
GridView1.DataSource = eleResObj
GridView1.DataBind()
This displays the raw URL in the gridview (i.e. non-clickable). I've experimented with adding an explicit hyperlink column a la [URL](setting AutoGenerateColumns false etc.), but haven't yet figured out how to assign the asp:hyperlink Text and NavigateUrl fields with the anonymous-type object eleResObj. Using a field construct such as Text='<%# Eval("siteurl") %>' isn't working, presumably a scope issue. Is a LinqDataSource needed in this case, and if so, how would that affect the original LINQ query?
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 Repliesok i have a file link not in the vs 2010 project .basically i have a list page in which i want to show the files, one file each for different organization. how can i make a link to that xml file which exists outside the project
View 1 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 Repliesmaking a file link
View 5 RepliesHow can i make a downlandable file links in asp.net mvc for downloading the files.Also how can i show the file as thumbnail in my page in asp.net mvc.
View 4 RepliesFor my project(in asp.net) i wrote near 1000 lines of c# code for one asp.net page.It includes so many functions.The problem is,it is going complicated while i am writing more codes on one page.How can i make multiple c# files for one asp.net page?? I tried by adding new class in VS2008.But calling a function from one file to other is making error(item is not present in current file).How can i do that??
View 6 RepliesI need to make a backup copy of a file on a remote server. The backup will remain in the same directory on that server. The problem I am having is that the file is large and it appears to be copying it back to the server the code is running on and is taking too much time. Is there a way to make a copy of the file in place without it being sent across the network?
View 4 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 RepliesMy goal is to take some form inputs and prompt the user to download a summary of everything once a certain button is clicked. I have no need for the file once it is downloaded and so I'd like to have a solution where the data is streamed directly to the user. My current solution doesn't even prompt the user for a download. Can anyone point out what I'm doing wrong?
I've got it wrapped as a webmethod and so I needed to add a definition of the _Default page class so I could access certain things.
[Code]....
this wasn't mentioned earlier but the webmethod is being called by an AJAX request!
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 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?