Visual Basic

Intranet Application In VB.Net

14-Sep-07 5:43

Do NOT post the same question in multiple forums. This is called "spamming" is just plain rude.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

VB 6.0

Obasi Emeka13-Sep-07 19:02

Obasi Emeka

13-Sep-07 19:02

Hi
Can anyone help!
I want tot develop a weather reporting software and an Economic tutor. I'm a bit
confused how to get about them. Thanks

Re: VB 6.0

Christian Graus14-Sep-07 3:50

Christian Graus

14-Sep-07 3:50

First step is to use a language that is still alive. VB6 is totally unsupported, move to VB.NET. Then, you need to either have a better starting point than 'I have no idea how to write XXX', or you need to pay someone to write it for you.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

vaibhavksharma13-Sep-07 18:17

vaibhavksharma

13-Sep-07 18:17

sir,

please tell me how i can make application in which server have database and client can make search through this database in vb.net

Tom Deketelaere13-Sep-07 20:53

Tom Deketelaere

13-Sep-07 20:53

this is simply a matter of using the correct connectionstring just point the data source part to the server: servername\sqlserverinstancename

example:
Data Source=server1\server1_DEV;Initial Catalog=DB;User ID=sa

then you can write you app like any other

If you'r question was how to write the app then you'r asking at the wrong place. Nobody here will write it for you, when you have a specific problem then you can ask for help here

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

~V~13-Sep-07 23:54

13-Sep-07 23:54

Hi,
I m facing the same problem Cry | :((

, I don't know what shd i do next?
Actully i developed an application in vb.net and try to run it over LAN, but i m unable to do it Sniff | :^)

I just copied the exe of my project on client machine and try to access the sqlserver 2000 database of the server using the server name and ip address and userid and password in connection string. But it doesn't work. it gives

error that "Connection is not established bcoz time out"

I have tried to increase the time out period up to 2000 in connection string but nothing happed Cry | :((

I want to run the application on local network.

Any information would be appriciated, I m looking forward for your guidance
Thanks with anticipation

vandana

darkelv14-Sep-07 0:09

darkelv

14-Sep-07 0:09

1. Is the SQL server allowed remote connect?
2. Port blocked? Firewall?
3. And many many reason can cause it.

~V~14-Sep-07 0:28

14-Sep-07 0:28

Thanks for your response.
What shd i do so that the client machine can allow to remote access.
Thanks once again Rose | [Rose]

vandana

Tom Deketelaere14-Sep-07 1:17

Tom Deketelaere

14-Sep-07 1:17

from the error I would think that you try to use you connection to the db before it has been initialized.
I'd debug the programme from the start and see where the connections with the db is made and where you first use it.

also check if the client can access the server by ip (just ping to the ip and see if it works)

next to that you have to give both the servername or ip and the sqlservername (usaly its the servername_dev)

so if you'r server has ip 1.1.1.1 and is named server and the database is named 'db' and you can login with user sa and pass sa then you'r connectionstring would look like:

Data Source=1.1.1.1\server_DEV;Initial Catalog=db;User ID=sa;Password=sa

hope this helps

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

~V~14-Sep-07 2:17

14-Sep-07 2:17

I used same connection string as you told me but it gives error Sleepy | :zzz:

that

"An error has occured while establising the connection to the server, the failer may be boz the fact that under the default settings sql server does not allow remote connection"

What type of setting i will have to change so that the client would be able to connect with server remotely?

Thanks once again Blush | :O

vandana

Tom Deketelaere14-Sep-07 3:46

Tom Deketelaere

14-Sep-07 3:46

I would first check the settings of sql server to see if it allows remote connection (like the error says)
then check firewall settings
networksettings
...

if the connectionstring is correct it must be something like the above

If my help was helpfull let me know, if not let me know why.

The only way we learn is by making mistaks.

~V~15-Sep-07 1:13

15-Sep-07 1:13

Actully problem is that the sql server doesn't allow the remote access.
I have changed connection in the configuration wizard
the remote connection to Local and Remote connection from local connection only ,I have also tried to do it by creating server's alias but nothing happened Frown | :(

Can you tell me what shd i do for the remote access of sql server?
Thanks once again Laugh | :laugh:

vandana

An academic problem

liv2luv13-Sep-07 18:08

liv2luv

13-Sep-07 18:08

Create Console Application in Visual Studio 2005 that prompts the user for a five digit positive integer, separates the number into individual digits and prints the digits separated from one another by three spaces each. For example, if the user types in the number 42339, the program should display at the command prompt

The separated digits of the input number are 4 2 3 3 9

liv2luv

chandu00413-Sep-07 19:49

chandu004

13-Sep-07 19:49

use divided by (/) and modulo (%) in a loop and print them.
here is the techique for you.
divide the number by 10000.
then you will get 4.
print it and give 3 spaces.
then number=number%10000.
then divide it by 1000
and so on.

pmarfleet13-Sep-07 22:01

pmarfleet

13-Sep-07 22:01

The easiest way to do this is to convert the number to a string, loop through each character in the string and add white space between each digit. The following code demonstrates how to do this:

int number = 12345; // change this line to however you get the number from user input
string number_string = number.ToString();
StringBuilder output = new StringBuilder();
for (int i = 0; i < number_string.Length; i++)
{
  output.AppendFormat("{0}   ", number_String.SubString(i, 1));
}

number_string = output.ToString().Trim(); // Trim trailing white space

Paul

Dave Kreskowiak14-Sep-07 5:34

14-Sep-07 5:34

Nothing like doing someones homework for them.

Congratulations!! You've now helped this person fail his class!!

I know this may seem like an odd thing to say, considering he'll use YOUR code to pass HIS little assignment. But, since HE didn't write the code, HE will have LEARNED NOTHING that he MUST LEARN in order to write code for FUTURE projects.

Again, congratulations on helping him fail...

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

pmarfleet14-Sep-07 5:47

pmarfleet

14-Sep-07 5:47

I think you should calm down a bit. People help each other for free on this site, and I am as entitled to offer assistance as anyone else. If you think this person is posting homework then take issue with him, not me.

Also, please don't shout at me. The forum guidelines forbids it.

Paul

Dave Kreskowiak14-Sep-07 6:08

14-Sep-07 6:08

pmarfleet wrote:
If you think this person is posting homework

You didn't read the OP's subject line, did you? "academic problem" screams homework.

Think about the help you're giving and why the person is asking for it before you post. Are you going to tell someone how to write a virus too?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

pmarfleet14-Sep-07 8:24

pmarfleet

14-Sep-07 8:24

Even if it was a homework question I don't think that justifies the tone of your response, which was out of proprtion to the issue at hand.

Anyway, people who cheat eventually get found out, so I don't think it makes much difference in the great scheme of things.

Paul

Paul Conrad14-Sep-07 19:12

Paul Conrad

14-Sep-07 19:12

Dave Kreskowiak wrote:
Nothing like doing someones homework for them.

What a cheat Mad | :mad:

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Paul Conrad14-Sep-07 19:13

Paul Conrad

14-Sep-07 19:13

Dave Kreskowiak wrote:
Again, congratulations on helping him fail...

No kidding Laugh | :laugh:

"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

Dave Kreskowiak15-Sep-07 2:16

15-Sep-07 2:16

The guy says that he'll give any help to anyone who wants it.

Well, what about that guy who wants to write an app that locks Windows with a password until the customer pays??

Sure, you help him out, he get the app working, then his code fails to unlock a machine after the customer pays. He then gets sued for damages, and now anyone who helped him write this code is now complicit in a, say, "scheme to defraud". Why is it so difficult to understand that you have to think before you post?!

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007