Trouble with sqlDataSource to update database - ASP.NET Discussion Boards

how to pass value from one telerik ajax panel to another telerik ajax panel

Piyush Vardhan Singh
Programmer
TAS NewDelhi
India

Dear what your actual requirement.

Did you check with cookies ?

Parwej Ahamad
g.parwez@gmail.com

I am using .Net2005(2.0)- Asp.net with C#

I have a button in a web form which opens a file in client machine.
Instead of directly opening the file, i need the application to prompt with "open with" dialogue box in client machine.

Eg: On button click, i need to open a text file -

Under normal course - the text file will be opened using notepad(as notepad is the default windows assosiated application to open a txt file)

Requirement - the file should prompt with "open with" dialogue box, so that the user can select MSword or Textpad

Is there any possibility to acheive this.

Thanks
Hema S Rose | [Rose]

Does this address your query?

http://support.microsoft.com/kb/260519[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Thanks Vasu,

that dosent help me much...

Iam looking for something like below in web environment
http://www.codeproject.com/csharp/openwith.asp

Visual Studio .NET cannot create or open the application. The likeliest problem is that required components are not installed on the local Web server. Run Visual Studio .NET setup and add the Web Development component.

hello friends this is the error i hv triend command aspnet_regiis -i on command prompt and restart iis but it didnt work can some one tell me soliuton

http://dotnetjunkies.com/Forums/ShowPost.aspx?PostID=4736[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Hi all,

I have a gridview and a datasource, when I make changes to the values in the gridview and update them they are changed on the gridview, but not in the database, so those values I changed stay the same in the database, the datasource gets updated but it never reflects to the database itself. How do I get the database updated with the edited values?

Here is the code I use:

<form id="form1" runat="server">

<div>

<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
DataKeyNames="menu_id,menu_language" AutoGenerateColumns="false" AutoGenerateEditButton="true" AllowPaging="true" OnRowUpdated="GridView1_RowUpdated">

<Columns>

<asp:BoundField ReadOnly="false" HeaderText="Id" DataField="menu_id" NullDisplayText="N/A" />
<asp:BoundField ReadOnly="false" HeaderText="Language" DataField="menu_language" NullDisplayText="N/A" />
<asp:BoundField ReadOnly="false" HeaderText="Text" DataField="menu_text" NullDisplayText="N/A" /> <asp:BoundField ReadOnly="false" HeaderText="url" DataField="menu_url" NullDisplayText="N/A" /> <asp:BoundField ReadOnly="false" HeaderText="Avtive" DataField="menu_active" NullDisplayText="N/A" />
<asp:BoundField ReadOnly="false" HeaderText="Content Id" DataField="menu_content_id" NullDisplayText="N/A" />

</Columns>

</asp:GridView>

</div>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
SelectCommand="Select * from [menu_items]"
ConnectionString="<%$ connectionStrings:localSqlServer %>"
DataSourceMode="DataSet"
UpdateCommand="Update [menu_items] set [menu_text] = @menu_text, [menu_url] = @menu_url, [menu_active] = @menu_active,
[menu_content_id] = @menu_content_id where [menu_id] = @menu_id and [menu_language] = menu_language"
ConflictDetection="OverwriteChanges" EnableCaching="true"
CacheKeyDependency="MyKey" CacheDuration="Infinite">

<UpdateParameters>

<asp:Parameter Type="string" Name="menu_text" />
<asp:Parameter Type="string" Name="menu_url" />
<asp:Parameter Type="string" Name="menu_active" />
<asp:Parameter Type="string" Name="menu_content_id" />
<asp:Parameter Type="string" Name="menu_id" />
<asp:Parameter Type="string" Name="menu_language" />

</UpdateParameters>

</asp:SqlDataSource>

</form>

Any suggestions or possible solutions will be appreciated

Thanks in advance

No matter how long he who laughs last laughs, he who laughs first has a head start!

Got it working, I have absolutly no idea how but it's working Laugh | :laugh:

No matter how long he who laughs last laughs, he who laughs first has a head start!

how can i add date between date befor and date after in SP

Developer

try this link
http://weblogs.sqlteam.com/jeffs/archive/2007/01/02/56079.aspx[^]

Thank you.

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

please do more spesific with u'r question Confused | :confused:

..
Maybe i can help solve u'r problem

Regards,

Tomi

Good Morning,

Is it possible to fire an event when user closes the browser window in javascript or any other language? Please help.

I have user a login system in my project which is being made in asp.net 2.0. I want that when user closes the browser window it should logout autmatically. If anyone of you knows about it please guide me. Thanks.

waiting for reply. Bye.

Abubakar

I saw an good article the other day on handing browser close events on the server side

http://aspalliance.com/1294_CodeSnip_Handle_Browser_Close_Event_on_the_ServerSide[^]

Hope it helps

Thanks for reply.

I don't think it could be solution becaue "onunload" function will be called every time even user moves to another page by clicking a link then user will be logout which is not right. what do u think?

hi there
ca u provide the link other then ajax
thanQ

Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....

Abubakarsb wrote:
I want that when user closes the browser window it should logout autmatically.

Session will have some timeout specified. It will end after that time. So no need to end it explicitly when user closes browser. And I don't think that doing this using javascript will be a good solution, because if javascript is disabled on user browser, your script won't work. Are you updating any value in database when user logs out ?

My Website | Ask smart questions

N a v a n e e t h wrote:
Are you updating any value in database when user logs out ?

Check out this article if you are depending on Session_OnEnd for your logic:

http://www.eggheadcafe.com/articles/20030418.asp[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Vasudevan Deepak Kumar wrote:
Check out this article if you are depending on Session_OnEnd for your logic:

Yes read that more than 3 times, all from your message only. But I didn't had any problem with firing session_end event. It works perfectly for me. I feel in article they are concentrating on webfarms, and this thread starter has not told that he is using a webfarm. He may be using InProc, and for that session_end will easy and optimum ? What do you say ?

My Website | Ask smart questions

No, I am not updating any value. I am just logging out of user from the system. The problem is sometimes when I close the browser it loged out user but when I try to relogin again with same username it says "User is currently Login"

Abubakarsb wrote:
it says "User is currently Login"

How you are checking this ? That's what I asked are you storing any values to identify whether user is online ?

My Website | Ask smart questions

Sorry guys! I was really busy with other parts of my project. Regarding to your question

"How you are checking this ? That's what I asked are you storing any values to identify whether user is online ? "

The thing is I am new in Visual Studio 2005 (Asp.net 2.0) and a developer already made this, I am just updating it. I don't have any idea how new login system works in VS2005. I really don't know how he is storing or checking that whether user is login or not?

He made a commonMaster page and I have found a check please check code below, may be it helps you to understand my problem, if you still need more please don't hasitate. I want to fix this soon. Thanks.

if (Properties.IsLoggedIn)
{
string cookieName = FormsAuthentication.FormsCookieName;
HttpCookie authCookie = Context.Request.Cookies[cookieName];
FormsAuthenticationTicket authTicket = FormsAuthentication.Decrypt(authCookie.Value);

MembershipUser mu = Membership.GetUser();
Properties.EndUserGUID = mu.ProviderUserKey.ToString().ToUpper();

DateTime expiration = authTicket.Expiration.AddSeconds(-90);
if (expiration < DateTime.Now)
{
mu.LastLoginDate = DateTime.Now;
Membership.UpdateUser(mu);
FormsAuthentication.SetAuthCookie(Context.User.Identity.Name, true, "/");
}
}

resources = new System.Resources.ResourceManager("SharpWebMail", System.Reflection.Assembly.GetExecutingAssembly());

The resources are not getting loaded and i am getting the error when i access the resources the following way

Session["resources"] = resources.GetResourceSet(invariant, true, true);

Hi,

I want to copy the data in a csv to sqlserver 2005 database.
Please help me in this regard.

Data in csv is in this format:
"1","Sa","New Aol","America,NY",""

Thanks a lot!!

SHWETA!!

Hi shweta, may i know u want to copy the data through soem programming source or directly through sql server 2005.

Hello Forum
Always be in touch to help about the topic ASP.NET