ASP.NET

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

scrollbar on top of the page...,

24-Oct-07 1:49

Thanks John
I am really really sorry. I didnt get you from the very first time. Now I got my own answer.

Thanks For Your Help
Im going to give you maximum point.

Sarfarj Ahmed

Member 387988124-Oct-07 0:22

Member 3879881

24-Oct-07 0:22

Hi I need scrollbars on top of my page also...,
How to do that?,

Regards,
Magi

Re: scrollbar on top of the page...,

Fred_Smith24-Oct-07 0:53

Fred_Smith

24-Oct-07 0:53

Write your page upside down then turn your monitor upside down as well. Big Grin | :-D

iam not getting minimize button in label in debugging

jagadeeshkumar198424-Oct-07 0:22

jagadeeshkumar1984

24-Oct-07 0:22

iam working on web parts .i kept the label in webpartzone .after debugging iam not getting the minimize button (down arrrow in the label)how can i resolve this problem

getting change forecolor depend on if statement

VinothRao24-Oct-07 0:04

VinothRao

24-Oct-07 0:04

hi,

i got the below code in my page.

protected string ConvertPercent(object number)
{
if (number == DBNull.Value)
return "-";
else
if (number.ToString().StartsWith("-"))
{
ChangePercent1.ForeColor = Color.Red;
return String.Format("{0:F}", number);
}
else
ChangePercent1.ForeColor = Color.Black;
return String.Format("+{0:F}", number);
}

but it seems i getting an error saying
"Object reference not set to an instance of an object"

The ChangePercent1 was initialize using
public System.Web.UI.WebControls.Label ChangePercent1;

BUT still errors persists. Please help me.....
Thx.

Re: getting change forecolor depend on if statement

Christian Graus24-Oct-07 0:21

24-Oct-07 0:21

What a disaster.

Why are you using ToString ? Why are you passing an object ?

If number == null, this code will give that error. If you're using .NET 2.0, I'd suggest passng an int?, checking for null, then using if number < 0 instead of a tostring call that may not work for all locales and is needlessly expensive.

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 )

Speed

mihksoft23-Oct-07 23:51

mihksoft

23-Oct-07 23:51

Hy I have a site on a host for ASP.NET.
I have a file with 30000 records.
I have a .mdf file with a table with 30000 records.

Method 1

I read from file a record and diplay in a label.

Label1.Text = File.ReadAllLines(Server.MapPath("~/fisier.txt"),Encoding.UTF8)[index];

Method 2

I read from .mdf file from my table the same record.

Can tell me witch of the 2 method is faster?

thx

Re: Speed

Christian Graus23-Oct-07 23:52

Upload a file to database

23-Oct-07 23:52

Probably the second, but both are a disaster, obviously.

Well, readalllines returns a string[] as I recall, so it won't compile. ReadAllText is probably faster than the database solution, as it mindlessly reads and passes a single string.

This does NOT mean that flat files are faster than databases.

Re: Speed

Guffa24-Oct-07 2:34

Guffa

24-Oct-07 2:34

Method 2 is by far the most efficient. A specific record in the table can be accessed directly without having to read all of them.

The ReadAllLines method will read the entire file and create an array that contains 30000 string objects. The memory used for this will be approximately double the file size, plus 120 kB for the array object itself.

A less wasteful method to read the file would be to use a StreamReader to read line by line until you reach the line you want. That will not create a huge array in memory, and you don't have to read the entire file.

---
"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

mukesh.mr0323-Oct-07 23:48

mukesh.mr03

23-Oct-07 23:48

hi i want to save a file to server. this is the code i'm using in my project.

if ((FileUpload1.PostedFile != null) && (FileUpload1.PostedFile.ContentLength > 0))
{
string fn = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
string SaveLocation = Server.MapPath("Data") + "\\" + fn;
try
{
FileUpload1.PostedFile.SaveAs(SaveLocation);
Response.Write("The file has been uploaded.");
}
catch (Exception ex)
{
Response.Write("Error: " + ex.Message);
//Note: Exception.Message returns detailed message that describes the current exception.
//For security reasons, we do not recommend you return Exception.Message to end users in
//production environments. It would be better just to put a generic error message.
}
}
else
{
Response.Write("Please select a file to upload.");
}

'Data' is afolder in the server. iwant to store the file in that folder. but its not working properly. its showing a config error while running. is there any additional settings needed?

Christian Graus23-Oct-07 23:51

23-Oct-07 23:51

mukesh.mr03 wrote:
Server.MapPath("Data") + "\\" + fn;

Why not use Path.Combine ?

What error ?

mukesh.mr0323-Oct-07 23:57

mukesh.mr03

23-Oct-07 23:57

what you mean by Path.Combine. Can you please send me some sample codes for this?

this is the error while running the application:

Runtime Error
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customerrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customerrors> tag should then have its "mode" attribute set to "Off".

<configuration>
<system.web>
<customerrors mode="Off">

Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customerrors> configuration tag to point to a custom error page URL.

<configuration>
<system.web>
<customerrors mode="RemoteOnly" defaultredirect="mycustompage.htm">

Christian Graus24-Oct-07 0:33

24-Oct-07 0:33

If you read the error, it's telling you to change our config so that you can see the actual error.

Path.Combine is in System.IO and will turn two strings into a single path.