Dataset.WriteXml doesnot release file - ASP.NET Discussion Boards

Paulraj G1-Mar-10 1:25

1-Mar-10 1:25

Yes...

Its working.... But i need to give links to each login name.

for ex,

paul - www.paul.com
raj - www.raj.com
rakesh - www.rakesh.com

Thats why i am asking to print in DIV.

Thanks...

G.Paulraj

Re: Access asp control from c#

rakeshs3121-Mar-10 1:47

rakeshs312

1-Mar-10 1:47

<div ID="display" runut="server">

foreach (DataRow drRow in dtResult.Rows)
{

Loginname = drRow["name"].ToString();
password = drRow["password"].ToString();

disp.InnerHtml += Loginname + "-" + password;
disp.InnerHtml+=("<br>");
}

how to get the right symbol beside the text box when validate the user

developerit1-Mar-10 0:14

developerit

1-Mar-10 0:14

iam checking the user is valid or not from the data base using asp.net with c#. when user is valid i should get the right symbol beside this control....what control i have to use in ajax or any

Re: how to get the right symbol beside the text box when validate the user

dan!sh 1-Mar-10 0:25

dan!sh

1-Mar-10 0:25

Read this[^]. Does it looks that hard finding out?

how to find the total hours he spend

developerit1-Mar-10 0:11

developerit

1-Mar-10 0:11

I'm using asp.net and sql server, i have table loguser fields arelike this userid varchar(50)
tdate datetime
login datetime
logout datetime
timespend datetime
i want to findout between that how many hour he spend...

Ex:

Login Time: 11:50:39
Logout Time: 12:35:03

then again when he login Login Time:12:50:03

Logout Time: 2:35:03

i want to find out today how much hours he spend
and update the field timespend in database

Re: how to find the total hours he spend

dan!sh 1-Mar-10 0:16

dan!sh

1-Mar-10 0:16

This question better belongs to General database forum.

Since the database columns are of type DateTime, you will have the date as well. Now, use DateDiff function and find the difference between login and logout time. This would give the time spent. Make sure that the dates are for both login and logout. If the dates are different, then login time to midnight would be time spent today and midnight to logout time would be the time spent the next day.

Re: how to find the total hours he spend

April Fans1-Mar-10 22:30

April Fans

1-Mar-10 22:30

Hi,
I think you can record the total timespend to db when he logs out: timespend =timespend + Logout Time - Login Time,

and you should check if the login is the first login of that day, if it is, set timespend = 0.

April

Comm100 - Leading Live Chat Software Provider

modified 27-May-14 8:47am.

Dataset.WriteXml doesnot release file

sunit_8228-Feb-10 23:51

sunit_82

28-Feb-10 23:51

I'm using Cache file dependency in my code with CacheItemRemovedCallback function set. File dependency is on a xml file which is output of a Dataset.WriteXml. Below is the code in my CacheItemRemovedCallback method

 <br />
public void RemovedCallback(String k, Object v, CacheItemRemovedReason r)<br />
{<br />
DataSet ds = new DataSet();<br />
ds.ReadXml(filePath);<br />
Cache.Insert("KeyName", ds, new CacheDependency(filePath), DateTime.Now.AddHours(1), TimeSpan.Zero, CacheItemPriority.High, OnRemove);<br />
}<br />

filePath points to the XML file which is output of ds.WriteXml.
When there is some update to the dataset I write the dataset using
ds.WriteXml(filepath, XmlWriteMode.WriteSchema);
On execution of above line, the call back methode RemovedCallback gets called. And as ds has not released the xml file yet, I get a error "...access denied as file is in use...".

Is there a way ds.WriteXml() method can release the file immediately after writing?
Else please suggest any alternate method ??

Thanx

s.a.w.

calling panel mulitple times

Ostwal Aarti28-Feb-10 23:29

Ostwal Aarti

28-Feb-10 23:29

how to call panel1 multiple times on linkbutton click event in asp.net 2005

Re: calling panel mulitple times

dan!sh 28-Feb-10 23:56

dan!sh

28-Feb-10 23:56

What do you mean by calling a panel?

Re: calling panel mulitple times

rakeshs3121-Mar-10 0:51

rakeshs312

1-Mar-10 0:51

use a loop and inside call the panel multiple times Laugh | :laugh:

not work in ff

diyaa_0828-Feb-10 22:35

diyaa_08

28-Feb-10 22:35

e.Row.Attributes.Add("onclick", "javascript:rowno(( e.Row.RowIndex);");

function rowno(rowindex)
{
here we want the correct index of row after moving rows

alert(rowindex);
i=rowindex;
}

function AddRow()
{

var gridview=document.getElementById("<%= gvPracticeFacility.ClientID %>");

var gridview1=document.getElementById("<%= gvPracticesAssignedFacilities.ClientID %>");

var tr = document.createElement("tr");

var cell1 = document.createElement("td");
var celln = document.createElement("td");
var cell2 = document.createElement("td");
var cell3 = document.createElement("td");
var cell4 = document.createElement("td");
var cell5 = document.createElement("td");
var cell6 = document.createElement("td");
var cell7 = document.createElement("td");
//var i =parseInt(document.getElementById("<%= hdnfldSelectedRow.ClientID %>").value);
cell1.innerHTML = gridview.rows[i].childNodes[0].innerHTML;
cell2.innerHTML = gridview.rows[i].childNodes[1].innerHTML;
cell3.innerHTML = gridview.rows[i].childNodes[2].innerHTML;
cell4.innerHTML = gridview.rows[i].childNodes[3].innerHTML;
cell5.innerHTML = gridview.rows[i].childNodes[4].innerHTML;
cell6.innerHTML = gridview.rows[i].childNodes[5].innerHTML;
cell7.innerHTML = gridview.rows[i].childNodes[6].innerHTML;
tr.appendChild(cell1);
tr.appendChild(cell2);
tr.appendChild(cell3);
tr.appendChild(cell4);
tr.appendChild(cell5);
tr.appendChild(cell6);
tr.appendChild(cell7);
gridview1.firstChild.appendChild(tr);

gridview.deleteRow(i);

}

<input id="Button1" type="button" runat="server" value="button" onclick="AddRow();" />
this code works in internet explorer but not works in ff...... Confused | :confused:

Re: not work in ff

Nasri871-Mar-10 21:09

Nasri87

1-Mar-10 21:09

what error msg display?

Sub menu - How to write click event?

Paulraj G28-Feb-10 19:46

Paulraj G

28-Feb-10 19:46

Hi...

I am having a main menu called menu1. Its sub menus are submenu1, submenu2,submenu3.

I can write event for main menu click event as

ASP code:

<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal"  ForeColor="white" BorderStyle="None" 
        Height="30px" onmenuitemclick="Menu1_MenuItemClick">

and c# code is:

protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
{
     Str = "sample";
}

Now how to write click event for submenu1?

any help will be appriciated....

thanks...

G.Paulraj

Re: Sub menu - How to write click event?

sashidhar28-Feb-10 20:09

sashidhar

28-Feb-10 20:09

Try this link it may help..!
http://msdn.microsoft.com/en-us/magazine/cc163848.aspx[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: Sub menu - How to write click event?

Abhijit Jana28-Feb-10 20:13

Abhijit Jana

28-Feb-10 20:13

Where is your menu SubItems ? You need to first create the menu subitems inside "Items" tag. Then you can use the same event handler for all the items.

Have a look into this article,
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.menu.menuitemclick%28VS.80%29.aspx[^]

Please let me know if you need any more information.

Thanks

Re: Sub menu - How to write click event?

Paulraj G28-Feb-10 20:28

Paulraj G

28-Feb-10 20:28

Hi Abhijith,

Thanks for your reply...

My code is as follows. Please tell me how to create menu subitem on this...

<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal"  ForeColor="white" BorderStyle="None" 
        Height="30px" onmenuitemclick="Menu1_MenuItemClick">
                    <DynamicHoverStyle ForeColor="#000000" BackColor="Black"/>
                    <Items>
                    
                    <asp:MenuItem Text="File" Value="File">
                        <asp:MenuItem Text="Open" Value="Open" ToolTip="Open File"></asp:MenuItem>
                        <asp:MenuItem Text="Recent Files" Value="Recent"></asp:MenuItem>
                        <asp:MenuItem Text="Exit" Value="Exit"></asp:MenuItem>
                    </asp:MenuItem>

Thanks....

G.Paulraj

Re: Sub menu - How to write click event?

Abhijit Jana28-Feb-10 20:42

Abhijit Jana

28-Feb-10 20:42

You need to close <items> tag and <asp:menu> tag First.

Try This :

<asp:Menu ID="Menu1" runat="server" Orientation="Horizontal"  staticdisplaylevels="5" BorderStyle="None" 
         onmenuitemclick="Menu1_MenuItemClick">
                    <Items>
                    <asp:MenuItem Text="File" Value="File">
                        <asp:MenuItem Text="Open" Value="Open" ToolTip="Open File"></asp:MenuItem>
                        <asp:MenuItem Text="Recent Files" Value="Recent"></asp:MenuItem>
                        <asp:MenuItem Text="Exit" Value="Exit"></asp:MenuItem>
                    </asp:MenuItem>
                    </Items>
    </asp:menu>

And In Code Behind :

protected void Menu1_MenuItemClick(object sender, MenuEventArgs e)
    {
        Response.Write(e.Item.Text);
    }

Here you will find on click of every menu items / subitems , Menu Text getting write on page.

Hope this will help you !

Re: Sub menu - How to write click event?

Paulraj G28-Feb-10 21:42

Paulraj G

28-Feb-10 21:42

Ya... Its working fine...

Thanks...

G.Paulraj

Re: Sub menu - How to write click event?

Abhijit Jana28-Feb-10 21:45

Abhijit Jana

28-Feb-10 21:45

Welcome

Packaging a web application

Priyanka15 g28-Feb-10 16:26

Priyanka15 g

28-Feb-10 16:26

Hi,
I have developed a web application which need to be deployed in client location. Can any body tell me how i can package it, so that others cannot view the code. My application is having both asp and asp.net pages.

Re: Packaging a web application

sashidhar28-Feb-10 20:13

sashidhar

28-Feb-10 20:13

Priyanka15 g wrote:
My application is having both asp and asp.net pages.

I never tried for both but in common the standard procedure is as below

Do you know this option called publish.If yes use publish option ..!

To Get tht..!
Top Menu -->Build-->publish-->It will notify u tht the files will be stored in some folder your publish files will be stored in tht folder..!
If No Refer this link below..!
http://msdn.microsoft.com/en-us/library/1y1404zt(VS.80).aspx[^]

http://www.15seconds.com/Issue/030806.htm[^]
http://www.beansoftware.com/ASP.NET-Tutorials/Deploy-ASP.NET.aspx[^]

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: Packaging a web application

Abhijit Jana28-Feb-10 20:21

Abhijit Jana

28-Feb-10 20:21

First thing that you need to it, Publish the code. Right Click on Solution > Publish Web Site. After Publishing the site, you will not find any .cs file in your published folder, all code will be converted in to dll only.

After than , you can create a Web Setup project which will work as Installer.

Please have a look into this,
http://www.beansoftware.com/ASP.NET-Tutorials/Deploy-ASP.NET.aspx[^]

This may help you. Let me know if you need more information.

Thanks !

Refreshing a datalist in the behind code gives conflict.

macupryk28-Feb-10 16:03

macupryk

28-Feb-10 16:03

public

void BindThumbnails()
{
DataSet ds = new DataSet();
ds = GetBinaryImagesByProfileID.FetchAllImagesInfo(intGetProfileID, "omegaloveConnectionString");
DLThumbnails.DataSource = ds;
DLThumbnails.DataBind();
}

Now when I come to the page on load I call the method BindThumbnails with a variable intGetProfileID
Will refresh the databind.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:omegaloveConnectionString %>"
SelectCommand="sprGetBinaryImages" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter Name="ProfileID" Type="Int32" DefaultValue="0" />
</SelectParameters>
</asp:SqlDataSource>
<asp:DataList ID="DLThumbnails" runat="server" RepeatDirection="Horizontal" CellPadding="3" DataKeyField="img_id"
HorizontalAlign="Center" CssClass="view" RepeatColumns="5" Item-BorderWidth="1"
Item-BorderColor="#c0c0c0" OnItemDataBound="DLThumbnails_ItemDataBound" OnItemCommand="DLThumbnails_ItemCommand"
BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px"
GridLines="Horizontal" ShowFooter="False" ShowHeader="False"
DataSourceID="SqlDataSource1">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<ItemStyle Width="20%" BackColor="#E7E7FF" ForeColor="#4A3C8C" BorderColor="silver"
BorderStyle="dotted" BorderWidth="3px" HorizontalAlign="Center" VerticalAlign="Bottom" />
<SelectedItemStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<FooterTemplate>
</FooterTemplate>
</asp:DataList>

How can I fix the above so I do not get the following error:

Both DataSource and DataSourceID are defined on 'DLThumbnails'. Remove one definition.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: Both DataSource and DataSourceID are defined on 'DLThumbnails'. Remove one definition.

Source Error:

Line 82: ds = GetBinaryImagesByProfileID.FetchAllImagesInfo(intGetProfileID, "omegaloveConnectionString");
Line 83: DLThumbnails.DataSource = ds;
Line 84: DLThumbnails.DataBind();Line 85: //CountPhotos = Convert.ToInt32(ds.Tables[0].Rows[0]["NumberOfPhotos"].ToString());

Re: Refreshing a datalist in the behind code gives conflict.

Abhijit Jana28-Feb-10 20:27

Abhijit Jana

28-Feb-10 20:27

You are getting this error because of DLThumbnails having two different dataSource. And the error message is saying the same thing.

If you check in codebehind,

macupryk wrote:
void BindThumbnails()
{
DataSet ds = new DataSet();
ds = GetBinaryImagesByProfileID.FetchAllImagesInfo(intGetProfileID, "omegaloveConnectionString");
DLThumbnails.DataSource = ds;
DLThumbnails.DataBind();
}

You are giving data source of DLThumbnails as ds.

On the other hand, in aspx page, you have created one more SQLDataSource,

macupryk wrote:
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:omegaloveConnectionString %>"
selectcommand="sprGetBinaryImages" selectcommandtype="StoredProcedure">
<selectparameters>
<asp:parameter name="ProfileID" type="Int32" defaultvalue="0">

and you have also assigned the same SQLDataSource as the DataSource of DLThumbnails. Which causes the confiliction error. You can remove any one them. Just Remove DataSourceID="SqlDataSource1" From Datalist aspx code. It will work Smile | :)

Hope this will help you. Let me know if you need any more help.

Thanks !

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