Bulk insert data into table and use cursor to insert data into another table

ASPX

 protected void Button_Click(object sender, EventArgs e)
        {
            if (fileupload.HasFile == true)
            {
                if (!Directory.Exists(Server.MapPath(@"~\ImportData\")))
                    Directory.CreateDirectory(Server.MapPath(@"~\ImportData\"));
                string path = Server.MapPath((@"~\ImportData\") + importdata.FileName);
                if (File.Exists(path))
                {
                    FileInfo f = new FileInfo(path);
                    f.Delete();
                }
                importdata.SaveAs(path);
                obj.FilePath = path;
                importData.Save(obj);
                importData.Transfer();
                lblMasage.Text = "Record Import Successfully....";
            }
        }

SP FOR   importData.Save(obj);

CREATEprocedure [dbo].[ImportData]       
@FilePath Varchar(500)     
as       
begin        
declare @sql varchar(max)            
set @sql='Truncate table temp'      
exec(@sql)      
set @sql='BULK INSERT temp FROM ''' +@FilePath+''' WITH ( DATAFILETYPE = ''char'', FIELDTERMINATOR =''                  '', ROWTERMINATOR = ''\n'' )'         
exec(@sql)      
End     


SP FOR   importData.Transfer()

CREATE procedure [dbo].[insertTemp]     
as     
begin     
declare @eid int,@dt varchar(30) 
declare chk cursor for      
select EmpId,convert(VARCHAR(30),convert(DATETIME,EmpDate,103),121) from Temp 
open chk      
fetch next from chk into @eid ,@dt      
while @@FETCH_STATUS=0      
begin   
print  @dt   
if not exists(select EmpId from temp1 where EmpId=@eid and EmpDate=@dt )      
begin      
print '1' 
INSERT INTO [temp1](EmpId,EmpDate)      
VALUES ( @eid ,@dt)      
End  
else 
begin 
print '0' 
end     
fetch next from chk into @eid ,@dt    
End      
Close chk      
DEALLOCATE chk     
end

read more

To Upload only specific extension file using javascript

JAVASCRIPT

<script type="text/javascript">
        function GetFileName(val) {
            jQuery('#<%=TextBox1.ClientID %>').val(val).trigger('change');
            return true;
        }
    </script>



    <script type="text/javascript">

        function ValidateFile(Source, args) {
            var fuData = document.getElementById('<%= importdata.ClientID %>');
            var FileUploadPath = fuData.value;
            var Extension = FileUploadPath.substring(FileUploadPath.lastIndexOf('.') + 1).toLowerCase();
            if (Extension == "txt") {
                args.IsValid = true;
            }
            else {
                args.IsValid = false;
                document.getElementById('<%= importdata.ClientID %>').value = "";
            }
        }




ASPX


<asp:FileUpload ID="importdata" runat="server" />
 <asp:CustomValidator ID="CusFileType" runat="server" ClientValidationFunction="ValidateFile"
ControlToValidate="importdata" Display="Static" ErrorMessage="Please Select a Text File" ForeColor="Red" SetFocusOnError="True" />

read more

Get date and days based on month and year sql server

SP

CREATE   PROCEDURE [dbo].[GetDateDaily]
@Month int=null ,
@Year int=null

AS 
BEGIN 
DECLARE @DATEFROM AS DATETIME 
DECLARE @DATETO AS DATETIME 
DECLARE @FirstPart AS VARCHAR(50) 
DECLARE @HOLDER TABLE(DATE DATETIME,n varchar(50)) 
SET @DATEFROM =DATEADD(month,@Month-1,DATEADD(year,@Year-1900,0)); 
SET @DATETO = DATEADD(day,-1,DATEADD(month,@Month,DATEADD(year,@Year-1900,0)));   
 
SELECT @FirstPart = (DATENAME(WEEKDAY, (@DATEFROM))) 
INSERT INTO @HOLDER (DATE,n) 
VALUES(@DATEFROM,@FirstPart) 
WHILE @DATEFROM < @DATETO 
BEGIN 
    SELECT @DATEFROM = DATEADD(D, 1, (@DATEFROM)) 
 SELECT @FirstPart =  (DATENAME(WEEKDAY, (@DATEFROM))) 
    INSERT INTO @HOLDER(DATE,n ) 
    VALUES(@DATEFROM,@FirstPart) 
END 

select CONVERT(varchar(10),DATE,105) as DATE,n from @HOLDER


Execution

EXEC GetDateDaily 10 ,2014

output

01-10-2014    Wednesday
02-10-2014    Thursday
03-10-2014    Friday
04-10-2014    Saturday
05-10-2014    Sunday
06-10-2014    Monday
07-10-2014    Tuesday
08-10-2014    Wednesday
09-10-2014    Thursday
10-10-2014    Friday
11-10-2014    Saturday
12-10-2014    Sunday
13-10-2014    Monday
14-10-2014    Tuesday
15-10-2014    Wednesday
16-10-2014    Thursday
17-10-2014    Friday
18-10-2014    Saturday
19-10-2014    Sunday
20-10-2014    Monday
21-10-2014    Tuesday
22-10-2014    Wednesday
23-10-2014    Thursday
24-10-2014    Friday
25-10-2014    Saturday
26-10-2014    Sunday
27-10-2014    Monday
28-10-2014    Tuesday
29-10-2014    Wednesday
30-10-2014    Thursday
31-10-2014    Friday

read more

To check time entered is less than 24 hours and 60 minutes

Javascript

 function ChkTimeUp(txt) {

            var str = document.getElementById(txt).value;
            if (str.length == 2) {
                if (str > 24) {
                    alert("Hour Must be less than 24.")
                    document.getElementById(txt).value = "";
                }
                else {
                    str = str + ".";
                    document.getElementById(txt).value = str;
                }

            }
            else if (str.length == 5) {
                if (str.substring(3, 5) >= 60) {
                    alert("Minute Must be less than 60")
                    document.getElementById(txt).value = str.substring(0, 3);
                }
            }
            else if (str.length >= 5) {
                alert("Only Two Characters allowed After Decimal. ")
                document.getElementById(txt).value = str.substring(0, 3);
            }
        }


ASPX

  <asp:TextBox ID="txtInTime" Width="90%" CssClass="formTextBox" onkeyup="ChkTimeUp(this.id)"  onkeypress="return ChkPress(this.id,event)" runat="server"></asp:TextBox>

read more