Diabetes remedy

http://www.diabeteshormone.com/

Mission of this site is simplifying the science of Diabetes and Endocrinology for layman and to provide a platform of discussion and interaction among professionals.

You need not waste time in browsing and looking around for information; just by a single click of mouse you will reach your area of interest.

In this site, information about hormonal problems including Diabetes is provided by various modes of communication like text, animation, slide shows, videos, etc. with expectation that it will generate great interest for the patients and their families and will solve most of the unanswered queries.

Diabetes School is the area full of practical info of day to day use. In addition, site has a huge collection of recipes and a number of useful Health tools. Parents can know about health of their kids in health tools.

For Hindi speaking population; we have a Hindi section of website Madhumeha.com.

I hope diabeteshormone.com will serve its purpose.

Other Resources and gadgets usefull for diabetic patient.

Export data from excel to database using c#

using System;
using System.Data;
using System.Configuration;
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.Odbc;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
/* This code requires there should be same name of column in sql table as well as in excel file and name of sheet of excel file should be abc */
}
protected void Button1_Click(object sender, EventArgs e)
{
ExportExcelTOSql();
}
public void ExportExcelTOSql()
{
OdbcConnection connection;
SqlBulkCopy bulkCopy;
string strExcelPath = Server.MapPath("abc.xls");
string ConnectionString = @"server=DEL-SKUMAR\SPLENDIDCRM;database=TestDatabase;Integrated Security=SSPI;";
string conn = @"Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + strExcelPath;
using (connection = new OdbcConnection(conn))
{
//To place in sql
OdbcCommand command = new OdbcCommand("Select * FROM [abc$]", connection);
connection.Open();
using (OdbcDataReader dr = command.ExecuteReader())
{
using (bulkCopy = new SqlBulkCopy(ConnectionString))
{
bulkCopy.DestinationTableName = "EmployeeNotSentReport";
bulkCopy.WriteToServer(dr);
}
dr.Close();
}
//To place in dataset and manipulate at the time of insertion
//here abc is name of sheet in excel or you can place sheet1 the default name of sheet if not changed in excel file.
OdbcDataAdapter placeindataset = new OdbcDataAdapter("Select * FROM [abc$]", connection);
DataSet ds = new DataSet();
placeindataset.Fill(ds);
}
bulkCopy.Close();
connection.Close();
}
}

For further detail please refer to these books.