Re: how to Merge two datatables in a dataset - C# Discussion Boards

is not working

Luc Pattyn16-Mar-09 4:19

Luc Pattyn

16-Mar-09 4:19

eyalbi007 wrote:
int j = this.Handle.ToInt32();

wrong

Luc Pattyn [Forum Guidelines] [My Articles]

- before you ask a question here, search CodeProject, then Google
- the quality and detail of your question reflects on the effectiveness of the help you are likely to get
- use the code block button (PRE tags) to preserve formatting when showing multi-line code snippets

Assign Color to text in Rich Textbox

Sajjad Leo16-Mar-09 1:58

Sajjad Leo

16-Mar-09 1:58

Hello,

I am working on window application and i want to assign multicolor to text through programming,
I am filling data in Rich Text box and i want to assign different color to text like. word "Hello" in red word "Welcome" in blue etc.
I am working on C# kindly tell me what should i do and how this problem can be solve easily.

Thanks

Re: Assign Color to text in Rich Textbox

Blue_Boy16-Mar-09 2:08

Blue_Boy

16-Mar-09 2:08

Create one string array and in that array set all words,and give color to each item of array and finally convert all array items in single line string.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.

Re: Assign Color to text in Rich Textbox

AB777116-Mar-09 2:10

AB7771

16-Mar-09 2:10

U need to use the selectedText and selectionColor properties of the Richtextbox.

Thanks & Regards,
Pramod
"Everyone is a genius at least once a year"

how to Merge two datatables in a dataset

Nitin K16-Mar-09 1:40

Nitin K

16-Mar-09 1:40

Hi
I have some problem while getting common data from two tables.
I have one dataset which contains tow datatables, one datatable contains 100 rows and second datatable contains 10 rows, both having one common field (example: currentdate), now i want matching rows from both table in one single table. how can i do it. please give me some example also.
Thank you

Re: how to Merge two datatables in a dataset

Russell Jones16-Mar-09 1:42

Russell Jones

16-Mar-09 1:42

create a relation between the two tables?

Re: how to Merge two datatables in a dataset

Nitin K16-Mar-09 1:51

Nitin K

16-Mar-09 1:51

hi...
i have used datarelation but i am not sure how to get that common data into one single table...can you give me some code for that.

Thank You.

Re: how to Merge two datatables in a dataset

Russell Jones16-Mar-09 1:56

Russell Jones

16-Mar-09 1:56

I guess the straight forward way would be to loop through one table and for each row copy its data and all the related rows into the new table.

Any idea why this error appears (SEH Exception)

Matjaz-xyz16-Mar-09 1:31

Matjaz-xyz

16-Mar-09 1:31

I get http://www.postimage.org/image.php?v=Pq1N1qmr[^] <- this error on one of the computers.

Dont know why.

this is the code:

try
            {
                label12.ForeColor = Color.Black;
                string dbConnComm = "INSERT INTO Vnosi ([Dostava],[Skatla],[Barkoda],[Oznaka],[Skener],[Operater],[Datum],[PosnetkiV3],[PosnetkiM3],[Opombe]) VALUES ("
                + cmbDostava.Text + ", "
                + cmbSkatla.Text + ", '"
                + cmbBarkoda.Text + "', '"
                + cmbEnota.Text + "', '"
                + cmbSkener.Text + "', '"
                + cmbOperater.Text + "', '"
                + cmbDatum.Text + "', "
                + txtVA3.Text + ", "
                + txtMA3.Text + ", '"
                + txtOpombe.Text + "')";


                SqlConnection dbConn = new SqlConnection(sqlConnection);
                dbConn.Open();

                SqlCommand dbComm = new SqlCommand(dbConnComm, dbConn);
                dbComm.ExecuteNonQuery();
                dbConn.Close();
                label12.Text = "Uspešno vnešeno";
            }
            catch(Exception ex)
            {
                label12.ForeColor = Color.Red;
                label12.Text = "Napaka pri vnosu";

                MessageBox.Show("Napaka: " + ex.ToString());
            }

PC has framework 2.0 and 1.1

Re: Any idea why this error appears (SEH Exception)

Michael Bookatz16-Mar-09 1:38

Michael Bookatz

16-Mar-09 1:38

A few quick question to help try find the answer.

Have you tried the insert into the database directly and dose it work?
What is the connection string you are using as it appears to be a connection issue?
Can you connect to the database from that machine?

Why are you using an insert? you should look at using a stored procedure as direct sql asks for an injection attack.

Re: Any idea why this error appears (SEH Exception)

Giorgi Dalakishvili16-Mar-09 2:29

Giorgi Dalakishvili

16-Mar-09 2:29

Don't use concatenation for building sql queries, it's dangerous. Read more here: Parametrized Queries VS String Concatenation[^]

Giorgi Dalakishvili

#region signature
My Articles

Asynchronous Registry Notification Using Strongly-typed WMI Classes in .NET [^]

My blog
#endregion

Re: Any idea why this error appears (SEH Exception)

Matjaz-xyz17-Mar-09 3:35

Matjaz-xyz

17-Mar-09 3:35

Yes Giorgi, thank you for your information on security about SQL injections.

I just needed an anwser which was more than funny. The SQL Connection string was wrong.
And its my bad that i forgot to mention that this error occurs only on computers which have low-access accounts in our domain. Now i've fixed this and it works.

HopingToCode was right. I should check the connection string. Which i did today.

Thank you both for your time.

Regards,
Matjaž

Application.Idle Event

saksp16-Mar-09 0:02

saksp

16-Mar-09 0:02

I am not able to attach Application.Idle event with the event handler. what will be the reasons??

thanks

Re: Application.Idle Event

DaveyM6916-Mar-09 0:20

DaveyM69

16-Mar-09 0:20

saksp wrote:
what will be the reasons

Maybe you're doing it wrong?

This works for me.

using System;
using System.Windows.Forms;

public partial class Form1 : Form
{
    public Form1()
    {
        InitializeComponent();
        Application.Idle += new EventHandler(Application_Idle);
    }

    // this method called when Idle event is raised
    void Application_Idle(object sender, EventArgs e)
    {
        // Do your thing
    }
}

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Re: Application.Idle Event

#realJSOP16-Mar-09 2:34

#realJSOP

16-Mar-09 2:34

saksp wrote:
I am not able to attach Application.Idle event with the event handler. what will be the reasons??

You're doing it wrong.

"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001

Transparent through the label

CodingLover15-Mar-09 23:00

CodingLover

15-Mar-09 23:00

Hi all,

On VS2005, I've add a background image on a form, fine. But when I added a label cannot see the image through it. How can I see the image through the label?

Thanks a lot.

I appreciate your help all the time...
CodingLover Smile | :)

Re: Transparent through the label

Christian Graus15-Mar-09 23:22

Christian Graus

15-Mar-09 23:22

Make the background color of the label transparent ? The other way is to draw the text on the form yourself.

Christian Graus

Driven to the arms of OSX by Vista.

Re: Transparent through the label

Wael Dalloul15-Mar-09 23:23

Wael Dalloul

15-Mar-09 23:23

CodingLover wrote:
How can I see the image through the label?

set the Backcolor for the label to: Transparent

label.Backcolor = Transparent

Re: Transparent through the label

Michael Bookatz15-Mar-09 23:41

Michael Bookatz

15-Mar-09 23:41

You set the label to transparent, However be aware that there is no true transparency in .net which means that transparent shows the background image and not the image underneathe.

handle shorcut Ctrl+V event on AxWebBrowser

sonukadole15-Mar-09 22:53

sonukadole

15-Mar-09 22:53

I am using AxWebBrowser control on windows form. I want to handle the shortcut paste(ctrl + V) event so that i can excute my own customised function to perform this operation.

I tried this as following:

private void editorWebBrowser_PreviewKeyDown(object sender, PreviewKeyDownEventArgs e)
 {
       if (e.KeyData == (Keys)Shortcut.CtrlV)
       {  
              MyTextPasteFunction();
       }
        base.OnPreviewKeyDown(e);
  }

But it is not stopping executing it's default paste event. So Ctrl + V is pasting the contents twice.
What should i do to stop the default paste event execution?

Thanks in Advance.

Re: handle shorcut Ctrl+V event on AxWebBrowser

Pete O'Hanlon15-Mar-09 23:11

Pete O'Hanlon

15-Mar-09 23:11

You could always inject an onpaste handler in the webpage immediately after it has been loaded.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys

Re: handle shorcut Ctrl+V event on AxWebBrowser

sonukadole15-Mar-09 23:15

sonukadole

15-Mar-09 23:15

To elaborate further ,i am working on Content management system and I have embedded the AxWebBrowserControl on Windows form.

Re: handle shorcut Ctrl+V event on AxWebBrowser

Pete O'Hanlon15-Mar-09 23:26

Pete O'Hanlon

15-Mar-09 23:26

When the web page has finished loading, you could inject some javascript into the page that handled the onpaste function.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys

Re: handle shorcut Ctrl+V event on AxWebBrowser

sonukadole16-Mar-09 0:09

sonukadole

16-Mar-09 0:09

I am working on content management system and the axwerbbrowser is nothing but HTML editor control

Re: handle shorcut Ctrl+V event on AxWebBrowser

Pete O'Hanlon16-Mar-09 2:47

Pete O'Hanlon

16-Mar-09 2:47

So, create a minimal webpage with the onpaste function already in it.

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys

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