|
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
|
|
|
|
|
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!
|
|
|
|
|
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!
|
|
|
|
|
maybe
yes, at least not logical ones
yes
yes
yes
yes
|
|
|
|
|
|
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);
PostMessage(hWndChild, wm_keydown, VkKeyScan('s'), 0);
PostMessage(hWndChild, wm_keyup, VkKeyScan('s'), 0);
PostMessage(hWndChild, wm_keyup, VK_CONTROL, 0);
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!
|
|
|
|
|
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?
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
I forget to mention that im using for Windows application.
Does windows application support session?
Can you tell me a lil detail
Thanks
|
|
|
|
|
Can you tell me how to use google?
Panic, Chaos, Destruction.
My work here is done.
|
|
|
|
|
im sorry but i didnt expect anything ques like that.
I understand what u mean...
Np thanks
Yes i can tell you...google it
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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...
|
|
|
|
|
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)
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
|
|
|
|
|
Hello,
I would read all lines of my excel file, can you help me? thank you verry mutch.
|
|
|
|
|
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
I are troll
|
|
|
|
|
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.
|
|
|
|
|
Is there a chart in that range of cells?
I are troll
|
|
|
|
|
Yes, I have 1506 rows and 10 collumns, thank you verry mutch.
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Sounds like two monologues intertwined...
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
|
|
|
|
|
I don't find any thing.please help me thank you verry mutch.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
)
