C# Discussion Boards - CodeProject

baranils13-Mar-09 8:34

baranils

13-Mar-09 8:34

Thank you Mike

Indeed !
And you can also learn a lot by sharing experience !
You give me a way by pointing out some documentation usefull to read

Maybe I will also found some good tricks here or elsewhere
And this is a way to study too !

Thanks too share your knowlege !

Olivier

led mike13-Mar-09 9:10

led mike

13-Mar-09 9:10

baranils wrote:
You give me a way by pointing out some documentation usefull to read

Actually no. I didn't because I used Google[^] to find it. So technically Google gives you a way by pointing out some documentation useful to read. Of course that requires you to use Google rather than posting questions in internet forums so that other people can use Google for you to find your help.

Get it? Got it? Good!

baranils13-Mar-09 11:13

baranils

13-Mar-09 11:13

Do you really read and understand the question in the first post
So you really think that I didn't make severall search before to post ?
Do yo really think that you first answer gives some help and the right answer ?

Do you understand the meaning of my polite answer to your first post ?

You can get some satifaction to scold other and you are at the right place for that !

Get it? Got it? Thanks!

led mike13-Mar-09 12:00

led mike

13-Mar-09 12:00

maybe
yes, at least not logical ones
yes
yes
yes
yes

Sending Ctrl+letter to application using PostMesssage or SendMessage

baranils13-Mar-09 14:13

baranils

13-Mar-09 14:13

This is the good search and the right answer Wink | ;-)

)

http://msdn.microsoft.com/en-us/library/system.drawing.font(VS.85).aspx[^]

Fredrik Hagg13-Mar-09 5:10

Fredrik Hagg

13-Mar-09 5:10

Hi!

I've been trying to send Ctrl+s to notepad, but havent succesfully manage to do this. I've googled it, but havent found anyone who have sent a ctrl+letter command to a process.

Currently, the sending part of my code look like this:

IntPtr hWnd = FindWindow("Notepad", null); 
IntPtr hWndChild = FindWindowEx(hWnd, IntPtr.Zero, "Edit", null); 
int VK_CONTROL = (int)0x11;
uint wm_keydown = (uint)0x100; 
uint wm_char = (uint)0x102; 
uint wm_keyup = (uint)0x101; 
 
PostMessage(hWndChild, wm_keydown, VK_CONTROL, 0);       //Send Ctrl down 
PostMessage(hWndChild, wm_keydown, VkKeyScan('s'), 0);   //Send 's' down 
PostMessage(hWndChild, wm_keyup, VkKeyScan('s'), 0);     //Send 's' up 
PostMessage(hWndChild, wm_keyup, VK_CONTROL, 0);         //Send Ctrl up

I've also tried different values for the lParam parameter (taken from Spy++) and to use hWnd instead of hWndChild, but it does not work. Does anyone know any way to send Ctrl+s to notepad using PostMessage (or SendMessage)? I would really appreciate if anyone could post some sample code. Thank you!

Re: Sending Ctrl+letter to application using PostMesssage or SendMessage

Luc Pattyn13-Mar-09 6:26

Luc Pattyn

13-Mar-09 6:26

Hi,

I'm not going to send you code; you should debug what you have yourself.

Did you manage to send regular text to Notepad at all?
if not, check values of hWnd, hWndChild, etc.

BTW: what is this VkKeyScan, if not your code, how to you reach it?

Smile | :)

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

Advice about Open Database Connection

soulidentities13-Mar-09 4:46

soulidentities

13-Mar-09 4:46

Hi ppl
Im again
In a data Entry software Most frequently usage is database Connection.
I have to insert data many tables in different forms. So I have to create diff connection for different table insert or update.
Like i have 3 forms. In 3 forms, I have to insert in 3 different table in a same database. So when I insert form1 in table1 then I have to create connection and close connection.
Again for form2 i have to do same jobs.

is there anyway to create one connection for all forms usage and close after manipulating, like "Visual Basic" ,module.
Or
any efficient way to do it?
or
Any Advice pls

Feel free to advice me

A lil detail of my problem:
i have to write all full conn every time.....
disgusting isnt it...like
//connection string
string connString = @"
server = HOME;
integrated security = true;
database = Monitoring
";
//query
string sql = string.Format(@"
SELECT Ins_ID, Ins_Nm
FROM Institution_Profile
WHERE Up_ID =
(SELECT Upazila_ID FROM Upazila
WHERE Upzila_NmB = '{0}')
", cmbUpazila.Text);

//create Connection
SqlConnection conn = new SqlConnection(connString);
try
{
//open Connection
conn.Open();
//create dataAdapter
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
//create dataSet
DataSet ds = new DataSet();
//fill dataset
da.Fill(ds, "Institution_Profile");
// get data table
DataTable dt = ds.Tables["Institution_Profile"];

foreach (DataRow row in dt.Rows)
{
cmbSchoolName.Items.Add(row["Ins_ID"].ToString() + " " + row["Ins_Nm"].ToString());
}
}
catch (Exception ex)
{
MessageBox.Show("Error:" + ex);
}
finally
{
conn.Close();
}

and again write the same code for another table insert or update...

------------
can i write once and use again n again
???

thanks

Nagy Vilmos13-Mar-09 4:59

Nagy Vilmos

13-Mar-09 4:59

Nice answer today:

- create one session and use it for all your updates.
- use transations to ensure atomic units.

Panic, Chaos, Destruction.
My work here is done.

soulidentities13-Mar-09 5:06

soulidentities

13-Mar-09 5:06

I forget to mention that im using for Windows application.
Does windows application support session?

Can you tell me a lil detail
Thanks

Nagy Vilmos13-Mar-09 5:12

Nagy Vilmos

13-Mar-09 5:12

Can you tell me how to use google?

Panic, Chaos, Destruction.
My work here is done.

soulidentities13-Mar-09 5:17

soulidentities

13-Mar-09 5:17

im sorry but i didnt expect anything ques like that.
I understand what u mean...
Np thanks

Yes i can tell you...google it

Dave Kreskowiak13-Mar-09 5:31

Dave Kreskowiak

13-Mar-09 5:31

It's bad practice to open a connection to the database and leave it sit idle. SQL Server connection licenses are quit expensive.

Normally, you'd get all of your data from the forms, open the connection, start a transaction, do all of your queries to update the database, commit the trasaction, and close the connection.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Nagy Vilmos13-Mar-09 10:30

Nagy Vilmos

13-Mar-09 10:30

Not sure I agree there. There is normally an expense to continuously opening and closing connections. In most systems there is no need for a connection per user, but often it is beter to maintain a pool of sesions and when a client needs to access the database it will take the next available session.
Unless of course we're talking about single user, single connection, single cell. Then the connect and drop might be excusable, but generally keep sessions open for the life of the system, but not always one per client.

Panic, Chaos, Destruction.
My work here is done.

Dave Kreskowiak13-Mar-09 12:23

Dave Kreskowiak

13-Mar-09 12:23

Well, there's a different perspective. ADO.NET caches connection client-side. You can open and close them all you want without suffering a huge performance hit by going back to the SQL Server to establish the connection. In you're code's eyes, the connection is closed, but ADO.NET maintains the open connection with the server, keeping it cached in a connection pool. When you code opens the connection again, it's already open by ADO.NET and it just executes the query.

Where I work, there are SQL Servers with only 1,000 seats, but supporting about 2,000 users because the application's data use is pretty sparse, even though the apps are open all day long...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Luc Pattyn13-Mar-09 6:28

Luc Pattyn

13-Mar-09 6:28

williamnw wrote:
Can you tell me how to use google?

That is easy.
Take the content of your subject line, and paste it into google's editbox
without all the "hi", "doubt", "urgent" and "plz" of course (hoping that leaves something to search for)

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

Read lines on exel file

abbd13-Mar-09 4:05

Re: Read lines on exel file

13-Mar-09 4:05

Hello,

I would read all lines of my excel file, can you help me? thank you verry mutch.

Eddy Vluggen13-Mar-09 4:19

Eddy Vluggen

13-Mar-09 4:19

Read the previous post, that's about writing Excel. Reading is done in roughly the same way.

You can Google for examples if you like Smile | :)

I are troll Smile | :)

Exception de HRESULT : 0x800401A8

abbd13-Mar-09 4:50

13-Mar-09 4:50

Hello ,

I try for :

<br />
Microsoft.Office.Interop.Excel.Application excelApplication = null;<br />
            Microsoft.Office.Interop.Excel.Workbook workbook = null;<br />
            Microsoft.Office.Interop.Excel.Worksheet worksheet = null;<br />
<br />
            excelApplication = new Microsoft.Office.Interop.Excel.Application();<br />
            excelApplication.Visible = false;<br />
<br />
            workbook = excelApplication.Workbooks.Open(@"D:\Après\mailing_RA_20090219.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);<br />
            worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[2];<br />
<br />
<br />
<br />
<br />
            excelApplication.Quit();<br />
            excelApplication = null;<br />
<br />
            string cellValue = "";<br />
            object cellObject = null;<br />
            Microsoft.Office.Interop.Excel.Range range = null;<br />
<br />
<br />
            range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[3,2];<br />
<br />
            cellObject = range.get_Value(null);<br />
            cellValue = (cellObject == null ? "" : cellObject.ToString().Trim());<br />
<br />
<br />
            Console.WriteLine(cellValue);<br />

i have the exception on : range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[3,2];, thank you verry mutch.

Eddy Vluggen13-Mar-09 5:03

Eddy Vluggen

13-Mar-09 5:03

Is there a chart in that range of cells?

I are troll Smile | :)

abbd13-Mar-09 5:07

13-Mar-09 5:07

Yes, I have 1506 rows and 10 collumns, thank you verry mutch.

Eddy Vluggen13-Mar-09 5:28

Eddy Vluggen

13-Mar-09 5:28

If there's a graphic or a chart at cell 3,2 then you won't be able to convert this to a string. That's seems to be the main problem when you Google for the error-code.

Furthermore, you're closing the Excel-application before you're reading, on these lines;

excelApplication.Quit();
excelApplication = null;

Is that as it was intended?

I are troll Smile | :)

abbd13-Mar-09 5:57

13-Mar-09 5:57

Thank you,

i try :

<br />
Microsoft.Office.Interop.Excel.Application excelApplication = null;<br />
            Microsoft.Office.Interop.Excel.Workbook workbook = null;<br />
            Microsoft.Office.Interop.Excel.Worksheet worksheet = null;<br />
<br />
            excelApplication = new Microsoft.Office.Interop.Excel.Application();<br />
            excelApplication.Visible = false;<br />
            try<br />
            {<br />
                workbook = excelApplication.Workbooks.Open(@"D:\Après\mailing_RA_20090219.xls", 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false);<br />
                worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[2];<br />
<br />
<br />
<br />
<br />
                <br />
<br />
                string cellValue = "";<br />
                object cellObject = null;<br />
                Microsoft.Office.Interop.Excel.Range range = null;<br />
<br />
<br />
                range = (Microsoft.Office.Interop.Excel.Range)worksheet.Cells[4,7];<br />
<br />
                cellObject = range.get_Value(null);<br />
                cellValue = (cellObject == null ? "" : cellObject.ToString().Trim());<br />
<br />
                Console.WriteLine(cellValue);<br />
<br />
                excelApplication.Quit();<br />
                excelApplication = null;<br />
<br />
                Console.Read();<br />
<br />
               <br />
                <br />
<br />
            }<br />
            catch (Exception ex)<br />
            {<br />
                Console.WriteLine(ex.ToString());<br />
                Console.Read();<br />
            }<br />

But i have an empty output, thank you verry mutch.

Luc Pattyn13-Mar-09 6:30

Luc Pattyn

13-Mar-09 6:30

Sounds like two monologues intertwined...

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

abbd13-Mar-09 6:54