Click here to Skip to main content
15,891,204 members
Home / Discussions / C#
   

C#

 
QuestionABCPDF library and using dll Pin
Mol4ok3-Dec-15 23:48
Mol4ok3-Dec-15 23:48 
AnswerRe: ABCPDF library and using dll Pin
OriginalGriff4-Dec-15 0:06
mveOriginalGriff4-Dec-15 0:06 
GeneralRe: ABCPDF library and using dll Pin
Member 1198551412-Mar-18 1:29
Member 1198551412-Mar-18 1:29 
GeneralRe: ABCPDF library and using dll Pin
OriginalGriff12-Mar-18 1:38
mveOriginalGriff12-Mar-18 1:38 
QuestionHow to make a list that contain lists which contain lists Pin
kmkmahesh3-Dec-15 20:53
professionalkmkmahesh3-Dec-15 20:53 
AnswerRe: How to make a list that contain lists which contain lists Pin
OriginalGriff3-Dec-15 21:34
mveOriginalGriff3-Dec-15 21:34 
AnswerRe: How to make a list that contain lists which contain lists Pin
Pete O'Hanlon3-Dec-15 21:37
mvePete O'Hanlon3-Dec-15 21:37 
AnswerRe: How to make a list that contain lists which contain lists Pin
LeHuuTien3-Dec-15 22:15
LeHuuTien3-Dec-15 22:15 
AnswerRe: How to make a list that contain lists which contain lists Pin
BillWoodruff4-Dec-15 4:04
professionalBillWoodruff4-Dec-15 4:04 
QuestionProblem with Event Pin
Member 121764283-Dec-15 10:19
Member 121764283-Dec-15 10:19 
AnswerRe: Problem with Event Pin
Matt T Heffron3-Dec-15 11:09
professionalMatt T Heffron3-Dec-15 11:09 
AnswerRe: Problem with Event Pin
Mycroft Holmes3-Dec-15 12:07
professionalMycroft Holmes3-Dec-15 12:07 
Questionwcf with net msmq binding Pin
Member 106619973-Dec-15 2:21
Member 106619973-Dec-15 2:21 
SuggestionRe: wcf with net msmq binding Pin
Richard MacCutchan3-Dec-15 3:51
mveRichard MacCutchan3-Dec-15 3:51 
QuestionWindows Service with multitple jobs in c# Pin
Member 109327092-Dec-15 12:02
Member 109327092-Dec-15 12:02 
AnswerRe: Windows Service with multitple jobs in c# Pin
Dave Kreskowiak2-Dec-15 12:33
mveDave Kreskowiak2-Dec-15 12:33 
QuestionHandle transaction without deadlock Pin
Member 106619971-Dec-15 4:25
Member 106619971-Dec-15 4:25 
AnswerRe: Handle transaction without deadlock Pin
Eddy Vluggen1-Dec-15 4:55
professionalEddy Vluggen1-Dec-15 4:55 
QuestionTimelineTool WPF C# Help Pin
Member 121189591-Dec-15 3:47
Member 121189591-Dec-15 3:47 
AnswerRe: TimelineTool WPF C# Help Pin
Pete O'Hanlon1-Dec-15 4:01
mvePete O'Hanlon1-Dec-15 4:01 
SuggestionRe: TimelineTool WPF C# Help Pin
Matt T Heffron1-Dec-15 8:06
professionalMatt T Heffron1-Dec-15 8:06 
QuestionJamaa SMPP: A connection attempt failed because the connected party did not properly respond Pin
Jassim Rahma1-Dec-15 0:38
Jassim Rahma1-Dec-15 0:38 
AnswerRe: Jamaa SMPP: A connection attempt failed because the connected party did not properly respond Pin
Richard Deeming1-Dec-15 0:44
mveRichard Deeming1-Dec-15 0:44 
QuestionNeed help with regards to datagridview Pin
Tbweri30-Nov-15 15:31
Tbweri30-Nov-15 15:31 
OleDbCommand cmd = new OleDbCommand();
cmd.CommandType = global::System.Data.CommandType.Text;
cmd.CommandText = "SELECT * FROM Table1 WHERE RFID = '" + textBox1.Text + "'"; 
cmd.Connection = myCon;
this.table1TableAdapter.Adapter.SelectCommand = cmd;
this.table1TableAdapter.Adapter.Fill(mdb11DataSet.Table1); 



dgvConnect = new NominalRollDBConnection();
conString = Properties.Settings.Default.NominalRollCS;
dgvConnect.connection_string = conString;
dgvConnect.Sql1 = "SELECT * FROM NominalRoll WHERE RFID = '" + textBox1.Text + "'";
ds = dgvConnect.GetConnection1;
 this.nominalRollTableAdapter.Fill(nominalRollDataSet.NominalRoll);


// my connection class

class NominalRollDBConnection
    {
        private string strCon;
        private string sql_string1;
       
        System.Data.SqlClient.SqlDataAdapter da_1;


        public string Sql1
        {
            set { sql_string1 = value; }

        }


        public string connection_string
        {
            set { strCon = value; }
        }


        public System.Data.DataSet GetConnection1
        {
            get
            { return MyDataSet1(); }

        }

     
private System.Data.DataSet MyDataSet1()
{

System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(strCon);
con.Open();
da_1 = new System.Data.SqlClient.SqlDataAdapter(sql_string1, con);

System.Data.DataSet dat_set = new System.Data.DataSet();
 System.Data.DataTable dat_table = new System.Data.DataTable();
da_1.Fill(dat_set, "Table_Data_1");
con.Close();
return dat_set;
}






I have a difference in output when using datagridview to display my data tables.

For the code above it outputs as per my query.

However for the second code it outputs the entire data table, can anyone please explain ?

Thank you Smile | :)


edit: I have binded the datagridview using the GUI for the code above and below to respective datasources

modified 30-Nov-15 21:45pm.

AnswerRe: Need help with regards to datagridview Pin
OriginalGriff30-Nov-15 21:38
mveOriginalGriff30-Nov-15 21:38 

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.