C# Discussion Boards - CodeProject

6-Oct-08 1:22

Hello World...
I want to connect to a sql server 2000 db remotely(Lan Network).
I write a c# test project and set server, my server IP but after run it ,give me this error: Time out, your server computer not response.
I beleve, i must to configure my server sqlserver but ...!!!???
sry for my very bad en... Roll eyes | :rolleyes:

TanX World...

Pedram Behroozi6-Oct-08 1:59

Pedram Behroozi

6-Oct-08 1:59

I think it is because of your ConnectionString, do you addressed your SqlDB correctly, in ConnectionString?

While (true) { Human.isLearnable = true; }

Hossein Afyuoni6-Oct-08 8:41

6-Oct-08 8:41

my connectionstring is corrent because when I change my server Name to (local) my app haven't any error...
... Confused | :confused:

Wendelius6-Oct-08 8:59

6-Oct-08 8:59

Basically three possibilities:
1. Your SQL Server isn't configured to use TCP/IP, use Configuration Manager at server
2. Your connection string is faulty, bad ip-address, port etc
3. IP traffic isn't routed to server, for example because of an firewall

The need to optimize rises from a bad design

Hossein Afyuoni6-Oct-08 9:24

6-Oct-08 9:24

- In sqlserver I see tcp/ip connection & I ticked it...
- If my connectionstring faulty ,i can not connect with it localy...
my connectionstring:

public void Connect()
        {
            string cs = "Server = 192.168.10.190; database = DB1; user=u1; password=123";
            con.ConnectionString = cs;
            con.Open();
        }

Wendelius6-Oct-08 9:42

6-Oct-08 9:42

Few questions:
- is the SQL Server running on the same computer where you're running the app?
- if you can connect to it locally but not remotely, what's the difference in connection string?

The need to optimize rises from a bad design

Hossein Afyuoni6-Oct-08 9:57

6-Oct-08 9:57

diference of it , is i change servername to (local)...
I have some pc with Lan network in one of these I have sqlserver with my database, and in other pcs i have app for connect to that.

Wendelius6-Oct-08 10:13

need to make an asynchronous call to a method that accepts arguments and then modifies form

6-Oct-08 10:13

Then the three choices I listed are most common reasons. It's a very different situation to use IP than to connect to localhost.

Few things you should check,
- try to ping the IP-address
- check on server side that the listening port is 1433 or if it isn't, specify the correct port in connection string
- check on server side that the other pc can listen to port 1433 (no Windows firewall blocking)
- check that it isn't a named instance on the server or if it is, specify the instance name in connection string

The need to optimize rises from a bad design

x0lubi5-Oct-08 23:55

Re: need to make an asynchronous call to a method that accepts arguments and then modifies form

5-Oct-08 23:55

hi all.

i need to make a call to a method asynchronously. this method accepts arguments. the method also returns a value that is then used to modify a form obviously created by the main thread.

to keep things simple, i created a prototype of what i'm trying to do. here's the code:

public partial class Form1 : Form
    {
        public delegate int SomeMethod();

        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            //AddToList(IntFetcher.SlowFetch());
            SomeMethod method = IntFetcher.SlowFetch;
            method.BeginInvoke(EndFetchInt, method);
        }

        public void EndFetchInt(IAsyncResult result)
        {
            SomeMethod method = result.AsyncState as SomeMethod;
            int i = method.EndInvoke(result);
            MethodInvoker mi = new MethodInvoker(this.AddToList);
            this.BeginInvoke(mi, i);
        }
        
        public void AddToList()
        {
            int i = 0;
            ListViewItem lvi = new ListViewItem();
            lvi.Text = i.ToString();
            lvi.SubItems.Add(DateTime.Now.ToString());
            listView1.Items.Add(lvi);
        }

        public void AddToList(int data)
        {
            ListViewItem lvi = new ListViewItem();
            lvi.Text = data.ToString();
            lvi.SubItems.Add(DateTime.Now.ToString());
            listView1.Items.Add(lvi);
        }

    }

    public static class IntFetcher
    {
        public static int SlowFetch()
        {
            // Simulate a slow i/o process
            Thread.Sleep(3150); 
            Random random = new Random(DateTime.Now.Millisecond);
            return random.Next(100, 500);
        }
    }

I had to create the AddToList() method to be confirm if the code was being called at all and to determine if it could modify the listview control. It did. But i still couldnt figure out a way to pass the value returned from the function to it.

I used MethodInvoker cos without it, I got an exception telling me that the running thread could not modify the control as it was created by the main thread.

Any contributions will be appreciated. Thanks.

Jaffer Mumtaz6-Oct-08 3:03

Jaffer Mumtaz

6-Oct-08 3:03

Hi,

Have a look at the link. Hope this helps.

http://en.csharp-online.net/CSharp_Delegates_and_Events%E2%80%94Asynchronous_method_calls[^]

Re: need to make an asynchronous call to a method that accepts arguments and then modifies form

x0lubi6-Oct-08 7:12

Re: need to make an asynchronous call to a method that accepts arguments and then modifies form

6-Oct-08 7:12

i still got this exception

Cross-thread operation not valid: Control 'listView1' accessed from a thread other than the thread it was created on.

while calling the AddToList() method directly from the callback method using the procedure outlined on that url.

combed thru msdn and got this url http://msdn.microsoft.com/en-us/library/ms171728.aspx which is supposed to help make thread-safe calls to windows form controls.

trying to understand the methods outlined there.

Wendelius6-Oct-08 9:11

Re: need to make an asynchronous call to a method that accepts arguments and then modifies form

6-Oct-08 9:11

First, based on documentation for MethodInvoker: This API supports the .NET Framework infrastructure and is not intended to be used directly from your code

Second, presumably the MethodInvoker executes the method passed in another thread so it basically the problem is exactly what the error says.

Take a look at BackgroundWorker Class[^]. I believe it would be helpful in your case.

The need to optimize rises from a bad design

x0lubi6-Oct-08 22:53

Re: need to make an asynchronous call to a method that accepts arguments and then modifies form

6-Oct-08 22:53

Thanks Mika, but i got it working already. the problem i had was marshalling the background thread to the main one. this was the modification i made to get it to work.

public void EndFetchInt(IAsyncResult result)
{
    SomeMethod method = (SomeMethod)result.AsyncState;
    int i = method.EndInvoke(result);

    //MethodInvoker mi = new MethodInvoker(this.AddToList);
    //this.BeginInvoke(mi, i);

    AddToList(i);
}

delegate void _addToList(int data);

public void AddToList(int data)
{
    if (this.listView1.InvokeRequired)
    {
        this.Invoke(new _addToList(AddToList), data);
    }
    else
    {
        ListViewItem lvi = new ListViewItem();
        lvi.Text = data.ToString();
        lvi.SubItems.Add(DateTime.Now.ToString());
        listView1.Items.Add(lvi);
    }
}

i would have had to do the same if even if i had used the BackgroundWorker class.

Wendelius7-Oct-08 6:50

Re: Read HTML file and replace relative path of images with absolute

7-Oct-08 6:50

Glad you got it solved!

Yeah, you have had to do the same in every implementation, but there was these two reasons why I suggested BackgroundWorker:
- if I understood correctly, MethodInvoker shouldn't be used. If it's internal, it's not well documented and there are no quarantees for backward compatibility in future versions
- with BW the model is easier to implement and therefore also more understandable

But then again, are those valid reasons at all fully depend on your needs.

Happy coding Smile | :)

The need to optimize rises from a bad design

[Message Deleted]

DJ2455-Oct-08 23:27

DJ245

5-Oct-08 23:27

[Message Deleted]

Eslam Afifi6-Oct-08 0:45

Eslam Afifi

6-Oct-08 0:45

Your code works. I replaced the createMailBody with the string directly.

string strImage = "TestImage.gif";
string strTitle = "HTML File";
string strMailBody = @"<html><body>    <table>        <tr>             <td><img src="$image$"/></td>             <td> $title$</td>        </tr>     </table></body></html>";
strMailBody = strMailBody.Replace("$image$", strImage);
strMailBody = strMailBody.Replace("$title$", strTitle);

I assume the problem is that you don't get the right string from the createMailBody method.

Eslam Afifi

Re: Read HTML file and replace relative path of images with absolute

DJ2456-Oct-08 20:37

DJ245

6-Oct-08 20:37

Sorry for delay...

iam using this to send a mail. Problem is, at the receiver end image doesn't display. How to solve this?

Re: Read HTML file and replace relative path of images with absolute

Eslam Afifi7-Oct-08 3:09

Eslam Afifi

7-Oct-08 3:09

The img src must be an absolute url or you can use attached images as described here[^].

Eslam Afifi

convert access forms to C#

sachinss19865-Oct-08 23:26

sachinss1986

5-Oct-08 23:26

I got a big Access database I'd like to convert to MS SQL Server 2005
and I'm looking for an efficient automated tool to convert data (over
1 400 tables), query, forms and interface.And i want to convert the access forms to C# Smile | :)

Does somebody can provide me with a list or, at least,a suggestion of
tools that has already been used or well known for their
efficiency.(except upsizing wizard and DTS, I tried with no success,
since I'm not a programmer)

Thanks,

Guy

Re: convert access forms to C#

x0lubi6-Oct-08 0:35