ASP.NET

Re: OnSelectedNodeChanged Event of Trevview in ASP.net

24-Oct-07 3:13

Thanks for reply

Jintal Patel24-Oct-07 3:47

Jintal Patel

24-Oct-07 3:47

hi
you get the solution or not

Jintal Patel

How can i store entire path of a file which has uploaded through asp.net upload control

yogesh_softworld12324-Oct-07 1:19

yogesh_softworld123

24-Oct-07 1:19

How can i store entire path of a file which has uploaded through asp.net uploadfile control?.
i want to store in sql database entire path of a uploaded file.
plz help me

yogesh

Re: How can i store entire path of a file which has uploaded through asp.net upload control

N a v a n e e t h24-Oct-07 1:31

N a v a n e e t h

24-Oct-07 1:31

Do you know where you saved the file in server ?

My Website | Ask smart questions

Re: How can i store entire path of a file which has uploaded through asp.net upload control

Spunky Coder24-Oct-07 1:34

Spunky Coder

24-Oct-07 1:34

FileUpload1.PostedFile.Name gives the entire path of the file in client machine...but this works only in IE in firefox or any other browser u will get only the file name ...

But why do u want to store entire path of the file when located in client's machine? When a file is uploaded u will save it at server and hence store the serverpath of the filename

Koushik

Re: How can i store entire path of a file which has uploaded through asp.net upload control

Guffa24-Oct-07 9:15

Guffa

24-Oct-07 9:15

Why? That path only makes sense on the client computer, the server can't use it for anything.

Some browsers doesn't return the comple path, and some antivirus/firewall software removes the complete path, so there is no guarantee that you will even get the complete path to the server.

---
"Anything that is in the world when you're born is normal and ordinary and is just a natural part of the way the world works. Anything that's invented between when you're fifteen and thirty-five is new and exciting and revolutionary and you can probably get a career in it. Anything invented after you're thirty-five is against the natural order of things."
-- Douglas Adams

Copy/Paste Functionality with GridView in ASP.net

Learning ASP.NET24-Oct-07 1:02

Re: Copy/Paste Functionality with GridView in ASP.net

24-Oct-07 1:02

Hello,

i want to allow users to copy an entire row from excel, and then with one "ctrl+v", this row will be pasted to a gridview in my web app. is this possible?

Thanks in Advance.

SHatchard24-Oct-07 1:05

SHatchard

24-Oct-07 1:05

You could provide a textbox which you can paste the row into which can then be processed and added to the gridview, the input of the textbox could easily be split at vbTab.

Re: Copy/Paste Functionality with GridView in ASP.net

Learning ASP.NET24-Oct-07 1:08

Implementing Copy/Paste functionality from Excel shhet to GridView in asp.net

24-Oct-07 1:08

Thanks for eary reply.
But i want to copy the row from Excel of 3 columns and i want to paste on gridview it exactly shows the row of 3 columns.

Learning ASP.NET24-Oct-07 0:48

DDL and selected item identity

24-Oct-07 0:48

Hi,

I have following requirements. User can copy/Paste contents from excel sheet to ASP.NET gridview control. I have a custom grid view control. How can i do this.

Can someone throw some idea how can i implement this with some design/code etc.

Thanks in advance

Sarfaraj Ahmed24-Oct-07 0:24

24-Oct-07 0:24

Hello Everybody

Table name dbo.Category in SQL SERVER 2005 and DropDownList name ddlCategory on my asp.net page.

ddlCategory.DataTextField = "CATEGORY NAME" (which is coming from SQL SERVER 2005)

how can i get ddlCategory selected item identity? (without write function, like function getCategoryID( categoryname as string) as integer)

waiting for your reply

Sarfarj Ahmed

John-ph24-Oct-07 0:37

24-Oct-07 0:37

before doing DataBind set the DataValueField of the DropDownList.
ddlCategory.DataValueField = "CategoryID".

Get the value of Selected Item Using
ddlCategory.SelectedValue

Regards
- J O H N -

Sarfaraj Ahmed24-Oct-07 0:54

24-Oct-07 0:54

This is my code,
I put your code but cant bind the data, could please have a look and please tell me what should i do

Protected Sub ddlCategory_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlCategory.Init<br />
        Dim conn As SqlConnection = New SqlConnection(Web.Configuration.WebConfigurationManager.ConnectionStrings("OxfordLibrary").ConnectionString)<br />
        Dim queryString As String = "SELECT CATEGORYNAME AS 'CATEGORY NAME' FROM BOOKSCATEGORY ORDER BY CATEGORYNAME ASC"<br />
        Try<br />
            conn.Open()<br />
            Dim comm As SqlCommand = New SqlCommand(queryString, conn)<br />
            Dim adapter As SqlDataAdapter = New SqlDataAdapter(comm)<br />
            Dim ds As DataSet = New DataSet()<br />
            ds.Clear()<br />
            adapter.Fill(ds)<br />
<br />
            ddlCategory.DataSource = ds<br />
            ddlCategory.DataTextField = "CATEGORY NAME"<br />
            ddlCategory.DataBind()<br />
<br />
            ddlCategory.Items.Insert(0, New ListItem("Select One..", "Value"))<br />
<br />
<br />
            conn.Close()<br />
        Catch ex As Exception<br />
<br />
            conn.Close()<br />
        End Try<br />
    End Sub

Sarfarj Ahmed

John-ph24-Oct-07 1:01

24-Oct-07 1:01

Sarfaraj Ahmed wrote:
Dim queryString As String = "SELECT CATEGORYNAME AS 'CATEGORY NAME' FROM BOOKSCATEGORY ORDER BY CATEGORYNAME ASC"

CategoryID missing in the Select Query.

Regards
- J O H N -

Sarfaraj Ahmed24-Oct-07 1:24

24-Oct-07 1:24

im writing code

ddlCategory_init()

should i changed it to
ddlCategory_SelectedIndexChanged()
or
ddlCategory_textchanged()

Sarfarj Ahmed

Sarfaraj Ahmed24-Oct-07 1:17

24-Oct-07 1:17

Im geting CategoryID = select one..

Dim queryString As String = "SELECT CATEGORYID, CATEGORYNAME AS 'CATEGORY NAME' FROM BOOKSCATEGORY ORDER BY CATEGORYNAME ASC"<br />
        Try<br />
            conn.Open()<br />
            Dim comm As SqlCommand = New SqlCommand(queryString, conn)<br />
            ' Dim dataReader As SqlDataReader = comm.ExecuteReader()<br />
            Dim adapter As SqlDataAdapter = New SqlDataAdapter(comm)<br />
            Dim ds As DataSet = New DataSet()<br />
            ds.Clear()<br />
            adapter.Fill(ds)<br />
            ddlCategory.DataSource = ds<br />
            ddlCategory.DataTextField = "CATEGORY NAME"<br />
            ddlCategory.DataValueField = "CategoryID"<br />
            _CategoryID = ddlCategory.SelectedValue<br />
            ddlCategory.DataBind()<br />
            ddlCategory.Items.Insert(0, New ListItem("Select One..", "Value"))<br />
<br />
<br />
            conn.Close()<br />
        Catch ex As Exception<br />
<br />
            conn.Close()<br />
        End Try

Sarfarj Ahmed

John-ph24-Oct-07 1:25

24-Oct-07 1:25

The problem is not with the DropDownList. You better find a Good ASP.NET book to quickly learn the basics.

Regards
- J O H N -

Sarfaraj Ahmed24-Oct-07 1:37

24-Oct-07 1:37

Very Strong Answer
Thanks

Sarfarj Ahmed

John-ph24-Oct-07 1:41

24-Oct-07 1:41

Sarfaraj Ahmed wrote:
Very Strong Answer

Intensely Practical solution.

Sarfaraj Ahmed wrote:
Thanks

You're Welcome.

Regards
- J O H N -

Sarfaraj Ahmed24-Oct-07 1:49