get a table from a website and save it into a db - C# Discussion Boards

AmbiguousName wrote:
breakpoint gets hit which means that I can not go on and continue resizing my form.

That is as to be expected, but does not add to the information you have been asked to provide.

First, that other process is not a "control". It's a foreign process "window". You cannot use the two terms interchangeably as this will confuse people.

Second, I already told you what you're doing is very difficult to control and you will not have complete control over the foreign process window. Users CAN and WILL manipulate that window just like it was sitting on the Desktop outside of your application. For example, they WILL be able to grab the window title bar and window edges and move them around. They can even minimize and maximize the window without your application knowing anything about it!

What you're doing is possible to do, but not in a production application. It's more of a novelty than anything else.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

Now that we finally know you are using the Win Media Player ... check out: [^].

cheers, Bill

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

hi,

i'm implementing one program in C#.net Console application for converting pcl files into pdf format using GhostScript open source dll.

could you please tell me how to implement the above task using mentioned dll, if anyone knows?

if possible, please send the source code which is properly working.

thank you,
sai k

GhostScript cannot read/convert pcl files: you need to use PCL (note that even GhostScript's site sometimes using PDL); it's part of the GhostScript "family"), see: [^].

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

modified 19-Sep-14 5:00am.

Hi,

I had the following code to Post my data to WebApi.

[code]
public EFileInfo UploadFile(string WebApiBaseAddress, string WebApiServiceUrl, WebApiParameters webParams)
{
EFileInfo eFile = null;

RestClient client = new RestClient(WebApiBaseAddress);
RestRequest request = new RestRequest(WebApiServiceUrl, Method.POST);
request.RequestFormat = DataFormat.Json;
request.AddBody(webParams);

IRestResponse response = client.Execute(request);

eFile = new System.Web.Script.Serialization.JavaScriptSerializer().Deserialize<efileinfo>(response.Content);

return eFile;
}
[/code]

And the following is my code to accept the parameter and post the data:

[code]
public EFileInfo PosteFile(WebApiParameters wParams) {
EFileInfo eFileResult = null;
var httpRequest = HttpContext.Current.Request;

try {
eFileResult = resp.Upload_File(AppRootPath, Convert.ToInt32(wParams.Parameters["year"]),
Convert.ToInt32(wParams.Parameters["month"]), wParams.Parameters["location"],
wParams.Parameters["brand"], wParams.Parameters["department"], wParams.Parameters["type"],
wParams.Parameters["generateFrom"], Convert.ToInt32(wParams.Parameters["expiryDuration"]),
wParams.UploadFiles.First());
} catch (InvalidOperationException ex) {
throw new NotImplementedException(ex.Message, new Exception(ex.InnerException.ToString()));
// throw new NotImplementedException(ex.Message, new Exception(ex.InnerException.ToString()));
}
return eFileResult;
[/code]

I am not sure why the parameter always unable to pass it to PosteFile. The process sometimes run smoothly but sometimes it pass NULL value to PosteFile function. I checked the parameters, everything is ok.

Not much information there. But why do you think there is a problem? Easiest solution of course is if wParams is null then check at the beginning of method and exit the method without doing anything.

hellow to every body
i have a little froblem with this question. i want to get an information from a website with c# and save to my database.i can get the website but i cant choose a part that what i want.the information that i want to save in my db is a table from a website.
i write the coosen code here . please give me a code that i can choose this part and save it in my db.
thank you All.
1393/07/04نرخ رسمي ارزيك دلار آمريكا26635يك يورو34496يك پوند انگليس43337يكصد ين ژاپن24847يك فرانك سويس28549يك دلار كانادا24266يك دلار استراليا24157يك كرون نروژ4160يك كرون سوئد3738يك كرون دانمارك4633يك درهم امارات متحده عربي7252يك ريال عربستان سعودي7102يك دينار كويت92677يك دينار بحرين70631يك ريال قطر7314يك ريال عمان69164يك روپيه هندوستان437يك لير تركيه12079يكصد دينار عراق2293يك راند آفريقاي جنوبي2442يوان چين4335رين گيت مالزي8280دلار سنگاپور21114دلار هنگ كنگ3437هزارروپيه اندونزي2235هزار وون كره جنوبي25775يكصد درام ارمنستان6515يك منات آذربايجان33961يك روبل روسيه695يك دلار تايوان885يك ريونيا اكراين2050يك هزار روبل بلاروس2534يكصد بات تايلند82684

and this is that code

HTML

<span style="direction:ltr" dir="ltr">1393/07/04</span></td></tr><tr><td class="auto-style2" style="color:white;background-color:green" colspan="2">نرخ رسمي ارز</td></tr><tr><td class="ms-list7-odd">يك دلار آمريكا</td><td class="ms-list7-odd">26635</td></tr><tr><td class="ms-list7-even">يك يورو</td><td class="ms-list7-even">34496</td></tr><tr><td class="ms-list7-odd">يك پوند انگليس</td><td class="ms-list7-odd">43337</td></tr><tr><td class="ms-list7-even">يكصد ين ژاپن</td><td class="ms-list7-even">24847</td></tr><tr><td class="ms-list7-odd">يك فرانك سويس</td><td class="ms-list7-odd">28549</td></tr><tr><td class="ms-list7-even">يك دلار كانادا</td><td class="ms-list7-even">24266</td></tr><tr><td class="ms-list7-odd" style="height: 23px">يك دلار استراليا</td><td class="ms-list7-odd" style="height: 23px">24157</td></tr><tr><td class="ms-list7-even">يك كرون نروژ</td><td class="ms-list7-even">4160</td></tr><tr><td class="ms-list7-odd">يك كرون سوئد</td><td class="ms-list7-odd">3738</td></tr><tr><td class="ms-list7-even">يك كرون دانمارك</td><td class="ms-list7-even">4633</td></tr><tr><td class="ms-list7-odd">يك درهم امارات متحده عربي</td><td class="ms-list7-odd">7252</td></tr><tr><td class="ms-list7-even">يك ريال عربستان سعودي</td><td class="ms-list7-even">7102</td></tr><tr><td class="ms-list7-odd">يك دينار كويت</td><td class="ms-list7-odd">92677</td></tr><tr><td class="ms-list7-even">يك دينار بحرين</td><td class="ms-list7-even">70631</td></tr><tr><td class="ms-list7-odd" style="height: 23px">يك ريال قطر</td><td class="ms-list7-odd" style="height: 23px">7314</td></tr><tr><td class="ms-list7-even">يك ريال عمان</td><td class="ms-list7-even">69164</td></tr><tr><td class="ms-list7-odd">يك روپيه هندوستان</td><td class="ms-list7-odd">437</td></tr><tr><td class="ms-list7-even" style="height: 23px">يك لير تركيه</td><td class="ms-list7-even" style="height: 23px">12079</td></tr><tr><td class="ms-list7-odd">يكصد دينار عراق</td><td class="ms-list7-odd">2293</td></tr><tr><td class="ms-list7-even">يك راند آفريقاي جنوبي</td><td class="ms-list7-even">2442</td></tr><tr><td class="ms-list7-odd">يوان چين</td><td class="ms-list7-odd">4335</td></tr><tr><td class="ms-list7-even">رين گيت مالزي</td><td class="ms-list7-even">8280</td></tr><tr><td class="ms-list7-odd" style="height: 23px">دلار سنگاپور</td><td class="ms-list7-odd" style="height: 23px">21114</td></tr><tr><td class="ms-list7-even">دلار هنگ كنگ</td><td class="ms-list7-even">3437</td></tr><tr><td class="ms-list7-odd" style="height: 23px">هزارروپيه اندونزي</td><td class="ms-list7-odd" style="height: 23px">2235</td></tr><tr><td class="ms-list7-even">هزار وون كره جنوبي</td><td class="ms-list7-even">25775</td></tr><tr><td class="ms-list7-odd" style="height: 23px">يكصد درام ارمنستان</td><td class="ms-list7-odd" style="height: 23px">6515</td></tr><tr><td class="ms-list7-even" style="height: 23px">يك منات آذربايجان</td><td class="ms-list7-even" style="height: 23px">33961</td></tr><tr><td class="ms-list7-odd" style="height: 23px">يك روبل روسيه</td><td class="ms-list7-odd" style="height: 23px">695</td></tr><tr><td class="ms-list7-even" style="height: 23px">يك دلار تايوان</td><td class="ms-list7-even" style="height: 23px">885</td></tr><tr><td class="ms-list7-odd" style="height: 23px">يك ريونيا اكراين</td><td class="ms-list7-odd" style="height: 23px">2050</td></tr><tr><td class="ms-list7-even" style="height: 23px">يك هزار روبل بلاروس</td><td class="ms-list7-even" style="height: 23px">2534</td></tr><tr><td class="ms-list7-odd" style="height: 23px">يكصد بات تايلند</td><td class="ms-list7-odd" style="height: 23px">82684</td></tr></table>

First, nobody is going to write your code for you. The code you get is the code YOU write.

Second, you haven't said anything at all about what you what out of that table.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

And Please format your code Frown | :(

Please up vote if it helped you Smile | :)

Thanks And Regards
Sibeesh

can we programmatically detect when user touch the panel left or right edge ? suppose i have one panel with 200X200 size now i want to update a label text when user place his mouse at the left or right most portion on the panel. anyone can help me to achieve it programmatically. thanks

tbhattacharjee

There's a mousemove event, and there's a mouseenter event on each control.

Bastard Programmer from Hell Suspicious | :suss:

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

I assume this is a Windows Forms project with: on the same Form:

1. a Panel named 'panel1 200x200 in size

2. a Label named 'label1

3. you define the Panel's 'MouseMove EventHandler:

C#

private void panel1_MouseMove(object sender, MouseEventArgs e)
{
    if (e.X < 5 || e.X > 195)
    {
        label1.Text = e.Location.ToString();
    }
    else
    {
        label1.Text = "";
    }
}

The label will be updated with the current mouse position in 'panel1 co-ordinates every time it is moved within 5 points of the right and left side.

Consider another simple solution:

1. a Panel, 'panel1 200x200

2. a Panel, 'panel2 190x200

3. a Label, 'label1

by placing 'panel2 inside 'panel1 (adding 'panel2 to panel1's ControlCollection), and writing this MouseMove EventHandler for 'panel1:

C#

private void panel1_MouseMove(object sender, MouseEventArgs e)
{
    label1.Text = e.Location.ToString();
}

The mouse-move will be detected only when the mouse is over the area not covered by 'panel2: which would be an area of the two horizontal sides of 'panel1 5 points in width.

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

here is your code.

C#

private void panel1_MouseMove(object sender, MouseEventArgs e)
{
    if (e.X < 5 || e.X > 195)
    {
        label1.Text = e.Location.ToString();
    }
    else
    {
        label1.Text = "";
    }
}

here you hard code 5 & 195. in my case value can be different. so how do i know what i should use to test this. let me know. thanks

tbhattacharjee

You should be able to easily figure out how to make those hard-coded numbers in my example calculated in your code by looking at the width of the Panel, and the value of your own variable that holds the width of the two areas you wish to be "mouse-sensitive."

I'm here to help you learn how to learn, any time Smile | :)

cheers, Bill

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

i have one panel and i put a flow layout panel in the main panel and flow layout panel has many images. my UI looks like this http://i.stack.imgur.com/14eJG.png[^]

now i got a code which scroll the container in the panel. i mean the flow layout will scroll in main panel when i will place my mouse at the left or right most area on the main panel. their code is working i checked but when i place their code in my project then that is not working, i means scrolling is not working when i place my mouse at the left or right most area on the main panel.

here i am attaching main code which causes to scroll the flow layout panel inside in main panel

protected override CreateParams CreateParams
{
get
{
CreateParams cp = base.CreateParams;
cp.ExStyle |= 0x02000000; // Turn on WS_EX_COMPOSITED
return cp;
}
}
int _myval = 5;
protected override void OnMouseMove(MouseEventArgs e)
{
base.OnMouseMove(e);

if (e.Y < metroPanel1.Top || e.Y > metroPanel1.Top + metroPanel1.Height) return;

if (e.X <= metroPanel1.Left && e.X >= metroPanel1.Left - 40)
{
if (metroPanel1.HorizontalScroll.Value <= _myval)
{
metroPanel1.HorizontalScroll.Value = _myval;
}
else
{
metroPanel1.HorizontalScroll.Value -= _myval;
}
}

if (e.X <= (metroPanel1.Left + metroPanel1.Width + 40) && e.X >= (metroPanel1.Left + metroPanel1.Width))
{
metroPanel1.HorizontalScroll.Value += _myval;
}
}

i just do not understand this value 40 used here if (e.X <= metroPanel1.Left && e.X >= metroPanel1.Left - 40)

i guess i need to use different value rather than 40 but i used 10 & 20 but did not work. here is my full project link from where anyone can download and see what is wrong in my routine which prevent the scrolling. here is the link https://onedrive.live.com/embed?cid=C4A6F16F34D7540A&resid=C4A6F16F34D7540A%21134&authkey=AM5Fq2gcFLtcw_A

so it is my request that please some one see my code and guide me what i need to change in code and why. thanks

tbhattacharjee

Come on! You've been here long enough to know that code snippets should always be pasted inside PRE tags. Not doing so make you're code very difficult to read.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

The problem with Windows ContainerControls and trying to create your own alternative for "seamless" AutoScrolling is that setting 'AutoScroll to 'true means Scrollbars will be shown.

But, the bigger problem is that Win Forms is not designed for smooth animation ... at least not from programming regular C# with no API calls ... If you have a FlowLayoutPanel with lots of fancy Controls in it, moving it yourself within its ContainerControl will probably lead to a "herky-jerky" kind of effect. And, what the user sees is probably going to be influenced by the power of their CPU, GPU, etc.

To do animation of Controls, Windows, etc., why not consider WPF rather than WinForms: it's designed to support such advanced graphic features.

Please, as Dave suggested, format your code example.

Try and state your goal here very clearly: is it to make a FlowLayoutTable Control inside a Panel automatically move right or left ... an animation ... when the mouse is within certain areas ?

The solution I would use would not involve using 'AutoScroll at all: I'd use a 'Timer, and two Panels outside the Panel that contains the FlowLayoutTable.

Be happy to help you discover how to achieve this, but I want to see more work on your part, first, and I strongly suggest you think about whether a lot of work here might lead to a disappointing visual result.

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

modified 18-Sep-14 13:40pm.

thanks for giving time.

here i am providing a link from where you can download win apps not wpf where people did the nice scroll with panel and flow layout panel. the link as follow https://onedrive.live.com/embed?cid=C4A6F16F34D7540A&resid=C4A6F16F34D7540A%21133&authkey=AC-BXcngO7n2g9Q[^]

the UI link as follows http://i.imgur.com/ZYzVMuV.gif[^]

the above UI is designed in winform.

i just copied and follow their code to implement same in winform but mine is not working. i guess i am missing or making a small mistake for which my scrolling is not working.

so please first see image preview link and if u have trust then download the apps from one drive and run at your end.
you will see writing a very minimum line of code how a nice automatic scrolling can be done. looking for your help. if possible please investigate my code and tell me what mine is not scrolling. thanks

tbhattacharjee

I've looked at your sample, run the code, and I do not call what it produces "smooth animation" at all.

You are using Sven Walter's Metro FrameWork for WinForms; it's always good to reveal things like that in your first post.

You can easily produce the quality of animation shown in Sven's code if you take the ideas I've given you, and start to work.

I'll be happy to help you learn to how to build your own animation function for WinForms, but you have to take the first steps. Helping you fix some problem with code copied from Sven is not going to teach you anything.

Please, come back with your own code, and specific questions.

cheers, Bill

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

He wrote this code to scroll his panel

C#

protected override CreateParams CreateParams
{
get
{
CreateParams cp = base.CreateParams;
cp.ExStyle |= 0x02000000; // Turn on WS_EX_COMPOSITED
return cp;
}
}
int _myval = 5;
protected override void OnMouseMove(MouseEventArgs e)
{
base.OnMouseMove(e);
 
if (e.Y < metroPanel1.Top || e.Y > metroPanel1.Top + metroPanel1.Height) return;
 
if (e.X <= metroPanel1.Left && e.X >= metroPanel1.Left - 40)
{
if (metroPanel1.HorizontalScroll.Value <= _myval)
{
metroPanel1.HorizontalScroll.Value = _myval;
}
else
{
metroPanel1.HorizontalScroll.Value -= _myval;
}
}
 
if (e.X <= (metroPanel1.Left + metroPanel1.Width + 40) && e.X >= (metroPanel1.Left + metroPanel1.Width))
{
metroPanel1.HorizontalScroll.Value += _myval;
}
}

and i follow the same but mine is not working. i am not trying to do any animation rather i want when i will place my mouse/left at the right most area of the panel then panel controls should start scroll. trying to simulate win8 start screen where lots of tiles are there and when people place his mouse at right/left most area then everything start scrolling.

please help. if u can help with code then answer.

thanks

tbhattacharjee

If you use your version of Sven's code, you need to use Visual Studio's debugging capabilities ... set break-points, single-step, etc. ... and isolate the problem in your code. Since you have Sven's code, which is working, you have something to compare directly with.

I am interested in helping people who develop their own solutions because that, I think, results in the maximum contribution of value to both the individual learning C# and writing code, and to CodeProject as a whole. Debugging/fixing a copy of another person's obscure undocumented code is not an activity that contributes to CodeProject, or you.

I repeat my assertion that you can achieve better looking, smoother scrolling, animation, than what Sven's code does.

You'll learn a lot writing your own version !

cheers, Bill

« I had therefore to remove knowledge, in order to make room for belief » Immanuel Kant

how do i delete my visual stuio project

Try this[^].

Bastard Programmer from Hell Suspicious | :suss:

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

https://www.google.com/search?q=delete+vs+online+project[^]

Gives you this[^]

The console is a black place