|
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
|
|
|
|
|
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!
|
|
|
|
|
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
|
|
|
|
|
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);
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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. 
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. 
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! 
|
|
|
|
|
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 all ,
i want to know To Access Label Inside GridView where GridView Inside Datalist By Client side
who can help me plz? im worried 
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
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);
}
please suggest me where i did wrong.
|
|
|
|
|
Beacuse field value set by javascript it not available in server side code
but you can access value by classical asp pattern
string txtvalue = request.form("fieldname")
|
|
|
|
|
I wanna
counter for my website with ASP.net (C# coding).
How can I do that ?
|
|
|
|
|
Here[^] or here[^] you go.
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...!!
|
|
|
|
|
Sorry
But I didnt get anything .
Can you please give me example or pdf .
|
|
|
|
|
Both the link contain the implementation of Hit counter, even one the link contains the attached code. Then why you are asking for example or pdf ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
I wanna to have
Yesterday visitors
Today visitor
Total visitor
<code>Online Visitor</code>
So whats the Solution?
Please Help!!!!!!!!!!!!!!!
|
|
|
|
|
The website contains the login controls which seems to work correctly. i.e. logging in with login details and showing the correct links accordinly...
Question:
How do I make sure on Logout, the user is presented with the Login screen? At present It shows Login or logout. In addition I would like to make sure if the user is not logged in, then he can not browse using the URL. And even if he tries to use the URL, then to see the Login screen.
Thanks
|
|
|
|
|
When your User logs in store the Username to the Session variable and change the login to logout and Change the Icon if you are using icons. When the user logs out set the Session that stored Username to an empty string or use Session.Abondon. Now on page load to have the Correct info Displayed, Check the Session is its not null , if its null then change the the label to logine else to logout.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Not sure how to do the session.abandon and where exactly. 
|
|
|
|
|
use this
Session["Username"] = "";
or
Session["Username"].Abondon();
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
Hello,
I think this is an easier way by placing it in the web.config accordingly
<location path="AddCodes.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
modified on Monday, January 11, 2010 10:03 AM
|
|
|
|
|
Have something like this:
1. Successful login, set a session variable with the username.
2. On logout link click, set that session variable as -1 and redirect to login page.
3. Set the default value of that session variable as -1 and place a check in all the pages that if that variable is -1, redirect to login page.
PS: Not an ASP.Net developer so there might be far better ways of doing this.
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...!!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
