C# Discussion Boards - CodeProject

OriginalGriff31-Dec-09 4:39

31-Dec-09 4:39

Replace the "catch (Exception)" with "catch (Exception ex)" and have a look at the ex message and so forth. It will be telling you there is an error in your SQL syntax and will probably say "in SQL syntax near ..." where the ... bit gives you a clue where the problem is.
If that doesn't make is obvious, then cut down the insert statement until either it works or has only one value left - in which case the problem will be your connection string.

BTW: Parameters.Add(...).Value has been superceeded by Parameters.AddWithValue(name, value) - it won't make any difference at this point, but it's worth using the up-to-date stuff if you can.

All those who believe in psycho kinesis, raise my hand.

Re: something wrong in codes

Erdinc271-Jan-10 23:44

Erdinc27

1-Jan-10 23:44

hi man
again me
i wrote ex as u said before and i have such a warning as an exception...
"The parameterized(@ad nvarchar(6),@soyad nvarchar(6),@firma nvarchar(4000))insert" expects parameter @firma,which was not supplied.and i have such codes to add this datas

cmd.Parameters.AddWithValue("@ad", txtAd.Text);
cmd.Parameters.AddWithValue("@soyad", txtSoyad.Text);
cmd.Parameters.AddWithValue("@firma", cmbFirma.SelectedItem);

and i keep that areas in my database like that
ad nvarchar(50),
soyad nvarchar(50),
firma nvarchar(60)

so i didnt get the problem i have now Frown | :(

Re: something wrong in codes

OriginalGriff2-Jan-10 0:02

OriginalGriff

2-Jan-10 0:02

I take it that you mean you have a field in your DB called "firma" which is declared as "nvarchar(60)", but your insert statement is still not working, and complains that parameter "@firma" is not supplied?
In which case, I suspect that cmbFirma.SelectedItem is a ComboBox and you have not selected anything in it? In which case "cmbFirma.SelectedItem" will return null, and this may be your problem - breakpoint the insert and check.
Good luck (and happy new year)!

All those who believe in psycho kinesis, raise my hand.

Retrieve an image from another pc in network

wasifmuneer31-Dec-09 1:54

wasifmuneer

31-Dec-09 1:54

Dear Members,
kindly tell me the problem how to resolve it,i have to retrieve an image file from another network pc or remote pc,i m confused about it,how to work on it either have to work by mapping a network drive,or have a windows service for this purpose...any suggestion plzz

The language platform is C#

Regards

Re: Retrieve an image from another pc in network

Paul Unsworth31-Dec-09 2:06

Paul Unsworth

31-Dec-09 2:06

I'm confused by your question.

Am I right in saying that you want to copy a file from another location on the network to use it?

I would simply suggest mapping a drive to that location. That location would have to be shared though.

Then you just use <codefile.copy(sourcefilepath, destinationfilepath);=""> from System.IO;.

I hope this helps, or even makes sense. I need more coffee.... Big Grin | :-D

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

Re: Retrieve an image from another pc in network

minnie mouse31-Dec-09 14:48

minnie mouse

31-Dec-09 14:48

Try having a look for " Socket Server C#" & " Socket Client C#"
or you could use good old "Sneakernet". ????
This is a bad question.

problem with custom serialization in .net 2.0

prasadbuddhika31-Dec-09 1:48

prasadbuddhika

31-Dec-09 1:48

i'm trying to serialize and deserialize an object using xmlSerializer .the serialization part is ok ,but in the deserialization part i don't get "amount" calculated as expected.

following is the code of the object i serialize.

[Serializable]
public class _object
{
public int itemCnt;
public string itemName;
public decimal unitPrice;
[NonSerialized]public decimal amount;

public _object(int _itemCnt,string _itemName,decimal _unitPrice)
{
itemCnt = _itemCnt;
itemName = _itemName;
unitPrice = _unitPrice;
}

protected _object(SerializationInfo info, StreamingContext context)
{
itemCnt = info.GetInt32("itemCnt");
itemName = info.GetString("itemName");
unitPrice = info.GetDecimal("unitPrice");
amount = info.GetDecimal("total");
}

[SecurityPermissionAttribute(SecurityAction.Demand,SerializationFormatter = true)]
public virtual void GetObjectData(SerializationInfo info, StreamingContext context)
{
info.AddValue("itemCnt", itemCnt);
info.AddValue("itemName", itemName);
info.AddValue("unitPrice", unitPrice);
amount = itemCnt * unitPrice;
}

}

any idea why?

Re: problem with custom serialization in .net 2.0

Paul Unsworth31-Dec-09 2:00

Paul Unsworth

31-Dec-09 2:00

Are you setting the amount outside your class? I cannot see where it would be calculated.

prasadbuddhika wrote:
[NonSerialized]public decimal amount;

If this is the case, when you are deserialzing your class, you will lose the Amount value as it is NonSerialized, so not stored when serialized... Poke tongue | ;-P

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

Re: problem with custom serialization in .net 2.0

Abhinav S31-Dec-09 3:14

Abhinav S

31-Dec-09 3:14

prasadbuddhika wrote:
[NonSerialized]public decimal amount;

Amount is marked as 'non serializable'.

There are only 10 types of people in this world — those who understand binary, and those who don't.

Re: problem with custom serialization in .net 2.0

prasadbuddhika31-Dec-09 19:14

prasadbuddhika

31-Dec-09 19:14

wish you all a happy new year..! thanx for your reply . i had made a mistake the constructor with the serialzationinfo and the streamcontext is the one which will be called at deserialization. so i had to calculate the amount in this . then the constructor will be changed to

protected _object(SerializationInfo info, StreamingContext context)
        {
            itemCnt = info.GetInt32("itemCnt");
            itemName = info.GetString("itemName");
            unitPrice = info.GetDecimal("unitPrice");
            amount = itemCnt * unitPrice;
        }

but the problem is still remaining...the itemCnt,itemName and unitPrice are getting accurately , only the calculation is not taking place..

"The path is not of a legal form." on trying to start the service created in c#

sri_346431-Dec-09 0:25

sri_3464

31-Dec-09 0:25

Hi,

I tried created a windows service which does a file transfer from the folder its watching whenever a new file being created in it.I am getting an exception saying "The path is not of a legal form." on trying to start the service. An the path the exception refering to is the path that i set to the FileSystemWatch. Path property. I dont understand why it happens. The path is "D:\Test". The folder has all the permission to access.

Can anyone help me out.

Re: "The path is not of a legal form." on trying to start the service created in c#

Rob Philpott31-Dec-09 0:42

Rob Philpott

31-Dec-09 0:42

When setting your path did you use an @ ?

string path = @"D:\Test";

Without that, that \T will likely get converted to a tab which would not be a legal form.

Regards,
Rob Philpott.

Re: "The path is not of a legal form." on trying to start the service created in c#

Keith Barrow31-Dec-09 0:46

Keith Barrow

31-Dec-09 0:46

Without the code it is difficult to help, can post it please? Remember to use <pre> tags Smile | :)

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

Re: "The path is not of a legal form." on trying to start the service created in c#

sri_346431-Dec-09 0:52

sri_3464

31-Dec-09 0:52

Service1.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Linq;
using System.ServiceProcess;
using System.Text;
using System.Configuration;

namespace FileTransfer
{
    public partial class Service1 : ServiceBase
    {
        public Service1()
        {
            InitializeComponent();
        }

        protected override void OnStart(string[] args)
        {
            try
            {
                FileTransferWatcher.Created += new System.IO.FileSystemEventHandler(FileTransferWatcher_Created);
            }
            catch (Exception ex)
            {
                EventLog.WriteEntry("Message :  " + ex.Message);
            }
        }

        void FileTransferWatcher_Created(object sender, System.IO.FileSystemEventArgs e)
        {
            System.IO.File.Copy(e.FullPath, @"D:\");
        }

        protected override void OnStop()
        {
        }
    }
}

Service1.Designer.cs

namespace FileTransfer
{
    partial class Service1
    {
        /// <summary> 
        /// Required designer variable.
        /// </summary>
        private System.ComponentModel.IContainer components;

        /// <summary>
        /// Clean up any resources being used.
        /// </summary>
        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
        protected override void Dispose(bool disposing)
        {
            if (disposing && (components != null))
            {
                components.Dispose();
            }
            base.Dispose(disposing);
        }

        #region Component Designer generated code

        /// <summary> 
        /// Required method for Designer support - do not modify 
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.FileTransferWatcher = new System.IO.FileSystemWatcher();
            // 
            // FileTransferWatcher
            // 
            this.FileTransferWatcher.EnableRaisingEvents = true;
            this.FileTransferWatcher.Path = "D:\\Test\\";
            // 
            // Service1
            // 
            this.ServiceName = "FileTransfer";

        }

        #endregion

        private System.IO.FileSystemWatcher FileTransferWatcher;
    }
}

The bolder statement is were the exception is thrown.

Re: "The path is not of a legal form." on trying to start the service created in c#

Keith Barrow31-Dec-09 1:09

Keith Barrow

31-Dec-09 1:09

You need to set

this.FileTransferWatcher.Path = "D:\\Test\\";

before this

FileTransferWatcher.EnableRaisingEvents = true;

As the inital path of a FileSystemWatcher is an empty string.

Also, as a side note, hardcoding the paths in magic strings isn't a good plan (though obviously the code posted is, by definition, unfinished). I'd also move out the FileWatcher/Transfer code into a separate class that deals with this and let the service just handle the service related stuff.

The other thing is, if you can, I'd run this as a console app and then convert it into a service later as debugging services is trickier.

CCC solved so far: 2 (including a Hard One!)
37!?!! - Randall, Clerks

Re: "The path is not of a legal form." on trying to start the service created in c#

sri_346431-Dec-09 3:24

sri_3464

31-Dec-09 3:24

Thanks Keefb!
I got the mistake i have done... Also as you said i should have started with as a console application.

Re: "The path is not of a legal form." on trying to start the service created in c#

0x3c031-Dec-09 2:25

0x3c0

31-Dec-09 2:25

This is just a guess, but does the directory exist? I've looked at the property's code through Reflector, and that's the only thing that will throw the exception.

By the way, your File.Copy will fail, because you haven't specified a source filename, just the parent directory.

OSDev

Re: "The path is not of a legal form." on trying to start the service created in c#

Thomas Krojer31-Dec-09 3:05

Thomas Krojer

31-Dec-09 3:05

Sorry, I try to understand what you are doing:

void FileTransferWatcher_Created(object sender, System.IO.FileSystemEventArgs e)
        {
            System.IO.File.Copy(e.FullPath, @"D:\");
        }
/pre>

Are you copying a file to your observed directory when you register the handler?

problem with RSS feed - pubDate

CrimeanTurtle200831-Dec-09 0:16

CrimeanTurtle2008

31-Dec-09 0:16

Hi All,

Hope everyone had a Merry Xmas and Happy New Year.

Just a question...I have made an RSS Feed which is syndicated by the Mozilla and IE , as an output of an XML file. However when either of the feeds show, they show the pubDate as being totally different dates to what is shown in the XML file. Even when I look at the source, the XML file still shows the correct dates as opposed to what is shown in the browser.
What do you guys think is the problem? Heres my code. Cheers.

public static void CreateNewsFeed(string mappath)
{
FileStream fs = null;
StreamWriter sw = null;

try
{

using (SqlConnection conn = Connection.connect())
{

SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "ShowNewsFeed";
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();

fs = new FileStream(mappath, System.IO.FileMode.Create, System.IO.FileAccess.Write);
sw = new StreamWriter(fs);

sw.WriteLine("<?xml version=\"1.0\" encoding=\"UTF-8\"?>");
//ISO-8859-1
//xmlns:atom=\"http://www.w3.org/2005/Atom\"

sw.WriteLine("<rss version=\"2.0\">");
sw.WriteLine("<channel>");
sw.WriteLine("<title>Company Name</title>");
sw.WriteLine("<link>http://www.companyname.com.au/Home/News/News.aspx</link>");
sw.WriteLine("<description>News and the latest updates</description>");
sw.WriteLine("<language>en-us</language>");

while (reader.Read())
{
DateTime dt = (DateTime)reader["datePosted"];

sw.WriteLine("<item>");
sw.WriteLine("<title>" + reader["title"].ToString() + "</title>");
sw.WriteLine("<link>http://www.companyname.com.au/NewsArticle.aspx?newsID=" + reader["newsID"] + "</link>");
sw.WriteLine("<description>" + reader["description"].ToString() + "</description>");
sw.WriteLine("<pubDate>" + dt.ToString("R") + "</pubDate>");
sw.WriteLine("</item>");

}

sw.WriteLine("</channel>");
sw.WriteLine("</rss>");
sw.Close();
fs.Close();

}
}
catch (Exception m)
{

throw new Exception(m.Message);
}

}

Re: problem with RSS feed - pubDate [modified]

ProtoBytes31-Dec-09 3:48

ProtoBytes

31-Dec-09 3:48

donno really, might be that the browser is rewriting the timestamps.

I tried your rss online at:

http://www.w3schools.com/rss/tryrss.asp?filename=rss_ex_pubdate[^]

and it works fine:

Company Name
News and the latest updates
RSS Version: 2.0
Feed Updated: Thu, 17 Aug 2000 23:32:32 GMT

Some Title: Some description
Published: Thu, 27 Apr 2006

modified on Thursday, December 31, 2009 10:00 AM

Internet explorer HTTP Authentication - sending or storing headers

Vijayanand Settin30-Dec-09 23:32

Vijayanand Settin

30-Dec-09 23:32

I am working on developing a browser helper object for IE. I have to automatically login in to some sites.
These are issues I am facing:

1. In one of the sites, although I use a Navigate2() function of IWebBrowser2 with 'Basic' Authorization header, the site neglects it because it looks like a javascript function is run while loaded and it opens up a pop asking for credentials again (response header with WWW-Authenticate and Basic realm).

2. There are a few other sites where I succeed in logging in by sending Authorization header. But if I click on any of the links or try to browse, they again ask for credentials - some times with same domain or a different domain when it happens to open a new window.

I need a way to store login credentials as a part of internet explorer which the browser can add to every request for a domain or a set of domains. Or, if there are any other solutions, please do suggest.

Please do let me know if I am not clear.

Thanks,
Vijay

Re: Internet explorer HTTP Authentication - sending or storing headers

Sipder31-Dec-09 1:40

Sipder

31-Dec-09 1:40

I think Cookies will be the best solution for this

Re: Internet explorer HTTP Authentication - sending or storing headers

Vijayanand Settin4-Jan-10 1:36

Vijayanand Settin

4-Jan-10 1:36

Sipder, thanks for the suggestion.
Could you elaborate more on that, pls? Won't the server look for an authorization header? How does one make sure cookies are read when credentials are required?

Thanks,
Vijay

Spelling checker

linatta30-Dec-09 23:00

linatta

30-Dec-09 23:00

How do i use the edit distance and longest common subsequence algortihms for building a spelling checker application ??

Re: Spelling checker

Ravi Bhavnani31-Dec-09 16:34

Ravi Bhavnani

31-Dec-09 16:34

You could start by reading this[^] article.

/ravi

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

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