Posted by: teddywijaya on: 23 Maret 2009
private void ThisAddIn_Startup(object sender, System.EventArgs e)
{
SqlDataReader reader = null;
string myConnectionString = "Data Source=.\\SQLEXPRESS;Initial Catalog=dbtest;Integrated Security=True;";
SqlConnection myConnection = new SqlConnection(myConnectionString);
string myInsertQuery = "SELECT npm,nama FROM mhs";
SqlCommand myCommand = new SqlCommand(myInsertQuery);
myCommand.Connection = myConnection;
myConnection.Open();
reader = myCommand.ExecuteReader();
Excel.Worksheet activeWorksheet = ((Excel.Worksheet)Application.ActiveSheet);
Excel.Range cellB1 = activeWorksheet.get_Range("B1", missing);
cellB1.Value2 = "NPM";
cellB1.EntireColumn.ColumnWidth = 10;
Excel.Range cellC1 = activeWorksheet.get_Range("C1", missing);
cellC1.Value2 = "Nama";
//Mencetak isi table mhs ke excel dari cell B2
int counter = 2; //Set awal baris
while (reader.Read())
{
cellB1.get_Offset(1, 0).Value2 = (String)reader[0];
cellC1.get_Offset(1, 0).Value2 = (String)reader[1];
counter++;
}
myCommand.Connection.Close();
}
Selamat mencoba
Posted by: teddywijaya on: 4 Februari 2008
Like Charles said “Semuanya berawal dari hello world…” ![]()
Komentar Terakhir