Re: Who to create BackUp DataBase Sql Server From C#.Net - C# Discussion Boards

Wrap Multi row value into one string [modified]

haishan12-Jan-08 1:45

2-Jan-08 1:45

Hello, hope someone can help!

I have one gridview with data like:

ClientID WorkerName
112 Jon
112 Tom
112 Jenny

I would like to fetch this into One row if it is possible:

ClientID WorkerName
112 Jon, Tom, Jenny

I am using Access as the database and asp.net with c#.

Thanks in advance! Smile | :)

modified on Wednesday, January 02, 2008 12:01:20 PM

Re: Wrap Multi row value into one string

DotNetXenon2-Jan-08 4:22

DotNetXenon

2-Jan-08 4:22

Loop through the gridview Dataset and store the
ClientID, WorkerName in another dataset.

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

Re: Wrap Multi row value into one string

haishan12-Jan-08 5:23

haishan1

2-Jan-08 5:23

Hello, I am new to .net, can you please show me what you mean?

thanks

Who to create BackUp DataBase Sql Server From C#.Net

Thaer Hamael2-Jan-08 1:45

Thaer Hamael

2-Jan-08 1:45

Hi all
I wount by using C#.Net BackUp Of DataBase From SQl Server
Thanks for any body help me Rose | [Rose]

Thaer

Re: Who to create BackUp DataBase Sql Server From C#.Net

Jimmanuel2-Jan-08 2:03

Jimmanuel

2-Jan-08 2:03

You'll need to use SQL SMO[^]

Re: Who to create BackUp DataBase Sql Server From C#.Net

Abhijit Jana2-Jan-08 2:08

Abhijit Jana

2-Jan-08 2:08

Hi Thaer,
Try to use this.

using Microsoft.SqlServer.Management.Smo;

private static Server srvSql;

<code>
     // Create a new backup operation
     Backup bkpDatabase = new Backup();
    // Set the backup type to a database backup
    bkpDatabase.Action = BackupActionType.Database;
   // Set the database that we want to perform a backup on
      bkpDatabase.Database = "Your Selected Database"
    // Set the backup device to a file
   BackupDeviceItem bkpDevice = new BackupDeviceItem(BackupFileName.bak, DeviceType.File);
     // Add the backup device to the backup
             bkpDatabase.Devices.Add(bkpDevice);
     // Perform the backup
       bkpDatabase.SqlBackup(srvSql);
</code>

Let me know if you have any problem !!!

Best Regards
-----------------
Abhijit Jana
View My CodeProject Articles

"Success is Journey it's not a destination"

Re: Who to create BackUp DataBase Sql Server From C#.Net

Thaer Hamael2-Jan-08 22:01

Thaer Hamael

2-Jan-08 22:01

Iam Very Thanks Mr Abhijit Jana
I Have Aproblem :-
This Code Create The Backup File In The BackUp File Of Sql Server
but I Wount to Create The Backup file In Path i Determine it
as Example C:\Thaer\Thaer.bak
Who I Can Do it
If You Can help me Do that pleas
Thanks you Mr Rose | [Rose]

Thaer

Re: Who to create BackUp DataBase Sql Server From C#.Net

Abhijit Jana3-Jan-08 3:22

Abhijit Jana

3-Jan-08 3:22

Hi,

Just use one SaveDialogControl

select a path where you want to save the backup....

BackUpSavePath=SaveDialog.FileName

and set the Filer of Savedialog as "*.bak"
then

BackupDeviceItem bkpDevice = new BackupDeviceItem(BackUpSavePath, DeviceType.File);

carry on !!! any probs ask me!!!

Best Regards
-----------------
Abhijit Jana
View My Latest Article :- SpyNet : Your Network Spy

"Success is Journey it's not a destination"

Converting Word DOCs to PDFs

Vruddhi Vasoo2-Jan-08 1:05

Vruddhi Vasoo

2-Jan-08 1:05

How to Convert word Document to PDF file? This question has been put up a lot of times,
but I am not able to find one stable answer. I am convinced with the conversion of WORD - PS - PDF.
I also found a link for the same. Following is the link.
http://aspalliance.com/1447_Creating_PDFs_with_C_using_Ghostscript.1[^]
This link and many others talk about Open Source PDF Libraries in C#. The above link talks about installing a PDF Printer Criver. I already have an Adobe PDF printer. Will this cause any clash between the two formats? Is there any way in which I dont have to install any printer and i can work with the existing one?

Thanks in anticipation.

Vruddhi

Re: Converting Word DOCs to PDFs

DotNetXenon2-Jan-08 4:27

DotNetXenon

2-Jan-08 4:27

Not sure, but this may help.

Get it.
http://www.case.edu/provost/gradstudies/etd/word2pdf.pdf[^]

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

Re: Converting Word DOCs to PDFs

Vruddhi Vasoo2-Jan-08 18:13

Vruddhi Vasoo

2-Jan-08 18:13

Hi,
I am sorry for not mentioning, I am trying to convert the word file into a PDF using C#.NET code... not manually. And would be comfortable in converting the Word to PS and then PS to PDF. Can you redirect me to any C# code which uses Adobe PDF printer, as it is already installed in my PC. I got the links which showed installation of various printers but none mentioned ADOBE PDF and I am not sure if two printers would clash... giving me some unwanted results..

Thanks

Vruddhi

Re: Converting Word DOCs to PDFs

Ed.Poore2-Jan-08 4:38

Ed.Poore

2-Jan-08 4:38

There's three easy ways about it:
1) Install CutePDF (very simple & hassle free), works on all Windows versions
2) Install Adobe PDF (why you don't use this I don't know) [has a problem with Vista x64 I know of]
3) Word 2007 has an add-in available to save as PDF

My Blog[^]

Re: Converting Word DOCs to PDFs

Vruddhi Vasoo2-Jan-08 17:58

Vruddhi Vasoo

2-Jan-08 17:58

Hi. Thanks for answering the question...
I am sorry that I did not mention, that I am trying to convert the Word File into a PDF File using C#.NET (through coding). I am already having the Adobe PDF with me. The question is how do I use it? Can you direct me to any C# code which uses this printer?

Thanks once again..

Vruddhi

Re: Converting Word DOCs to PDFs

Thomas Stockwell2-Jan-08 14:10

Thomas Stockwell

2-Jan-08 14:10

I would suggest installing a printer driver, one free program which I am very pleased with is doPDF. This program adds a printer to the Printers of the computer and when you print to the doPDF printer then a prompt requests where you want the file to be saved.

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios[^]

Re: Converting Word DOCs to PDFs

Vruddhi Vasoo2-Jan-08 18:07

Vruddhi Vasoo

2-Jan-08 18:07

Hi,
Thanks for answering the question... I am sorry I did not mention, I am not trying to convert the word file manually, but through C#.NET code. And as I said in my previous post, I have Adobe PDF in my machine. Can you please redirect me to any c# code which uses this printer? Or can I use any other code using some other Printer without causing any clashes with the existing one(ADOBE PDF).

Thanks

Vruddhi

Gridview postback quesion

eyeseetee2-Jan-08 0:43

eyeseetee

2-Jan-08 0:43

Hi
I have a page with a radio button on, when this button is clicked the page is refreshed and a gridview is displayed. However when someone clicks on the page buttons at the bottom instead of going to the next page in the gridview, it resets the page back to its original state.
Now is this because the radio button is posting back to the same page and therefore when someone clicks on the pager button at the bottom it then resets back to before the postback
any help would be great
cheers

Re: Gridview postback quesion

eyeseetee2-Jan-08 2:38

eyeseetee

2-Jan-08 2:38

anyone?
does it need explaing more?

Re: Gridview postback quesion

Abhijit Jana2-Jan-08 4:54

Abhijit Jana

2-Jan-08 4:54

did you try it using AJAX ?

Best Regards
-----------------
Abhijit Jana
View My Latest Article :- SpyNet : Your Network Spy

"Success is Journey it's not a destination"

Re: Gridview postback quesion

Urs Enzler2-Jan-08 7:52

Urs Enzler

2-Jan-08 7:52

I don't understand your question - "page buttons"?, "going to the next page in the gridview"?

Does the GridView save its ViewState (Property ViewState == true).
What are you doing in either PreLoad, or Load of the Page - method overrides or event handlers.

happy programming
Urs

-^-^-^-^-^-^-^-^-^-^-^-
no code is free of bugs

Searching / Filtering database

ph1l22-Jan-08 0:14

ph1l2

2-Jan-08 0:14

Hi all,

Ive built an app that involves searching a database, i have an access database, but as it is now getting quite large it is taking a long time to search.

At the moment i am doing it using quereys, but each time it fills the data it can take a while then even longer when after doing the search it has to then fill the entire table again.

Im sure there must be a way of simply filtering the data, can anyone help with ideas of how i can do this?

Thanks

Re: Searching / Filtering database

J4amieC2-Jan-08 0:45

J4amieC

2-Jan-08 0:45

As you've posted no code i'll assume you are loading the entire database table into a System.Data.DataTable and using the Select method to do your filtering. If this is the case, then what you really want to be doing is writing the query such that any filtering of data is done in the database and only the results loaded into the datatable.

Your options for this are limited in Access to using the LIKE keyword in your query.

SELECT * FROM myTable WHERE myColumn LIKE '%something%'

Re: Searching / Filtering database

ph1l22-Jan-08 1:51

ph1l2

2-Jan-08 1:51

Right, im fairly new to this so here goes trying to explain a little more...

I load all of the data into the app using tableadapter.Fill as there is data to be refrenced and displayed, but i have created a querey using the dataset designer then i load it using the tableadpater.quereyname. That runs ok but then i have to reload the information back in so it will display all the data. Thats the bit that really takes the time.

I was thinking that surely there is a way that it loads the information once but then when you search it will simply hide records that do not match what your searching for, a filter rather than a search? That way, when you display all the data, it simply removes the filter.

Is that clear what im trying to acheive? Am i way off here?

below is a bit of the code im using....

To get all the data....
this.tecTableAdapter.Fill(this.tecDataSet.History);

Then to search....
this.tecTableAdapter.SearchN(this.tecDataSet.History, sn.Text);

Re: Searching / Filtering database

J4amieC2-Jan-08 3:08

J4amieC

2-Jan-08 3:08

Seeing as I have no clue what tecTableAdapter represents the code is pretty useless. (I was going to assume it was something like a SqlDataAdapter but that does not have a method SearchN)

However it is clear enough what you are trying to do, just not very clear where you have a problem. If you want to display all the data and it takes too long to load then don't show all the data all in one go. Load up, say, a page of 100 records at a time.

Filter/Copy datatable columns

mpavas2-Jan-08 0:04

mpavas

2-Jan-08 0:04

Hello,

I have a data table which has multiple columns. I want to create another data table with only selected columns.

For Example

If my datatable1 has below columns:
Emp no, Name, Age, Date Of Birth, Join Date

I want to create another datatable with below columns
Name, Age, Date Of Birth

I do not want to loop the datatable and insert the values in another datatable.

Please suggest an optimized way of doing it.

Regards,
Pavas

Re: Filter/Copy datatable columns

ChandraRam2-Jan-08 0:50

ChandraRam

2-Jan-08 0:50

mpavas wrote:
I have a data table which has multiple columns. I want to create another data table with only selected columns.

For Example

If my datatable1 has below columns:
Emp no, Name, Age, Date Of Birth, Join Date

I want to create another datatable with below columns
Name, Age, Date Of Birth

I do not want to loop the datatable and insert the values in another datatable.

If the destination table already exists, look up the INSERT INTO command... otherwise you might want to look up SELECT INTO

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