How to point to localhost? - ASP.NET Discussion Boards

Re: How to get data into the dropdown list from database table(c#)

albCode15-Jun-06 5:11

15-Jun-06 5:11

SqlConnection c = new SqlConnection(stringconection);<br />
c.Open();<br />
DataSet ds = new DataSet();<br />
SqlDataAdapter da= new SqlDataAdapter ("select command",c);<br />
da.Fill(ds);<br />
Dropdownlist1.DataSource = ds.Tables[0];<br />
Dropdownlist1.DataValueField = "Column1";<br />
Dropdownlist1.DataTextField = "Column2";<br />
c.Close();

Re: How to get data into the dropdown list from database table(c#)

varshavmane15-Jun-06 5:34

varshavmane

15-Jun-06 5:34

Goto DropdownList's properties and DataValueField put the PK of Database and DataTextField put the column name which u want to display form Database.
Then Write Method as:

DataSet ds = GetValuesFromDB();
DropdownList1.DataSource = ds;
DropdownList1.DataBind();
ListItem lst = new ListItem("All Values", "0");
DropdownList1.Items.Insert(0, lst);

Where GetValuesFromDB() will contain sql which will return Dataset.The query will have PK and the column name which u want to display.

I hope this will help u.
Thanks and Regards.

Static instances

Dario Solera15-Jun-06 4:33

Dario Solera

15-Jun-06 4:33

Hi, I have this question about static instances of classes:
Is a static instance of a class unique at the Application level, or there is a different instance for every session?

In other words, does a static field of a non-static class behave like it was in the Application["..."] object dictionary?

Thanks.

______________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] and the ScrewTurn Software experiment

Re: Static instances

Colin Angus Mackay15-Jun-06 5:17

Colin Angus Mackay

15-Jun-06 5:17

Appliation level. All sessions share the same static classes/methods/fields/properties.

If you update a static in one session, the update will instantly be available to all sessions.

Scottish Developers events:
* .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy
* Developer Day Scotland: are you interested in speaking or attending?
My: Website | Blog

Re: Static instances

Dario Solera15-Jun-06 5:23

Dario Solera

15-Jun-06 5:23

Thanks, in fact I have did a test and it behaves that way. Cool.

______________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] and the ScrewTurn Software experiment

Re: Static instances

Guffa15-Jun-06 5:22

Guffa

15-Jun-06 5:22

A static instance is just a static reference to a regular instance of the class. Therefore it has the same scope as any static variable.

A static variable is unique at the application level.

---
b { font-weight: normal; }

Re: Static instances

Dario Solera15-Jun-06 5:24

Dario Solera

15-Jun-06 5:24

Guffa wrote:
A static variable is unique at the application level.

Cool. I did a test and in fact it works that way.
Thank you.

______________________________________
Tozzi is right: Gaia is getting rid of us.
My Blog [ITA] and the ScrewTurn Software experiment

How to point to localhost?

leckey15-Jun-06 4:19

leckey

15-Jun-06 4:19

I am working on an ASP.NET project where I make a call to a database. I know how to create a key in the web.config file to point to the actual server, but I made a copy of the database on my local computer and want it to point to that.

Real Server:
<add key="ConnectionString" value="Data Source=SERVER-SQLSC1;Initial Catalog=Parts;User ID=user;Password=morecowbell" />

What I tried for localhost:
<add key = "ConnectionString" value = "Data Source = localhost;Initial Catalog=PartsDB;"/>
(I named the copy PartsDB to avoid confusion.)

What am I doing wrong here?

Re: How to point to localhost?

Paddy Boyd15-Jun-06 4:21

Paddy Boyd

15-Jun-06 4:21

Just raise your arm and extend your finger in the direction of your pc...

or use server=(local)

Re: How to point to localhost?

leckey15-Jun-06 4:25

leckey

15-Jun-06 4:25

add key = "ConnectionString" value = "Server=(local);Initial Catalog=PartsDB;"

Like that?
I've been having problems pasting...

Re: How to point to localhost?

Paddy Boyd15-Jun-06 4:26

Paddy Boyd

15-Jun-06 4:26

You can try wrapping your code in code tags (formatting below the entry textbox).

And yes.

Re: How to point to localhost? [modified]

leckey15-Jun-06 4:28

leckey

15-Jun-06 4:28

Then I get this error...

System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection

-- modified at 10:29 Thursday 15th June, 2006

What user do I use?

Re: How to point to localhost?

Paddy Boyd15-Jun-06 4:31

Paddy Boyd

15-Jun-06 4:31

How are you connecting to your other db? You'll need to supply a db user name and password (probably sa and blank)...

Big Grin | :-D

Re: How to point to localhost?

leckey15-Jun-06 4:33

leckey

15-Jun-06 4:33

Real server:
add key="ConnectionString" value="Data Source=SERVER-SQLSC1;Initial Catalog=Parts;User ID=aspuser;Password=crlamo5"

Trying:
add key = "ConnectionString" value = "Server=(local);Initial Catalog=PartsDB; User ID = aspuser; Password=crlamo5

Get error:

System.Data.SqlClient.SqlException: Login failed for user 'aspuser'. Reason: Not associated with a trusted SQL Server connection

Re: How to point to localhost?

Paddy Boyd15-Jun-06 4:31

Paddy Boyd

15-Jun-06 4:31

you might want to have a look at this:

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

Re: How to point to localhost?

leckey15-Jun-06 4:36

leckey

15-Jun-06 4:36

Good site...what I can't figure out is why the "aspuser" works on the real server but not on localhost. I can't find anything different with permissions.

Re: How to point to localhost?

Paddy Boyd15-Jun-06 4:37

Paddy Boyd

15-Jun-06 4:37

You could always put in the name of your machine rather than (local). worth a try.

Re: How to point to localhost?

leckey15-Jun-06 4:38

leckey

15-Jun-06 4:38

Grr! Not working either!

Using Script to query Access

RX Maverick15-Jun-06 3:58

RX Maverick

15-Jun-06 3:58

A quick simple question:
I want to query access using only script (I'm using VB), then loop through the data? I know this is easy, and I think it's similar to how I do things in ASP, but does anyone know where a simple tutorial is? Also one for script querying SQL would be great.

Thanks

Re: Using Script to query Access

RichardGrimmer15-Jun-06 5:20

RichardGrimmer

15-Jun-06 5:20

a little VBScript should do the trick.....

<br />
dim oConn as ADODB.Connection<br />
oConn.Open(ConnectionStringHere)<br />
<br />
dim oRS as new ADODB.Recordset<br />
oRS.Open ("SELECT * FROM SomeTable", oConn)<br />
<br />
while oRS.EOF = false and oRS.BOF=false<br />
  call MyProcessingFuntion()<br />
wend<br />

apologies if it's not quite bang on - been a while since I've done ANY VBS :$

"Now I guess I'll sit back and watch people misinterpret what I just said......"
Christian Graus At The Soapbox

How do I join FirstName and LastName in a datagrid and make it as "Lesse Name"?

Slow Learner15-Jun-06 3:54

Slow Learner

15-Jun-06 3:54

Hello,
I have comming two different columns FirstName and LastName from the datasource. I have no problem in binding it to the gridview. But I need help on how to make FirstName and LastName to be displayed in a single column.

Could some one please help me with that?
Thanks
-L

Re: How do I join FirstName and LastName in a datagrid and make it as "Lesse Name"?

albCode15-Jun-06 4:49

albCode

15-Jun-06 4:49

select (FirstName + ' ' + LastName) as Name from table

Re: How do I join FirstName and LastName in a datagrid and make it as "Lesse Name"?

Slow Learner15-Jun-06 4:53

Slow Learner

15-Jun-06 4:53

Yeah I have already done that. But I need to be able to pass these First and Last names to a different page. If I do like you said in the selection of the table I will have to use function like split to split the fname and lname and then display fname and lname seperatley.

Looks like I will have manipulate in the table selection itself.

Thanks for the input,
-L

Re: How do I join FirstName and LastName in a datagrid and make it as "Lesse Name"?

albCode15-Jun-06 5:16

albCode

15-Jun-06 5:16

use seperatly
select FirstName,Lasntname, (Firstname + ' ' + Lastname)as Name from table

Re: How do I join FirstName and LastName in a datagrid and make it as "Lesse Name"?

Slow Learner15-Jun-06 5:20

Slow Learner

15-Jun-06 5:20

'ats works too Smile | :)

and we can hide the FirstName and LastName columns in the grid. I will try that way .. I mean either way its gonna take enough time in my situation. But I like this idea.
Thanks
-L

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.