select newid()
select abs(checksum(newid())) as number
select abs(cast(cast(newid() as varbinary(10)) as int)) as number
Wednesday, December 31, 2008
Tuesday, December 30, 2008
SalesForce DateTime Webservice Partner API
SalesForce DateTime Field is Saving in GMT Format
Convert your DateTime value to GMT prior to saving it Like following for PST:
Sample Lead generation Date and time for sql server:
CONVERT(VARCHAR(23),cast(DATEADD(hh,8,a.LeadGenDateTime) as datetime), 126)+'-00:00'
Tuesday, December 23, 2008
Saturday, December 13, 2008
Wednesday, December 10, 2008
Excel to Sql-server table Complete code C# asp.net 2.0 / 3.5, SqlBulkCopy
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpLoad id="FileUpLoad1" runat="server" />
<asp:Button id="UploadBtn" Text="Upload File" OnClick="UploadBtn_Click" runat="server" Width="105px" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Upload To Sql Table" />
<asp:Label ID="Label1" runat="server" Width="188px"></asp:Label></div>
</form>
</body>
</html>
code Behind
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:FileUpLoad id="FileUpLoad1" runat="server" />
<asp:Button id="UploadBtn" Text="Upload File" OnClick="UploadBtn_Click" runat="server" Width="105px" />
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Upload To Sql Table" />
<asp:Label ID="Label1" runat="server" Width="188px"></asp:Label></div>
</form>
</body>
</html>
code Behind
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
using System.Data.SqlClient;
using System.IO;
using System.Data.Common;
public partial class Default5 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void UploadBtn_Click(object sender, EventArgs e)
{
if (FileUpLoad1.HasFile)
{
// FileUpLoad1.SaveAs(@"c:\\inetpub\\wwwroot\\sftest3\\App_Data\\" + FileUpLoad1.FileName);
string filepath=Server.MapPath("~/App_Data/" + FileUpLoad1.FileName);
FileUpLoad1.SaveAs(filepath);
Label1.Text = "File Uploaded: " + FileUpLoad1.FileName ;
}
else
{
Label1.Text = "No File Uploaded.";
}
}
void dataupload()
{
// Connection String to Excel Workbook
string excelConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\inetpub\\wwwroot\\sftest3\\App_Data\\ProductionFile.xls;Extended Properties=""Excel 8.0;HDR=YES;""";
// Create Connection to Excel Workbook
using (OleDbConnection connection = new OleDbConnection(excelConnectionString))
{
OleDbCommand command = new OleDbCommand("Select * FROM [Upload1$]", connection);
connection.Open();
// Create DbDataReader to Data Worksheet
using (DbDataReader dr = command.ExecuteReader())
{
// SQL Server Connection String
string sqlConnectionString = "Data Source=Local;Initial Catalog=dev;User ID=dev;Password=dev";
// Bulk Copy to SQL Server
using (SqlBulkCopy bulkCopy =
new SqlBulkCopy(sqlConnectionString))
{
bulkCopy.DestinationTableName = "LeadTemp";
bulkCopy.WriteToServer(dr);
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
dataupload();
}
}
Upload a file using asp.net 2.0 c# and file control sample code
<%
@ Page Language="C#" AutoEventWireup="true" CodeFile="Default5.aspx.cs" Inherits="Default5" %><!
DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><
html xmlns="http://www.w3.org/1999/xhtml" ><
head runat="server"> <title>Untitled Page</title></
head><
body> <form id="form1" runat="server"> <div> <asp:FileUpLoad id="FileUpLoad1" runat="server" /><
asp:Button id="UploadBtn" Text="Upload File" OnClick="UploadBtn_Click" runat="server" Width="105px" /> <asp:Label ID="Label1" runat="server" Width="188px"></asp:Label></div> </form></
body></
html> code behind
using
System;using
System.Data;using
System.Configuration;using
System.Collections;using
System.Web;using
System.Web.Security;using
System.Web.UI;using
System.Web.UI.WebControls;using
System.Web.UI.WebControls.WebParts;using
System.Web.UI.HtmlControls;public
partial class Default5 : System.Web.UI.Page{
protected void Page_Load(object sender, EventArgs e){
}
protected void UploadBtn_Click(object sender, EventArgs e){
if (FileUpLoad1.HasFile){
FileUpLoad1.SaveAs(
@"C:\webfiles\" + FileUpLoad1.FileName);Label1.Text =
"File Uploaded: " + FileUpLoad1.FileName ;}
else{
Label1.Text =
"No File Uploaded.";}
}
}
Subscribe to:
Posts (Atom)