Re: Problem deleting selected value from dropdownlist - ASP.NET Discussion Boards

I was being sarcastic.....

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 )

Guess he didn't get the memo Laugh | :laugh:

only two letters away from being an asset

Hi Guy

I think we want do fast work for that, becuase if when he select a item from the dropdownlist and process delete command, he wihs's delete from the database, so we must bind data again to dropdownlist, so i thought we reduce the time for the operation since, suggest AJAX update panel.

Just use ad tell me, how about applciation perfomance this operation

Cheers
RRave
MCTS,MCPD

The time it takes to perform the operation will not be reduced by using an UpdatePanel!!

only two letters away from being an asset

Hi Guy

i told not loading and getting and binding operation time man, i told page refresh and data show time. means, if u use update panel, postback time is very very less.

Cheers
RRave
MCTS,MCPD

Ravenet wrote:
i told page refresh and data show time

No, you said

Ravenet wrote:
if you put in the updatepanel, doesn't take much more time for this operation.

With only 2.5 years you obviously don't have "excellent experience in programming" or "excellent knowledge...with all other MS related languages and databases"

only two letters away from being an asset

Hi Man

i said about loading time . not data transfer time

Cheers
RRave
MCTS,MCPD

Hello Mr. Rave

I am not a very good programmer, just tryied following code but its not working.

when ever I am pressing delete button after selecting a value in dropdownlist, it just deleting the top most value.
--------------------------------------------------------------------------
C# CODE:
--------------------------------------------------------------------------

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

public partial class newDeleteValueDDList : System.Web.UI.Page
{
OleDbConnection cn;
OleDbCommand cmd;
DataSet ds;
OleDbDataAdapter da;

protected void Page_Load(object sender, EventArgs e)
{
getData();
}
protected void Button1_Click(object sender, EventArgs e)
{
connectDatabase();

string str = DropDownList1.SelectedValue;
string strDelete = "delete state from tblState where state='" + str + "'";
cmd = new OleDbCommand(strDelete, cn);
cmd.ExecuteNonQuery();
cn.Close();
getData();

}
private void connectDatabase()
{
string strConnectionString = Server.MapPath("~/App_Data/dummyDb.mdb");
cn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=" + strConnectionString);
cn.Open();
}
private void getData()
{
connectDatabase();

string strSelectState = "select state from tblState order by state";
da = new OleDbDataAdapter(strSelectState, cn);
ds = new DataSet();
da.Fill(ds);

DropDownList1.DataSource = ds.Tables[0];
DropDownList1.DataTextField = "state";
DropDownList1.DataValueField = "state";

DropDownList1.DataBind();

cn.Close();
}
}

-------------------------------------------------------------------------
DESIGN SOURCE:
-------------------------------------------------------------------------
<body>
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="DropDownList1" runat="server">
</asp:DropDownList>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Delete" /></div>
</form>
</body>
--------------------------------------------------------------------------
ACCESS DATABASE:
--------------------------------------------------------------------------
ID STATE
-- -----
10 AAA
20 BBB
30 CCC
40 DDD
--------------------------------------------------------------------------

I am sending the relevent db and code which has been used in my code

If anybody can help I will be grateful to him.

Thanks
wajid

Are you certain that DropDownList1.SelectedValue is correct?

Since ID appears to be a unique key in the table structure use that for the value. This eliminates the need to pass strings around and do string comparisons. It also guards against deleting multiple rows with duplicate state values.

DropDownList1.DataValueField = "ID";

int id = Convert.ToInt32(DropDownList1.SelectedValue);
string strDelete = "delete state from tblState where ID=" + id + ";

only two letters away from being an asset

Hi Mark

Thanks for your help.

But still its giving same problem.

Thanks Again
Wajid

string strDelete = "delete ~~state~~ from tblState where ID=" + id + ";

only two letters away from being an asset

Hi Mark

Same old problem, Its not working.
But thanks for your suggestion.

Thanks
Wajid

i want to execute the text written in text box
e.g
i have a function
public void func(string s)
{
}

what i want to achieve is if i write
func("waheed")
in the textbox this function should be called on clicking a button

i cant use if/case etc
my requirement is this the textbox text will be passed to another function where this text will execute as code
Thanks

waheed awan wrote:
i want to execute the text written in text box
e.g
i have a function
public void func(string s)
{
}

what i want to achieve is if i write
func("waheed")
in the textbox this function should be called on clicking a button

If you want this on javascript try the below on the onclick event of the button, (OnClientClick, if it is a Server Side button)

func(document.getElementById('MY_TEXTBOX').value)

If you want the above in ASP.NET, double click button, it will take you to the code behind, where you can try the below code in the Button Click event,

func(MY_TEXTBOX.Text);

Here MY_TEXTBOX is the ID of the textbox you mentioned

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

modified on Tuesday, February 12, 2008 9:52 PM

document.getElementById returns an object. How will this work in your example?

only two letters away from being an asset

It should be

func(document.getElementById('MY_TEXTBOX').value);

Thanks Marks for pointing out.

[Venkatesh Mookkan]
My: Website | Yahoo Group | Blog Spot

First, it isn't a very smart idea to try executing arbitrary code entered from a textbox.

If you want to do this on the client-side you need to use the eval function. http://www.w3schools.com/jsref/jsref_eval.asp[^]

On the server-side you can try using CodeDOM http://msdn2.microsoft.com/en-us/library/y2k85ax6.aspx[^] However, it is VERY, VERY dangerous to try compiling code input from a textbox. Don't even think about it, try something else.

only two letters away from being an asset

THANKS
the arical you gave me reference is very helpful and it solved another problem that i was facing
but here my problem is
as i write
func("vaue"); in the cs file the function is called

what i want to achieve is when i write
func("vaue"); in the textbox then on clicking the button the textbox should be executed

waheed awan wrote:
then on clicking the button the textbox should be executed

I don't understand what you are asking for here. Confused | :confused:

Do you want something like; func("Console.WriteLine("Hello, World");" ) which causes "Hello, World" to be written to a console window? Confused | :confused:

only two letters away from being an asset

i want to say
the textbox will be used to write code statements and clicking the button will execute the statement written in the textbox

Example;
if in the textbox i write
MessageBox.Show("Hello");
then clicking the button executes the statement in the textbox in this case display a messagebox

Then read my previous response about CodeDOM, and the warning that this is VERY dangerous thing, don't do it, think of another way.

only two letters away from being an asset

THANKS
the arical you gave me reference is very helpful and it solved another problem of adding a class that i was facing
but here my problem is
as i write
func("vaue"); in the cs file the function is called

what i want to achieve is when i write
func("vaue"); in the textbox then on clicking the button the textbox text should be executed

Im my online photo album i have three tables categories, pictures, and comments
only logged in people can post or edit or leave comments. I also have a chat room that only logged on users can chat on. When you sign up for an account you add name ..password,ect,ect, and an Email address. Now here is my question, I want to have a link or button click that would say leave message..to the person that posted the pic.
What table would the Email go in the pictures or the comments,or would I need a fourth
table?
Any help on this would be greatly appreciated. I seen a working example of this at
Plenty of fish .com you click on a pic after you create an account and you will see the send message button. But you never see the persons email. I would like this but am sure i am not smart enough yet on this matter
Sincerly
Paul quinn

I'd imagine that the logical thing would be that a users email address is part of the table that stores login information, and the id of the user who sent the photo would be stored in the table with the photos. So, you'd use the Id to look up the email address in the other table.

This is really a SQL question.

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 )

Hi,
I have a development and testing environment. I have set the the following on my web.config file:

authentication mode="Windows"
identity impersonate="true"

And I'm trying to list directories and its subfolders and files from a different file_server/shared on my page.

In my development environment, it is working fine. I was able to see the folders and files, but in the testing it is giving me:

System.UnauthorizedAccessException: Access to the path "file_server/shared" is denied.

On both development and testing IIS, I have the "Integrated Windows authentication" checked only. I granted "Everyone" and "Authenticated Users" read only to the file_server/shared. My codes are exactly the same on both environments. I'm also able to get the "WindowsIdentity.GetCurrent.Name" on both environments.

I'm totally puzzled. Can anyone help me on how to troubleshoot this?

Thank you very much
May