从MS SQL到datagrid的结论是什么？ [英] Conect manualy from MS SQL to datagrid?

问题描述

我需要连接

 tring saveStaff =选择roba为'Naziv artikla'，SUM（施放（kolicina as float））作为'Količina'来自（选择roba，kolicina来自mp_racun_roba联盟所有选择roba，kolicina来自mp_faktura_roba）as alltables group by roba; 

要清空数据网格



字符串工作但添加新列...不在我的实体栏中



我错了什么？



我尝试了什么：

 private void trenutne_zalihe2（）
 {
 using（SqlConnection openCon = new SqlConnection（cs））
 
 {
 
 string saveStaff =选择roba作为'Naziv artikla'，SUM（演员（kolicina as float））作为'Količina'从（选择roba，kolicina来自mp_racun_roba union all select roba，kolicina来自mp_faktura_roba）作为alltables group by roba; 
 
 
使用（SqlDataAdapter querySaveStaff = new SqlDataAdapter（saveStaff，cs））
 
 {
 DataTable dt = new DataTable（）; 
 querySaveStaff.Fill（dt）; 
 trenutnazalihadataGridView.DataSource = dt; 
 trenutnazalihadataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect; 
 
 trenutnazalihadataGridView.Columns [naziv_artikla] .FillWeight = 571; 
 trenutnazalihadataGridView.Columns [kolicina] .FillWeight = 200; 
 
 
 
 trenutnazalihadataGridView.Update（）; 
 trenutnazalihadataGridView.Refresh（）; 
} 
 
} 
 
} 

解决方案

似乎在您的查询中，您使用了列名称中的重音：Količina。但是在代码中你引用的列没有重音

 trenutnazalihadataGridView.Columns [   kolicina ] .FillWeight =  200 ; 

我会避免在名字中使用重音，因为你可能会遇到不同类型的问题。



另一件事是您在名称中使用了撇号，因此必须以与查询中相同的方式在代码中编写。



所以尝试将查询更改为

  string  saveStaff = < span class =code-string> 选择roba为'Naziv artikla'，SUM（cast（kolicina as float））为'kolicina'（select roba，来自mp_racun_roba联盟的kolicina全部选择roba，来自mp_faktura_roba的kolicina）作为alltables group by roba; 

和代码

 trenutnazalihadataGridView.Columns [  Naziv artikla] .FillWeight =  571 ; 
 trenutnazalihadataGridView.Columns [  kolicina] .FillWeight =  200  

I need to conect

tring saveStaff = "Select roba as 'Naziv artikla', SUM (cast(kolicina as float)) as 'Količina' from (select roba, kolicina from mp_racun_roba union all select roba, kolicina from mp_faktura_roba) as alltables group by roba";

To Empty datagrid

String work but add new column...not in my actualy column

What I wrong?

What I have tried:

private void trenutne_zalihe2()
        {
            using (SqlConnection openCon = new SqlConnection(cs))

            {

                string saveStaff = "Select roba as 'Naziv artikla', SUM (cast(kolicina as float)) as 'Količina' from (select roba, kolicina from mp_racun_roba union all select roba, kolicina from mp_faktura_roba) as alltables group by roba";

                                
                using (SqlDataAdapter querySaveStaff = new SqlDataAdapter(saveStaff, cs))

                {
                    DataTable dt = new DataTable();
                    querySaveStaff.Fill(dt);
                    trenutnazalihadataGridView.DataSource = dt;
                    trenutnazalihadataGridView.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
                      
                    trenutnazalihadataGridView.Columns["naziv_artikla"].FillWeight = 571;  
                    trenutnazalihadataGridView.Columns["kolicina"].FillWeight = 200; 
                 
                    

                    trenutnazalihadataGridView.Update();
                    trenutnazalihadataGridView.Refresh();
                }

            }

        }

解决方案

It seems that in your query you have used an accent in the column name: Količina. However in the code you refer the column without an accent

trenutnazalihadataGridView.Columns["kolicina"].FillWeight = 200;

I would avoid using accents in names since you may encounter different kinds of problems with them.

Another thing is that you have used apostrophes in the names so they have to be written in the code the same way as in the query.

So try changing the query to

string saveStaff = "Select roba as 'Naziv artikla', SUM (cast(kolicina as float)) as 'kolicina' from (select roba, kolicina from mp_racun_roba union all select roba, kolicina from mp_faktura_roba) as alltables group by roba";

and the code

trenutnazalihadataGridView.Columns["Naziv artikla"].FillWeight = 571;  
trenutnazalihadataGridView.Columns["kolicina"].FillWeight = 200;

这篇关于从MS SQL到datagrid的结论是什么？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！