C# Discussion Boards - CodeProject

Re: how to create the web config file?

13-Feb-09 3:54

in your web project, right click, go to Add New Item and select Web Configuration File.

Calin

vaghelabhavesh13-Feb-09 3:58

vaghelabhavesh

13-Feb-09 3:58

Web.config file is used for Web Application such ASP.NET application but if you are working on Windows Forms Application you can use app.config file.

How to add Web.config file[^]

How to Add App.config file[^]

If you are using Visual Studio then right click the Project ->Add New Item->Select Web Configuration File for web.config or Application Configuration File for app.config.

Create a XML file from Doc.txt

abbd13-Feb-09 3:40

abbd

13-Feb-09 3:40

Hello,

I would create a xml file from txt, i make this :

<br />
XDocument doc = new XDocument(<br />
                new XDeclaration("1.0", "utf-8", "yes"),<br />
                new XComment("Liste des clients"));<br />
while ((s = sr.ReadLine()) != null)<br />
                        {<br />
                            String[] tbStr = s.Split(new Char[] { ';' });<br />
 <br />
 <br />
                           <br />
                new XElement("clients", new XElement("client", new XAttribute("ID", tbStr[0]),<br />
                    new XElement("société", tbStr[1]), <br />
                    new XElement("site", tbStr[2])));<br />
         <br />
                        }<br />
                        doc.Save(@"C:\Documents and Settings\Administrateur\Bureau\output\test.xml");<br />
                    }<br />
 <br />
 <br />

unfortunately, they are an exception : Token EndDocument in state Document would result in an invalid XML document. help me to construct the xml file, thank you verry mutch.

Re: Create a XML file from Doc.txt

Calin Tatar13-Feb-09 3:52

Create a XML file from txt

13-Feb-09 3:52

please see the other post

Calin

abbd13-Feb-09 3:40

abbd

13-Feb-09 3:40

Hello,

I would create a xml file from txt, i make this :

<br />
XDocument doc = new XDocument(<br />
                new XDeclaration("1.0", "utf-8", "yes"),<br />
                new XComment("Liste des clients"));<br />
while ((s = sr.ReadLine()) != null)<br />
                        {<br />
                            String[] tbStr = s.Split(new Char[] { ';' });<br />
 <br />
 <br />
                           <br />
                new XElement("clients", new XElement("client", new XAttribute("ID", tbStr[0]),<br />
                    new XElement("société", tbStr[1]), <br />
                    new XElement("site", tbStr[2])));<br />
         <br />
                        }<br />
                        doc.Save(@"C:\Documents and Settings\Administrateur\Bureau\output\test.xml");<br />
                    }<br />
 <br />
 <br />

unfortunately, they are an exception : Token EndDocument in state Document would result in an invalid XML document. help me to construct the xml file, thank you verry mutch.

Calin Tatar13-Feb-09 3:47

13-Feb-09 3:47

I think you are getting this error because you are not adding a root element.

Calin

Calin Tatar13-Feb-09 3:51

13-Feb-09 3:51

so I suggest you to add a ROOT element and after that add the elements in foreach.

Calin

abbd13-Feb-09 4:02

abbd

13-Feb-09 4:02

can you show me, how we can do that? thank you verry mutch.

Method summery tags question

Ramkithepower13-Feb-09 15:01

Ramkithepower

13-Feb-09 15:01

Can you give us the structure of the text file that you would like to convert?

Programm3r13-Feb-09 2:43

Programm3r

13-Feb-09 2:43

Hi all,

I have a library with a couple of methods. I make use of the xml tags to comment the method.

/// <summary>
/// Executes the command.
/// </summary>
/// <param name="Command">The command.</param>
/// <returns></returns>
public bool ExecuteCommand(string Command)

The problem is as soon as I compile the code and use the library in another project, none of the comments displays Confused | :confused:

How can I fix this.
Many thanks in advance

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Programm3r13-Feb-09 2:49

Programm3r

13-Feb-09 2:49

See this[^] document.

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

ABitSmart13-Feb-09 3:21

ABitSmart

13-Feb-09 3:21

If you are trying to say/ask something, please type it. No one will dare download the document for security reasons Big Grin | :-D

EliottA13-Feb-09 3:27

EliottA

13-Feb-09 3:27

I wouldn't go as far as to say no one Poke tongue | ;-P

Check out the CodeProject forum Guidelines[^]

Scott Dorman13-Feb-09 5:01

Scott Dorman

13-Feb-09 5:01

Make sure you have the project set to create an XML documentation file (project properties, build tab, and check the "XML documentation file" checkbox).

Scott Dorman

Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA

[Blog][Articles][Forum Guidelines]

Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai

Accessing reporting services from C#

Urs Enzler13-Feb-09 11:35

Urs Enzler

13-Feb-09 11:35

Check the "create XML documentation file" and provide a path for the docu file in the project settings.

Copy your dll and the docu xml together to your other project.

-^-^-^-^-^-^-^-
planetgeek.ch

Ajit_thedude13-Feb-09 0:20

Ajit_thedude

13-Feb-09 0:20

Hello,

I have username and password va;ues with me. I want to check programmatically whether the username & password are correct to login to reporting services or not. Is there any way to check it from c#?

Thanks,
Ajit

Re: Accessing reporting services from C#

Calin Tatar13-Feb-09 5:07

problem with passing parameters to sql 2000 DB

13-Feb-09 5:07

Hi
You may use Reporting Services Web Service for this. http://msdn.microsoft.com/en-us/library/aa274396(SQL.80).aspx[^]

ReportingService service = new ReportingService();
service.Credentials = new System.Net.NetworkCredential("USR", "PSW", "DOMAIN");

Calin

prasadbuddhika13-Feb-09 0:06

prasadbuddhika

13-Feb-09 0:06

i'm trying to pass values to db through a query.this ia the update query.

" UPDATE T_PRECORD 
  set PR_FIELD10= @singhalaname ,PR_FIELD8 =@singhaladesignation 
  where PR_FIELD21 = @regno";

i used

command.Parameters.Add("PR_FIELD10", SqlDbType.VarChar);
               command.Parameters.Add("PR_FIELD8", SqlDbType.VarChar);
               command.Parameters.Add("PR_FIELD21", SqlDbType.VarChar);

               command.Parameters["PR_FIELD10"].Value = cadbn.Name_singhala;
               command.Parameters["PR_FIELD8"].Value = cadbn.Desig_sinhala;
               command.Parameters["PR_FIELD21"].Value = cadbn.Regno;

but when i execute this i get the exception saying that to declare the
@singhalaname,@singhaladesignation, @regno

can anyone tell me how to pass vales as parameters to sql 2000 DB

musefan13-Feb-09 0:14

musefan

13-Feb-09 0:14

when you add params you need to type the param name not the fieldname

that maybe the problem

If only MySelf.Visible was more than just a getter...

A person can produce over 5 times there own body weight in excrement each year... please re-read your questions before posting

ABitSmart13-Feb-09 0:26

ABitSmart

13-Feb-09 0:26

How about this ?

command.Parameters.Add("@singhalaname", SqlDbType.VarChar);<br />
                command.Parameters.Add("@singhaladesignation", SqlDbType.VarChar);<br />
                command.Parameters.Add("@regno", SqlDbType.VarChar);<br />
ommand.Parameters["@singhalaname"].Value = cadbn.Name_singhala;<br />
                command.Parameters["@singhaladesignation"].Value = cadbn.Desig_sinhala;<br />
                command.Parameters["@regno"].Value = cadbn.Regno;

prasadbuddhika13-Feb-09 0:44

prasadbuddhika

13-Feb-09 0:44

thanks , but i still getting the same exception? any other idea?

ABitSmart13-Feb-09 2:01

ABitSmart

13-Feb-09 2:01

How are you executing the query ? Can you paste the code/error for better understanding ?

Make sure,
column names PR_FIELD10,PR_FIELD8,PR_FIELD21 do exists in the table and there is no typo
All your datatypes are varchar ?

Try doing it with this string,

string updateQuery = <br />
" UPDATE T_PRECORD <br />
  set PR_FIELD10= '" + cadbn.Name_singhala + "' ,PR_FIELD8 = '" + cadbn.Desig_sinhala + "'  where PR_FIELD21 = '" cadbn.Regno "'";

Edit - Also, make sure you are updating the right columns

prasadbuddhika13-Feb-09 17:07

prasadbuddhika

13-Feb-09 17:07

sorry i couldn't answer you, but the way you suggest is the way this was done previously, the problem is for these fields i used other language(sinhalese)so when that values are put into the bean they are stored in english characters, so there is a high possibility for sql exception or injections (ex:set PR_FIELD10= 'hahal'kf' because of the ' in middle the query fails)