Re: mark rows as deleted or updated befor loading them in a dataset - C# Discussion Boards

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 5:42

Hello,
I'm developping a sync solution enables filtering but is there any way to load the changes form the source database into a dataset and mark the deleted or updated rows to transfer this dataset to client and update its data?
I've tryied to use the Microsoft Sync Framework but it does not allow filtering even if I use a custom provider because in my scenariro I want to sync a subset of the data on the server with a client and vice versa sync framework depends on primary key only which not acceptable here because when deleting or updating rows these rows may deletetd for another user in the source database the primary key in the client will not be the same as the server this is because I want to select the changes as xml and populate the dataset soit can mark the deleted rows and updated .. ctc

Dad

Not Active14-Apr-10 6:02

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 6:02

Normally in this situation there is a timestamp field, or some other type, in the database that is used to tell if a row has been updated. Add a where clause to your query to get the changed rows.

I know the language. I've read a book. - _Madmatt

hadad14-Apr-10 6:06

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 6:06

Yes I've done it but I want to transfer the data to the client as a dataset holding the changes so how I tell the dataset that certain row is deleted or inserted or updated when it reads the xml file and not aftr loading the data throw the rowstate property

Dad

Not Active14-Apr-10 8:33

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 8:33

I don't understand what you are asking. You have all the tools, what is the problem you are having?

I know the language. I've read a book. - _Madmatt

hadad14-Apr-10 21:56

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 21:56

I select the modified data from the sql server as a xml I've added an attribute to each row to tell me its state when I load this file to a dataset it does not read the stated it marks all rows as Added by default so if I want to change the state I have to loop over the table and change the rowstate property my question is Can I change the state when the data set loads the xml file or I have to loop over the table after population?

Dad

Not Active14-Apr-10 22:11

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 22:11

Why are you returning XML that is then placed into a dataset? OMG | :OMG:

This makes no sense at all. Its like converting an int to a string then back to an int.

Add the column to the select query then it will be in the dataset already. Otherwise, no, there is no other way except to iterate through the rows.

I know the language. I've read a book. - _Madmatt

hadad14-Apr-10 22:43

Re: mark rows as deleted or updated befor loading them in a dataset

14-Apr-10 22:43

I've tried the xml to let me choose an intermediate method to tell the dataset the state of rows but it will be more efficient if it loads the data directly but If it does, also, How can I tell the row state? this data set will be transferred to a client where another adapter will update the client database so the dataset must tell the state of the rows which I cant do when loading the data because the column which tell the state is invented by my sql script and it does not belong to table so the data set will trait it as a normal column.

Dad

Not Active15-Apr-10 1:51

15-Apr-10 1:51

You are making this out to be much more difficult that it really is. This issue in particular and the entire architecture of your application from the sounds of it.

If the client can call the database to update the records why are you placing this intermediary step in between, access from the client, or better yet from a properly constructed dta accsss layer.

hadad wrote:
invented by my sql script and it does not belong to table

YES it does. If it's in the select statement is will be in the dataset.

RTFM!!

I know the language. I've read a book. - _Madmatt

SortedList

Morgs Morgan14-Apr-10 5:31

Morgs Morgan

14-Apr-10 5:31

Hi guys does anyone know how to check if a sortedlist
is empty or not?
I tried using the 'capacity' and keys|values 'count' property but none work
Anyone with a different approach?
help
Morg

DaveyM6914-Apr-10 5:37

DaveyM69

14-Apr-10 5:37

Capacity won't tell you if it's empty or not (if it's 0 then it's empty, but it could be empty and > 0).
Count should - what doesn't work about it?

Dave

If this helped, please vote & accept answer!

Binging is like googling, it just feels dirtier. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Morgs Morgan14-Apr-10 6:01

Morgs Morgan

14-Apr-10 6:01

Cool it works fine now...it was just logic

OriginalGriff14-Apr-10 5:40

14-Apr-10 5:40

Use the Count property:

SortedList<int, string> sl = new SortedList<int, string>();
sl.Add(4, "four");
sl.Add(3, "three");
MessageBox.Show(sl.Count.ToString());

Gives "2".

SortedList<int, string> sl = new SortedList<int, string>();
//sl.Add(4, "four");
//sl.Add(3, "three");
MessageBox.Show(sl.Count.ToString());

Gives "0".

You should never use standby on an elephant. It always crashes when you lift the ears. - Mark Wallace

C/C++ (I dont see a huge difference between them, and the 'benefits' of C++ are questionable, who needs inheritance when you have copy and paste) - fat_boy

Alan N14-Apr-10 5:42

Alan N

14-Apr-10 5:42

Why do you think that the Count property is inaccurate? Can you give an example of the exact problem you are facing.

Alan.

PIEBALDconsult14-Apr-10 5:44

PIEBALDconsult

14-Apr-10 5:44

return ( 42 ) ;

hadad14-Apr-10 5:52

Csharp .Net image processing error

14-Apr-10 5:52

The count property can determine whether the list is empty or not if it is 0 so the list is empty

Dad

djsproject14-Apr-10 5:24

djsproject

14-Apr-10 5:24

Hi I wrote the code for adding image as well as saving the image but whenever I add photos and save them the original size of the photos gets reduced.It takes size of 80,80 I commented the line but still the size of the photos is 80,80 Can somebody pls help......

<br />
//to add photos<br />
private void btnAddPhotos_Click(object sender, EventArgs e)<br />
        {<br />
            openFileDialog.Filter = "Image Files(*.BMP;*.JPG;*.GIF)|*.BMP;*.JPG;*.GIF|All files (*.*)|*.*";<br />
            openFileDialog.Multiselect = true;<br />
<br />
            if (openFileDialog.ShowDialog() == DialogResult.OK)<br />
            {<br />
                listView1.View = View.LargeIcon;<br />
                //imageList.ImageSize = new Size(80, 80);<br />
<br />
                for (int c = 0; c < openFileDialog.FileNames.Length; c++)<br />
                {<br />
                    Image i = Image.FromFile(openFileDialog.FileNames[c].ToString());<br />
                    Image img = i.GetThumbnailImage(256, 256, null, new IntPtr());<br />
                    imageList.Images.Add(img);<br />
                }<br />
                listView1.LargeImageList = imageList;<br />
                int cntl = listView1.Items.Count;<br />
<br />
                if (cntl == 1)<br />
                {<br />
                    ListViewItem lstItem = new ListViewItem();<br />
                    lstItem.ImageIndex = 1;<br />
                    listView1.Items.Add(lstItem);<br />
                }<br />
                else<br />
                {<br />
                    for (int j = cntl; j < imageList.Images.Count; j++)<br />
                    {<br />
                        ListViewItem lstItem = new ListViewItem();<br />
                        lstItem.ImageIndex = j;<br />
                        listView1.Items.Add(lstItem);<br />
                    }<br />
                }<br />
            }<br />
            else<br />
            {<br />
                return;<br />
            }<br />
       }<br />
 <br />
//to save photos<br />
        private void btnSavePhotos_Click(object sender, EventArgs e)<br />
        {<br />
            clsImageSettings saveFileDia = new clsImageSettings();<br />
            clsImageSettings objSaveImage = new clsImageSettings();<br />
            FolderBrowserDialog objFolderDai = new FolderBrowserDialog();<br />
            string imgPath = "";<br />
            if (listView1.Items.Count > 0)<br />
            {<br />
                if (objFolderDai.ShowDialog() == DialogResult.OK)<br />
                {<br />
                    imgPath = objFolderDai.SelectedPath;<br />
<br />
                    for (int i = 0; i < openFileDialog.SafeFileNames.Length; i++)<br />
                    {<br />
                        string imgFilePath = openFileDialog.FileNames[i].ToString();<br />
                        string imgFileName = openFileDialog.SafeFileNames[i];<br />
                        Image imgBrighten = imageList.Images[i];<br />
                        objSaveImage.saveJpeg(imgPath + "\\" + imgFileName, new Bitmap(imgBrighten), 85L);<br />
                    }<br />
                }<br />
                else { return; }<br />
            }<br />
            else { return; }<br />
<br />
            MessageBox.Show("Images Saved Succesfully @Path " + imgPath, "BatchImage Editor & Uploader");<br />
        }<br />

OriginalGriff14-Apr-10 5:35

14-Apr-10 5:35

Rule one: If you are going to post code fragments - especially long code fragments - use the "code block" widget (or <pre> </pre> tags) to preserve the formatting, not the "inline code" widget (or <code> </code> tags).
Rule two: From a quick scan (which is all I'll do with unformatted stuff), it is a good idea when reading in an image file to keep both the image, and the thumbnail - not keep the thumbnail and throw away the image... Would it surprise you to know that a thumbnail is 80 x 80? Suggest anything about you problem?

djsproject14-Apr-10 6:08

djsproject

14-Apr-10 6:08

I want the images to be in original size as they were before i dont want them to get small can u suggest something

OriginalGriff14-Apr-10 6:14

14-Apr-10 6:14

When you save, perhaps saving the thumbnail image is not the best way to get a full size picture?

Luc Pattyn14-Apr-10 6:37

Luc Pattyn

14-Apr-10 6:37

This can not possibly be a "good answer", as all you do is reply with yet another question...
how about providing a real suggestion?

Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles]

Prolific encyclopedia fixture proof-reader browser patron addict?
We all depend on the beast below.

OriginalGriff14-Apr-10 8:12