How do I join FirstName and LastName in a datagrid and make it as "Lesse Name"? - ASP.NET Discussion Boards

leckey15-Jun-06 4:33

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

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

varshavmane15-Jun-06 5:20

varshavmane

15-Jun-06 5:20

On ItemCommand event of DataGrid just pass the employee no and name by Query String and u will it.If not then please let me know I will tell u how to use Querystring.

Thanks and Regards.

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

minhpc_bk15-Jun-06 16:11

minhpc_bk

15-Jun-06 16:11

In addition to grouping the two columns in one, you can simply use the TemplateField in the GridView, and you can bind the two data columns in this template column, for example use two labels controls or place two databinding expressions.

Memory consumption: aspnet_wp.exe recycled

Talal Sultan15-Jun-06 3:33

Talal Sultan

15-Jun-06 3:33

Hi people,

I'm using a COM object to generate a very large bitmap file. I get this error logged in the event log:

aspnet_wp.exe (PID: 3828) was recycled because memory consumption exceeded the 460 MB (60 percent of available RAM).

Is there any way to increase the percentage of available RAM allocated to the process? (keeping aside the fact that we can add more RAM! Big Grin | :-D

)

Thanks,
Talal

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook

Re: Memory consumption: aspnet_wp.exe recycled

minhpc_bk15-Jun-06 16:08

minhpc_bk

15-Jun-06 16:08

Talal Sultan wrote:
aspnet_wp.exe (PID: 3828) was recycled because memory consumption exceeded the 460 MB (60 percent of available RAM).

You can see the memoryLimit attribute of the processModel[^] element

Re: Memory consumption: aspnet_wp.exe recycled

Talal Sultan15-Jun-06 22:12

Talal Sultan

15-Jun-06 22:12

Thanks for the tip, I will look into that.

Talal

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook

bitmap class in vb.net

amaneet15-Jun-06 3:29

amaneet

15-Jun-06 3:29

Sir,
This is the third time I am posting the same question and I will continue this until i will get the answer.

I am using bitmap class to check the dimensions of the file I mean height and width.

Dim bm as new bitmap(filepath)<br />
bm.height<br />
bm.width

Now the problem is when the path contains file of extention .jpg or some other extentions it occurs an exception .What is another way by which the dimensions of any type of image file can be find out.

Can u help me.

Re: bitmap class in vb.net

RichardGrimmer15-Jun-06 5:24

RichardGrimmer

15-Jun-06 5:24

amaneet wrote:
This is the third time I am posting the same question and I will continue this until i will get the answer.

I REALLY recommentd you dont - this isn't some SERVICE that you can demand results from - for that try funking google

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

Retreiving a File Path - Simple Question

capricious_00115-Jun-06 3:25

capricious_001

15-Jun-06 3:25

Hi guys,

I was just wondering, is there anyway in ASP you can retrieve the complete file path of a script? For example if you had the script test.asp, what object method would you use to retreive the file path like C:/test/stuff/test.asp.

If anyone knows, I would really appreciate it.

Thanks,

Robbie

Re: Retreiving a File Path - Simple Question

Guffa15-Jun-06 3:28

Guffa

15-Jun-06 3:28

Use Server.MapPath to the get physical path from a virtual path.

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

Re: Retreiving a File Path - Simple Question

capricious_00115-Jun-06 3:36

capricious_001

15-Jun-06 3:36

Hey Guffa,

Thanks a lot man, that worked!

Robbie

template column in vb.net 1.1 [modified]

amaneet15-Jun-06 3:23

amaneet

15-Jun-06 3:23

I am having two template column . In the first i inserted label control and in the second i have checkbox and an editeitemcommand . on update button I am writing some code

dim ch as checkbox<br />
ch = CType(e.item.cells(1).control(0),checkbox)

Now the problem is an error is occuring
Specified cast is not valid.

can u help me.

-- modified at 9:24 Thursday 15th June, 2006

Re: template column in vb.net 1.1

minhpc_bk15-Jun-06 16:13

minhpc_bk

15-Jun-06 16:13

amaneet wrote:
e.item.cells(1).control(0)

I guess you can easily check the real type of it when you debug your application.

[Solved] WS-E 2.0 problem: "Creation time in the timestamp can not be in the future" [modified]

Arjan Einbu15-Jun-06 2:35

Arjan Einbu

15-Jun-06 2:35

Hi!

I'm calling on a webservice with WS-E 2.0 (because I need to use Dime), and the server returns this exception message:

Microsoft.Web.Services2.Security.SecurityFault: An error was discovered processing the <Security> header ---> System.Exception: Creation time in the timestamp can not be in the future.

I've allready checked that the clock on both machines are in sync (also the same timezone). I've also tried different combinations of setting the <timeToleranceInSeconds> and the <defaultTtlInSeconds> settings in both the clients app.config file and the servers web.config file.
still gets me the same exception...

Does anyone here have any suggestions on how to fix this?

-- modified at 9:53 Thursday 15th June, 2006
Found it... While trying to fix this problem, I had inadvertenly cleared the Security collection of the SoapRequestHeader, so that the other two fixes didn't seem to work... Well, they did work, after removing that statement.

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