Click here to Skip to main content
15,909,332 members
Home / Discussions / C#
   

C#

 
AnswerRe: DataSet object not being reconized inside dataview constructor Pin
Ashwini Dhale31-Dec-15 23:58
professionalAshwini Dhale31-Dec-15 23:58 
C#
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(Command);
          

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





Pass the command object in adapter
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 
QuestionSetPixel on Controls Pin
Member 1221969226-Dec-15 21:28
Member 1221969226-Dec-15 21:28 
AnswerRe: SetPixel on Controls Pin
Richard MacCutchan26-Dec-15 22:09
mveRichard MacCutchan26-Dec-15 22:09 
AnswerRe: SetPixel on Controls Pin
OriginalGriff26-Dec-15 22:14
mveOriginalGriff26-Dec-15 22:14 
AnswerRe: SetPixel on Controls Pin
Dave Kreskowiak27-Dec-15 11:04
mveDave Kreskowiak27-Dec-15 11:04 
AnswerRe: SetPixel on Controls Pin
BillWoodruff27-Dec-15 22:19
professionalBillWoodruff27-Dec-15 22:19 
AnswerRe: SetPixel on Controls Pin
John Torjo28-Dec-15 0:05
professionalJohn Torjo28-Dec-15 0:05 
QuestionHow can I replace all text in a listBox1 that matches "some text " with "other text "? Pin
Member 1041097226-Dec-15 8:41
Member 1041097226-Dec-15 8:41 
AnswerRe: How can I replace all text in a listBox1 that matches "some text " with "other text "? Pin
BillWoodruff26-Dec-15 9:46
professionalBillWoodruff26-Dec-15 9:46 
QuestionDynamic Treeview using C# Pin
Member 1124005623-Dec-15 19:49
Member 1124005623-Dec-15 19:49 
SuggestionRe: Dynamic Treeview using C# Pin
CHill6023-Dec-15 23:14
mveCHill6023-Dec-15 23:14 
SuggestionRe: Dynamic Treeview using C# Pin
Richard Deeming4-Jan-16 3:26
mveRichard Deeming4-Jan-16 3:26 

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.