concurency violation delete command affected 0 records in acess database? - C# Discussion Boards

GermanDM15-Nov-06 0:58

15-Nov-06 0:58

basically yeah like im using sql at work but i dont have sql at home.
mmm i was thinking xml as well thx

but why do you say if i get mad??

thanks

Re: Data Storage

Guffa15-Nov-06 1:04

Guffa

15-Nov-06 1:04

GermanDM wrote:
but why do you say if i get mad??

That's his signature.

He just haven't figured out yet how to make it look like a signature. Wink | ;)

---
b { font-weight: normal; }

Re: Data Storage

Tamimi - Code15-Nov-06 1:07

Tamimi - Code

15-Nov-06 1:07

i will change it for you Wink | ;)

, have some ideas ??

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: Data Storage

Guffa15-Nov-06 2:17

Guffa

15-Nov-06 2:17

I use the small tag to make the text a bit smaller than the message body, and some dashes to make a separator. That is one way to do it.

---
b { font-weight: normal; }

Re: Data Storage

Tamimi - Code15-Nov-06 2:29

Tamimi - Code

15-Nov-06 2:29

i can see you Signature
the small tag is your style give me somthing else
man, share some ideas ??

When you get mad...THINK twice that the only advice
Tamimi - Code

Re: Data Storage

tgrt15-Nov-06 16:30

tgrt

15-Nov-06 16:30

You could always use the Express edition of SQL Server. Otherwise, XML or Access *gasp*. Obviously, use the Framework Crypto classes. Don't try to roll your own.

Re: Data Storage

Guffa15-Nov-06 0:57

Guffa

15-Nov-06 0:57

Don't be so concerned about anyone viewing the information, just make sure that the information they see is useless.

Store the hash code of the passwords, not the passwords themselves. That way the passwords can not be recreated from the stored information. When you verify a password, get the hash code for the entered password and compare against the stored hash code.

You can use for example MD5 to get a hash code for the passwords. (The GetHashCode method of System.String is not suitable for creating a long term hash code, as it may change between versions.)

---
b { font-weight: normal; }

concurency violation delete command affected 0 records in acess database?

subburaj.sabapathy15-Nov-06 0:28

subburaj.sabapathy

15-Nov-06 0:28

Dear sir,
in my application i have using Access database.in that when i try to add new item and then modify those item at same time it show error like concurency violation delete command affected 0 records expected 1 records.so if any one knows means please help me.

accessing the value of a textbox in another form

shanisnathan15-Nov-06 0:24

shanisnathan

15-Nov-06 0:24

hi all,

i am a beginner in C#.
please can any one suggest me a solution?
I am having two forms.first one is "Login" and Second one is "Entry"
In "Login" form i have a text box "Login Id". i want the value that is entered in this text during login in the next from "Entry".
//===========Login form======

public string strLoginID ;

strLoginID = txtLoginID.Text.Trim();

//==========Entry form==========
frmLogin objLogin = new frmLogin();
string strLoginChk = "";
strLoginChk = objLogin.strLoginID ;

this is the code i have given.during runtime i am unable to get the value stored in the txtLoginID.its getting disposed.i have also called a dispose fuction in the "Entry" form.

please if any one can suggest me another solution

Thanks in advance

sha04

Re: accessing the value of a textbox in another form

rah_sin15-Nov-06 0:34

rah_sin

15-Nov-06 0:34

u can store the loginid in string and can pass it to entry form
and can retrive that value in constructor of entry form

rahul

When to use Application Data

nflrodrigues15-Nov-06 0:18

nflrodrigues

15-Nov-06 0:18

Hi,

I have a problem concerning to application data, how to use and what to store.

I have application reports that are installed during application setup.
Inside my application, the users are able to run the reports and also to create new ones.

Now, I'm installing the reports in Application Data\AllUsers\..., and reports created by users, go to the same folder.

My question is: Is this the correct way to do this?

Should my installed reports go to Program Files\... (Application installation folder), and user created report to Application Data\All Users\...?

Does anyone knows best practices for this problem?

Thanks in advance.

NFLR Sniff | :^)

Re: When to use Application Data

Anthony Mushrow15-Nov-06 0:56

Anthony Mushrow

15-Nov-06 0:56

I don't think it really matters, in my 'Application Data' folder, apps store things like their settings, playlists, extra data they need etc. But ive also seen all of these things in a programs folder in 'Program Files'

I don't know what the 'Best Practice' is but, i think its OK to put the data in either place

how to download file using https?

Larisa_K15-Nov-06 0:06

Larisa_K

15-Nov-06 0:06

string url="https://......./file.exe"
.............
try
{
WebClient myWebClient = new WebClient();
myWebClient.Credentials=CredentialCache.DefaultCredentials;
myWebClient.DownloadFile(url,path);
}

But server returns an error:(403) Forbidden
I think that I must to give a sertificate. But how can I do it in WebClient?

Thank you for answer.

Re: how to download file using https?

Ashish Derhgawen15-Nov-06 5:22

Ashish Derhgawen

15-Nov-06 5:22

I haven't tried your code...but check out these links..maybe you'll find them useful:
http://www.csharpfriends.com/Articles/getArticle.aspx?articleID=115[^]
http://www.c-sharpcorner.com/Code/2004/Sept/DownloadUsingHTTP.asp[^]

Regards,
Ashish

Time flies like an arrow;
Fruit flies like a banana.

Ashish Derhgawen - http://ashishrd.blogspot.com[^]

Re: how to download file using https?

Scott Dorman15-Nov-06 7:44

Scott Dorman

15-Nov-06 7:44

You can also check out http://www.codeproject.com/useritems/filedownloader.asp[^].

You almost have things setup correctly, but the CredentailCache.DefaultCredentials will supply the request object with the default system credentials, not the username and password required by the web site.

In order to do that, you will need to do something like this:

Uri uri = new Uri(url);
CredentialCache credCache = new CredentialCache();
NetworkCredential userCred = new NetworkCredential(username, password, domain);
credCache.Add(uri, "Basic", userCred);

The "NTLM" in the call is a string that specifies the authentication type. The valid choices are "NTLM", "Digest", and "Basic". You will need to use the type that is appropriate for your specific case.

Also, make sure that you don't need a proxy to be specified.

-----------------------------
In just two days, tomorrow will be yesterday.

Execute a part of code in other context

James Poulose15-Nov-06 0:05

James Poulose

15-Nov-06 0:05

Hi,
I need to run some part of my code in a different security context. For eg. when i try to write to a remote share it throws access denied exception. but i have the username\pwd of that machine. Please help

James Poulose

XPaths to SOAP xmls

James Poulose15-Nov-06 0:02

James Poulose

15-Nov-06 0:02

Hi,
i am not able to fire xpath queries (SelectSingleNode method with namespace object) to a SOAP xml. It complains about a namespace problem. here is a sample

<soap:envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:body>
<setresponse xmlns="http://tempuri.org/">
<smessageid>EEF0AFFE-A9F5-41A2-AE82-4601E3E2465F

i want the data in the "sMessageID" element. Any idea??

James Poulose

Re: XPaths to SOAP xmls

Stefan Troschuetz15-Nov-06 0:07

Stefan Troschuetz

15-Nov-06 0:07

Your XML snippet isn't visible. Please modify your post by either replacing all < with &lt; or check the "Ignore HTML tags in this message" option beneath the smilie selection. Furthermore it will be helpful to see XPath expression your currently using.

"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." - Rick Cookwww.troschuetz.de

Re: XPaths to SOAP xmls

James Poulose15-Nov-06 5:06

James Poulose

15-Nov-06 5:06

So sorry for the inconvinience caused. Please find the xml below

<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<SetResponse xmlns="http://tempuri.org/">
<sMessageID>EEF0AFFE-A9F5-41A2-AE82-4601E3E2465F</sMessageID>
</SetResponse>
</soap:Body>
</soap:Envelope>

xpath i am trying to use the "sMessageID" element
/soap:Envelope/soap:Body/SetResponse/sMessageID

Regards,
James

Re: XPaths to SOAP xmls

Stefan Troschuetz15-Nov-06 5:36

Stefan Troschuetz

15-Nov-06 5:36

I'm not sure, but I think the problem is that the SetResponse and sMessageID element are in the "http://tempuri.org/" namespace (defined as standard namespace without prefix) but this doesn't reflect in your XPath expression.
Try to use the SelectSingleNode overload that additionally takes a XmlNamespaceManager instance. Add entries for the pair (soap "http://schemas.xmlsoap.org/soap/envelope/") and (somePrefix "http://tempuri.org/") and use the somePrefix in your XPath: /soap:Envelope/soap:Body/somePrefix:SetResponse/somePrefix:sMessageID.

"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." - Rick Cook

www.troschuetz.de

Re: XPaths to SOAP xmls

James Poulose15-Nov-06 17:57

James Poulose

15-Nov-06 17:57

Hi,
I have already done all the namespace mechanisms known to me.The problem is , if i add a namespace on my own, it should be applicable to all parts in the xpaths, not just the last couple of parts. I think, we need to find a way to specify that "soap" prefix is not a namespace and it is just an element name. Any way thanks for your reply Smile | :)

Regards,
James

How do you update an XML record?

gowland037915-Nov-06 0:01

gowland0379

15-Nov-06 0:01

I'm a current MCAD student. Hope someone can help me with a small query. I am working on an application that saves student records to an xml file. Through using an Xml Schema, a dataset generated from the xml schema, a new student row and the WriteXml method, I can save a new record to an xml file.

However, if I display an existing record to a series of textboxes and want to amend the record, how do I save the amended record back to the xml file. If I find a student row using the Student ID, populate the textboxes with the details, then use WriteXml method again, that saves a new record to the file instead of amending the existing records. I therefore conclude this is the wrong way of doing things so I am asking if anyone can point me in the right direction.

Is there another dataset method I should be using that I am not aware of to update an existing record. The NewStudentRow() method adds a new record, is there another method for updating?

Grateful for any help.

converting from string array to int array

karanba14-Nov-06 23:32

karanba

14-Nov-06 23:32