ASP.NET

Re: Question about deleting multiple items at once ...

1-Sep-06 1:20

Hi
How we can allow deleting mulitple items at once.Assume we have a DataList web control that is populated with some items from database and we place a check box under each item.Then the user can select items using the checkboxes after that the user can click delete button to delete all selected items at once.How we can do this ? please tell me with nice details. I need to use this technique in a project soon. Please help me.

Thanks in advance

_AK_1-Sep-06 1:30

Re: Question about deleting multiple items at once ...

1-Sep-06 1:30

you can send the IDs of the rows in a comma separated file to your stored procedure and there using cursors you can delete the records separetely.

Best Regards,
Apurva Kaushal

devboycpp1-Sep-06 1:39

Re: Question about deleting multiple items at once ...

1-Sep-06 1:39

I dont know how to use cursors and I dont want to. I have a method in my data layer that lets me delete records one by one.My problem is how to retrieve those IDs please tell me.

_AK_1-Sep-06 1:44

Re: Question about deleting multiple items at once ...

1-Sep-06 1:44

you can get the IDs by iterating through all the rows and then checking whether they are selected or not. But in your case there will be so many round trips to database which will decrease the performance of yor application.

Best Regards,
Apurva Kaushal

devboycpp1-Sep-06 1:53

Re: Question about deleting multiple items at once ...

1-Sep-06 1:53

Can you show me how I can use cursor technique . Show me a Stored Procedure that gets a comma seperated list of IDs and delete the records using cursor.

_AK_1-Sep-06 2:02

Re: Question about deleting multiple items at once ...

1-Sep-06 2:02

here is the basic example for cursor:
http://www.eggheadcafe.com/PrintSearchContent.asp?LINKID=141[^]

and here the split function example:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=50648[^]

You can combine them and use it for your purpose.

Best Regards,
Apurva Kaushal

devboycpp1-Sep-06 2:43

Re: Question about deleting multiple items at once ...

1-Sep-06 2:43

Thanks for your help. In that cursor example it just uses cursor to fetch records.Can you please show me how to use cursor to delete records.How does it make sense ?

_AK_1-Sep-06 2:47

how to add .DWT template file in asp.net 1.0

1-Sep-06 2:47

Normally what happens in cursor is it fetches the record and do the operation. There in that example it is fetching the record and then printing some value. That is where you can do your delete operation.

Best Regards,
Apurva Kaushal

nabeelkhan1-Sep-06 1:14

nabeelkhan

1-Sep-06 1:14

hi all,
plz tell me i have a main template that i was made in macromedia dreamweaver and in this tempelate i have editable region that is filling from the database ,now i want to add this template in my asp.net page,plz tell me how can i add this template in my asp.net page.
if possible plz send me some code snippet that wud be great for me .
bst regards

Not able to read the value from App.config file

kumar sudhir11-Sep-06 0:54

kumar sudhir1

1-Sep-06 0:54

I want to read the security key value from App.config file. Below is the procedure which I did :

Create a new config file name as App.config

In the App.config file:
Added this:
<appsettings>

<add key="SecurityKey" value="MyNewKey">

After that I did the following:

System.Configuration.AppSettingsReader settingsReader
= new AppSettingsReader();

when i am debugging these, i find that the value of dimension is 0 which supposed to 1. since there is one key-value present in the App.config

string key = (string)settingsReader.GetValue("SecurityKey", typeof(String));

Also it's throwing an exception stating

“The key "SecurityKey" does not exist in the appSettings configuration section”.--which already present in the App.config.

Also i tried with the second scenario:

string key =
System.Configuration.ConfigurationManager.AppSettings["SecurityKey"];

which giving me the key value null.

Do i required to do some setting for reading the "SecurityKey" Value?

Needs help!

Thanks

Sudhir Kumar

Sudhir Kumar

Re: Not able to read the value from App.config file

_AK_1-Sep-06 0:57

Re: Not able to read the value from App.config file

1-Sep-06 0:57

I think you can get it like this:
ConfigurationSettings.AppSettings.Get("key")

Best Regards,
Apurva Kaushal

Not Active1-Sep-06 2:21

Not Active

1-Sep-06 2:21

DON'T CROSS POST Mad | :mad:

only two letters away from being an asset

Not able to read the value from App.config file

kumar sudhir11-Sep-06 0:51

kumar sudhir1

1-Sep-06 0:51

I want to read the security key value from App.config file. Below is the procedure which I did :

Create a new config file name as App.config

In the App.config file:

<configuration>

<appsettings>

<add key="SecurityKey" value="MyNewKey">

After that I did the following:

System.Configuration.AppSettingsReader settingsReader
= new AppSettingsReader();

when i am debugging these, i find that the value of dimension is 0 which supposed to 1. since there is one key-value present in the App.config

string key = (string)settingsReader.GetValue("SecurityKey", typeof(String));

Also it's throwing an exception stating

“The key "SecurityKey" does not exist in the appSettings configuration section”.--which already present in the App.config.

Also i tried with the second scenario:

string key =
System.Configuration.ConfigurationManager.AppSettings["SecurityKey"];

which giving me the key value null.

Do i required to do some setting for reading the "SecurityKey" Value?

Needs help!

Thanks

Sudhir Kumar

Sudhir Kumar

Re: Not able to read the value from App.config file

Leon Segal3-Sep-06 15:51

Leon Segal

3-Sep-06 15:51

If your web.config appSettings sections looks like the following:
<appsettings>
<add key="SecurityKey" value="my new key">

You can then use ConfigurationManager.AppSettings["SecurityKey"] to access it.

Hope this helps.

.leON.

Hide Datagrid row..............

Nagraj Naik1-Sep-06 0:46

Nagraj Naik

1-Sep-06 0:46

Hi,
In Itemdatabound event of grid
I want to hide row if preceding row contain some conditional data.

I mean

sub itemdatabound(s As Object, ByVal e as DataGridItemEventArgs)
If e.Item.ItemType = ListItemType.Item Then
If e.Item.Cells(2).Text = "Hide next" Then
hide next row of grid
end if
end if
end sub

I hope someone help me.

Regards,
Nagraj

_AK_1-Sep-06 1:33

1-Sep-06 1:33

e.Item.Visible=false;

Best Regards,
Apurva Kaushal

Nagraj Naik1-Sep-06 21:01

Nagraj Naik

1-Sep-06 21:01

Thanks for reply,
But
This code will hide same row.
I want to hide next row means from if 2nd row is having test "Hide next" 3rd row should hide completely

_AK_3-Sep-06 17:54

3-Sep-06 17:54

In that case what you can do is to take a boolean variable and then when you meet the requirement then boolean variable to true and then check for that boolean vale and make that particular row hidden. isn't it? Smile | :)

Best Regards,
Apurva Kaushal

postmaster@programmingknowledge.com

postmaster@programmingknowledge.com1-Sep-06 4:39

1-Sep-06 4:39

sub itemdatabound(s As Object, ByVal e as DataGridItemEventArgs)<br />
   If e.Item.ItemType = ListItemType.Item Then<br />
         If e.Item.Cells(2).Text = "Hide next" Then<br />
               e.Item.Visible = False<br />
         end if<br />
    end if<br />
end sub

==postmaster
http://www.programmingknowledge.com/[^]

error: Automation server can't create object

Nagraj Naik1-Sep-06 21:00

Nagraj Naik

1-Sep-06 21:00

Thanks for reply,
But
This code will hide same row.
I want to hide next row means from if 2nd row is having test "Hide next" 3rd row should hide completely

24891281-Sep-06 0:40

2489128

1-Sep-06 0:40

hi! i creates a html page as below. it works properly

<title>Untitled Page

function f()
{

// Declare the variables
var Excel, Book;

// Create the Excel application object.
Excel = new ActiveXObject("WINWORD.Application");

// Make Excel visible.
Excel.Visible = true;

// Create a new work book.
Book = Excel.Workbooks.Add()

// Place some text in the first cell of the sheet.
Book.ActiveSheet.Cells(1,1).Value = "This is column A, row 1";

// Save the sheet.
Book.SaveAs("C:\\TEST.XLS");

// Close Excel with the Quit method on the Application object.
Excel.Application.Quit();

}

but when i put this code in an aspx page, using VS.NET 2005, then generates an error ...
[Microsoft JScript runtime error: Automation server can't create object]
what is the problem?

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>

<title>

function f()
{

// Declare the variables
var Excel, Book;

// Create the Excel application object.
Excel = new ActiveXObject("Excel.Application");

// Make Excel visible.
Excel.Visible = true;

// Create a new work book.
Book = Excel.Workbooks.Add()

// Place some text in the first cell of the sheet.
Book.ActiveSheet.Cells(1,1).Value = "This is column A, row 1";

// Save the sheet.
Book.SaveAs("C:\\TEST.XLS");

// Close Excel with the Quit method on the Application object.
Excel.Application.Quit();

}

How to navigate records from database

Kissy161-Sep-06 0:36

Kissy16

1-Sep-06 0:36

Here i had a problem that,when i click button it should move to the next,like to the end of the data table.with datareader i can read at a time and display,
but i have to do this each time when button was clicked.
give me a suitable example.
thanks in advance

kissy

Re: How to navigate records from database

_AK_1-Sep-06 0:59