|
Ahh. Thanks Heath!
RageInTheMachine9532
|
|
|
|
|
Hi there!
I wrote an application which calls several methods of a WebService. But how can i set the URL where the WebService is located AFTER compiling my application?
Thanks for reading 
|
|
|
|
|
Hi flaffy,
To Call methods which are exists in the Web Service into your application.....go to your application and check the references and right click on it and select the Add Web refernces it will popup a form for the web service URL there u have to provide your web service url to get all the methods ...then click on Add button it will automatically add to ur web references.
Thanks
Ramakrishna.J
SoftProSys.ltd.
|
|
|
|
|
You can change the path to a web service using Url property inheritted from WebClientProtocol (in the web service proxy class that your client uses). To externalize this settings, you can add it to your .config's <appSettings> section and read it in with ConfigurationSettings.AppSettings["yourKeyName"]. You can also configure your proxy in VS.NET to do the same thing using the designer, but I don't remember off the top of my head how. Just explore.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thanks  Exactly what i had looked for 
|
|
|
|
|
I tried to insert data into SQL server database using the following code. All data that I received from all my connections (10 socket). It runs for sometime and I was able to insert some data then suddenly in the middle of the process I encountered
System.InvalidOperationException: There is already an open DataReader associated with this Connection which must be closed first.
at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean executing)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at ossrop.Class1.SaveToSQLDB(String strFile, String strOpt) in d:\ossrop\class1.cs:line 560
I declare my DBConnect as modular and with CONNECTION POOLING.
//DBConnect = new SqlConnection("Pooling=true;server=OSSSQL01;database=nfmse;uid=alarmadmin;pwd=alarmadm1n;Min Pool Size=3;Max Pool Size=100;");
DBConnect.Open();
Processdata()
{
iRx = theSockId.thisSocket.EndReceive (asyn);
char[] chars = new char[iRx]; // + 1];
System.Text.Decoder d = System.Text.Encoding.UTF8.GetDecoder();
int charLen = d.GetChars(theSockId.dataBuffer, 0, iRx, chars, 0);
StringBuilder szData = new StringBuilder();
szData.Append(chars);
SaveTOSQL();
}
void SaveTOSQL()
{
string strInsert = "insert into rop values ('" + strjv.Trim() + "','" + strdate.Trim() + "','" + strclass.Trim() + "','" + strFile + "','" + strFile + "')" ;
DBCommand = new SqlCommand(strInsert,DBConnect);
DBCommand.ExecuteNonQuery();
}
PS : I don't close the connection nor the command becuase this is a 24 hour process.
Thanks in advance.
/dabsukol
|
|
|
|
|
One of two possibilities that I can think of.
(1) You read data with a DataReader and didn't close it when you were done reading.
(2) You are still reading data with the DataReader when you call the code to insert data on the same connection as the DataReader.
The solution for (1) is to remember to Close() DataReaders when you're done with them.
The solution for (2) is to open a new connection because you cannot run two or more commands on the same connection at the same time. (The Data Reader is still running the command because it doesn't get the data from the database until it neads it) - Since you're using Connection pooling this isn't much of an overhead.
Actually since you're using Connection pooling why not close the connection after each operation the any subsequent operations will just pull the connection back out of the pool.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
|
Hi,
Your're correct I 'm seleceting records from the first table using ofcourse the Connection. then, while selecting ip/ports from my first table i'm also at the same time inserting data into the 2nd table with the same connection. That's why I got this error message.
Solution: all data selected from the 1st table is temporarily inserted into an array variable and from it I try to run connect and insert retrieved data into SQL using a different connection. At the same time I use a Connection Polling.
SqlConnection sqlconn = new SqlConneciotn(connstring)
open connection
Select from table1
insert into array variable
close connection
SqlConnection sqlconn = new SqlConneciotn(connstring)
open connection
insert into SQL
close connection
It work so far. Thank you very much and God Bless you.
/dabuskol
Ps : My program is running for 1 1/2 hour now with no problem registering to the log file and console.
|
|
|
|
|
dabuskol wrote:
My program is running for 1 1/2 hour now with no problem registering to the log file and console
Excellent! I'm glad it's working out.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
|
How would I go about creating a borderless CheckBox. I don't want it to display a border as I will be overlaying it onto an image that already has the border for the CheckBox.
|
|
|
|
|
Give checkbox border style to Groove
Thanks
Ramakrishna.J
SoftProSys.ltd.
|
|
|
|
|
I do not know if the string enter is number.
|
|
|
|
|
Here is one possible test implementation, but of course exceptions should not really be used like this (it is bad because an exception takes so much time to handle).
try
{
Convert.ToInt32(myString);
}
catch
{
}
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
|
|
You can do it in CurrentCellChanged event of datagrid.
Mazy
"Man is different from animals in that he speculates, a high risk activity." - Edward Hoagland
|
|
|
|
|
I want to how I can hook the keyboard and mouse messagea using c#?
saleh
|
|
|
|
|
|
|
If you only want to hook these messages in your application, implement IMessageFilter and add an instance of your implementation to the list of message filters using Application.AddMessageFilter. See the documentation for the aforementioned method for more information and an example.
If you only want to do this for an application, DO NOT use a system-wide hook as you'll degrade the performance of the entire system at the cost of your application, and could possibly corrupt the entire system if you don't implement it correctly or efficiently. Also, the second response will only work per-Form and only if you have KeyPreview set to true so that the parent (the Form) receives and processes messages sent to the child. You would have to do this on every form, then, which is pretty inefficient and can lead to code duplication.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi,
I want to know how can I make the listview scroll to index that I want to view?? e.g If I have 100 items in my listView, I want to view it start from items 40 ~ , or I wnat to the range start from 80..??
Is there any way can do that? I've tried to use .items[index].selected = true. but seems doesn't work. Can someone tell me..
Thanks a lot
|
|
|
|
|
Selected only makes it the selected item. To make sure it's visible, use listView1.Items[index].EnsureVisible(). This won't make it selected, but you've already figured out how to do that.
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Thank you very much ~!!
It works, but is it possible to make the selected range always display in the middle of list view??
I just set the start and end index to visible, am I correct ?
listView1.Items[start].EnsureVisible();<br />
listView1.Items[end].EnsureVisible();
but sometimes, the range showed at very bottom.
e.g. if I currently seeing item 5~20, then I wnat to jump to see item 70~80, so the items display 70~80 at the bottom.
Is there a way to improve ?
thank you
|
|
|
|
|
EnsureVisible only makes sure the item is visible. "It" doesn't care where in the list view it's visible.
If you always want a certain number to be at the top or anything of that nature, you can always calculate the position of what item you want at the top and send the SBM_SETPOS to the control (which gets passed to the scroll bars) or use the SetScrollPos function (recommended).
So, if you wanted item 70 to be at the top, you would do something like this:
[DllImport("user32.dll")]
[return:MarshalAs(UnmanagedType.SysInt)]
private static extern int SetScrollPos(IntPtr hWnd,
[MarshalAs(UnmanagedType.SysInt)] int nBar,
[MarshalAs(UnmanagedType.SysInt)] int nPos,
bool bRedraw);
private const int SB_HORZ = 0;
private const int SB_VERT = 1;
SetScrollPos(listView1.Handle, SB_VERT, 70, false);
Microsoft MVP, Visual C#
My Articles
|
|
|
|
|
Hi Guys,
I tried to insert data into SQL server database using the following code. All data that I received from all my connections (10 socket). It runs for sometime It was able to insert some data then suddenly in the middle of the process I encountered
"The connection is already Open (state=Open)". when it goes to SaveTOSQL.
I declare my DBConnect as modular and with CONNECTION POOLING.
//DBConnect = new SqlConnection("Pooling=true;server=OSSSQL01;database=nfmse;uid=alarmadmin;pwd=alarmadm1n;Min Pool Size=3;Max Pool Size=100;");
Processdata()
{
iRx = theSockId.thisSocket.EndReceive (asyn);
char[] chars = new char[iRx]; // + 1];
System.Text.Decoder d = System.Text.Encoding.UTF8.GetDecoder();
int charLen = d.GetChars(theSockId.dataBuffer, 0, iRx, chars, 0);
StringBuilder szData = new StringBuilder();
szData.Append(chars);
DBConnect.Open();
SaveTOSQL();
}
void SaveTOSQL()
{
string strInsert = "insert into rop values ('" + strjv.Trim() + "','" + strdate.Trim() + "','" + strclass.Trim() + "','" + strFile + "','" + strFile + "')" ;
DBCommand = new SqlCommand(strInsert,DBConnect);
DBCommand.ExecuteNonQuery();
}
PS : I don't close the connection nor the command becuase this is a 24 hour process.
Thanks in advance.
/dabsukol
|
|
|
|
|
Are you sure the error is not actually occurring on DBConnect.Open();?
I say this because the debugger will often highlight the line after the one where the error is if the error occurred in a method for which there is no source code.
I cannot see anything in SaveTOSQL() that would generate the message you are getting, and if the error did occur there then you would be saying which line in SaveTOSQL() generated the error.
I suggest that you enclose the DBConnect.Open(); in an if statement checking the State property of the connection before trying to open it.
"You can have everything in life you want if you will just help enough other people get what they want." --Zig Ziglar
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
