C# Discussion Boards - CodeProject

http://www.connectionstrings.com/mysql[^]

12-Oct-09 2:31

Re: Connect to a remote MySql DB

SummerBulb12-Oct-09 2:38

SummerBulb

12-Oct-09 2:38

I don't know why, but copying the dll (MySql.Data.dll) to the location of the application did the trick.

I'll apreciate an explaination...

Thanks again.

Re: Connect to a remote MySql DB

stancrm12-Oct-09 2:46

12-Oct-09 2:46

If you just want to use MySql.Data.dll, you can set "CopyLocal = true" in reference property. Then the MySql.Data.dll will be copied automatically to Debug or Release directory. You can distribute it. To connect to remote DB, then what you need is connectionstrings.

thread problem

Member 59031012-Oct-09 2:06

Member 590310

12-Oct-09 2:06

hw can i suspend and resume thread.

Re: thread problem

stancrm12-Oct-09 2:14

paging in Sharepoint document library

12-Oct-09 2:14

From MSDN : "Thread.Suspend has been deprecated. Please use other classes in System.Threading, such as Monitor, Mutex, Event, and Semaphore, to synchronize Threads or protect resources. http://go.microsoft.com/fwlink/?linkid=14202"

http://msdn.microsoft.com/en-us/library/ms173179.aspx[^]

Sudhir Mangla12-Oct-09 1:11

Sudhir Mangla

12-Oct-09 1:11

Hi

I have a client requirement that we need to implement paging in sharepoint document library.

For instance in some cases document library contain 100 or more files in such cases we need to implement paging.

Can any one suggest any solution that can be implemented easily using jquery or server side code.

Any help in this case will be appreciated.

Sudhir Mangla

http://tips.DevelopersVoice.com
(Technical Tips and Tricks)
http://Programmerworld.net
(Free books and source code)
http://Faq.Programmerworld.net
(FAQ and Tips for programmers)

http://health.Programmerworld.net
(Health tips)

Re: paging in Sharepoint document library

Not Active12-Oct-09 1:35

Not Active

12-Oct-09 1:35

Don't spam the forums looking for an answer. This is clearly a SharePoint related question that should not have been asked here. Mad | :mad:

only two letters away from being an asset

Connect to mapped network drive

musefan12-Oct-09 1:05

12-Oct-09 1:05

Hi All,

I have an application (Win Forms) that amongst other things downloads files from a server. This is done with the use of a mapped network drive.

The problem is sometimes the network drive will have a red cross (vista) to show it is not connected, it simply takes the user to double-click the desired path in order for it to connect. But if I try to access it through code while it is 'not connected' then it fails. All it takes is the user to double-click the drive and then the application will work again fine. But I don't want users to have to do this.

Basically, I want to know if there is a way I can check the connection status, and if need be, attempt to connect the drive before accessing the files. I don't want to un-map/re-map the drive each time either.

Thanks for any suggestions

Life goes very fast. Tomorrow, today is already yesterday.

Henry Minute12-Oct-09 1:29

Henry Minute

12-Oct-09 1:29

Could you not:

if (!File.Exists("DriveLetter:\PathToSomeFileOnMappedDrive"))
{
    Refresh the mapping here
}

musefan12-Oct-09 1:35

12-Oct-09 1:35

Thanks for your reply,

I get how to test is I can access it but I do not know how to ask it to try to connect.

I don't want to have to un-map the drive and re-map because that seems messy and will probably result in user-rights issues for some of my users

Life goes very fast. Tomorrow, today is already yesterday.

Henry Minute12-Oct-09 1:49

Henry Minute

12-Oct-09 1:49

This[^] has a zRestoreDrive method that would appear to do what you require.

It is a more recent version of Map Network Drive (API)[^] from here on Code Project.

musefan12-Oct-09 2:42

12-Oct-09 2:42

Thanks, I'll take a look

Life goes very fast. Tomorrow, today is already yesterday.

musefan12-Oct-09 3:10

12-Oct-09 3:10

Not supported in vista and later[^]

But it's given me something to search for, was getting no where before so thanks for that. I'll post if I get an answer

Life goes very fast. Tomorrow, today is already yesterday.

Luc Pattyn12-Oct-09 3:50

Luc Pattyn

12-Oct-09 3:50

isn't MSDN great? they tell you the function is gone, but don't point you to a solution...

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

musefan12-Oct-09 5:28

12-Oct-09 5:28

I know, I really was expected to get somewhere from that. Well maybe I can use this as an excuse to stop my users having Vista! Laugh | :laugh:

Life goes very fast. Tomorrow, today is already yesterday.

how to compare textbox string with data base field

ragnaroknrol12-Oct-09 7:56

ragnaroknrol

12-Oct-09 7:56

musefan wrote:
Well maybe I can use this as an excuse to stop my users having Vista!

One needs an excuse?

Mangesh Tomar12-Oct-09 0:49

Mangesh Tomar

12-Oct-09 0:49

hi,
i doing one stanalone application in that i am crearing a login control in this i am checking the name and pssw which stored in the data base if the name and passw present in data base then user get login else error mssg
i tried some here but when i run my prog. it shows runtime exception that connection not open need help
here is my code

public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private OleDbCommand cmd;
private void Form1_Load(object sender, EventArgs e)
{
String connectionString = "Provider= Microsoft.Jet.OLEDB.4.0; Data Source= C:\\Login1.mdb; username=xxx;password=xxx;database=login1";
OleDbConnection connection = new OleDbConnection(connectionString);
connection.Open();

string selectString =
"SELECT Name, Password " +
"FROM login1 " +
"WHERE Name = '" + login.Text + "' AND Password = '" + psw.Text + "'";

cmd = new OleDbCommand(selectString, connection);
connection.Open();
String strResult = String.Empty;
if (strResult.Length > 0)
{
label5.Text = "YOU ARE LOGGED IN!";
}

else
{
label5.Text = "INCORRECT USER/PASS!";
}
connection.Close();

Re: how to compare textbox string with data base field

Luc Pattyn12-Oct-09 1:00

Luc Pattyn

12-Oct-09 1:00

the exception holds file name, class name, method name and line number information.
And an IDE (such as Visual Studio[^] can be told to always show line numbers in editor windows.

Hence it is easy to spot where things go wrong; now read the error/exception message carefully, and check your code. Which I didn't read as it isn't properly formatted using PRE tags.

Smile | :)

Luc Pattyn

I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: how to compare textbox string with data base field

Md. Marufuzzaman12-Oct-09 1:24

Md. Marufuzzaman

12-Oct-09 1:24

Could you provide the error detail.. I think some other issues are there....

Thanks
Md. Marufuzzaman

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Re: how to compare textbox string with data base field

OriginalGriff12-Oct-09 3:08

OriginalGriff

12-Oct-09 3:08

There are so many things wrong with this! For example:

Mangesh Tomar wrote:
connection.Open();

string selectString =
"SELECT Name, Password " +
"FROM login1 " +
"WHERE Name = '" + login.Text + "' AND Password = '" + psw.Text + "'";

cmd = new OleDbCommand(selectString, connection);
connection.Open();

Why try to open it twice?

Mangesh Tomar wrote:
String strResult = String.Empty;
if (strResult.Length > 0)
{
label5.Text = "YOU ARE LOGGED IN!";
}

What do you think is going to happen? Magic?

I sugest you go right back to the begining - create a new project, connect to that database and read a single record from the table. When you get that working, start building up from there.
Oh, and Luc is right - preserve your formatting with <pre> and </pre> tags around you original code when you post it here. It make it easier to read, and thus more likely to be read. (And Luc is one of the people you really want to read your code - you will probably never learn half the stuff he has forgotten...)

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Dynamically created Icon for Number in Taskbar

stancrm11-Oct-09 23:30