C#nedir?com Homepage
Forum Home Forum Home > C# / .NET > Visual C#
  New Posts New Posts RSS Feed - Datagridview header change
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Datagridview header change

 Post Reply Post Reply
   

Author
Message
adnan View Drop Down
Newbie
Newbie


Joined: 16 Temmuz 2013
Location: Turkey
Status: Offline
Points: 1
Post Options Post Options   Thanks (0) Thanks(0)   Quote adnan Quote  Post ReplyReply Direct Link To This Post Topic: Datagridview header change
    Posted: 16 Temmuz 2013 at 18:59
Merhaba C# da üzerinde çalıştığım bir projede excelden verileri alıp datagridde göstermem gerekiyor.Verileri çekiyorum datagride de aktarıyorum fakat exceldeki ilk satırın hücrelerini datagridde başlıklara atıyor ve sonraki satırdan itibaren datagride yazmaya başlıyor.Benim istediğim datagride bu verileri çekerken ilk satırın başlıklara gitmemesi başlık sabit bişey olabilir.
Kodlarım ;
openFileDialog1.InitialDirectory = "Desktop";
            openFileDialog1.FileName = "";
            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
               string isim, yol;
               isim = openFileDialog1.FileName;
               yol = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source= " + isim + "; Extended Properties='Excel 12.0;HDR=Yes;';";
               OleDbConnection con = new OleDbConnection(yol);
               con.Open();
               OleDbDataAdapter adapte = new OleDbDataAdapter("Select * from [Sayfa1$]", yol);
               dt = new System.Data.DataTable();
               adapte.Fill(dt);
               dataGridView1.DataSource = dt;

Umarım açıklayıcı olmuştur. Acil yardımlarınızı bekliyorum şimdiden teşekkürler.
Back to Top
mavi_anka_01 View Drop Down
Senior Member
Senior Member


Joined: 04 Kasım 2008
Status: Offline
Points: 256
Post Options Post Options   Thanks (0) Thanks(0)   Quote mavi_anka_01 Quote  Post ReplyReply Direct Link To This Post Posted: 22 Temmuz 2013 at 13:56
Bir ara benimde başıma gelmişti. Nasıl çözdüm tam hatırlamıyorum ama sanırım satır satır okuyup datagride yazmıştım tam emin değilim senin için bi kontrol edeyim kodları bulunca paylaşırım.
^^G_ü_V_e_N^^
Back to Top
Ikado View Drop Down
Newbie
Newbie


Joined: 24 Nisan 2008
Location: Turkey
Status: Offline
Points: 25
Post Options Post Options   Thanks (0) Thanks(0)   Quote Ikado Quote  Post ReplyReply Direct Link To This Post Posted: 22 Temmuz 2013 at 16:30
gelen datatable'ın ilk satırını ucurursan sorun ortadan kalkabilir.
Back to Top
polis88 View Drop Down
Senior Member
Senior Member


Joined: 10 Kasım 2011
Status: Offline
Points: 721
Post Options Post Options   Thanks (0) Thanks(0)   Quote polis88 Quote  Post ReplyReply Direct Link To This Post Posted: 22 Temmuz 2013 at 22:23
HDR=Yes; olan kısmı HDR=No; yaz eğer olmassa IMEX=1 bunu ekle


İletişim
24 Ekim 2011 Saat= 9:00 Yazılım Kursuna Başlad
Back to Top
jimmyoutlet10te View Drop Down
Newbie
Newbie


Joined: 23 Temmuz 2013
Status: Offline
Points: 4
Post Options Post Options   Thanks (0) Thanks(0)   Quote jimmyoutlet10te Quote  Post ReplyReply Direct Link To This Post Posted: 23 Temmuz 2013 at 09:24
types of two liters jimmy choo uk two drop. Cotton and chemical fiber cheap jimmy choo shoes clothing apparel growing trend, an increase of 13.44 percent and 1.92 percent, compared with January-November karen millen outlet 2009, the growth rate higher than the 0.58 and 0.41 percentage points. Wool garments, silk and vegetable fiber clothing is still a downward trend, decreased by polo ralph lauren sale 22.44%, 38.27%, compared with January-November 2009, the high growth rate of wool clothing 0.89 percent, silk and vegetable fiber apparel low growth rate of karen millen dresses 0.03 jimmy choo outlet percentage points. Silk and vegetable fiber apparel downward trend is still karen millen sale very evident. Judging from the number of imports, four species are also two liters two jimmy choo sale drop. Cotton clothing and chemical fiber garments were up 9.27% ​​and 18.74%, compared with January-November 2009, the growth rate were higher 1.78 and 0.82 percentage points. Wool garments, silk and vegetable fiber apparel decreased by 12.61%, 38.02%, compared with January-November 2009, the growth ralph lauren polo shirts sale rate and a high polo ralph lauren 1.08 percentage points. In jimmy choo shoes 2009 the number of U.S. apparel imports from China slow recovery, but the silk and vegetable fiber apparel downward trend is not much relief. Non-apparel jimmy choo shoes categories: downward trend evident decline slowed in 2009, U.S. imports from China are karen millen uk still non-apparel products decreased, the amount of jimmy choo sale imports and quantities decreased 15.37% year on jimmy choo outlet year and 5.67%, compared with January-November 2009, increasing speed, respectively, 1.51 and 2.33 percentage points high, jimmy choo wedding shoes decline slowed. Judging from the product category, the four major types of products either from the amount or from the quantity, are showing a downward trend, non-wool apparel products, silk and plant fiber products of non-apparel products decreased greatly. Yarn and fabric: the growth rate is inversely proportional to the number and amount of 2009, U.S. imports from China increased the amount of yarn, decline, decrease the amount of imported fabric, quantity growth. January to November 2009 compared with imported yarn amount and number of high growth rate were 35.47 and 2.11 percentage points. A significant increase in the amount of growth, indicating that China's foreign trade yarn competitiveness of enterprises is growing. The amount of imported fabric down, volume growth, compared with 2009, the amount and number of imported fabric high 2.56,3.83 percentage points, respectively, import trends to rise slowly.

Clothing extension and expansion of endogenous growth inward transformation - Statistics - Business Wire - China apparel network
Industry Analysis: Apparel extension and expansion of endogenous growth inward shift
 2012 annual reports of listed companies some clothing Analysis
 On the development trend, garment enterprises to enhance the value of the enterprise, we must take into account the short-term benefits and long-term effectiveness of the balance between rapid expansion and to find a balance between endogenous growth points, in particular, to raise awareness and operational capital ability to achieve fast jimmy choo uk and sustainable growth.
 Recently, the textile and 
Back to Top
 Post Reply Post Reply
  Share Topic   
   


Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 11.01
Copyright ©2001-2014 Web Wiz Ltd.