.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Post New Web Links

Create new record using external CSV file

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 

Hello,

I have a CSV file that contains e-mail addresses. I would like to use that file to create new records for customers whose e-mail addresses exist in the CSV file.

The new record for all customers will be identical, except for the counter which is a unique key:

Here is the structure of the table:

CREATE TABLE [dbo].[Letter_C](
	[Counter] [int] IDENTITY(1,1) NOT NULL,
	[DateCreated] [datetime] NULL,
	[DateModified] [datetime] NULL,
	[PrimaryCode_C] [nvarchar](30) NOT NULL,
	[UserCreated] [nvarchar](30) NULL,
	[UserModified] [nvarchar](30) NULL,
	[ContactCode_C] [nvarchar](50) NULL,
	[Description_C] [nvarchar](250) NULL,
	[LetterName_C] [nvarchar](250) NULL,
	[LetterPath_C] [nvarchar](250) NULL,
	[LetterCode_C] [nvarchar](50) NULL,
 CONSTRAINT


View Complete Post


More Related Resource Links

Does this look correct for saving a file/ new record to a database

  

So thank you for all your help so far, So I think i got this right,
but would like for you all to look it over to see if there is any
areas I might run into trouble with:

//using asp.net mvc 2
the table (sql server 2005, using entities framework)
"Pattern_Media"
table fields
"Pattern_Media_GUID  uniqueid 
"Pattern_GUID  uniqueid
"Media varbinary(max)  
"height int
"Width int
"Media_Type String (50)


the form:
<h2> Add Media to this pattern</h2>
<% Html.EnableClientValidation(); %>
<% Html.BeginForm("AddMedia", "Pattern", new { id= Model.Pattern_Guid} , FormMethod.Post, new {enctype = "multipart/form-data"}); %>
   
    <%: Html.Label("height") %>
    <%: Html.TextBox("height") %>

    <%: Html.Label("width") %>
    <%: Html.TextBox("width") %>

    <%: Html.Label("Media") %>
    <input type="file" id="Media" name="Media" />
   
    <input type="submit" name=

file upload in Create User Wizard Created User event with UpdatePanel Tag wont work?

  

Hi,

In my Create User Wizard1 Created User Wizard Event, I am collecting extra information from text boxes and allowing

the user to uplad a file.

 

 

I have put the Submit button within an Update Panel Tag but since I have done this it does not work.

Is there a way round it. In this situation would you use a trigger.?

 

     <CustomNavigationTemplate>
          
                       <div>
<br />

  <asp:UpdatePanel ID="UpdatePanel2" runat="server">
                <ContentTemplate>  


  <asp:Button ID="StepNextButton" runat="server"  CommandName="MoveNext"  align="middle"
                                            Text="Submit my Profile" />
   

VS2010 Express ASP.net and database file with SQL Authentication - How to create database file with

  

Hi, I have installed Visual Studio 2010 Express in my local system.

Steps 1. File->New Website

 2.Open datbase explorer, right click on dataconnection

 3.Select Create new connection

 4.use Microsoft SQL Server Database file

5. Type new databse filename

6. Now i want to use SQL authentication which is not working

 7.If we use windows authentication its wokring without any problem

8.But i need sql authentication to be used.

 9.I have not installed SQL studio.

 I am only using the one which is packaged in VisualStudio 2010 SQLClient. Let me know how can we create a new database file with userID and password. So that i can host it in other systems as well without any windows authentication.  I know that VS2010 setup also installs the SQL client which is requiredto create and manage sql databse files/quries etc

 

i dont know the default userID and password for SQLauthentication. As the express setup did not asked any credentials while installing SQL components

 

Thanks and regards

 Mahesh kotekar

http://mahesh.kotekar.com


Create excel file from Binary data on SqlServer

  

Hi,

My requirement is that i upload an excel file then i need to validate that data.

Approach

1. Uploading file using using upload control saving binary in SqlServer

2. Then i am creating file from binary data  on Sql Server using below command and then using OPENROWSET to dump data to Sql table

3. Then reading Sql Table row wise and validating data.

 

Alter Procedure spUploadExcelFile
(
  @PKID int,
  @BatchID int
)
AS

BEGIN

	Declare @VarBin varbinary(max)
	Declare @FileName varchar(100)
	DECLARE @sql nvarchar(MAX)
                DECLARE @errMsg nvarchar(MAX)
	DECLARE @ObjectReturn INT
	DECLARE @ErrorSource VARCHAR(255)
	DECLARE @ErrorDesc VARCHAR(255)
	DECLARE @ObjectToken INT

	Select @VarBin  = Content , @FileName = [FileName] from MultilangBinaryData Where PKID = @PKID
	SET @FileName = 'C:\'  + @FileName
 
	EXEC sp_OACreate 'ADODB.Stream' @ObjectToken OUTPUT
	EXEC sp_OASetProperty @ObjectToken, 'Type', 1
	EXEC sp_OAMethod @ObjectToken, 'Open'
	EXEC sp_OAMethod @ObjectToken, 'Write', NULL, @VarBin
	EXEC sp_OAMethod @ObjectToken, 'SaveToFile', NULL, @FileName, 2
	EXEC sp_OAMethod @ObjectToken, 'Close'
	EXEC sp_OADestroy @ObjectToken  
	
	SET @sql = 'INSERT INTO dbo.UserBulkData SELECT 0,NULL,'+ @BatchI

Create PDF file in server side

  
Hi,I need to create a .pdf file which can download by client clicking on the link in my web site. That pdf should be generated using stored information in database. It has different types of fonts which has not installed in client machine and only installed in web server. In this case, I'm not interesting to use crystal report or any other third party components that need to register to use and has some limitations.How can I do that using ASP.NET with C#?Thanks.

SSRS 2005 external images won't display - images on DIFFERENT file server

  
Hi, Been having trouble getting external images to display in reports rendered on SSRS 2005. Images are displayed as a red X. However, my scenario is different from some of the examples I have read about. - The images are stored on a file server that is DIFFERENT from the box on which the Report Service is running. For various business reasons I cannot copy the images locally to the Report Service box. I am using "file://fileserver/path/to/image.jpg" to retrieve the images. - Since the file server does not have IIS installed, I cannot access the images using the URL method (http:// access). I need to use the file:// method. Currently I am prototyping this setup on my test box, which is running XP Pro and IIS 5.1. The Report Service is installed on this same box. I am currently testing this through the Report Manager web site (http://servername/Reports). The images are displayed using the Image control, which I added to the report using the visual report designer in Visual Studio 2005. It is set up with source=External and with "file://fileserver/path/to/image.jpg" path values. File names are retrieved from our database and file paths are built dynamically using a data processing extension I have written. My best guess as to why this is happening is that the ASPNET service account on my test box does not have access to the particular share on the file serve

How to put text from an external text file into a text box on a report.

  
Hi all, We're moving from our legacy reporting app to SQL Server Reporting Services 2008 and I'm converting our reports slowly but surely.  In our organization, one of our departments sends out letters that have standard marketing messages and disclaimers that they put into .rtf files.  Currently, our reporting application has an RTF box control that can do that fairly easily.  I've not found a similar control in SSRS 2008.  My thought, then, was to use a piece of embedded code in the report to grab the necessary text from the file and reference it in the Value of a Placeholder (using a Code.<FunctionName>.ToString() statement) - using HTML tags for the necessary formatting for those files. I don't care if I have to convert the existing RTF files to HTML files to do this, that's not an issue.  The code I'd come up with is this:  Public Function GetTextFile(ByVal strFileName as String) As String Dim oFile as System.IO.File Dim oRead as System.IO.StreamReader oRead = oFile.OpenText(strFileName) GetTextFile = oRead.ReadToEnd() End Function And the Expression I was using to get the text from the file is:  =Code.GetTextFile("HTMLTest.txt").ToString() Where "HTMLTest.txt" is the file name that I'm using.  The text itself is just a line of text with some HTML tags included for formatting - bold, color,

How to create .asmx file

  
I have a web service project that was created using Visual Studio 2005. In the IDE I can see that there is an .asmx file, and a source code file for the web service. I had doubts that my .asmx file (Starpe.asmx) was reflecting my code changes, so I searched for the .asmx file using windows search and then deleted it with the intention of re-creating it through a rebuild. I can still see the .asmx file in the IDE, and my code works. However I selected the .asmx file in the IDE and then did properties. I went to the path where it said the file was located, but the .asmx file is not there?? asmx files from other web services are there, but not the Starpe.asmx file. So how do I rebuild/recreate the .asmx file? Sure it shows in my IDE project, but it no longer exists on my hard drive.    

Create drop-down filter for External List

  
I hope this is an easy question. I will have an external list of a bunch of people.  There are several ways I want to display this data: All of them, Only the ones that have a value of 1-4 in the status field, Only the ones that have any other value in the status field, and people that have a value of 1-4 in the status field, but are at a certain location. I want to be able to put a drop-down filter above the list where people can select that. Could someone please point me in the right direction? Time is of the essence.  

Create excel file

  
Hi, I have create a webpart that's communicate with a oracle database. everything looks fine and works good. Now i want to add a button to create a excel file. I'm using Open XML SDK 2.0 but i get always a access denied when i create the excel. Here is some of my code // Create a spreadsheet document by supplying the filepath. // By default, AutoSave = true, Editable = true, and Type = xlsx.. SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create("excel.xlsx", SpreadsheetDocumentType.Workbook, false); // Add a WorkbookPart to the document. WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart(); workbookpart.Workbook = new Workbook(); // Add a WorksheetPart to the WorkbookPart. WorksheetPart worksheetPart = workbookpart.AddNewPart<WorksheetPart>(); worksheetPart.Worksheet = new Worksheet(new SheetData()); // Add Sheets to the Workbook. Sheets sheets = spreadsheetDocument.WorkbookPart.Workbook.AppendChild<Sheets>(new Sheets()); // Append a new worksheet and associate it with the workbook. Sheet sheet = new Sheet() { Id = spreadsheetDocument.WorkbookPart.GetIdOfPart(worksheetPart), SheetId = 1, Name = "mySheet" }; sheets.Append(sheet); workbookpart.Workbook.Save(); // Close the document. spreadsheetDocu

i have a XML File how to create a Tree View and how to get & post xml to cgi

  
<?xml version="1.0"?><Hierarchy>  <HD id="Acct">    <SH id="Books">      <TRK id="Annual">        <TGT id="ABA.0001">Closure of accounts for 2009-10</TGT>      </TRK>      <TRK id="Monthly">        <TGT id="ABM.0003">Finalization of expense accounts for Jun</TGT>      </TRK>    </SH>  </HD>  <HD id="Admin">    <SH id="GH">      <TRK id="Eqpt">        <TGT id="AGE.0001">Shifting of BSNL Landline.</TGT>      </TRK>    </SH>    <SH id="Offc">      <TRK id="Eqpt">        <TGT id="AOE.0002">Routine Maintenance</TGT>        <TGT id="AOE.0003">Electrical Eqpt Procedures</TGT>      </TRK>     

How to Create Excel File Silently with ASP.Net & C#?

  
Hi there, I am using VS2005, ASP.Net with C#. Here is little situation; and trying to resolve 2 issues. 1.       I need to add dynamic drop down in certain Excel sheet column. 2.        I need to create excel file on the web server silently. Here is the code I am trying to use;        DropDownList dropdownList = new DropDownList();        dropdownList.Items.Add("Item No 1");        dropdownList.Items.Add("Item No 2");        dropdownList.Items.Add("Item No 3");        dropdownList.Items.Add("Item No 4");         //Create an Excel App        Microsoft.Office.Interop.Excel.ApplicationClass excelApp = new                     Microsoft.Office.Interop.Excel.ApplicationClass();        excelApp.Visible = false;         //Interop params        object oMissing = System.Reflection.Missing.Value;       &n

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

  
Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

  
Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

Create zip file of dyanamicaly generated Excel sheet in c#

  
hi all,   I want to give product details in excel sheet but that excel sheet should be zipped and then pass it to user. I know how to create excel sheet from database but  how to pass that excel sheet into folder and then zip that folder..?   plz giv me any solution 

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

  
I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

How to create .sln file?

  
Hi Friends,         Can anybody explain me use of .sln file and how to create it for web-site project in asp.net.?          Whether it is created automatically or have to create on our own?Thanks in advance.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend