Read the emailID from txt file

Read the emailID from txt file:
_____________________________________

Using Regular Expression, we can do this.

the textfile format may be in any format like

sdfsd

danasegarane@test.com,

test@test.com,

me@me.com

sdf

sdfs

dfsd


First Method:

string pattern = @"[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*@(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?";

System.Text.RegularExpressions.Regex reg = new System.Text.RegularExpressions.Regex(pattern);

//Read file
string sFileContents =System.IO.File.ReadAllText(Server.MapPath("Email.txt"));

System.Text.RegularExpressions.MatchCollection mc = reg.Matches(sFileContents);

//string array for stroing
System.Collections.Generic.List str = new System.Collections.Generic.List();foreach (System.Text.RegularExpressions.Match m in mc)

{

str.Add(m.Value);

}

OR

Second Method:

using System.Text.RegularExpressions;
using System.IO;

try
{
//the file is in the root - you may need to change it
string filePath = MapPath("~") + "/EmailText.txt";

using (StreamReader sr = new StreamReader( filePath) )
{
string content = sr.ReadToEnd();
if (content.Length > 0)
{
//this pattern is taken from Asp.Net regular expression validators library
string pattern = @"\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*";
MatchCollection mc = Regex.Matches(content, pattern);
for (int i = 0; i <>

Export Data To Excel using ADO.Net

Excel Workbook is just like database with sheets corresponding to tables. See the mapping below.

Database <—————> Excel Workbook

Sheet <—————-> Table

Connection String for Excel 97-2003 Format (.XLS)

For Excel 97-2003 format Microsoft Jet OLEDB Driver 4.0 is used. A sample connection string as follows.

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties='Excel 8.0;HDR=Yes'"

Connection String for Excel 2007 Format (.XLSX)

For Excel 2007 format the new Microsoft Ace OLEDB Driver 12.0 is used. A sample connection string as follows.

"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Book1.xlsx;Extended Properties='Excel 8.0;HDR=Yes'"

Rest everything is same for both versions. One thing to note Microsoft Ace OLEDB Driver 12.0 works for both Excel 2003 and Excel 2007 format.

You can specify whether your Excel file has Headers or not using the HDR property.

When HDR is set to Yes the First Row is considered as the Header of the Excel file.

Establish a Connection

String strExcelConn = "Provider=Microsoft.Jet.OLEDB.4.0;"

+ "Data Source=Book1.xls;"

+ "Extended Properties='Excel 8.0;HDR=Yes'";

OleDbConnection connExcel = new OleDbConnection(strExcelConn);

OleDbCommand cmdExcel = new OleDbCommand();

cmdExcel.Connection = connExcel;

Accessing Sheets

connExcel.Open();

DataTable dtExcelSchema;

dtExcelSchema = connExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);

connExcel.Close();

The dtExcelSchema contains all the Sheets present in your Excel Workbook

You access them in the following way

string sheetName = dtExcelSchema.Rows[0]["TABLE_NAME"];

This will give the name of the first sheet. i.e. Sheet1$

Create a new sheet

cmdExcel.CommandText = "CREATE TABLE [tblData]" +

"(ID varchar(10), Name varchar(50));";

connExcel.Open();

cmdExcel.ExecuteNonQuery();

connExcel.Close();

The above code creates a new Sheet in the Excel Workbook with the name tblData with two columns ID and Name.

Insert Record into Sheet

connExcel.Open();

cmdExcel.CommandText = "INSERT INTO [tblData] (ID, Name)" +

" values ('1', 'MAK')";

cmdExcel.ExecuteNonQuery();

connExcel.Close();

Update existing Record into Sheet

connExcel.Open();

cmdExcel.CommandText = "UPDATE [tblData] " +

"SET Name ='John' WHERE ID = '1'";

cmdExcel.ExecuteNonQuery();

connExcel.Close();

C# How to place an arraylist inside a Session Variable and Iterate through it

Question:

Hi,

In my web form, I want to store multiple IDs inside an arraylist and then store the arraylist in a Session Variable (e.g. Session["InstallationID"]) to use it in a different web form where I want to use every ID inside the arraylist.

How do I place the arraylist inside the Session Variable and then take each ID off of it to be used in a SELECT statement?

Answer:

Something like this:

1    protected void Page_Load(object sender, EventArgs e)
2    {
3        if (!IsPostBack)
4        {
5            List<int> ids = new List<int> {1, 2, 3, 4, 5};
6            Session["myIds"] = ids;
7        }
8    }
9    
10   protected void buttonSubmit_Click(object sender, EventArgs e)
11   {
12       List<int> ids = Session["myIds"] != null ? (List<int>) Session["myIds"] : null;
13       if (ids != null)
14       {
15           foreach (int id in ids)
16           {
17               ListBox1.Items.Add(String.Format("select * from customer where id={0}", id));
18           }
19       }
20   }

OR


protected void Page_Load(object sender, EventArgs e)
  {
      //Save
      ArrayList idList = new ArrayList();
      idList.Add("1");
      idList.Add("2");
      idList.Add("3");
      Session["InstallationId"] = idList;
  }//Page2

protected void Page_Load(object sender, EventArgs e)

{

//Retreive

ArrayList idList = (ArrayList)Session["InstallationId"];

string id1 = idList[0].ToString() ;

string id2 = idList[1].ToString();

string id3 = idList[2].ToString();

}

Refer for references: http://forums.asp.net/t/1425975.aspx

Maintain Scroll Position after Asynchronous Postback

Maintain Scroll Position after Asynchronous Postback

Do you want to maintain the scroll position of a GridView, Div, Panel, or whatever that is inside of an UpdatePanel after an asynchronous postback? Normally, if the updatepanel posts back, the item will scroll back to the top because it has been reloaded. What you need to do is “remember” where the item was scrolled to and jump back to there after the postback. Place the following script after the ScriptManager on your page. And since the _endRequest event of the PageRequestManager happens before the page is rendered, you’ll never even see your item move!

<script type="text/javascript">
var xPos, yPos;
var prm = Sys.WebForms.PageRequestManager.getInstance();
prm.add_beginRequest(BeginRequestHandler);
prm.add_endRequest(EndRequestHandler);
function BeginRequestHandler(sender, args) {
xPos = $get('scrollDiv').scrollLeft;
yPos = $get('scrollDiv').scrollTop;
}
function EndRequestHandler(sender, args) {
$get('scrollDiv').scrollLeft = xPos;
$get('scrollDiv').scrollTop = yPos;
}
</script>