Re: Set Frame - ASP.NET Discussion Boards

import all Outlook Contacts into my Sql table

Member 38798815-Dec-07 17:04

5-Dec-07 17:04

Hi ,i have to import all Outlook Contacts into my Sql table via asp.net,
Its possible ?,plz if anyone have idea abt that plz share with me,

Thanks & Regards,
Mageshh,
please don't forget to vote on the post

Re: import all Outlook Contacts into my Sql table

Sathesh Sakthivel5-Dec-07 17:11

Sathesh Sakthivel

5-Dec-07 17:11

Reading a list of contacts from an Access database which has been exported from Outlook, and importing a comma separated CSV file into the same Access database of contacts.

We’ll be using the built in OleDb data classes for database connectivity and some fairly complex DataSet and DataTable manipulations to accomplish our importing from the CSV file.

Get it here for more details.

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

Cannot implicitly convert type 'object[]' to 'System.Collections.ArrayList

samy1005-Dec-07 16:49

samy100

5-Dec-07 16:49

Hi,

i am trying to use in my client application a web service that retuurns an arrylist.

this is my code

ArrayList b = new ArrayList();
b = newService.GetList();

when i try to compile it i get this message:
Cannot implicitly convert type 'object[]' to 'System.Collections.ArrayList

what is the problem? how can i get the array list from the webservice?

thanks

Re: Cannot implicitly convert type 'object[]' to 'System.Collections.ArrayList

Christian Graus5-Dec-07 17:26

Christian Graus

5-Dec-07 17:26

The problem is that you are returnin an object[] and you need to convert or cast it.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Cannot implicitly convert type 'object[]' to 'System.Collections.ArrayList

ReactiveX5-Dec-07 20:57

ReactiveX

5-Dec-07 20:57

Your GetList() function in your web-service hasn't been defined properly. Make sure that the return type is an ArrayList

public System.ArrayList GetList()
{
}

Daniel Minnaar
Lead Software Developer

Re: Cannot implicitly convert type 'object[]' to 'System.Collections.ArrayList

samy1006-Dec-07 4:07

samy100

6-Dec-07 4:07

this is my webservice:

[WebMethod]
public ArrayList GetDevicesList()
{
Hashtable DeviceList = new Hashtable(10);
for (int i = 0; i < 10; i++)
{
DeviceList.Add("test"+i.ToString(),"test");
}

ArrayList a = new ArrayList();
a.Add(DeviceList);
return a;
}

of course my hash table will later be set with real values, but for now i am just testing my architecture.

so it does return ArrayList.
how can i use it from my client?

Set Frame

AnhTin5-Dec-07 16:38

AnhTin

5-Dec-07 16:38

hi all
I have 3 frame in page asp.net

When i debug the frame ifmap run fist in and run to in page_load in map.aspx

How can i set frame ifmap2 run fist so dont change position iframe ???

Re: Set Frame

boy.pockets5-Dec-07 18:20

boy.pockets

5-Dec-07 18:20

This is a bit of a hack, but...

page_Init will run before page_Load. So if you do your stuff for ifmap2 in its page_init and your stuff for ifmap in its page_Load the order will be as you have requested.

User Accounts

Ken Mazaika5-Dec-07 13:17

Ken Mazaika

5-Dec-07 13:17

Hi,

I'm making a website in ASP.NET (C#) that handles users. How do I store data specific to the user's connection. I got it working using static variables, but it turns out that all users have the same values for static variables (which makes sense now that I think about it).

How can I "remember" the user id of someone who logged in and not have it mix up other users? I know I could do it by using a static hashtable of userids and ipaddresses but I feel like this is probably a more complicated solution than it needs to be.

I know this is probably a pretty common question, and I'm sorry if its been asked before. Any response would be helpful though. Thanks,

Re: User Accounts

Christian Graus5-Dec-07 14:16

Christian Graus

5-Dec-07 14:16

Most people do not have static IP addresses. You would expect to have a database of usernames and passwords and then store who is logged in, in the session.

Re: User Accounts

Ken Mazaika5-Dec-07 16:26

Ken Mazaika

5-Dec-07 16:26

thanks christian. the word 'session' was what i was looking for. I appreciate it...thanks a lot man,

-ken

Implementing asp:CreateUserWizard

AghaKhan5-Dec-07 13:04

AghaKhan

5-Dec-07 13:04

I am just working with ASP.NET 2.0 and started first chapter Online Diary project. The first page contains asp:CreateUserWizard control. For some reasons it does not work properly. So I created my own test website and add that control. It is the same result. I entered more than 7 characters with at-least on numerical character but I get the same reply “Password length minimum: 7. Non-alphanumeric characters required: 1.”. Does someone know what is going on? If I want to test the password with database how can I retrieve the password? How to remove some of the controls from wizard? Your help will be very much appreciated.

Cry | :((

how to write code to download file

uowzd015-Dec-07 11:48

uowzd01

5-Dec-07 11:48

i am trying to export a excel file to the user when they click a button, i tried Response.WriteFile("filename"), it only display the content in the same page, can someone tell me whats the code to prompt them with a save as option? Thank you in advance.

Re: how to write code to download file

Christian Graus5-Dec-07 12:09

Christian Graus

5-Dec-07 12:09

You need to set the content type to be application/zip and then it will come back as a download.

Re: how to write code to download file

Sandeep Akhare5-Dec-07 19:31

Sandeep Akhare

5-Dec-07 19:31

Another way is to add the file in header of the response

<br />
tring filename = "YourFileName.xls";<br />
<br />
if (filename != "")<br />
{<br />
<br />
string path = Server.MapPath(filename);<br />
<br />
System.IO.FileInfo file = new System.IO.FileInfo(path);<br />
<br />
if (file.Exists)<br />
{<br />
<br />
Response.Clear();<br />
<br />
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);<br />
<br />
Response.AddHeader("Content-Length", file.Length.ToString());<br />
<br />
Response.ContentType = "application/octet-stream";<br />
<br />
Response.WriteFile(file.FullName);<br />
<br />
Response.End();<br />
<br />
}<br />
<br />
else<br />
{<br />
<br />
Response.Write("This file does not exist.");<br />
<br />
}<br />
<br />

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

GRIDVIEW: make cell visible only when checkbox is checked

allenpotter5-Dec-07 11:23

allenpotter

5-Dec-07 11:23

I have a gridview with two template fields and two data bound fields.
The two template fields are a checkbox and a textbox. My problem is I only want the textbox visible when the checkbox is checked.

I have been trying to do this with C# in code behind--but I am off to a bad start, this is new to me. Thanks in advance for any help.

My aspx code for the gridview columns is:

<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:CheckBox ID="chkSelect" runat="server" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="PSO" HeaderText="PSO" SortExpression="PSO" />
<asp:BoundField DataField="PSO_id" HeaderText="PSO_id" InsertVisible="False" ReadOnly="True"
SortExpression="PSO_id" />
<asp:TemplateField HeaderText="Percent">
<ItemTemplate>
<asp:TextBox ID="percentEntered" Width="40px" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>

solarthur015-Dec-07 7:22

solarthur01

5-Dec-07 7:22

i have sucessfully created a login system that enables users to register and login using visual studion 2005. It works fautlessly on the local machine. However when i run it remotely i get an error. the details of the error are not displayed to me. It is obviously a problem with IIS configuration???? can anyone help please.

nested grid

wasimsharp5-Dec-07 6:55

wasimsharp

5-Dec-07 6:55

how can i create nested grid

wasim khan

Re: nested grid

Fred_Smith5-Dec-07 7:02

Fred_Smith

5-Dec-07 7:02

Try this....[^]

Re: nested grid

Member 38798815-Dec-07 17:09

Member 3879881

5-Dec-07 17:09

Hi u can do nested grid using template column...,
in that template column u can asign one more grid...,

Thanks & Regards,
Mageshh,
please don't forget to vote on the post

Re: nested grid

Sathesh Sakthivel5-Dec-07 17:28

Sathesh Sakthivel

5-Dec-07 17:28

Nested grid

SSK.

Anyone who says sunshine brings happiness has never danced in the rain.

User controls in IE - Runtime Security Policy / Code Groups

RichardGrimmer5-Dec-07 5:46

RichardGrimmer

5-Dec-07 5:46

Not sure if this is the right place exactly, but here goes...

We've coded up a component in the form of a .Net user control, embedded into IE. The control itself is to do with updating some stuff on the client machine.

During development, I managed to set up code groups etc using the Framework 2.0 config tool (which uses Caspol.exe behind the scenes). Basically, I set up a child group to the Local Intranet group under the Machine node, and alles ist gut at they say in Hamburg

Can you guess what's next? Precisely - moved to an external webserver, and despite setting up the codee groups "correctly", I'm not getting the control rendered to the page.

I've tried several approaches - Child group of the Internet zone, Top level group itself, Machine level, User level etc, but can't seem to find any combination of settings that works from the internet (Tried URL evidence and strong name evidence)

Anyone been able to set something like this up in the past, and if so, how the funk did you manage it hehe?

C# has already designed away most of the tedium of C++.

Performing Calulations Upon Data

Paul McGann5-Dec-07 5:37

Paul McGann

5-Dec-07 5:37

I have a small problem that i can't figure out:

I have a for loop that looks something like the:

for i=0 to rs.rows.count - 1

sqlstring = "Select * From [User] Where Age=" & i &"
rs2.open sqlstring, conn

for each x in rs2
Height = Height + rs.rows(x).items("Height")
next
'This is the part i'm having now i need to divide the height by the total number of rows this will hopefully give me the average height for people in that age group. This will then be inserted into a new Table with all the average heights.
Next

If anyone can see where I'm going wrong please can you help. Any advice is most appreciated.

Re: Performing Calulations Upon Data

J4amieC5-Dec-07 6:10

J4amieC

5-Dec-07 6:10

Oh god, you couldnt do this a worse way if you tried!

if you have a table called users with columns

<br />
Age INT<br />
Height FLOAT<br />

and you want to know the average height of 10 year old users you can do this with one query:

select AVG(Height) AS AverageHeight from Users WHERE Age=10

Re: Performing Calulations Upon Data

Paul McGann5-Dec-07 7:46

Paul McGann

5-Dec-07 7:46

This is exactly the code:

Dim oR1, SQL1
Dim oR2, SQL2
Dim XML

Set oR1 = Server.CreateObject("ADODB.Recordset")
Set oR2 = Server.CreateObject("ADODB.Recordset")

XML = "<graph caption="Output report" subcaption="By Quantity" decimalprecision="0" xaxisname="Age" yaxisname=" Height">"

SQL1 = "Select * From [User]"
Set oR1 = oConn.Execute(SQL1)

For i=1 to 100
SQL2 = "select AVG(Height) As AVGHeight, Age from [User] Where Age=" & i & "Group By Age"
Set oR2 = oConn.Execute(SQL2)

While Not oR2.Eof
XML = XML & "<set name="" & or2("Age") & "" value="" & or2("AVGHeight") & "" />"
oR2.MoveNext
Wend
Next

XML = XML & "</graph>"

But when I run this it gives me this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'Age' as part of an aggregate function.

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