Click here to Skip to main content
15,889,335 members
Home / Discussions / C#
   

C#

 
AnswerRe: Gradient Colors in Memory Pin
BillWoodruff1-Jan-16 20:59
professionalBillWoodruff1-Jan-16 20:59 
QuestionEmail with Mailchimp Pin
balaji201030-Dec-15 21:32
balaji201030-Dec-15 21:32 
AnswerRe: Email with Mailchimp Pin
Richard MacCutchan30-Dec-15 21:46
mveRichard MacCutchan30-Dec-15 21:46 
GeneralRe: Email with Mailchimp Pin
balaji20104-Jan-16 4:15
balaji20104-Jan-16 4:15 
AnswerRe: Email with Mailchimp Pin
Marco Bertschi1-Jan-16 5:59
protectorMarco Bertschi1-Jan-16 5:59 
GeneralMessage Closed Pin
30-Dec-15 17:45
Member 1223717030-Dec-15 17:45 
AnswerRe: Need people for project Pin
Anurag Gandhi30-Dec-15 18:31
professionalAnurag Gandhi30-Dec-15 18:31 
QuestionDataSet object not being reconized inside dataview constructor Pin
Member 1144944730-Dec-15 5:55
Member 1144944730-Dec-15 5:55 
I want to add a filter button to the datagrid with, but it shows an error in the dataview constructor ('The name 'ds' does not exist in the current context'). What might be wrong?

C#
public void filtrar_Click(object sender, EventArgs e)
        {
            DataView dv = new DataView(ds);
           
          
            //define a ordenação e o filtro
            dv.AllowNew = false;
            dv.AllowDelete = true;            
            dv.RowFilter = "NIF Like '" + textBoxNIF.Text + "*'";
            //exibe o resultado
            grid_lic.DataSource = dv;
        }

        public void Consulta()
        {
            //MessageBox.Show(grid_lic.CurrentRow.Cells[3].Value.ToString());
            con = new OdbcConnection("driver= {MySQL ODBC 5.1 Driver};server=192.168.19.78; database=licenciamento; uid=estagio; password=1234; option = 3 ");
            con.Open();

            OdbcCommand Command = con.CreateCommand();
            Command.CommandText = "select lojas.Id, lojas.NIF, lojas.Loja, lojas.Bloquear, lojas.DataFim, lojas.lastupdate, lojas.Nome, " +
            " licenciamentoloja.EArtigo, licenciamentoloja.EFamilia, licenciamentoloja.EClientes, licenciamentoloja.EFornecedores, licenciamentoloja.Evendas," +
            "licenciamentoloja.ECompras, licenciamentoloja.EStocks, licenciamentoloja.ELiquidacao, licenciamentoloja.ECaixas, licenciamentoloja.EInfoStock," +
            "licenciamentoloja.ZSArtigos, licenciamentoloja.ZSClientes, licenciamentoloja.ZSStocks, licenciamentoloja.id from lojas inner join licenciamentoloja on lojas.NIF = licenciamentoloja.NIF and lojas.Loja = licenciamentoloja.loja";

            Command.CommandType = CommandType.Text;
            Command.Connection = con;

            OdbcDataAdapter adapter = new OdbcDataAdapter();
            adapter.SelectCommand = Command;

            DataSet ds = new DataSet();
            adapter.Fill(ds);
            grid_lic.DataSource = ds;
            grid_lic.DataMember = ds.Tables[0].TableName;

AnswerRe: DataSet object not being reconized inside dataview constructor Pin
Richard Andrew x6430-Dec-15 6:23
professionalRichard Andrew x6430-Dec-15 6:23 
GeneralRe: DataSet object not being reconized inside dataview constructor Pin
Member 1144944730-Dec-15 7:28
Member 1144944730-Dec-15 7:28 
AnswerRe: DataSet object not being reconized inside dataview constructor Pin
Richard Andrew x6430-Dec-15 9:04
professionalRichard Andrew x6430-Dec-15 9:04 
AnswerRe: DataSet object not being reconized inside dataview constructor Pin
Ashwini Dhale31-Dec-15 23:58
professionalAshwini Dhale31-Dec-15 23:58 
GeneralRe: DataSet object not being reconized inside dataview constructor Pin
Ashwini Dhale1-Jan-16 0:04
professionalAshwini Dhale1-Jan-16 0:04 
QuestionReal time communication between web to windows and vice versa Pin
gautamkhatri42829-Dec-15 19:49
gautamkhatri42829-Dec-15 19:49 
QuestionRe: Real time communication between web to windows and vice versa Pin
Agent__00729-Dec-15 19:58
professionalAgent__00729-Dec-15 19:58 
AnswerRe: Real time communication between web to windows and vice versa Pin
gautamkhatri42829-Dec-15 20:54
gautamkhatri42829-Dec-15 20:54 
GeneralRe: Real time communication between web to windows and vice versa Pin
BillWoodruff29-Dec-15 21:57
professionalBillWoodruff29-Dec-15 21:57 
GeneralRe: Real time communication between web to windows and vice versa Pin
gautamkhatri42829-Dec-15 22:43
gautamkhatri42829-Dec-15 22:43 
AnswerRe: Real time communication between web to windows and vice versa Pin
Richard MacCutchan29-Dec-15 22:31
mveRichard MacCutchan29-Dec-15 22:31 
GeneralRe: Real time communication between web to windows and vice versa Pin
gautamkhatri42829-Dec-15 22:47
gautamkhatri42829-Dec-15 22:47 
GeneralRe: Real time communication between web to windows and vice versa Pin
Richard MacCutchan29-Dec-15 23:14
mveRichard MacCutchan29-Dec-15 23:14 
GeneralRe: Real time communication between web to windows and vice versa Pin
Pete O'Hanlon30-Dec-15 1:23
mvePete O'Hanlon30-Dec-15 1:23 
GeneralRe: Real time communication between web to windows and vice versa Pin
jschell30-Dec-15 7:05
jschell30-Dec-15 7:05 
Questioncall a HTML file from a universal C# project to show a map Pin
yemen_mansour28-Dec-15 12:55
yemen_mansour28-Dec-15 12:55 
AnswerRe: call a HTML file from a universal C# project to show a map Pin
Richard Andrew x6428-Dec-15 14:34
professionalRichard Andrew x6428-Dec-15 14:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.