ASP.NET

Re: Close session in While closing browser

11-Jan-10 19:43

Do following thing :

create on button on you page, put it in one div and make div display as none ( button id btnLogout) attach server side event ex. name LogoutUser

attach event in the body tag of form
onunload="doUnload()"

write following script
call server side event
function doUnload()
{
if (window.event.clientX < 0 && window.event.clientY < 0)
{
alert("Window is closing...");
//calling button click event
document.getElementById('btnLogout').click();
//btnlogout is client id so if ur not getting than use //btnlobout.ClientId of .net of server side code
}
}

sever side code

protected void LogoutUser(object sender, EventArgs e)
{
//code to logout user
// server abandon
}

modified on Tuesday, January 12, 2010 1:56 AM

Venkatesh Mookkan11-Jan-10 22:50

Venkatesh Mookkan

11-Jan-10 22:50

Amit Patel1985 wrote:
How to close session if user close the brower.

You cannot do that. If a user closes the browser, the session automatically expires at it SessionTimeout (20 minutes is the default Timeout). But you can still achieve it, I have seen code to call function on closing the browser. You are search it on google. JavaScript "unload" event fires whenever you go off that page. "unload" event will not help you.

Amit Patel1985 wrote:
And my second question is if session timeout happens
then session end method is called from in Global.asax
how to do the redirection from the Global.asax

What do you meant by redirection? Global.asax is not page, that you need to redirect from.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

grab contacts from Social network

kokilaB11-Jan-10 17:28

11-Jan-10 17:28

Please give me some idea to grab the contacts from myspace,Linkedin account.

sashidhar11-Jan-10 17:44

sashidhar

11-Jan-10 17:44

Every One has their own interfaces ,so you have to interact with the interface they provided..!
Ex: for Facebook..!
http://wiki.developers.facebook.com/index.php/User:ASP.NET[^]

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

kokilaB11-Jan-10 18:43

11-Jan-10 18:43

Need to develop web application to grab the contacts from Facebook,gamil,myspace...site if the userID and password is given in application.

sashidhar11-Jan-10 18:51

sashidhar

11-Jan-10 18:51

Then You need to develop for each application..!

If you want to make your work more easy..!try any third party provider is available or not..!but i am not sure abt the third party provider..!
but try to look at this link you can have an idea..!
http://openinviter.com/index.php[^]

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

kokilaB11-Jan-10 18:44

11-Jan-10 18:44

Hi thanks for your reply..

Need to develop web application to grab the contacts from Facebook,gamil,myspace...site if the userID and password is given in application.

Thanks
Kokila

kokilaB11-Jan-10 19:22

11-Jan-10 19:22

Thanks. Third party tools are available for this but i want to do it by own.. as you said i have to develop one for each site..

searching for the API or code to implement it. Till now i dint get any solution for this. So i posted here..

Thanks for your help..
Kokila

Manupulating Columns of datatable

Vasudevan Deepak Kumar12-Jan-10 4:08

Vasudevan Deepak Kumar

12-Jan-10 4:08

You would need to check with each vendor's API for the same and consume the same towards getting the data.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

kris_viswa11-Jan-10 17:27

kris_viswa

11-Jan-10 17:27

Hi experts

I have designed my page to allow users to upload excel/csv files and I am interested to capture the data from only few columns of these files. The column names of the files varies from user to user hence i created the form to obtain the column names of user's file for mapping to my database. Now my requirement is that I want to first read the column names of uploaded file and retain only columns and data which are matching to the user entered column names for mapping.

clues or guidance solicited preferably in vb.net

thanks in advance
kris

Re: Manupulating Columns of datatable

Pranay Rana11-Jan-10 19:08

Re: Manupulating Columns of datatable

11-Jan-10 19:08

Do following code you can read all data in datatable which easily fill you requirement

FileInfo fileinfo = new FileInfo(filePath);

string strSql = "SELECT * FROM [" + fileinfo.Name + "]";

string strCSVConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileinfo.Directory.FullName + ";" + "Extended Properties='text;HDR=No;'";

OleDbDataAdapter oleda = new OleDbDataAdapter(strSql, strCSVConnString);
DataTable dtbCSV = new DataTable();
oleda.Fill(dtbCSV);

kris_viswa12-Jan-10 3:32

kris_viswa

12-Jan-10 3:32

Hi pranay

thanks for response. what you explained is all about connection and fetching data to data table which is ok. My actual requirement starts there after. I would like to explain the requirements stepwise here

1.Establishing connection to db and populating data table
2.Reading the column names of the data table and retaining only columns and data which user has specified as mapping fields in page, which too may not be in sequence.
3.Adding few more columns dynamically to data table with default values
4.finally binding data to grid for user editing and final saving to db

thanks
kris

Re: Manupulating Columns of datatable

Pranay Rana12-Jan-10 17:29

DataSet/DataTable or SQL Query for complex data retrieval?

12-Jan-10 17:29

In that case I think first row in csv file must be name of columns.

So for that read csv file in the data table.

Than create you dynamic table by looping through fist row of your data table and create one dynamic datatable in between that by comparing selected row.

Than loop through other rows similar fashion and read whole file and insert data row in datatable created by you.

I hope that this will work for you.

James Shao11-Jan-10 14:01

James Shao

11-Jan-10 14:01

Hi, I have a time series information on stock market that includes 4 columns: Dates, StockTicker, Price, and Volume. My original goal was to try writing SQL query statement to retrieve stocks that demonstrate certain price and volume patterns on a given date, but then found it a bit hard to do so due to my limited skill on constructing SQL query statement. Sigh | :sigh:

One of my friends who's good at programming suggests that it would be easier for me to retrieve source data into a DataTable/DataSet and then process them from there. However, I'm not sure whether this is as efficient as SQL, if it oculd be done in SQL that is. Unsure | :~

Here's the type of pattern I'd like to check in my stock table:

1. Given 2 specific dates, retrieve all stocks that show (Price of earlier date) > (Price of later date) AND (Volume of earlier date) < (Volume of later date).

2. Stocks that fulfill condition 1 and that price is within a certain range. Or condition 1 and that volume is within a certain range.

Regarding information retrieval, I thought it's always more efficient to do in SQL, especially if you have a lot of variables and don't know what you're looking for.

I'd greatly appreciate for any suggestions! Thanks! Smile | :)

Re: DataSet/DataTable or SQL Query for complex data retrieval?

dan!sh 11-Jan-10 16:27

dan!sh

11-Jan-10 16:27

You would be filling the Dataset/DataTable from the SQL only. It is not wise to get entire source in DataSet and then filter out what you need. This is what you should do, IMO:

1. Fill the dataset through your SQL command (including the where clause).
2. Use the datas created to display, insert or update data.

Also, if you just need one time access to the data, use DataReader.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

hi, How To Access Label Inside GridView where GridView Inside Datalist( Only By Javascript)?

re7et_3esh11-Jan-10 7:08

re7et_3esh

11-Jan-10 7:08

hi all ,
i want to know To Access Label Inside GridView where GridView Inside Datalist By Client side

who can help me plz? im worried Frown | :(

setting value on ClinetClick and reading changed value on OnClik[Server Side]

K V Sekhar11-Jan-10 6:00

K V Sekhar

11-Jan-10 6:00

Hi all,

I have a TextBox and Button.
The Button have two events 'OnClentClick'(javascript) and 'OnClick'(server side).

OnClientClick of button i could able to set the value to textbox and i could see the value in TextBox.
But when OnClick of Button i could not able to read the changed value of TextBox. Its giving value which i assigned at design time. But i could see the new value in textbox. Why? whats the reason.

How to read that changed value on OnClick(Server Side].

Please suggest me how to do that.

Thanks in advance.

Re: setting value on ClinetClick and reading changed value on OnClik[Server Side]

Abhijit Jana11-Jan-10 6:43

Abhijit Jana

11-Jan-10 6:43

Can you please show us the code ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Re: setting value on ClinetClick and reading changed value on OnClik[Server Side]

K V Sekhar11-Jan-10 15:34

K V Sekhar

11-Jan-10 15:34

Here is the sample code.

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>GridView Export</title>
    <script type="text/javascript" language="javascript">
    function ChangeText()
    {
        var tBox = document.getElementById("TextBox1");
        tBox.value = "New Text";
        alert(tBox.value);
    }
    </script>
</head>
<body>    
    <form id="form1" runat="server">
    <div>
        <asp:TextBox ID="TextBox1" runat="server" Text="Old Text"></asp:TextBox>
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" OnClientClick="javascript:ChangeText();" />
</div>
</form>
</body>
</html>

the code behid page:
Firm1.aspx.cs:

protected void Button1_Click(object sender, EventArgs e)
{
     Response.write("New Text"+TextBox1.Text); //out put: "Old Text"[Given at design time]
}

please suggest me where i did wrong.

Re: setting value on ClinetClick and reading changed value on OnClik[Server Side]

Pranay Rana11-Jan-10 18:17