Storing and retrieving objects inside databse - C# Discussion Boards

First Prev Next

Re: Disabling button not working

Ravi Bhavnani11-Oct-12 8:47

Ravi Bhavnani

11-Oct-12 8:47

That should work. Are you sure you're not enabling it again -or- inadvertently trying to start another instrance of your background task?

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware
ravib(at)ravib(dot)com

C# SNMP Printer! HELPPP!

batuhan karaduman11-Oct-12 4:22

batuhan karaduman

11-Oct-12 4:22

Hi,

i need your help. i search "how to check toner level in printer using c# and SNMP protocol.

Please give me your ideas.

thanks a lot.

Re: C# SNMP Printer! HELPPP!

Eddy Vluggen11-Oct-12 4:44

Eddy Vluggen

11-Oct-12 4:44

Check the SNMP-documentation; not all printers will provide the functionality, and I doubt that there will be much copy/pastable solutions out there.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: C# SNMP Printer! HELPPP!

Wes Aday11-Oct-12 4:46

Wes Aday

11-Oct-12 4:46

alexalexalex1907 wrote:
check toner level in printer

Read the documentation for the printer (whatever it is) and/or check with whomever the manufacturer is.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Re: C# SNMP Printer! HELPPP!

jschell11-Oct-12 8:55

jschell

11-Oct-12 8:55

SNMP is a protocol just like http (just http) is.

Knowing SNMP however tells you absolutely nothing about solving your problem. Just as knowing nothing but http would not allow you to interact with a web site.

So you must learn more about the specific printer, and driver software and version.

Re: C# SNMP Printer! HELPPP!

batuhan karaduman11-Oct-12 20:31

batuhan karaduman

11-Oct-12 20:31

now i wont be able to code this with examples on the internet, right?

XML

String snmpAgent = "ipAddressOfPrinter";
String snmpCommunity = "public";
SimpleSnmp snmp = new SimpleSnmp(snmpAgent, snmpCommunity);
Dictionary<SnmpSharpNet.Oid, AsnType> result = snmp.Get(SnmpSharpNet.SnmpVersion.Ver1, new string[] { "OidOfPrinter" });
if (result == null)
{
    MessageBox.Show("Request Failed", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{

    foreach (KeyValuePair<SnmpSharpNet.Oid, AsnType> entry in result)
    {
        textBox1.Text = entry.Key.ToString() + " = " + SnmpConstants.GetTypeName(entry.Value.Type) + " (SysDesc.): " + entry.Value.ToString() + "->" + SnmpConstants.SMI_APPSTRING;

        textBox1.Text += "SysName: "+entry.Key;
    }
}

Here is the connection to the printer. I can get the name, software, oid of the printer but i cant check its status(if it is online, paper jam, offline, toner low, etc.) how can i get theese properties?

Thanks a lot

Re: C# SNMP Printer! HELPPP!

Marco Bertschi12-Oct-12 4:57

Marco Bertschi

12-Oct-12 4:57

Hi,

I am not sure if this will help you, but check it out:

http://checktoner.blogspot.ch/[^]

Storing and retrieving objects inside databse

Sabry190511-Oct-12 4:08

Sabry1905

11-Oct-12 4:08

Hi i want to store and retrieve objects of any kind to SQL server database, i did the following, inside the database table, i had created a field of type varbinary(MAX),
and in the code, i had made the following to store the object

object treatment = dataGridViewDrugList.Rows;
MemoryStream memStream = new MemoryStream();
StreamWriter sw = new StreamWriter(memStream);
sw.Write(treatment);
dataRow[0] = memStream.GetBuffer();

and it was successful,
now i am not able to retrieve the object back
any ideas?

modified 11-Oct-12 10:32am.

Re: Storing and retrieving objects inside databse

Eddy Vluggen11-Oct-12 4:43

Eddy Vluggen

11-Oct-12 4:43

Try to 'serialize' the object, as opposed to simply trying to wildly dump it's contents. There's an example using the XmlSerializer on MSDN; once it works, you replace the XmlSerializer with a BinaryFormatter and you're done.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Storing and retrieving objects inside databse

Sabry190511-Oct-12 7:06

Sabry1905

11-Oct-12 7:06

please send the link

Re: Storing and retrieving objects inside databse

Eddy Vluggen11-Oct-12 9:59

Eddy Vluggen

11-Oct-12 9:59

Here[^] it is. Serialization may take some getting-used-to, but it's more versatile than dumping memory.

I'd recommend building it in two separate steps; First, create a small console-app to serialize a random object. Once that works, you should be able to switch between Xml-serialization and binary with ease.

Second part would be to store that "information" in a database. That will work the same way for any information; if you get stuck once you're there, simply come back and we'll look at it again Smile | :)

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Storing and retrieving objects inside databse

Sabry190514-Oct-12 2:54

Sabry1905

14-Oct-12 2:54

Thanks, i solved the issue,
my error was that i was trying to serialize an object of type DataGridViewRowCollection

which is not marked as a Serializable object, i made my custom class which marked as Serializable, i had stored all the data in the DataGridViewRowCollection in that class,

now everything is OK

thanks again,

3 tier architecture

tannu dwivedi11-Oct-12 1:51

tannu dwivedi

11-Oct-12 1:51

i want to create 3 tier architecture in asp.net and c# using stored procedure

tannu

Re: 3 tier architecture

Wes Aday11-Oct-12 2:25

Wes Aday

11-Oct-12 2:25

tannu dwivedi wrote:
i want to create

Okay so go ahead and do that. Did you maybe have some sort of a question that you wanted to ask?

modified 11-Oct-12 10:48am.

Re: 3 tier architecture

Eddy Vluggen11-Oct-12 4:47

Eddy Vluggen

11-Oct-12 4:47

..and you're looking for a tutorial? Did not find anything on Google? Perhaps you'd like to start with Tier 1[^] and work your way up from there?

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: 3 tier architecture

CptSupermrkt11-Oct-12 16:26

CptSupermrkt

11-Oct-12 16:26

I don't know what you're asking, if anything at all, but check out http://imar.spaanjaars.com/416/building-layered-web-applications-with-microsoft-aspnet-20-part-1 It's a multi-part series that details what the 3 tier architecture is, and exactly how to implement it, with a real world example, complete with code snippets. I based our intranet solely on that article series, and it's worked out well so far.

Injection

ALIJavany11-Oct-12 1:24

ALIJavany

11-Oct-12 1:24

Hi Developers
How We Can Stop SQL Injection With Delegate ?
Please Help ME Thanx

Re: Injection

J4amieC11-Oct-12 1:30

J4amieC

11-Oct-12 1:30

You can't that makes no sense whatsoever.

You stop SQL Injection attacks (mainly) by using named parameters.

Re: Injection

ALIJavany11-Oct-12 8:37

ALIJavany

11-Oct-12 8:37

Really Really Thank you For Helping ME .
Thank You Very Much BUT I Do That Before With Creating Delegate And I Think one Code Can Do Faster And This is Why i Sent That Question.

Re: Injection

Eddy Vluggen11-Oct-12 1:30

Eddy Vluggen

11-Oct-12 1:30

Use a parameterized query[^]; the word 'delegate' is out of place here.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Re: Injection

Abhinav S11-Oct-12 20:57

Abhinav S

11-Oct-12 20:57

Proper validations inside a parameterized stored procedures can help reduce SQL injection.

WP7.5 Apps - XKCD | Calvin | SMBC | Sound Meter | Speed Dial

Re: Injection

KiranKumar Roy14-Oct-12 1:20

KiranKumar Roy

14-Oct-12 1:20

Go Through below link..
MSDN Protect From SQL Injection

KiranKumar Roy

Opacity

ALIJavany11-Oct-12 1:21

ALIJavany

11-Oct-12 1:21

Hi All Developers I have A Problem :
How I can Change Opacity Of a Control IN Windows Application C#.net .. I Know How I can Change Form Opacity But How we can Change Control Opacity Like A button.
Thanx Developers

Re: Opacity

J4amieC11-Oct-12 1:30

J4amieC

11-Oct-12 1:30

Why Are All Your Questions Written In Title Casing? It Looks Really Dumb In Normal Sentences. Stop It.

Re: Opacity

Eddy Vluggen11-Oct-12 1:31

Eddy Vluggen

11-Oct-12 1:31

The native button doesn't support transparancy.

Bastard Programmer from Hell Suspicious | :suss:

if you can't read my code, try converting it here[^]

Last Visit: 31-Dec-99 18:00 Last Update: 24-Apr-24 2:23

Refresh

ᐊ Prev 1...1831 1832 1833 183418351836 1837 1838 1839 1840 Next ᐅ

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