Breaking News

Editors Picks

Saturday, December 31, 2011

read csv file using streamreader in c#


DataTable dt = new DataTable();
string line = null;
int i = 0; 
using (StreamReader sr = File.OpenText(@"c:\Data_file.csv"))
{  
      while ((line = sr.ReadLine()) != null)
      {
            string[] data = line.Split(',');
            if (data.Length > 0)
            {
                  if (i == 0)
                  {
                  foreach (var item in data)
                  {
                        dt.Columns.Add(new DataColumn());
                  }
                  i++;
             }
             DataRow row = dt.NewRow();
             row.ItemArray = data;
             dt.Rows.Add(row);
             }
      }
}
Read more ...

Bulk Insert into SQL Server using SqlBulkCopy


DataTable dt = new DataTable();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
      cn.Open();
      using (SqlBulkCopy copy = new SqlBulkCopy(cn))
      {
            copy.ColumnMappings.Add(0, 0);
            copy.ColumnMappings.Add(1, 1);
            copy.ColumnMappings.Add(2, 2);
            copy.ColumnMappings.Add(3, 3);
            copy.ColumnMappings.Add(4, 4);
            copy.DestinationTableName = "TableName";
            copy.WriteToServer(dt);
      }
} 
Read more ...

Wednesday, December 28, 2011

Simple Javascript Ajax Example


<html>
<head>
<title>Simple Ajax Exampletitle>

<script language="Javascript">
function xmlhttpPost(strURL) {
var xmlHttpReq = false;
var self = this;
// Mozilla/Safari
if (window.XMLHttpRequest) {
self.xmlHttpReq = new XMLHttpRequest();
}
// IE
else if (window.ActiveXObject) {
self.xmlHttpReq = new ActiveXObject("Microsoft.XMLHTTP");
}
self.xmlHttpReq.open('POST', strURL, true);
self.xmlHttpReq.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
self.xmlHttpReq.onreadystatechange = function() {
if (self.xmlHttpReq.readyState == 4) {
updatepage(self.xmlHttpReq.responseText);
}
}
self.xmlHttpReq.send(getquerystring());
}

function getquerystring() {
var form     = document.forms['f1'];
var word = form.word.value;
qstr = 'w=' + escape(word);  // NOTE: no '?' before querystring
return qstr;
}

function updatepage(str){
document.getElementById("result").innerHTML = str;
}
script>

head>
<body>
<form name="f1">
<p>
word:
<input name="word" type="text">
<input value="Go" type="button" onclick='JavaScript:xmlhttpPost("WebFrmforTest.aspx")'>p>
<div id="result">
div>
form>
body>
html>
Read more ...

Monday, December 26, 2011

Setting the default Button for a TextBox in ASP.NET


JavaScript function
function clickButton(e, buttonid)
{
var evt = e ? e : window.event;
var bt = document.getElementById(buttonid);
if (bt)
{
if (evt.keyCode == 13)
{
bt.click();
return false;
}
}
}

Call on button
<asp:ImageButton ID="ImageButton1" runat="server" Height="50" Width="50" BorderWidth="1"
CssClass="btnimage" ImageUrl="" OnClick="ImageButton1_Click" />
<input name="TextBox1" type="text" id="TextBox1" onkeypress="return clickButton(event,'ImageButton1')"  />
Read more ...

Contact Us

Name

Email *

Message *