Re: List items [modified] - C# Discussion Boards

Re: Update changes made in gridview in DataTable

Yustme11-Dec-08 10:34

Yustme

11-Dec-08 10:34

Hi,

Any chance you can give me a code sample? I've tried a few i found on the net. But no luck.

Re: Update changes made in gridview in DataTable

Dave Kreskowiak11-Dec-08 12:31

Dave Kreskowiak

11-Dec-08 12:31

There is a single line of code you add to the creation of the DataAdapter to do this. I cannot believe you didn't find an example that explains this.

dbCommand.CommandText = "SELECT firstName, LastName FROM Customer";
customerAdapter = new SqlDataAdapter(dbCommand.CommandText, connectionString);
Dim cb = new SqlCommandBuilder(customerAdapter);
customerTable = new System.Data.DataTable();
customerAdapter.Fill(customerTable);

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Update changes made in gridview in DataTable [modified]

Yustme11-Dec-08 20:22

Yustme

11-Dec-08 20:22

Hi,

I was actually talking about how to update the datatable after a few rows have been removed.

I already got those lines in my application.

I tried updating the datatable with customerAdapter.Update() method.

But it's complaining about a deleteCommand.

So after some rows have been removed from the gridview which i caught in the event handler of the datagridview, how do i update the datatable and update the sql database with the customerAdapter.Update() method?

[EDIT]

Ah never mind, i see what i was doing wrong. I forgot to put the adapter inside the () of the commandbuilder instance.

Thank you, it works perfectly now!

[/EDIT]

modified on Friday, December 12, 2008 2:37 AM

Report viewer

Neo Andreson11-Dec-08 2:52

Neo Andreson

11-Dec-08 2:52

I am facing problem with ReportViwer during excel file creation. excel format is not proper, it's height is constant. Is there any property by using which i can set the width of excel sheet.

My code is
fileSaveDialog.ShowDialog();

if (fileSaveDialog.FileName != string.Empty)
{
Warning[] warnings;
string[] streamids;
string mimeType;
string encoding;
string extension;

byte[] bytes = this.rvAuditTrail.LocalReport.Render(
type, null, out mimeType, out encoding,
out extension,
out streamids, out warnings);

// this.rvAuditTrail.LocalReport.SetParameters(
//ReportParameter
FileStream fs = new FileStream(fileSaveDialog.FileName,
FileMode.Create);
fs.Write(bytes, 0, bytes.Length);
fs.Close();
}

Truth Is The Simplest !!!!

List items [modified]

nlowdon11-Dec-08 2:45

nlowdon

11-Dec-08 2:45

Afternoon all,

I'm trying to tidy up my code a little and wondered if its possible to add a number of object to a list on one line of code.

i.e

zooAnimals.Add(newcat1);
zooAnimals.Add(newcat2);
zooAnimals.Add(newtig1);
zooAnimals.Add(newtig2);

is there a way of putting these all in the one statement ?

Something like,

zooAnimals.Add(newcat1),(newcat2),(newtig1),(newtig2);

(I know the above DOESN'T work, it's just there to readers an idea of what i mean)

Thanks
Neil

modified on Thursday, December 11, 2008 8:57 AM

Re: List items

Simon P Stevens11-Dec-08 2:55

Simon P Stevens

11-Dec-08 2:55

There is a method 'AddRange' that takes a enumerable such as an array or something like that.

Simon

Re: List items

Brij11-Dec-08 3:11

Brij

11-Dec-08 3:11

For adding multiple values at a time you need another collection which contains all the item that you want to add and do it as
zooAnimals.AddRange(newarr);
newarr can be any collection which is inherited from IEnumerable.

Cheers!!
Brij

Re: List items [modified]

#realJSOP11-Dec-08 4:03

#realJSOP

11-Dec-08 4:03

As others have said, you need to put the objects into an ArrayList, but IMHO, that would be a waste of time if that's the only reason you're creating the ArrayList. At some point, you have to add them one at a time *somewhere*, so why not just do it without an intermediate data structure? Just add them one at a time and be done with it.

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

modified on Thursday, December 11, 2008 11:37 AM

Re: List items

Paul Unsworth11-Dec-08 4:37

Paul Unsworth

11-Dec-08 4:37

Hi
Try this:

object[] myObjects = new object[] { newcat1, newcat2, newtig1, newtig2 };
ArrayList myArrayList = new ArrayList(myObjects);

It should keep things nice and tidy for you...

oooo, the Jedi's will feel this one....

Re: List items

Luc Pattyn11-Dec-08 4:42

Luc Pattyn

11-Dec-08 4:42

assuming ZooAnimal is the type held by zooAnimals, you can do:

zooAnimals.AddRange(new ZooAnimal[]{newcat1,newcat2,newtig1,newtig2});

which creates a temporary array and adds its content to zooAnimals.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Fixturized forever. Confused | :confused:

Re: List items

#realJSOP11-Dec-08 4:57

#realJSOP

11-Dec-08 4:57

I think if yo use completely random names for things, you could obfuscate it more. Smile | :)

(Yes, I'm one of those weird Outlaw Programmer moods today. Nobody is safe.) Smile | :)

Directory.GetFiles - how do I get the file names only and not the complete path?

Member 340288611-Dec-08 1:26

Member 3402886

11-Dec-08 1:26

I have the following code which stores the filenames in an array. However, I want only the filenames to be stored. Surely there is an easy way to do this? I know I can replace the line, imageNames.Add(img); with imageNames.Add(img.Remove(0, 22)); which will remove the path (first 22 chars) leaving just the filename but this will be different when I upload to my server so don't really want to do it this way. Any ideas will greatly appreciated.

foreach (string img in Directory.GetFiles(imagesDir, "*.jpg"))
{
imageNames.Add(img);
}
Many thanks
Lorna

Re: Directory.GetFiles - how do I get the file names only and not the complete path?

TJS4u11-Dec-08 1:31

TJS4u

11-Dec-08 1:31

hello

DirectoryInfo di = new DirectoryInfo(Path........);
FileInfo[] rgFiles = di.GetFiles("*.jpg");
foreach (FileInfo fi in rgFiles)

{
// add u r needs
}

Re: Directory.GetFiles - how do I get the file names only and not the complete path?

Member 340288611-Dec-08 1:41

Member 3402886

11-Dec-08 1:41

Thanks but is that not the same as what I have and I get the complete path - here is another 2 lines of the code:

ArrayList imageNames = new ArrayList();
string imagesDir = Server.MapPath("~/administration/uploaded/");

foreach (string img in Directory.GetFiles(imagesDir, "*.jpg"))
{
imageNames.Add(img);
}

thanks
Lorna

Re: Directory.GetFiles - how do I get the file names only and not the complete path?

Giorgi Dalakishvili11-Dec-08 1:31

Giorgi Dalakishvili

11-Dec-08 1:31

Path Class[^]

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Re: Directory.GetFiles - how do I get the file names only and not the complete path?

Paul Unsworth11-Dec-08 4:43

Paul Unsworth

11-Dec-08 4:43

Hi Lorna

This should help you...

DirectoryInfo dir = new DirectoryInfo(@"C:\Test");
foreach (FileInfo file in dir.GetFiles())
{
    Console.WriteLine(file.Name);
}

oooo, the Jedi's will feel this one....

Re: Directory.GetFiles - how do I get the file names only and not the complete path?

Member 340288611-Dec-08 5:06

Member 3402886

11-Dec-08 5:06

Hurray it works! Thank you very much. For any other interested parties, I rewrote as:

DirectoryInfo dir = new DirectoryInfo(@Server.MapPath("~/administration/uploaded/"));

foreach (FileInfo file in dir.GetFiles())
{
imageNames.Add(file.Name);
}

Which gave me an ArrayList of filenames only (no path).

Re: Directory.GetFiles - how do I get the file names only and not the complete path?

Paul Unsworth11-Dec-08 5:16

Paul Unsworth

11-Dec-08 5:16

Glad to help. Big Grin | :-D

oooo, the Jedi's will feel this one....

Client connecting to web service

Chazzysb11-Dec-08 1:20

Chazzysb

11-Dec-08 1:20

Hi,

.Net2 VS2005

I have a windows forms client app that connects to a web service. In iis I know the port number can be set for the web service (default is 80 but lets say I change this to 81) - and this is repeated in the app.config file in the client. (so this port number is all to do with the web service)

The app connects to the web service and works fine - but is there another similar setting available for the app?? ie on the client machine can I specify what port the client uses connect outward?

Thanks,
Chas

Re: Client connecting to web service

blackjack215011-Dec-08 1:40

blackjack2150

11-Dec-08 1:40

Can't you specify the port in the URL of the web service with a colon?
ie:
http://www.MyWebService.com:7560

Insert funny quote here.

Re: Client connecting to web service

Chazzysb11-Dec-08 2:07

Chazzysb

11-Dec-08 2:07

Hi,

Yes that is what im doing...

What I was after is what port does the client pc use locally? I guess what im asking is something like what port does a pc use when it connects to anything on the net - and can this be changed?

Thanks,
Chas

[Message Deleted]

Neo Andreson11-Dec-08 1:19

Neo Andreson

11-Dec-08 1:19

[Message Deleted]