|
I believe you can use OleDBConnection for SQL also but its not optimized. Why dont you just store the connection in the config file?? 
This posting is provided "AS IS" with no warranties, and confers no rights.
Alex Korchemniy
|
|
|
|
|
Thank you everybody.
Finally I found a way to do what I want.
I read the connectionString as a text file.
using (StreamReader sr = new StreamReader("c://WINNT//myConnection.udl"))
{
string line;
//--the connection string is define at the third line of the file
line = sr.ReadLine();
line = sr.ReadLine();
line = sr.ReadLine();
connectionString = line;
}
|
|
|
|
|
Hi,
I have a form with many controls and panels in it. I need to know the location of each control, but when I use the Control.PointToScreen , not always I get the correct answer. I tried to use Control.Parent.PointToscreen, and in some cases it did help.
The problem is that I don't know when to use the Control.Parent.PointToscreen and when to use the Control.PointToScreen .
Can someone please explain me ?
Thanks,
yonit
|
|
|
|
|
|
I need the absolute point relative to the screen.
I have container in container and so on..
my problem is that I don't know what the Control.Parent.PointToScreen refers to and what the Control.PointToScreen refers to.
|
|
|
|
|
hi
could anyone point me to a link or source about how to edit a winforms datagrid cells to a new value,
adding a new row and update those values to the sqldatabase....
i have spent allday searching google all it had was about asp.net datagrid ... nothinf about winforms DataGrid
thanks in advance
bart
|
|
|
|
|
DataGrid Girl listed many articles. ome of them may link you back to CP.
Cheers
It is Illogical to define an inventor by his invention
|
|
|
|
|
Assuming you have your external database, create a dataadapter to connect to it. Then generate your dataset. Now set your source of your datagrid to the dataset table you want the grid to represent. To show up the information, use the Fill command from your adapter (it takes the datagrid as a parameter.) Do whatever you want to your datagrid. When you are done, use the Update command from your adapter. This will update your database.
|
|
|
|
|
Hi~
Using remoting, there is server, client and remotable object type. The remotable object is in the client side and invoke methods to send data to server. However, the server don't know the object values. How does the server get the object?
Thanks
|
|
|
|
|
I recommend that you put the remotable object into a "shared" assembly. Depending on what solution you need you can have either singleton, single-call, or client activated mode. The object is hosted on the sever. Whenever you call a method it is actually executed on the server.
Search around on MSDN for more information. Here's a good link for Microsoft QuickStart: samples.gotdotnet.com/quickstart/howto/doc/Remoting/nutshell.aspx[^]
This posting is provided "AS IS" with no warranties, and confers no rights.
Alex Korchemniy
|
|
|
|
|
Hi
If the object is hosted on the server, then is the client get the object from the server and call methods on the client is the same as call the methods on the server?
If it is correct, can you give some examples.
Thanks!
|
|
|
|
|
Anyone know a good place to find a DLL/Project that I can import into my Solution that allows me to edit an ID3 tag in an MP3?
Currently out there the pickings are slim for anything that updates version 2 tags. I want something simple that I can reference like this:
using ID3Edit;
private void Get()
{
ID3Tag id3Tag = new ID3Tag();
id3Tag.GetV2andV1Tag("C:\\test.mp3");
txtTitleV2.Text = id3Tag.TitleV2;
txtTitleV1.Text = id3Tag.TitleV1;
}
private void Save()
{
id3Tag.TitleV2 = txtTitle.Text;
id3Tag.UpdateV2Tag("C:\\test.mp3");
}
I would be willing to pay $100 or so if someone could create a DLL like this for me within the next few days. I bet many other people out there are willing to pay for it as well. If you know of something that's already created in C# that is as easy to use as my above code, email me right away. I just don't have the time or knowledge to put something like that together.
Email me for details if you want the job or if you have a DLL like this:
Ethan
ethanwa@comcast.net
|
|
|
|
|
I will get you started and then let you finish up, this is really not a difficult task. If you read ID3 made easy[^], they explain the byte layout for the ID3 tag within a file. If you have further questions please feel free to post here. The following should get the ID3 tag out of your file:
class ID3Tag
{
public string title;
public string artist;
public string album;
public string year;
public string comment;
public string tracknumber;
public string genre;
}
private ID3Tag GetTag(string file)
{
string strTag = string.Empty;
ID3Tag tag = new ID3Tag();
ASCIIEncoding encoding = new ASCIIEncoding();
FileStream fs = new FileStream(file, FileMode.Open);
if(fs != null)
{
byte[] block = new byte[128];
fs.Seek(-128, SeekOrigin.End);
fs.Read(block, 0, 128);
fs.Close();
strTag = encoding.GetString(block);
if(strTag.Substring(0,3) == "TAG")
{
tag.title = strTag.Substring(3, 30);
tag.artist = strTag.Substring(33, 30);
tag.album = strTag.Substring(63, 30);
tag.year = strTag.Substring(93, 4);
tag.comment = strTag.Substring(97, 28);
if(strTag[125] == 0)
{
tag.tracknumber = strTag[126];
}
else
{
tag.tracknumber = 0;
}
tag.genre = strTag[127];
}
}
return tag;
}
HTH
- Nick Parker
My Blog | My Articles
|
|
|
|
|
I didn`t have Data tab in my Toolbox. Why is this? Tried reinstall. Thanks
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
When I`m adding reference from COM, It shows error, " A reference to 'Microsoft ActiveX Data objects ............' could not be added. The type library wrapper tool 'tlbimp' connot be found on this system. Please re-install Visual Studio. "
i`ve already reinstall Visual studio, but it didn`t solve the problem. I then tried searching the tlbimp.exe, and found out it`s in C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\Bin folder, and tried moving the file to windows system folder, and it didn`t change anything. Help please. I`m desperate. What should I do???
<italic>Work hard and a bit of luck is the key to success. You don`t need to be genius, to be rich.
|
|
|
|
|
If nothing helps you can always use the tool to manually generate the wrapper. See MSDN[^] for more information.
This posting is provided "AS IS" with no warranties, and confers no rights.
Alex Korchemniy
|
|
|
|
|
I have a Panel object consist of many other objects such as labels, textboxes, checkboxes. Now I want to clone a copy of this Panel object. Does anybody know How to do it?
|
|
|
|
|
There is no built-in way of doing this. What you have to do is create a new instance and copy all the properties to the new instance. You can use reflections to do this.
Take a look at this: www.dotnet247.com/247reference/msgs/58/292067.aspx[^]
This posting is provided "AS IS" with no warranties, and confers no rights.
Alex Korchemniy
|
|
|
|
|
how would you remove and add child and root items to a tree view through code?
|
|
|
|
|
|
Hi,
I'm trying to close and dispose a form that is running in another process, but I get the error message "A first chance exception of type 'System.ObjectDisposedException' occurred in system.windows.forms.dll", "Additional information: Cannot access a disposed object named "frmProgressWindow".".
Here's what I'm trying to do basically...
My main UI thread launches another thread in which I show a modal Progress Window (form with a progress bar). When I'm done performing certain actions, I want to close the progress window from my main thread, so I call this code:
Private Sub CloseProgressWindow()<br />
If _progressWindow Is Nothing Then Return<br />
_progressWindow.Invoke(New CloseProgressWindowDelegate(AddressOf _progressWindow.Close))<br />
_progressWindow.Invoke(New DisposeProgressWindowDelegate(AddressOf _progressWindow.Dispose))<br />
End Sub
The exception occurs on the "End Sub" (!) line. See the screenshot at http://www2.adonis.ca/disposeerror.png[^].
What am I doing wrong?
Thanks!
Carl
PS: I know the code is VB, and this is a C# forum, but I figured people in the VB forum wouldn't have enough knowledge for this question. Since I fully understand both languages, feel free to answer in C# 
|
|
|
|
|
I figured it out!
For the record, I created a method in my Progress Window that close and dispose itself, and I call this method from my main thread. Works like a charm!
|
|
|
|
|
Hi Carl!
I created a method in my Progress Window that close and dispose itself, and I call this method from my main thread.
Sounds like the mistake I made when implementing my first Dispose() method. Although you're not supposed to access normal members after disposing an object calling Dispose() more than once should not throw an exception. If you haven't already done so I strongly recommend using the Dispose Pattern[^].
Best regards
Dennis
|
|
|
|
|
Hi all,
I want to get the absolute value of the pixel cordinates of an image using mouse position on the image. at present I can read the cordinates with respect to the active area of the image. But if the image is larer than the active window, we willbe havin scroll bars. for the remaining image, when we use the scroll bars, the remaining image will be shown in the actie area and when i read for the cordinates it is giving me relative tot he active area, which is not equal to the actual pixel cordinates of the image.
So, how can we read hte actual cordinates of the pixel cordinates on the image.
any ideas or suggestions,
|
|
|
|
|
If you are using a control based on ScrollableControl check the AutoScrollPosition.
This posting is provided "AS IS" with no warranties, and confers no rights.
Alex Korchemniy
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
