problem with sql insert using c# - C# Discussion Boards

Cross post. Please ignore

Pete O'Hanlon6-Dec-07 1:05

Pete O'Hanlon

6-Dec-07 1:05

See title

Deja View - the feeling that you've seen this post before.

My blog | My articles

Instantiate Shell32.ShellLinkObjectClass object

dan!sh 6-Dec-07 0:34

dan!sh

6-Dec-07 0:34

Hi can anyone help me to instantiate Shell32.ShellLinkObjectClass object.

I am doing it this way :
Shell32.ShellLinkObjectClass o = new ShellLinkObjectClass();

And it gives following exception.
Retrieving the COM class factory for component with CLSID {11219420-1768-11D1-95BE-00609797EA4F} failed due to the following error: 80040154.

Until you realize this message has nothing to say, its too late to stop reading

comparing two arrays

rameshdontagani6-Dec-07 0:27

rameshdontagani

6-Dec-07 0:27

hi,

i have two array lists..

first arraylist consists of 1,2,4,6,8;

second arraylist consists of 2,6,9,8

now i want to display the matched values from two arraylists and i need the values of second arraylist which are not in first arraylist..

how can i do this in c#

Re: comparing two arrays

J4amieC6-Dec-07 0:39

J4amieC

6-Dec-07 0:39

If this is homework:

Give it a try yourself, come back with specific coding problems and someone will help you. We will not however do your work for you.

If this is paid work:

You should not be employed as a programmer.

Re: comparing two arrays

Skippums6-Dec-07 0:52

Skippums

6-Dec-07 0:52

Easily... Take Jamie's advice. Post some code that illustrates you can put forth some effort in finding the solution yourself. Until you post code that appears to be close to working (or that we feel was typed in a good-faith effort to solve the problem), and with specific problems/questions, we will not help.
-Jeff

Re: comparing two arrays

Guffa6-Dec-07 2:06

Guffa

6-Dec-07 2:06

First sort the lists, then you can loop through them side by side and compare the items to find out where they match and where there are items that exist in only one of the lists.

Experience is the sum of all the mistakes you have done.

Re: comparing two arrays

NassosReyzidis6-Dec-07 2:31

NassosReyzidis

6-Dec-07 2:31

Guffa wrote:
First sort the lists, then you can loop through them side by side

He can loop through the first ArrayList and use the .Contains(object item) method for the second array list and not interate through both ArrayLists.

just a thought

Nassos.NET

problem with sql insert using c#

eyeseetee6-Dec-07 0:08

eyeseetee

6-Dec-07 0:08

Hi
I have the following bit of code:

What the code is doing is inserting values into a table by selecting them from another table where a room code matches a room code in a session

however the insert is not working

any ideas?

cheers

SqlCommand cmd2 = new SqlCommand("INSERT INTO room_type_temp (Room_code, Room_description, area, instance_variant, Room_notes, height, spanotes, pladescription, perdescription, floor, walls, ceiling, doorsets, glazing, windows, chanotes, hatch, air, lighting, noise, safety, awt, ast, amvs, amve, amvsu, ap, af, ah, lsi, lsn, lli, lcr, lslg, nasl, nsp, nt, sahs, AF2, sdhw, atn, amn, apn, lsin, lsnn, llin, lslgg, lcrn, nn, sn, fn, npf, nms, nin, fe, fad, Room_Sheet SELECT Room_code, Room_description, area, instance_variant, Room_notes, height, spanotes, pladescription, perdescription, floor, walls, ceiling, doorsets, glazing, windows, chanotes, hatch, air, lighting, noise, safety, awt, ast, amvs, amve, amvsu, ap, af, ah, lsi, lsn, lli, lcr, lslg, nasl, nsp, nt, sahs, AF2, sdhw, atn, amn, apn, lsin, lsnn, llin, lslgg, lcrn, nn, sn, fn, npf, nms, nin, fe, fad, Room_Sheet FROM room_types where room_code = " + (Session["room_code"]), con);

Re: problem with sql insert using c#

CKnig6-Dec-07 0:12

CKnig

6-Dec-07 0:12

sorry but this is almost unreadable - please reformat.
And: what is the exception - output?

Re: problem with sql insert using c#

eyeseetee6-Dec-07 0:22

eyeseetee

6-Dec-07 0:22

Hi
ok let me make it simpler

I basically want to insert values into a table by selecting them from another table in the same query, however the post before does not work.
any suggestions?
cheers

Re: problem with sql insert using c#

meeram3956-Dec-07 1:11

meeram395

6-Dec-07 1:11

Hi,

Please find below an sql query which I have used for one of my projects. Replace the columns and fields with yours and check whether it will suits with your requirement:

insert into stalericstemp1(RIC_Name, No_of_Days, Last_Update_Date, Next_Update_Date, PE_Fid1, HeadEnd_Fid1383, Location_Fid836, CTBTR_BKDG, Ric_Added_Date, Record_Entry_Date, StaleRic, Message, Updated_Date, File_no) select * from StaleRicsTemp where next_update_date > '11/25/2007' and next_update_date < '12/03/2007'

order by ric_name

The * in the select query of second table contains exactly the same field and datatype of first table. Please let me know if it helps you.

Smile | :)

Meeram395

Re: problem with sql insert using c#

Le centriste6-Dec-07 2:10

Le centriste

6-Dec-07 2:10

It looks like you are missing a parenthesis just before the SELECT.

-----

You seem eager to impose your preference of preventing others from imposing their preferences on others. -- Red Stateler, Master of Circular Reasoning and other fallacies

If atheism is a religion, then not collecting stamps is a hobby. -- Unknown

God is the only being who, to rule, does not need to exist. -- Charles Baudelaire

How to make Multilingual TextBox in C#.NET

D i x y5-Dec-07 23:54

D i x y

5-Dec-07 23:54

Hi How to make Multilanguage supportive textbox in C#.net

Re: How to make Multilingual TextBox in C#.NET

Skippums6-Dec-07 10:20

Skippums

6-Dec-07 10:20

I have used a RichTextBox in the past, and simply required that the end user has the microsoft language pack installed. That way, the OS deals with the language exclusively (changing keyboard input and the like), which makes this kind of operation transparent to your application.

-Jeff

Show a PDF file in a MDI application of C#

BinName5-Dec-07 22:58

BinName

5-Dec-07 22:58

Hello everybody, I encounter a problem and need your help.

In a MDI application of C#, I want to show a PDF file in a child form. I have added a PDF browser to the child form and change it to pulic, just like below:
public AxAcroPDFLib.AxAcroPDF pdfBrowser;

When the MDI load, my code likes below:

Code:

private void MDIFrm_Load(object sender, EventArgs e)<br />
        {<br />
            ChildFrm myChildFrm = new ChildFrm();<br />
            myChildFrm.pdfBrowser.LoadFile("C:\\dev\\linux-i18n-intro.pdf");<br />
            myChildFrm.MdiParent = this;<br />
            myChildFrm.Show();<br />
        }

However,I can not see the PDF content in the Child form,but if I set the ChildFrm as the strartup object,it will show PDF correctly.

Could anyone give some suggestions?
Thanks very much!
Birch

Re: Show a PDF file in a MDI application of C#

CKnig5-Dec-07 23:22

CKnig

5-Dec-07 23:22

I can only guess:

maybe the pdfBrowser loads an empty file on Form_Load?
Anyway: you should not put the pdfBrowser on a public property - better give the path to the constructor and set it in the form.

Anyway he problem seems to be with the pdfBrowser - maybe try using the webbrowser-control to show your files?

DataGridview help

sindhutiwari5-Dec-07 22:56

sindhutiwari

5-Dec-07 22:56

hi,
My aim is to print the datagridview text in to a textbox on clicking it .. i have done this before unfortunately i am not able to recollect it so if any one knows this please do inform me
REGARDS
SINDHU TIWARI

its me sid

Re: DataGridview help

dan!sh 5-Dec-07 22:59

dan!sh

5-Dec-07 22:59

just write the concerned code in cell click event

Until you realize this message has nothing to say, its too late to stop reading

Re: DataGridview help

suyuan19845-Dec-07 23:07

suyuan1984

5-Dec-07 23:07

I have encountered similarly problem ,please give me some code for this question

my english is very bad!

Re: DataGridview help

Gopal.S5-Dec-07 23:31

Gopal.S

5-Dec-07 23:31

Here is the code snippet:

private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
textBox1.Text = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString();
}

Gopal.S

How to change the initial value of DataSet.CaseSensitive (in .NET 2.0, it is false by default)

shintaerp5-Dec-07 22:12

shintaerp

5-Dec-07 22:12

I have written many methods that using DataSet.
Now, I realise that I need the property 'CaseSensitive' of every DataSet instance to be 'true'. I don't want to change every source file to make it. Is there any simple way to make each DataSet instance created with 'CaseSensive = true'? e.g. envirment setting

I am using Visual Studio 2005 (.NET 2.0).

Thank you.

C# and microthreads - more info wanted

Geert Masureel5-Dec-07 22:10

Geert Masureel

5-Dec-07 22:10

Hi all,

I recently found out about microthreads and I'm looking for more info on this topic (for implementation in C#) !

Any one knowing links to existing classes or articles ? Please let me know !

Thanks in advance !

Greetz,

Geert

TCP Class - Send Function

Programm3r5-Dec-07 21:25

Programm3r

5-Dec-07 21:25

Hi all,

I'm sending some data over TCP/IP and when I make use of a special character like ~ (tilde) it displays on my TCP/IP server as +AH4-

This is the code:

client.Client.Send(System.Text.Encoding.UTF7.GetBytes(richTextBoxSendData.Text));

Many Thanks in advance
Regards,

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: TCP Class - Send Function

CKnig5-Dec-07 23:27

CKnig

5-Dec-07 23:27

well seems your TCP/IP server don't understand UTF7 - try ASCII!
(System.Text.Encoding.ASCII.GetBytes(...)

Re: TCP Class - Send Function

Programm3r6-Dec-07 0:32

Programm3r

6-Dec-07 0:32

Thanks for the response, I'll give it a shot

Regards

The only programmers that are better that C programmers are those who code in 1's and 0's Green Alien | [Alien]

Programm3r
My Blog: ^_^

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