C# Discussion Boards - CodeProject

Problem with refill of listview after removal in database

henur13-Apr-07 23:48

13-Apr-07 23:48

Hi
I have a listview with items. I select, for instance 2 items for removal. I run my code to remove in database, wich work just correct.

Then i run my method for fill, in a class, to refill the listview from database.

In the case where i selected 2 items only 1 disappered from the listview, the other is still showing. If i select 1 item, that one is still showing after the fill.

I do not understand what happens. I rather new in C# but i have done the same in VB.NET and FoxPro 9.0 and i have no problems.

Here is the code. Anybody that can tip me about whats wrong ?

if (result == DialogResult.OK)
{
clsReadKatalog clsReadKatalog;
clsReadKatalog = new clsReadKatalog();
foreach (int idx in this.Katalog.SelectedIndices)
{
String xid = this.Katalog.Items[idx].SubItems[5].Text;
int tabortid = this.Katalog.Items[idx].Index;
clsReadKatalog.TaBortPost(xid); // DELETE FROM DATABASE
}
String urval = null;
urval = "SELECT * FROM pwd WHERE ownid="
+ "'" + this.GlobalAnvändare + "'"
+ " AND posttyp='1'";
OdbcDataReader Reader = clsReadKatalog.LäsKatalog(urval);
if (Reader.HasRows)
{
clsReadKatalog.FyllKatalog(Reader, this.Katalog); // REFILL FROM DATABASE
}

Here is the code for fill listview: This is the same method i run the first time, to fill the listview, before i make my selection for remove, and then it pick right from database.

public void FyllKatalog(OdbcDataReader Reader,ListView Lista)
{
Lista.Items.Clear();
int x=0;
while (Reader.Read())
{
Lista.Items.Add(Convert.ToString(Reader["beskr"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["anv"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["pwd"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["privatekey"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["vektor"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["id"]));
x += 1;
}
Reader.Close();
}

With Kind Regards

Heino

Heino Nurmik

Re: Problem with refill of listview after removal in database

Christian Graus14-Apr-07 0:12

Christian Graus

14-Apr-07 0:12

henur wrote:
String xid = this.Katalog.Items[idx].SubItems[5].Text;
int tabortid = this.Katalog.Items[idx].Index;
clsReadKatalog.TaBortPost(xid); // DELETE FROM DATABASE

Wouldn't a proc that takes a collection of Ids to delete make more sense ? What is tabortid used for ?

henur wrote:
Lista.Items.Clear();
int x=0;
while (Reader.Read())
{
Lista.Items.Add(Convert.ToString(Reader["beskr"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["anv"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["pwd"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["privatekey"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["vektor"]));
Lista.Items[x].SubItems.Add(Convert.ToString(Reader["id"]));
x += 1;
}
Reader.Close();

If this pulls out data you thought you deleted, then you can't possibly have deleted it. Unless the reader was created before something was deleted, but that doesn't seem possible, either.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Problem with refill of listview after removal in database

henur14-Apr-07 3:32

henur

14-Apr-07 3:32

Ok , "tabortid" is just a remaining after that i removed the items by the selected items.index.

But about the deletion, yes they are removed in the database. In debug-mode i do a hold, and then open the access-database and check the table....and they are gone.

And really, i have a similar problem in an other place. When i add a item, when i refill the listview the new one is not added to the view, but be sure! ...it is in the database.

So...i don't get it!

Re: Problem with refill of listview after removal in database

Christian Graus14-Apr-07 13:37

Christian Graus

14-Apr-07 13:37

What you're describing is not possible. If you delete a row, and refresh from the DB, the row will be gone, unless you don't clear the control first ( and I see, you did ). So, something else is going on here.

Re: Problem with refill of listview after removal in database

henur15-Apr-07 20:14

henur

15-Apr-07 20:14

That's true...something else.... Smile | :)

Well , i will go thru my code again and see if i can find anything that could cause my problem.

As you said earlier "...if the reader is created before.." in some way the problem "feels" like that. So i will check that possibility.

Heino

is any query (in sql server) that i can export data ?

B.A13-Apr-07 23:26

B.A

13-Apr-07 23:26

hi ...

i wan to export data in sql server 2005 with wizard but take follow error !!!!!

"Only part of a ReadProcessMemory or WriteProcessMemory request was completed (System)"

is any query (in sql server) that i can export data ?
thanks

Re: is any query (in sql server) that i can export data ?

Colin Angus Mackay13-Apr-07 23:57

Colin Angus Mackay

13-Apr-07 23:57

What does this have to do with C#? It belongs in the SQL Forum... But I see you've already asked it there!

Upcoming events:
* Edinburgh: Web Security Conference Day for Windows Developers (12th April)
* Glasgow: Introduction to AJAX (2nd May), SQL Server, Mock Objects

Never write for other people. Write for yourself, because you have a passion for it. -- Marc Clifton

My website

Serialization problem

NaNg1524113-Apr-07 23:19

NaNg15241

13-Apr-07 23:19

[Serializable]
Class A
{
 public event Handler OnChange;
 public A()
 {
  this.OnChange += new Handler(this.Save);
 }
 public void Save()
 {
  filestream.Save(Serialize(this)); // Saves to file
 }
}
class B
{
 A myA;
 public B()
 {
  myA = new A();
  /* do stuff to myA that triggers OnChange()
  *E* - error - cannot serialize class of type B.
 }
}

why doesn't it serialize myA, but it tries to serialize B ?

THANKS ALOOOOT to the one\s who help me solve this.
NaNg.

Re: Serialization problem

Christian Graus14-Apr-07 0:17

Christian Graus

14-Apr-07 0:17

I don't see why that should happen, what is the 'stuff' that you do ?

Re: Serialization problem

NaNg1524114-Apr-07 1:09

NaNg15241

14-Apr-07 1:09

set a property which checks if this.OnChange != null and if not it triggers it.

Re: Serialization problem

NaNg1524114-Apr-07 1:48

NaNg15241

14-Apr-07 1:48

nevermind, I found the problem while debugging.

It saved in the event B from some reason.
I just added: [field: NonSerialized()]
to every event.

It works fine now.
Thanks anyways Smile | :)

How to check whether my application running under ClickOnce

pashitech13-Apr-07 22:43

pashitech

13-Apr-07 22:43

HI all,
i am using ClickOnce to deploy my application, whenever i run the below code its asking me to check is ur application is running under click once,

my code,

if (ApplicationDeployment.IsNetworkDeployed)
{
// Hold a reference to the current deployment
ApplicationDeployment currentDeploy = ApplicationDeployment.CurrentDeployment;
// Check to see if an update is available on the server
if (currentDeploy.CheckForUpdate())
{
// One is available, go get it
currentDeploy.Update();
// Make sure you save application state here
DialogResult dr = MessageBox.Show(
"Update downloaded, restart application?",
"Application Update", MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
Application.Restart();
}
}
}

if (ApplicationDeployment.IsNetworkDeployed)
if i din't use this ApplicationDeployment.IsNetworkDeployed, its giving INVALIDDEPLOYMENTEXCEPTION--Application not installed.
Please help me how to overcome this thing..
Thnx in advance,
prashanth

network stream to byte[]

marwan_siala13-Apr-07 22:41

marwan_siala

13-Apr-07 22:41

i need to convert from network stream to byte[]...

please help

Re: network stream to byte[]

Christian Graus13-Apr-07 22:42

Christian Graus

13-Apr-07 22:42

What does the code look like ? ( I'm curious how a network stream looks, is it just a stream object ? )

Re: network stream to byte[]

marwan_siala13-Apr-07 22:51

marwan_siala

13-Apr-07 22:51

TcpListener tcpListener = new TcpListener(2112);<br />
tcpListener.Start();<br />
TcpClient tcpClientIP = tcpListener.AcceptTcpClient();<br />
NetworkStream nsIP = tcpClientIP.GetStream();<br />
StreamReader srIP = new StreamReader(nsIP);<br />
string resultIP = srIP.ReadToEnd();

as u can see the last result is a sting... but before that i need it to be byte[] because i am using an encryption...

Re: network stream to byte[]

Christian Graus14-Apr-07 0:05

Christian Graus

14-Apr-07 0:05

OK, converting a string to a byte[] is pretty easy, why do you need to convert it *before* it's a string ? You read a stream using the methods it offers, does it offer one to read a byte [] ?

Re: network stream to byte[]

marwan_siala14-Apr-07 0:27

marwan_siala

14-Apr-07 0:27

the received stream is encrypted... and the encryption methode i used is dealling with the byte[]
so i need to convert the stream to byte[] first and then decrypte the byte[], then convert it back to string

Encoding error.. help guys:(

Muammar©13-Apr-07 22:27

Muammar©

13-Apr-07 22:27

Hello everyone, I have this problem when saving Arabic letters into Oracle do you think it's the dataset?? please help.

ps. I keep getting "???? ?? ????" Confused | :confused: