How c# app connect to sql server on another pc in local network? - C# Discussion Boards

kripzz15-Apr-07 12:47

15-Apr-07 12:47

Details

Jaiprakash M Bankolli15-Apr-07 7:41

Jaiprakash M Bankolli

15-Apr-07 7:41

Can you send me your code so that we can pin point the error !!

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/

kripzz15-Apr-07 13:07

Re: Moving list view items up or down. [modified]

15-Apr-07 13:07

Here is my code, im not sure if im even tackling this problem correctly.

<br />
        private void listView1_KeyDown(object sender, KeyEventArgs e)<br />
        {<br />
            if (e.KeyValue == 40)<br />
            {<br />
                ListViewItem temp = new ListViewItem();<br />
                ListViewItem temp2 = new ListViewItem();<br />
                for (int i = 0; i < listView1.SelectedIndices.Count; i++)<br />
                {<br />
                    if(listView1.SelectedItems[i].Index + 1 <= listView1.Items.Count)<br />
                    {<br />
                        //store next item in list<br />
                        temp = listView1.Items[listView1.SelectedItems[i].Index + 1];<br />
                        //store currently selected item<br />
                        temp2 = listView1.Items[listView1.SelectedItems[i].Index];<br />
<br />
                        //swap positions<br />
                        listView1.Items[listView1.SelectedItems[i].Index + 1] = temp2;<br />
                        listView1.Items[listView1.SelectedItems[i].Index] = temp;<br />
                    }<br />
                }<br />
            }<br />
        }<br />

Luc Pattyn15-Apr-07 13:38

Luc Pattyn

15-Apr-07 13:38

Hi,

there is a bug: if the last listview item is selected (the one with index=count-1),
then temp will refer to the one with index=count, which exceeds the array.

there probably is a second bug: if items 2 and 3 are selected, then maybe
first 2 and 3 get swapped, then 3 and 4 get swapped, which might not be what
was intended.

index       0 1 2 3 4 5
So original A B C D E F
becomes     A B D C E F
then        A B D E C F

Also I am not sure the items in SelectedItems are in numerical
order, in selection order, or random order.

Furthermore, there is no need to create new ListViewItems (temp, temp2).

Hope this helps

Smile | :)

-- modified at 3:39 Monday 16th April, 2007

Luc Pattyn

[My Articles]

kripzz16-Apr-07 2:51

16-Apr-07 2:51

Im really stuck Frown | :(

How c# app connect to sql server on another pc in local network?

Luc Pattyn16-Apr-07 3:08

Luc Pattyn

16-Apr-07 3:08

Since this is not a question, I will only give a piece of advice:

- try to formulate a good, detailed and complete description of what you
want to achieve before you start implementing something
(e.g. what is swapping meant to do when three things are selected ?)
- then implement, test and debug it
- if stuck in a very specific thing, read the documentation, search Google or
codeproject, possibly launch a question here
- if stuck in general, publish all the above plus detailed description of the
behavior you observed and what it is you dont like about it.

Smile | :)

Luc Pattyn

[My Articles]

sgeorgije15-Apr-07 2:04

sgeorgije

15-Apr-07 2:04

I use below conection string, but there's appear error in remote connection.
On same pc connection is OK.

mConnection = new SqlConnection(@"data source=servername\sqlexpress;" +
"database=databasename;" +
"UID=user;PWD=pass;");

Error mesage is:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Server Authentication is SQL Server and Windows Authentication mode.
Allow remote connections to this server is set.

What may cause this mistake?

Thanks.

Re: How c# app connect to sql server on another pc in local network?

Damir Ugrin15-Apr-07 3:42

Damir Ugrin

15-Apr-07 3:42

Hi,

Your problem is that SQLExpress server by default has Named Pipes and TCP/IP protocol disabled. In order to connect to SQLExpress on different networked PC you should enable at least one of this protocols and restart your SQLExpress service under:

SQL Server Configuration Manager :: ... Network Configuration :: Protocols for ... :: Named Pipes and (or) TCP/IP.

Also it could be (but not necessary) required to setup client protocols on client PC.
Some other settings may be required on your firewalls and ...

After that, it should works.

damir@iit.com.hr

Re: How c# app connect to sql server on another pc in local network?

sgeorgije16-Apr-07 4:20

sgeorgije

16-Apr-07 4:20

Thanks a lot Damir, it's works!!! Smile | :)

Re: How c# app connect to sql server on another pc in local network?

Jaiprakash M Bankolli15-Apr-07 7:42

Jaiprakash M Bankolli

15-Apr-07 7:42

Go to the SQL Server 2005 configuration and set the required seting for remote connection

Regards,
Jaiprakash M Bankolli
jaiprakash.bankolli@gmail.com
http://jaiprakash.blog.com/

NotifyIcon baloon tip

CodeItWell15-Apr-07 1:59

CodeItWell

15-Apr-07 1:59

I have a NotifyIcon object. The user sees it near the clock on the desktop.
Now, I want to tell the user that something happend (Like when Windows says
that updates are ready to be installed)- a small baloon that comes out of
the icon.
Does anyone knows how to do it?

Guffa15-Apr-07 2:24

Guffa

15-Apr-07 2:24

Have you tried the ShowBalloonTip method?

---
single minded; short sighted; long gone;

CodeItWell15-Apr-07 3:02

CodeItWell

15-Apr-07 3:02

Can you tell me more clearly. And I have VS 2003. Is that class here?

Guffa15-Apr-07 3:15

Guffa

15-Apr-07 3:15

C# programming wrote:
And I have VS 2003. Is that class here?

That would explain it. That method is only available in framwork 2.

---
single minded; short sighted; long gone;

Communication with Bluetooth device via COM Port

Luc Pattyn15-Apr-07 6:03

Luc Pattyn

15-Apr-07 6:03

There are several articles on this topic. Search CP !

Luc Pattyn

[My Articles]

Adnan Siddiqi14-Apr-07 21:58

Adnan Siddiqi

14-Apr-07 21:58

Hi
I am looking for some basic tutorial to send data[SMS] to mobile via COM port. Any help will be appreciated.

Thanks

How can I communicate to the USB port?

zeeShan anSari14-Apr-07 21:03

zeeShan anSari

14-Apr-07 21:03

Hi,
Can anybody tell me that how i can communicate with the USB port ?i want to make a simple program (at that time) in the visual studio c# ,such program has ability to on/off the LED connected to the USB port. Please guide me..........
Sigh | :sigh:

Re: How can I communicate to the USB port?

Wayne Phipps14-Apr-07 22:08

Wayne Phipps

14-Apr-07 22:08

Ummm, I don't think "simple" describes what your trying to achieve.

You will need some kind of develepment baord which will contain some kind of usb controller. Some of these use flash firmare which you can rebuild to your own requirements (perform your functions).

The .net framework was not designed to perform low level usb communications so you'll probably end up using a third party library.

A quick search on google pulled up these links:

Basic USB - Using Microchip Stack and C#.Net - Hardware

USB and C#

The USB library for .NET

Regards

Wayne Phipps
____________

Time is the greatest teacher... unfortunately, it kills all of its students
View my Blog

about saving data into remote system

upadesh14-Apr-07 20:21

upadesh

14-Apr-07 20:21

i want to save entire data from my system to remote system. is it posible? can anybody guide me? by using remoting we can access remote system files. but i want save into the remote system. how can i?

Re: about saving data into remote system

Jun Du15-Apr-07 5:47

Jun Du

15-Apr-07 5:47

Yes, it's more than possible. I don't know your specific requirements, but I can suggest some general approaches we normally use:
1) Using OS service directly, such as network drive mapping.
2) Using low-level IPC, such as socket and RPC.
3) Using high-level IPC, such as Remoting, DCOM and Web Service.

Best,
Jun

SMS receiver using C#

fajrif14-Apr-07 20:14

fajrif

14-Apr-07 20:14

Hi guys,

i'am looking for a tutorial / reference
to make application SMS receiver
using .NET(C#)

i never do that before,
so i want to find a simple basic learning from site,
did anyone have a clue / recommended site?

thanks guys.

Re: SMS receiver using C#

Wayne Phipps14-Apr-07 22:27

Wayne Phipps

14-Apr-07 22:27

You have the chioce of using a GSM modem or a SMS gateway service.

A GSM modem will use an AT command set similar to a traditional modem which would allow you to 'query' the modem perhaps using a serial COM port.

A SMS gateway is likely to impliment thier own API or Web Service which you would consume in your application.

In both cases, the implimentation is likely to differ based on the service or hardware your use. You will therefor need to refer to the documentation provided by the manufacturer or service provider.

The following links may help:

SMS Gateway

GSM Modem

Introduction to SMS Messaging

Hope this helps

Regards

Wayne Phipps
____________

Time is the greatest teacher... unfortunately, it kills all of its students
View my Blog

Open program and detect when it closes

kripzz14-Apr-07 19:49