Read XML string, Manipulate, Store in Dataset & SqlBulkCopy - C# Discussion Boards

OriginalGriff28-Aug-13 21:13

OriginalGriff

28-Aug-13 21:13

And?
What have you tried? Where are you stuck?
What help do you need?

We aren't going to write the whole thing for you - that's what you are paid to do - so you need to help us to help you!

This message is manufactured from fully recyclable noughts and ones. To recycle this message, please separate into two tidy piles, and take them to your nearest local recycling centre.
Please note that in some areas noughts are always replaced with zeros by law, and many facilities cannot recycle zeroes - in this case, please bury them in your back garden and water frequently.

Member 1023886728-Aug-13 21:43

Member 10238867

28-Aug-13 21:43

Well I know that!

I have created a service already and its displaying the message started but , I think it is not reading my query..
All i just wanted it to check for record and see email at particular time.

regards

OriginalGriff28-Aug-13 22:00

OriginalGriff

28-Aug-13 22:00

Then tell us these things! We can't see your screen, or access your HDD, or read your mind... Laugh | :laugh:

Bernhard Hiller28-Aug-13 21:17

Bernhard Hiller

28-Aug-13 21:17

You do not need a Windows Service, you can use a Scheduled Task.
Where are you stuck now?

Re: DataGridView Printing

Member 1023886728-Aug-13 21:46

Member 10238867

28-Aug-13 21:46

The truth is I'm first timer , i have been out of Development for long time.

So when i was asked to build RFID monitoring service ,to send to admin people at different location.I thought of this way.

regards,

DataGridView Printing

Tsukasa8328-Aug-13 7:33

Tsukasa83

28-Aug-13 7:33

I'm using the following solution as my DataGridView Printer

Printing a DataGridView on DotNet Framework[^]

I'm attempting to modify it with no current luck.
When I print out my results the cell's BackColor always seems to be grey when the cell's in my DataGridView are a combination of different colors. These aren't set per row or per column, they are per cell.

I'm looking at GridDrawer.cs and i'm guessing this is because of the Method DrawRows and the line

g.FillRectangle(new SolidBrush(row.BackColor()), RowBounds);

I changed it and verified that it does change the row's back color.

How can I modify this so that each cell's BackColor represents the correct color from the DataGridView?

Or if there is another solution that already does this per cell not per row formatting that would be great also.

Thanks

OriginalGriff28-Aug-13 21:15

OriginalGriff

28-Aug-13 21:15

Don't ask this here - if you look at the article, there is a "messages" section at the bottom, which allows you to talk to the author directly. Any comment you post there sends an email to the original author of the article, so he can read it. Posting here relies on him "dropping by" and realizing it is for him!

Read XML string, Manipulate, Store in Dataset & SqlBulkCopy

murugesan.ks28-Aug-13 7:32

murugesan.ks

28-Aug-13 7:32

Hi,

My requirement is to read a XML string, Manipulate and store it in MS SQL Server.

XML:
<?xml version="1.0" encoding="UTF-8" ?>
<Data>
<Table1>
<Col1>Value1</Col1>
<Col2>Value2</Col2>
<Col3>Value3</Col3>
</Table1>
<Table1>
<Col1>Value1a</Col1>
<Col2>Value2a</Col2>
<Col3>Value3a</Col3>
</Table1>
...
...
...
...
</Data>

its available in string
string sXML = "<?xml version=\"1.0\" encoding=\"UTF-8\" ?><Data><Table><Col1>Value1</Col1><Col2>Value2</Col2><Col3>Value3</Col3></Table><Table><Col1>Value1a</Col1><Col2>Value2a</Col2><Col3>Value3a</Col3></Table></Data>"

MS SQL Server table structure and xml mapping

MyTable - XML
Column1->Col1
Column2->Col2
Column3->Col3
Column4->Col1+Col2
Column5->Col3+200
Column6-> {current system date}
Column-> {Default constraint stores '0' always}

Number of rows inserted will be max of 100 rows at a time
current clients accessing this app and passing XML would be around 20
Frequency of calling is 1 min

I use .NET 4.0, C# and MS SQL Server 2008

My Approach is read, xml file, manipulate it, store in dataset/datatable and do the bulk copy.

My Question is :
1. In this approach, How to manipulate and store it in dataset/datatable
1. Is there any better way to do it?

Thank you.

Re: Read XML string, Manipulate, Store in Dataset & SqlBulkCopy

SledgeHammer0128-Aug-13 9:26

SledgeHammer01

28-Aug-13 9:26

No need to over think / over engineer things.

1) load string into XML DOM
2) loop through table1's with xPath
3) bulk insert into SQL

If you want to be somewhat tricky, you only really need to insert the first 3 columns. The other 4 can be auto computed.

Converting MS-office files to PDF

sujeet32128-Aug-13 0:48

sujeet321

28-Aug-13 0:48

Hello Friends,

i Need API which will convert MS-Office files to PDF files
any help ?

Re: Converting MS-office files to PDF

Simon_Whale28-Aug-13 0:54

Simon_Whale

28-Aug-13 0:54

This is the first link from Google

how do i convert word files to pdf programmatically[^]

from this search string c# ms word to pdf[^]

Every day, thousands of innocent plants are killed by vegetarians.

Help end the violence EAT BACON

approve file

Diya Ayesa28-Aug-13 0:10

Diya Ayesa

28-Aug-13 0:10

hey

How can I have it so someone can click on a "Click here to Upload" button, and then select a file off their computer, (And preferably I'd like to be able to limit what kinda files they could upload to just .rar files) once they upload the file, an admin on the website can view the uploaded file, and click an "approve or Deny" button, and be able to download the file.

Re: approve file

Eddy Vluggen28-Aug-13 2:07

Eddy Vluggen

28-Aug-13 2:07

Ayesha Atif wrote:
<layer>How can I have it so someone can click on a "Click here to Upload" button, and then select a file off their computer, (And preferably I'd like to be able to limit what kinda files they could upload to just .rar files)

There's an option on the filedialog that let's one specify a filter. The same thing that causes users to rename the file-extension when sending a zip-file using GMail.

Ayesha Atif wrote:
once they upload the file, an admin on the website can view the uploaded file, and click an "approve or Deny" button, and be able to download the file.

Uploading a file, putting it somewhere on the server, have "someone" click a button - those are basic operations. Did you look for an example?

We can help with specific coding-questions; as is, this sounds like a request for an ASP.NET application.

Bastard Programmer from Hell Suspicious | :suss:

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

Re: approve file

Forbiddenx28-Aug-13 6:42

Forbiddenx

28-Aug-13 6:42

You can also sometimes detect the type of file beyond the standard ext by readings it into binary and checking the first couple of bytes to see if its a zip file, mp3.. etc..

Its a method to prevent people form uploading say exe with a .jpg extension..

I have done it with Mp3's and it worked pretty good.

Information about JPEG Header

Discover.ir27-Aug-13 23:40

Discover.ir

27-Aug-13 23:40

Hi,
I am working on a project about watermarking, so in part of my project I need to know some information and structure about a JPEG file header.
I searched many sites and red some articles but they were not useful... by the way I decide to ask from you.

In my project I'm trying to read inside a jpeg file by Buffer Streaming and I need to know from where through where is about what (seems complicated!! Blush | :O

).

Maybe if I know the header structure of a JPEG file, I will solve my problem.

Thanks

Amarnath S28-Aug-13 0:22

Amarnath S

28-Aug-13 0:22

You need to study the JPEG standard - available online here[^]

First, read the paper by Gregory Wallace available here[^].

modified 28-Aug-13 6:37am.

Discover.ir28-Aug-13 1:35

Discover.ir

28-Aug-13 1:35

Dear Amarnarh, Thank u...
I have red some books like:

* JPEG2000 Image Compression Fundamentals, Standards and Practice(2002)
* JPEG2000 Standard for Image Compression Concepts Algorithms and VLSI Architectures

But my question exactly is about offset of information included in JPEG header.

Thanks again

Dave Kreskowiak28-Aug-13 2:17

Dave Kreskowiak

28-Aug-13 2:17

What's so hard about typing "jpeg file format" into Google??

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Discover.ir28-Aug-13 2:27

Discover.ir

28-Aug-13 2:27

...?
I am talking about data structure of jpeg files.

reading from a dynamically created textarea

Dave Kreskowiak28-Aug-13 3:20

Dave Kreskowiak

28-Aug-13 3:20

Yeah, and ...?

You we're given links to the internals of JPEG, how it works, and told how to find the file format. There is nothing else in this process.

You can only either work with the data as it is in the file or with the data as it is represented in memory, which, by the way, in GDI is NOT in a JPEG format. You've been given both.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Hbr_Tha_real27-Aug-13 4:27

Hbr_Tha_real

27-Aug-13 4:27

Hi Guys.

I am having a situation here, i want to read a dynamically textarea content,

String CommentOut = null;

for (int intX = 0; intX < dt.Rows.Count; intX++ )
    {
        CommentOut += "<div class='commentBox'><table><tr><th>" + dt.Rows[intX][2].ToString() + " on:" + dt.Rows[intX][1];
        CommentOut += "</th></tr><tr><td bgcolor='#f5f1f1'>" + dt.Rows[intX][4].ToString() + "</td></tr><tr><td class='commentBoxIns'>";

        Quir = "Select  Username_ as 'Posted By', comment_ as 'Comment', Date_ as 'date' ";
        Quir += " From CommentsTBL_ where CommentID_ = '" + dt.Rows[intX][0].ToString() + "'";


        SqlCommand Sqlcom2 = new SqlCommand(Quir, Con);
        SqlDataAdapter Adapt2 = new SqlDataAdapter(Sqlcom2);
        DataTable dt2 = new DataTable();
        Adapt2.Fill(dt2);

    for(int intY=0; intY<dt2.Rows.Count; intY++){

        CommentOut += "<table width='70%' align='right'></tr><th>" + dt2.Rows[intY][0].ToString() + " on:" + dt2.Rows[intY][2].ToString();
        CommentOut += "</th></tr><tr/><td>" + dt2.Rows[intY][1].ToString();
        CommentOut+= "</td></tr></table>";
}
        Adapt2.Dispose();
        dt2.Dispose();
        Sqlcom2.Dispose();

        CommentOut += "</td></tr><tr><td><textarea id='comment" + intX + "' name='comment" + intX + "' rows='5' cols='20' style='width:97%;' runat='server'>type your comment here</textarea>";

    //IsueViewAndComment.aspx
        CommentOut += "</td></tr><tr class='commentBoxCom'><td><a href=?ID1=" + dt.Rows[intX][0].ToString() + "&ID2=comment" + intX + ">Comment</a>";


        //CommentOut += "<script type='text/javascript'>";
        //CommentOut+=" function fub" + intX + "(StrId, comment" + intX + ") {";
        //CommentOut+= " var prtContent = document.getElementById(StrId)";
        //CommentOut += " var prtContent = document.getElementById(comment" + intX + ")}</script>";

        CommentOut += "</td></tr><tr><td>";
    CommentOut += "</table>  </div><br/>";
    }

this.LitCont.Text = CommentOut;

Jason Gleim27-Aug-13 4:59

Jason Gleim

27-Aug-13 4:59

You'll need to be more specific. Please edit your question and tell us what the specific issue is. What have you tried that isn't working? Is it throwing an error? If so, tell us what it is. Some general information about what you are trying to do would be helpful and an idea of how this fits into the bigger picture.

Your post, as-is, is way too generic. You have dumped your car at the mechanic and said, "something is wrong." Imagine for a moment that we have no idea what you are doing and pretend that we need to be told all of the information you have about the problem.

Hbr_Tha_real28-Aug-13 1:53

Hbr_Tha_real

28-Aug-13 1:53

Thanks for replying.

the code that i posted above generates data from the database then creates the div (with a table inside) and in the table that i have here i put some values that are generated from the database, then per record that is returned i generate the replies that have been posted by other users, and create another table in one of the cells of the outter table, back to the outter table i create a textarea for each record and an that posts to the same page that postsback the record ID and the textarea ID,

and on my form_load event i have a condition that checks if if the

if (Request.QueryString.Count > 0)
     {
       f1(Request.QueryString[0], Request.QueryString[1]);
     }

then my f1 function

does this

<pre lang="c#">


private void f1(String fn, String fm) 
    {
      System.Web.UI.HtmlControls.HtmlTextArea TArea = new System.Web.UI.HtmlControls.HtmlTextArea();
            TArea.FindControl(fm);
            String Str1 = TArea.Value;
            Response.Write("<script type='text/javascript'>alert('" + Str1 + "')</script>");
        }

Jason Gleim28-Aug-13 7:24

Jason Gleim

28-Aug-13 7:24

OK... you explained your code and provided some additional code but you still haven't told us what the problem is. What are you trying to do? What is the problem? What have you tried that isn't working?

Unless you can define the desired behavior and how your code is deviating from that, we can't help you. Nobody can look through what you have posted to find an error that you haven't defined.