|
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",""
Please reply asap..
Thanks a lot!!
SHWETA!!
SHWETA!!
|
|
|
|
|
Did you try the DTS Wizard?
|
|
|
|
|
That is hardly a question that belongs on the ASP.NET forum, but now that it's been asked, I'll try and answer it. Vasudevan gave you a basic answer, but there is no DTS wizard in SQL 2005. Right click the database you want to import into, then the Import/Export Wizard (slave to SSIS), will prompt you for a from data source, where you choose a flat file provider, and a to data source, where you choose your target database. It's a wizard, follow its help.
"Once in Africa I lost the corkscrew and we were forced to live off food and water for weeks." - Ernest Hemingway
My New Blog
|
|
|
|
|
Brady Kelly wrote: no DTS wizard in SQL 2005
Since I have both the tools in my desktop, I think, I have overlooked the fact. 
|
|
|
|
|
I want to transfer the data using asp.net(C#) code.
plz help me!!
SHWETA!!
|
|
|
|
|
What it has to do with ASP.NET???
Anyways you can try DTS wizard.
|
|
|
|
|
Hi shweta first thing is that u posted this message second time in short time.
also keep habbit of loking for the solution on goolge, as of me its a solution for all what we need.
regarding ur post i have the solution but it is through programming
tell me on what platform u r working currently.
u can also mail me for asking about the same.
personalmail@mysampatti.com
Hello Forum
Always be in touch to help about the topic ASP.NET
|
|
|
|
|
I have habit of searchin by my self and then askin the question..
Abd I got the solution by my self.. I have written the code that can do the task..
Thanks a lot..
SHWETA!!
|
|
|
|
|
Well m sorry for the mistake but I forgot to write that I want to copy the data from CSV to database(SQL Server 2005) using asp.net code.
M sorry again..
But please help me..
SHWETA!!
|
|
|
|
|
There is no such thing as ASP.NET code. ASP.NET uses existing languages, such as C# and VB.NET, so based on your previous message I suppose you mean C#. This is no trivial task, and judging from your level of knowledge, I would not attempt it alone.
I recommend A Fast CSV Reader[^], by Sebastian Lorien here on Code Project. He has really done his homework on this.
"Once in Africa I lost the corkscrew and we were forced to live off food and water for weeks." - Ernest Hemingway
My New Blog
|
|
|
|
|
Hi
I want to bind the pages of the sitemap to a gridview and then be able to select a page from there taking its name in the querystring to another page which I will be using as an admin page for it.
Any help appreciated. I am using c#
Many thanks
Adam
|
|
|
|
|
hi friends
i need ajax2.0 dll
any link avilable regarding this
regards
saravanan
|
|
|
|
|
|
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]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
|
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
|
|
|
|
|
|
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 
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
|
|
|
|
|
|
please do more spesific with u'r question ..
Maybe i can help solve u'r problem
Regards,
Tomi
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
