Re: cant connect to sql 2005 database - C# Discussion Boards

Re: having trouble making messenger

26-Dec-05 17:22

I did know that UDP was unreliable but didn't know that it was unreliable to this extent that we couldn't trust it. Thanks for pointing that out. Smile | :)

If UDP is so unreliable, why the hell is it there and what type of applications use it??

---
With best regards,
A Manchester United Fan

The Genius of a true fool is that he can mess up a foolproof plan!

Dave Kreskowiak28-Dec-05 1:57

Dave Kreskowiak

28-Dec-05 1:57

Save My Soul - (SMS) wrote:
If UDP is so unreliable, why the hell is it there and what type of applications use it??

Streaming media.

UDP is connectionless, so you don't expect any acknowledgements back from the client, or multiple clients in broadcast. There are no retrys on packets that are lost since the send never gets notified that they've been dropped or recieved out of order. Since this is where TCP gets "bogged down", if you could call it that, UDP is a little faster.

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

cant connect to sql 2005 database

kourvoisier22-Dec-05 19:06

22-Dec-05 19:06

I receive this error

"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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"

Here is my connection string
Data Source=SQLEXPRESS; Initial Catalog=dbEasyManager; User id=sa; Password=;

i even had data source = localhost

Came across enabling pipes in sql config manager, but i have no idea where that is in the manager cant find it

that may not even be the problem, because i had connected to the db before with someone elses code just dont know where it is.

can someone help me please

Colin Angus Mackay22-Dec-05 22:14

Colin Angus Mackay

22-Dec-05 22:14

kourvoisier wrote:
Data Source=SQLEXPRESS

This tells it to look for the SQL Server on a machine called SQLEXPRESS. I suspect that this is the instance name and you just haven't told it which machine on your network to find that instance of SQL Server.

Try:

Data Source=MachineName\InstanceName

My: Blog | Photos

"Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius

kourvoisier23-Dec-05 12:26

23-Dec-05 12:26

Colin Angus Mackay wrote:
Data Source=MachineName\InstanceName

I still get the same error.

here is connection string i used among others

"Data Source=./SQLEXPRESS; Initial Catalog=dbEasyManager; User id=sa;Password=;"

after adding a connection thru database explorer, by browsing thru the files and selecting the actual database, it stated i made a successful connection. It then generated a connection string.....(below)

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Program Files\MicrosoftSQLServer\MSSQL.\MSSQL\Data\dbEasyManager.mdf";Integrated Security=True;ConnectTimeout=30;UserInstance=True

I was going to test this connection string in my code but couldnt figure out how to make the whole thing a string with the extra ""'s in it throws the syntax off.

Bottom line is i still cant connect to my database

I am using SQL server 2005 express and
visual 2005 c# express on a windows xp machine

the name of my database is dbEasyManager.mdf

someone help me, is there any other info you need to get me connected, its got to be something little i just cant figure it out.

HELP

kourvoisier23-Dec-05 13:54

23-Dec-05 13:54

server=(local)/SQLExpress;database=Pubs;Integrated Security=true

Error i get because of the slash "/" --> Unrecognized escape sequence
why is this?....

on tutorials they have it setup this way but when i compile i get this error...
someone help me.

kourvoisier23-Dec-05 16:45

Delete a folder with data in c#.net

23-Dec-05 16:45

After a couple of days of trying to figure this thing out i did!
something very simple, i knew it would be

in my connection string the "unrecognized escape sequence" error i was getting was because
c# does not like the "/" character one bit, so before your string you must use the @ symbol
to make c# happy.

and WHALA!!! works like a charm

Malayil alex22-Dec-05 18:54

Malayil alex

22-Dec-05 18:54

Hello,

I am beginner in c#.net, i need your help.Now i am in a problem i want to delete a folder with data in my c# application.Can you help me please.

Thanks in advance.
alex.

Help me

Re: Delete a folder with data in c#.net

Gerben Jongerius22-Dec-05 18:55

Gerben Jongerius

22-Dec-05 18:55

Take a look at System.IO.Directory

electronic usage

Sheharyar_JH22-Dec-05 18:29

Sheharyar_JH

22-Dec-05 18:29

how i can control electric items through c# application?

need some help from u people.

Sheharyar_JH

GDavy22-Dec-05 20:52

GDavy

22-Dec-05 20:52

By sending data over WiFi, or serial bus, or parallell port or USB, or internet, having your 'electric item' connected to the correct media over which you are sending your commands. Adjust the item so that it can interpret any command you send to it. Make sure your item is powered. And that should pretty much do it.

(more specific questions might result in more specific answers btw)

leppie23-Dec-05 0:07

leppie

23-Dec-05 0:07

Why you put the question down? Why did you get 5's? D'Oh! | :doh:

Confused? See my reply to original question.

^{xacc.ide-0.1.1 released! :) Download and screenshots}

Dave Kreskowiak23-Dec-05 6:05

Dave Kreskowiak

23-Dec-05 6:05

Because the question was SOOOO vague, with an utter lack of any detail, that it was the only answer possible! Laugh | :laugh:

RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome

Re: Datagrid problem in c#

leppie23-Dec-05 0:10

leppie

23-Dec-05 0:10

The technology you are refering to is called X10. It is aimed at controlling household appliances thru you computer.

MS recently posted an article on doing exactly this on their 'codeforfun' website. Sorry, no link, but you should find the answers you are looking for. Smile | :)

^{xacc.ide-0.1.1 released! :) Download and screenshots}

Datagrid problem in c#

yaminilathatv22-Dec-05 17:53

yaminilathatv

22-Dec-05 17:53

Hi all, idont know where am i going wrong please help me.My idea is that, i am retrieving the deptnames from database into the dropdown list and afterthe selection of the deptname the respective details are to be displayed on the datagrid. The code is working till the dropdownlist.

code to get deptnames to the dropdownlist:
private void Page_Load(object sender, System.EventArgs e)
{
try
{
connectdb();
Cmd.CommandText = "Select distinct (Dept) from emp";
da.SelectCommand = Cmd;
da.Fill(ds,"Emp");
DropDownList1.Items.Clear();
foreach (DataRow dr in ds.Tables["emp"].Rows)
{
DropDownList1.Items.Add(dr["Dept"].ToString());
}

}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Con.Close();
}

code to dispaly the details onto datagrid:
private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
{
try
{
connectdb();
Cmd.CommandText = "Select * from emp Where Dept Like '" + DropDownList1.SelectedItem.Value.ToString() + "' order by Empno";
da.SelectCommand = Cmd;
da.Fill(ds,"Emp");
DataGrid1.DataSource = ds;
DataGrid1.DataMember = "Emp";
DataGrid1.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
Con.Close();
}

Note: The same code is working if i enter the deptname in a textbox and click the button to display details on to the datagid. But the code is not working if i select the option in the dropdownlist.Is the event Dropdownlist_SelectedIndexChanged relevent or any other events are there to select the dropdownlist.
pleasehelp me

thanks in advance
yamini

PrakashBhaskar22-Dec-05 18:07

PrakashBhaskar

22-Dec-05 18:07

Hi,
By default AutoPostBack property for dropdown list is set to false, set the AutoPostBack property to true

Smile | :)

Thanks
Warm Regards
Prakash-B

Virtual and override.

HakunaMatada22-Dec-05 17:23

22-Dec-05 17:23

Can anyone give me the exact difference between Virtual and Override? I am a bit confused... D'Oh! | :doh:

Bikash Rai

Gerben Jongerius22-Dec-05 19:06

Gerben Jongerius

22-Dec-05 19:06

Virtual indicates that any inherriting class may override the function and replace it with its own content. The keyword override indicates that I intend to replace a function out of a base class with my own.

So you can only use override when a member in the base class is declared as: virtual, abstract or override. (as stated in the override article on the MSDN)

The related articles from MSDN are:
virtual
override

HakunaMatada22-Dec-05 19:39

22-Dec-05 19:39

Gerben Jongerius wrote:
So you can only use override when a member in the base class is declared as: virtual, abstract or override.

Lets say that I have a base class A. A has one virtual function whose name is func. Now I create another class B which inherits from A. I override the function func using the override modifier. Lets say I create another class C which inherits from B. Now, if I have to override the function func of B in C then do I use override? D'Oh! | :doh:

Thanks for helping. Smile | :)

---
With best regards,
A Manchester United Fan

The Genius of a true fool is that he can mess up a foolproof plan!

GDavy22-Dec-05 20:47

GDavy

22-Dec-05 20:47

yep, you use override once again.
override states that it is overriding the function from the base class, and the overridden function still remains virtual, meaning that classes that derive from the class that overrode the func can still override it and do their own stuff...

Greetings,
Davy

HakunaMatada22-Dec-05 21:26