Re: back up sql data programmetically - ASP.NET Discussion Boards

Christian Graus14-Jul-09 2:31

14-Jul-09 2:31

Looks to me like you insert the same value from the textbox all the time. Your code is also bad for other reasons. The most obvious one - I can erase your database any time I like, because you do nothing to protect against SQL injection attacks.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: Help Related to database

Abhijit Jana14-Jul-09 2:33

Abhijit Jana

14-Jul-09 2:33

KhandelwalA wrote:
I am creating n number of text dynamically,

Where did you crated the textbox? means in which event? If you are not creating dynamic textbox before Page_load(). and best to create in Page_PreInit(). Because all Postback data and ViewStore data restore just before Page_Load().
So if you create dynamic textbox before page_laod it will not able to hold the viewstate or postback data.

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Problem forming .msi file in Visual Studio 2005

Anujit14-Jul-09 1:20

Anujit

14-Jul-09 1:20

I am facing the following problem.

i have a solution file having more than one asp.net-c# project file.
I have added Web setup file to the solution and then add->group option, then the primary output and the content file of all the project to the setup project.

Then I have built it. And then installed it. This all the process was successfully done.
A virtual directory was created too.

But when I want to browse the site, i can see all the html pages. but no .aspx file. then I have discovered that there is no .aspx.cs file in the location.

I am deploying a project for the first time.

Please help.
Thanks in advance.

Anujit Karmakar
Software Programmer

Re: Problem forming .msi file in Visual Studio 2005

Vimalsoft(Pty) Ltd14-Jul-09 2:00

Vimalsoft(Pty) Ltd

14-Jul-09 2:00

Good Day Anujit

There are Different types of Deployment , Some don't have the CS some do have. In the Properties -->MSBuild Options, you will find that there is an option that says "Allow precompiled site to be updatable" or others , if one one them are checked then uncheck them and build your setup again and install it and the CS Files will be in your destination file.

Thanks

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: Problem forming .msi file in Visual Studio 2005

Abhijit Jana14-Jul-09 2:25

Abhijit Jana

14-Jul-09 2:25

Anujit wrote:
but no .aspx file. then I have discovered that there is no .aspx.cs file in the location.

aspx file should be there. but there should have no aspx.cs file. And the reason is the deployment of web application (publishing). I will suggest you first read the article, then let me know if any doubts
WS Publishing

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

back up sql data programmetically

billcodes14-Jul-09 0:44

billcodes

14-Jul-09 0:44

hi,
I am using sql database with asp.net in c#.I have a database application.HOw can i back up the data programmetically?
regards
Bill

Re: back up sql data programmetically

Manas Bhardwaj14-Jul-09 0:48

Manas Bhardwaj

14-Jul-09 0:48

this should help[^]

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: back up sql data programmetically

r a m e s h14-Jul-09 0:51

r a m e s h

14-Jul-09 0:51

Refer these links:

SQL Server Database Backup Utility using VB.NET and SQL-DMO (New version)[^]

http://www.aspfree.com/c/a/VB.NET/Simple-BackupRestore-Utility-With-SQLDMO-Using-VBNET/[^]

http://www.experts-exchange.com/Programming/Languages/.NET/Visual_Basic.NET/Q_24262177.html[^]

Re: back up sql data programmetically

Sabari MD14-Jul-09 0:52

Sabari MD

14-Jul-09 0:52

backup database 'dbname' to disk='C:\...'

Sabari MD
Application Developer
Veloxit Info Solutions

Re: back up sql data programmetically

Vimalsoft(Pty) Ltd14-Jul-09 2:28

Vimalsoft(Pty) Ltd

14-Jul-09 2:28

That is Simple

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go


-- backup a database
ALTER PROCEDURE [dbo].[sp_BackupDatabase]

	@databasename varchar(32),
	@path varchar(256),
	@filename varchar(64)

AS

set nocount on

declare @sql varchar(4000)

select @sql = 		'BACKUP DATABASE ' + ltrim(rtrim( @databasename ))
select @sql = @sql + 	'   TO DISK = ''' + ltrim(rtrim(@path)) + ltrim(rtrim(@filename)) + ''' '
select @sql = @sql + 	'   WITH INIT'
--print @sql
execute ( @sql )

select 'Database successfully backed up!' [Result]

Welcome

Dynamically radiobuttons?

Priya Prk14-Jul-09 0:18

Priya Prk

14-Jul-09 0:18

Hi Friends,
Im new in this and hope to get some advice.
I have to make a application to give advice to the students wich study direction they can choose.
They have to get a questionlist that they can awnser. The awnsers can be yes or no, or more then that, with 3 or more choices. The user can only select one awnser. So i have to use radiobuttonlists.
Now how can i implement this ? how can i make dynamically radionbuttonlists? what's the easist way to get this work?

Thanks

Re: Dynamically radiobuttons?

s.crosby14-Jul-09 0:35

s.crosby

14-Jul-09 0:35

Hi Are you looking to build the radio buttons in Javascript, or through an AJAX update panel ?

Re: Dynamically radiobuttons?

Muhammad Mazhar14-Jul-09 0:41

Muhammad Mazhar

14-Jul-09 0:41

All you need is to load your data in some data wrapper answer by answer and then bind it to radio button list control by assigning it to its datasource property and call databind upon control.

Share your experience with others
Check my Blog...

Re: Dynamically radiobuttons?

Sabari MD14-Jul-09 0:51

Sabari MD

14-Jul-09 0:51

if you want to make radio button dynamically , make html radio buttons

Sabari MD
Application Developer
Veloxit Info Solutions

add custom function to built-in function list in InfoPath

JimmyRopes14-Jul-09 0:12

JimmyRopes

14-Jul-09 0:12

How do I add a custom function to the built-in function list in InfoPath.

I have some custom functions that gather Active Directory information I would like to auto populate into InfoPath form fields that I want to include in the built-in function list drop down so a non-programmer form designer can apply them to fields on their forms.

I know how to do this programmatically so please don't tell me to add event logic to the form because there are many different organizations designing forms that need this functionality. I need to present these functions to people as they design their forms so they can apply them to textbox fields.

For example I would like a textbox field to populate with AD information, say telephone number or location, just like they would apply the userName function to get the name of the user logged into the workstation filling out the form in an application.

Simply Elegant Designs JimmyRopes Designs
Think inside the box! ProActive Secure Systems

I'm on-line therefore I am.
JimmyRopes

Reload Frames

yesu prakash14-Jul-09 0:02

yesu prakash

14-Jul-09 0:02

Hi,

I a parent page i have two frame, each having diffrent source pages.
How can i reload a page from another page?

eg: page Frame.aspx having two frames, onec src is home.aspx, second is user.aspx. When a button click event occur in home.aspx, i need to reload the user.aspx without changing position and without reloading Frame.aspx

Thankyou
YPKI

Re: Reload Frames

Baran M14-Jul-09 1:20

Baran M

14-Jul-09 1:20

Didn't you try Master Pages instead of html frames ?

Education is not a way to escape poverty — it is a way of fighting it.

plz send an article on grid view updating value

haleemasher13-Jul-09 23:25

haleemasher

13-Jul-09 23:25

plz anyone send updating gridview in simple steps.its source should b taken from more than one table and having no datakey

Re: plz send an article on grid view updating value

Baran M14-Jul-09 1:31

Baran M

14-Jul-09 1:31

Any specific questions ? If you google or bing it you will get a lot examples

Education is not a way to escape poverty — it is a way of fighting it.

Re: plz send an article on grid view updating value

Christian Graus14-Jul-09 2:32

Christian Graus

14-Jul-09 2:32

Surely your book has examples.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: plz send an article on grid view updating value

Vimalsoft(Pty) Ltd14-Jul-09 2:32

Vimalsoft(Pty) Ltd

14-Jul-09 2:32

Before you post you must first Google.

see below how its done.

http://www.dotnetfunda.com/articles/article71.aspx[^]

We will forgive you for now.Because you are 5 months old in CP

Crystal

Chris Maunderr13-Jul-09 22:56

Chris Maunderr

13-Jul-09 22:56

How can i pass parameter to crystal report so it display the parameter recod and not all the record in teh table. I'm using a wizerd to make the report

Re: Crystal

Manas Bhardwaj13-Jul-09 22:59

Manas Bhardwaj

13-Jul-09 22:59

GlobalUni wrote:
How can i pass parameter to crystal report

Have a look here[^]. This would surely give you an answer.

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Crystal

Chris Maunderr13-Jul-09 23:19

Chris Maunderr

13-Jul-09 23:19

I don't use google what search engenise u have other than that

Re: Crystal

Manas Bhardwaj13-Jul-09 23:26

Manas Bhardwaj

13-Jul-09 23:26

GlobalUni wrote:
I don't use google what search engenise u have other than that

MSN Search 
Ask.com  
GoodSearch  
SearchMe  
Quaero  
Ask.com  
Live Search  
ChaCha Beta  
Guruji.com Beta  
wikiseek  
Sproose  
Wikia Search  
Blackle.com  
Powerset  
Viewzi  
Cuil  
Boogami 
LeapFish Beta  
VADLO  
Sperse! Search  
Duck Duck Go  
Searchme  
Bing

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.