WEBSITE MONITORING:REQUEST:URGENT PLZZZZZZ - ASP.NET Discussion Boards

auto upload/export of a downloaded CSV file to SQLSERVER on the server

amitcoder8310-Jul-06 19:55

10-Jul-06 19:55

my application is actually a web application where i manually upload CSV file to the database.but i want to automate the process,so i have thought of a second stage to this application i.e through a windows application i would download the CSV file from the NSEIndia.com site automatically and then upload the same to SQLServer on the server.i am facing a problem with upload i.e exporting the data to the database.it would be a great help to me if any one could provide me a solution either in VB.Net code or C# code.

AMIT(TATA CMC)

Re: auto upload/export of a downloaded CSV file to SQLSERVER on the server

Saifi Hasan11-Jul-06 2:51

Saifi Hasan

11-Jul-06 2:51

You need to programaticcaly involke DTS package.
for this you need to add 3 COM object references

1. Microsoft DTS Custom Task Object Lib
2. Microsoft DTSDatapump scripting object
3. Microsoft DTS Package object lib

once you do this i suggest u to use import / export wizard to import data and save package in VB file.
once you open this VB file you will be abl to under stand how to use object of above mention references

Nobody is perfect i'm Nobody

save image in database and show all images in control from database [modified]

srinandan..10-Jul-06 19:52

srinandan..

10-Jul-06 19:52

Hi all

i wants to save the images with name in database.i want to bind the images and imagename with control to show in list .

please send the code.

Best Regards,
srinandan

Re: save image in database and show all images in control from database

Paul Conrad25-Jul-06 9:23

Paul Conrad

25-Jul-06 9:23

Not that hard to do yourself.

srinandan.. wrote:
please send the code.

Nope. Look at my sig Smile | :)

I'd like to help but I am too lazy to Google it for you.

Insert comment in Excel sheet with Asp.net

mhemant10-Jul-06 19:50

mhemant

10-Jul-06 19:50

I want to show data in comments in excel sheet and worksheet will be created in asp.net

Thanks in Advance

Design Question

smarttom9910-Jul-06 18:25

smarttom99

10-Jul-06 18:25

I've been developing with c# and forms and I use the Split Container heavily because it automatically resizes when in full-screen. What is the recommendation with asp.net to accomplish this? What control should I use to lay out the various panels on the screen.

Re: Design Question

Paddy Boyd10-Jul-06 22:09

Paddy Boyd

10-Jul-06 22:09

It's not maybe a question of controls - there are a number of ways of laying out a web page - you might want to have a look at www.csszengarden.com[^] or http://www.alistapart.com/[^].

There are many more things to think about when laying out a web form (e.g. cross browser capability) than when laying out a win form.

Hope that helps. Wink | ;)

WEBSITE MONITORING:REQUEST:URGENT PLZZZZZZ

Devi C10-Jul-06 18:03

Devi C

10-Jul-06 18:03

HI,

We are developing one application in ASP.NET to monitor web sites which is running in the server(WEB SERVER).we need to monitor single URL and also sequence URL to know the status of server,when the server is getting down.If server is getting down means we need to send SMS alert Message to Adminstartor.Kindly any one can help me how to proceed in technically.I am new to this topic.Plz suggest some technical guidence.If you post any articals means its help full to me to know.PLZ its very urgentttttttttttttttttttt.Kindly help me.THANKS IN ADVANCE

DeviChella

VCalendar in C#

B Desai10-Jul-06 12:59

B Desai

10-Jul-06 12:59

Hi everybody,
Is there any way to implement VCalendar using C# in asp.net? I have List of events in datagrid, in which i am showing only dates in the datagrid.when someone click on a row in datagrid, it will display the details for that date's event in tabular format using a javascript function on a same page.I have one hyperlink to add that details in the microsoft outlook. when some one click on that hyperlink, the displayed event will be added to the outlook.I am very confuse with this as I am implementing first time.
If any body can help me with some code, it will be great for me.
Thank you very much.
Robin

Unmangle DLL name in DotNetNuke

wildfiction10-Jul-06 11:29

wildfiction

10-Jul-06 11:29

I'm trying to compile a module that I've written for DotNetNuke. (Actual I have compiled it without problem.)

When I generate the web site the DLL for that module has a wacky mangled name. Is there anyway to tell the compiler (VS2005) what the name of the DLL should be for a module that you are compiling? (For any cs or vb file that you're compling...)

Thanks

3D Dynamic Virtual Tour

DaViL8310-Jul-06 9:37

DaViL83

10-Jul-06 9:37

Hi there.

I've created a 3D dynamic virtual tour with asp.net/atlas (editor) and java3d.
Please post your impressions!

To show go here: http://davil.exent.it/virtualtour

here a preview: http://davil.exent.it/virtualtour/preview.jpg

Thanks for your impressions!

DaViL

Re: 3D Dynamic Virtual Tour

DaViL8311-Jul-06 2:47

DaViL83

11-Jul-06 2:47

...

Drop down list not populating [modified]

leckey10-Jul-06 9:35

leckey

10-Jul-06 9:35

I have a drop down list (not attached to my datagrid anymore for those of you on the saga with me). I just want to populate this plain old drop-down box. But I can't get it to populate. I could get it to populate when I had it inside a datagrid, so I'm sure it's something easy.

Here is my asp code:

<asp:dropdownlist id=ddPartType style="Z-INDEX: 101; LEFT: 104px; POSITION: absolute; TOP: 48px" tabIndex=1 runat="server" Width="144px" Height="24px" DataSource="<%# GetPartTypes()%>" DataTextField="ptDescription" DataValueField="ptId" EnableViewState="True" AutoPostBack="True"><br />
			</asp:dropdownlist>

All I'm doing is calling GetPartTypes. Okay, here's that code (C#)

public DataSet GetPartTypes()<br />
		{<br />
			ds3 = new DataSet();<br />
			ds3= SqlHelper.ExecuteDataset(this.connectionString, "dbo.GetDescriptions", null);	<br />
			dt3 = ds3.Tables[0];<br />
			ds3.Tables[0].TableName="PartTypes";<br />
			ddPartType.DataSource = ds3;<br />
			ddPartType.DataBind();<br />
			return ds3;<br />
<br />
		}

This calls a stored procedure, GetDescriptions. I know this code works because it executes in Query Analyzer. It's just basically return the descriptions and order by description.

Going through the debugger it's like the code never gets called. So I delibrately called it in PageLoad and got a stack overflow.

BLECH!

Follow up: Okay I can get it to populate if I put the code in the PageLoad. Is this the only way to do it? Or is there something similiar to what I was trying to do?

-- modified at 16:09 Monday 10th July, 2006

Re: Drop down list not populating

Not Active10-Jul-06 11:51

Not Active

10-Jul-06 11:51

Remove DataSource="<%# GetPartTypes()%>"

When you assign the datasource in the page load it is trying to bind to the method you have defined, which again calls DataBind, which again calls this method, which...see where the stack overflow comes in?

Re: Drop down list not populating

postmaster@programmingknowledge.com10-Jul-06 17:47

postmaster@programmingknowledge.com

10-Jul-06 17:47

Find an example at http://www.programmingknowledge.com/dataControl.aspx[^]

Use of query strings

leckey10-Jul-06 5:55

leckey

10-Jul-06 5:55

I want to change my session variable to a query string but not finding a lot of info on actually how to program them.

On page 1 of my asp.net application the user enters a part number in a textbox. So I have:

strPartNumberInputReference = txtSearchPart.Text;<br />
Session["ptNum"] = strPartNumberInputReference;

On subsequent pages I call:
partNumber2 = Session["ptNum"].ToString();

So if I want to use a query string do I just change the first page to:

strPartNumberInputReference = txtSearchPart.Text;<br />
strPartNumberInputReference = Request.QueryString["strPartNumberInputReference"]

So 2 questions:
1. Am I writing the above correctly?
2. How do I call in subsuquent pages?

Thanks!

Re: Use of query strings

Paddy Boyd10-Jul-06 6:06

Paddy Boyd

10-Jul-06 6:06

No.

<br />
strPartNumberInputReference = txtSearchPart.Text;<br />
<br />
response.Redirect(url & "?strPartNumberInputReference=" & strPartNumberInputReference )<br />

Re: Use of query strings

leckey10-Jul-06 6:10

leckey

10-Jul-06 6:10

So how do I use it in subsequent pages?
Do I just declare strPartNumberInputReference again or do I use:
strPartNumberInputReference = Request.QueryString["strPartNumberInputReference"];

Thanks for your help!

Re: Use of query strings

Paddy Boyd10-Jul-06 6:11

Paddy Boyd

10-Jul-06 6:11

Option 2. Web pages are stateless by default, so you are just passing your parameter, as a string in the url, that is all. It's very different from the way that session works.

Re: Use of query strings

leckey10-Jul-06 7:04

leckey

10-Jul-06 7:04

Okay, trying to do the response redirect:

Response.Redirect ("...Pages/Add_Weight.aspx" & "?strPartNumberInputReference=" & strPartNumberInputReference );

Getting a compiler error: "Operator '&' cannot be applied to operands of type 'string' and 'string'

What am I doing wrong?

Re: Use of query strings

eggsovereasy10-Jul-06 7:21

eggsovereasy

10-Jul-06 7:21

<br />
Response.Redirect ("...Pages/Add_Weight.aspx"?strPartNumberInputReference=" + strPartNumberInputReference );<br />

Re: Use of query strings

eggsovereasy10-Jul-06 7:23

eggsovereasy

10-Jul-06 7:23

& is a bitwise AND

Re: Use of query strings [modified]

leckey10-Jul-06 7:46

leckey

10-Jul-06 7:46

Okay, there are only three quotations in your code. Still getting compiler error. Tried as you wrote and said ; and ) expected. Tried the following:
Response.Redirect ("...Pages/Add_Weight.aspx"?strPartNumberInputReference=" + strPartNumberInputReference" ); and got ) expected.

Am I missing parenthesis or is it the quotes?
THANK YOU!

Okay, got it to work with the following:
Response.Redirect ("Add_Weight.aspx?strPartNumberInputReference=" + strPartNumberInputReference);

Had an extra quotation. Hopefully I won't have any more problems!

-- modified at 14:15 Monday 10th July, 2006

Scrolling Issue in component Art grid

MaheshSharma10-Jul-06 5:40

MaheshSharma

10-Jul-06 5:40

I have a component art grid inside user control. how do i set the vertical and horizontal scrolling if it can exceed the page size. Allowhorizontalscrooling and scroolbar="auto" property not works in that

can any one please help me

thanks
mahesh

need help with server address? used on my webpage

keroed_edmond10-Jul-06 5:29

keroed_edmond

10-Jul-06 5:29

i created an application that streams from a server but my problem is on my server there quiet a few drives for eg drive m,u,f,g,h right and lets say my ip for my server is 123.34.0.1 for arguements sake right

1. i have some audio on the u drive and i want to retrieve it how would i do this???

i tried http://123.34.0.1/recordings/ken.wav................i tried that since the ken.wav is located on u:/recordings/ken.wav

kenny

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