C#

FirstPrevNext

Update DataGrid Mazdak17-Mar-02 7:48 Mazdak 17-Mar-02 7:48  I have a datagrid and I bind it to a datasource,It show the records ok,but after I insert a record to database I don't know how to update the datagrid to show the new record. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid Andres Manggini17-Mar-02 8:40 Andres Manggini 17-Mar-02 8:40  How are you inserting this new record ?. Andres Manggini. Buenos Aires - Argentina. Re: Update DataGrid Mazdak17-Mar-02 20:12 Mazdak 17-Mar-02 20:12  Andres Manggini wrote: How are you inserting this new record ?. oleDbCommand1.Connection.Open(); oleDbCommand1.ExecuteNonQuery(); oleDbDataAdapter1.Update(dataSet11,"Table2"); dataGrid1.DataSource=dataSet11.Tables["Table2"]; ??????Something must be here but I don't know what? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid Andy Smith17-Mar-02 20:32 Andy Smith 17-Mar-02 20:32  Mazdak wrote: oleDbCommand1.Connection.Open(); oleDbCommand1.ExecuteNonQuery(); oleDbDataAdapter1.Update(dataSet11,"Table2"); dataGrid1.DataSource=dataSet11.Tables["Table2"]; dataGrid1.DataBind(); Re: Update DataGrid Mazdak17-Mar-02 20:46 Mazdak 17-Mar-02 20:46  Andy Smith wrote: dataGrid1.DataBind(); That does not exist in WinForms Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid Andy Smith17-Mar-02 21:14 Andy Smith 17-Mar-02 21:14  oh, oops sorry, i'm a webguy, and I just kind of assumed... um, From my vb6 days... I seem to remember setting the datasource to nothing and then setting it again... so try something like this: dataGrid1.DataSource = null; dataGrid1.DataSource = myDataSourceExpression; Re: Update DataGrid James T. Johnson17-Mar-02 14:52 James T. Johnson 17-Mar-02 14:52  If you make changes to the database itself you reload the data into a dataset and bind the datagrid to that. If you make changes to the dataset, you just rebind to the dataset. Hope that makes sense, James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 Re: Update DataGrid James T. Johnson17-Mar-02 14:52 James T. Johnson 17-Mar-02 14:52  DataSet or DataTable Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 Re: Update DataGrid Mazdak17-Mar-02 20:14 Mazdak 17-Mar-02 20:14  I kow it,I do it like this: oleDbCommand1.Connection.Open(); oleDbCommand1.ExecuteNonQuery(); oleDbDataAdapter1.Update(dataSet11,"Table2"); dataGrid1.DataSource=dataSet11.Tables["Table2"]; ???Binding???????? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid James T. Johnson17-Mar-02 20:33 James T. Johnson 17-Mar-02 20:33  In WinForms I found all I had to do was assign to the DataSource property as you have done; I think in ASP.NET you do that and you have to call dataGrid1.DataBind();. Any closer? James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 Re: Update DataGrid Mazdak17-Mar-02 20:45 Mazdak 17-Mar-02 20:45  James T. Johnson wrote: dataGrid1.DataBind();. I'm aware of that in ASP.Net,but it does not exist in windows form James T. Johnson wrote: In WinForms I found all I had to do was assign to the DataSource property as you have done; You mean you set the datasource of datagrind without any databinding,and datagrid reflect the changes ? Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid James T. Johnson17-Mar-02 20:56 James T. Johnson 17-Mar-02 20:56  Mazdak wrote: You mean you set the datasource of datagrind without any databinding,and datagrid reflect the changes I'll have to see if i can find my test code; but I don't recall doing anything more than what you have done. James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 Re: Update DataGrid James T. Johnson17-Mar-02 21:34 James T. Johnson 17-Mar-02 21:34  I've uploaded a quick sample I did; by all means do not look at it as the proper way to deal with user created dialogs or naming conventions (i stuck with defaults for names, and the dialog is handled oddly since i wanted to require both username/password and didn't look up the "proper" way of doing that). I've included the compiled executable so you don't have to try monkeying around with the VS.NET generated .resx's http://www.takklesoft.com/dotnet/DataGridTestApp.zip James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 Re: Update DataGrid Mazdak17-Mar-02 22:11 Mazdak 17-Mar-02 22:11  Really thanks James,You are always big help. Now I can add recoeds to database and show it in DataGrid too but I have a question about it: In Visual C++ when I add a record to a database the DataGrid reflect it by using only Refresh() method,But here in .NET I have to create new Row dynamicly for DataGrid and do it seprately from the new record in DataSource(Here when I say DataSource I mean my Access file not DataSet),Is that right or other way exists too? I think I mess up thinks in VC++ and C# Thanks Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid James T. Johnson17-Mar-02 22:24 James T. Johnson 17-Mar-02 22:24  Mazdak wrote: Is that right or other way exists too? I haven't delved too deep into data binding yet, soon as i get the crummy design phase done though I'll be diving into it head first But from what I can tell if you update the data source without going through the underlying dataset/table, then you have to go about it as you are now. If you make your changes through the DataSet (and the underlying DataTables) then you can just call Update on the *DataAdapter to have the changes reflected back to the data source. Mazdak wrote: Really thanks James,You are always big help. Awwwww shucks James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 Re: Update DataGrid Mazdak17-Mar-02 22:43 Mazdak 17-Mar-02 22:43  Here you talk in simple words,I understand them. Mazy "So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here." Wish You Were Here-Pink Floyd-1975 Re: Update DataGrid James T. Johnson18-Mar-02 8:02 James T. Johnson 18-Mar-02 8:02  My intention is never to confuse anyone, but at times it sounds like English isn't my native language I have no idea why that is, I know the rules for grammar structure and what not but my thoughts always come out jumbled around so i have to try to piece them together the correct way. James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978 chdir equivalent in c# Kannan Kalyanaraman17-Mar-02 5:32 Kannan Kalyanaraman 17-Mar-02 5:32  I need to change the current working directory to a different directory. But I cant find any method for this in c#. However, I found a equivalent method available in vb.net(chdir). Anyidea, on how to do this in c#. Thanks Kannan Re: chdir equivalent in c# Kannan Kalyanaraman17-Mar-02 6:15 Kannan Kalyanaraman 17-Mar-02 6:15  I found it, there is a get/set property in Environment class. Environment.CurrentDirectory Thanks Kannan Databinding and xml Mazdak16-Mar-02 4:01 Mazdak 16-Mar-02 4:01  I have a xml file and datalist,I put label on datalist and I want to bind it to xml file. The definition of xml is something like this: <?xml version="1.0" ?> - <Something xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Title>MFC</Title> <Title>Button</Title> <Title>RichEdit</Title> <Title>EditBox</Title> <Title>ComboBox</Title> </Something> I want to bind Title to labels of datalist I don't know how to do it,is that correct: Read the xml file with xmlreader then bind a table to data list?If it is correct I don't know one thing about databining: DataBinder.Eval(Container,?????-->what should be here?) thanx <html><FONT face="Lucida Handwriting, Cursive">Mazy</FONT></html> <small>"So,so you think you can tell, Heaven from Hell, Blue skies from pain,... How I wish,how I wish you were here."<br>Wish You Were Here-Pink Floyd-1975</small> math functions in C# ??? Christian Graus15-Mar-02 21:55 Christian Graus 15-Mar-02 21:55  I need to get ahold of C# functions such as pow, abs, etc. min and max would also be nice. Do they exist ? Where ? Christian The tragedy of cyberspace - that so much can travel so far, and yet mean so little. "I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002 Re: math functions in C# ??? Christian Graus15-Mar-02 22:08 Christian Graus 15-Mar-02 22:08  Got it. I typed System.Math and intellisense did not find it, so I assumed it did not exist. I need to get Visual Assist on here, pronto. Christian The tragedy of cyberspace - that so much can travel so far, and yet mean so little. "I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002 Re: math functions in C# ??? Nish Nishant15-Mar-02 22:10 Nish Nishant 15-Mar-02 22:10  Christian Graus wrote: need to get Visual Assist on here, They have a Visual Assist beta for VS.NET Nish My miniputt high is now 29 I do not think I can improve on that My temperament won't hold www.busterboy.org Re: math functions in C# ??? Christian Graus15-Mar-02 22:21 Christian Graus 15-Mar-02 22:21  I know, thanks, I just had not reinstalled it just yet after all the hassles I had getting .NET installed at all. Intellisense is working, Matk is a class. How gay - I have to type Math.Min when I want to min something ? I suppose I could type Math m; m.Min, but it still sucks. C# is pretty cool though, but I need to do some testing. I am convering an image library I wrote using GDI+ in C++ and I think initially it is orders of magnitude slower doing exactly the same thing as the C++ code I wrote prior. Christian The tragedy of cyberspace - that so much can travel so far, and yet mean so little. "I'm thinking of getting married for companionship and so I have someone to cook and clean." - Martin Marvinski, 6/3/2002 Re: math functions in C# ??? James T. Johnson16-Mar-02 15:29 James T. Johnson 16-Mar-02 15:29  Christian Graus wrote: Matk is a class. How gay - I have to type Math.Min when I want to min something ? Welcome to the world of "everything is an object" James Sonork ID: 100.11138 - Hasaki "Smile your little smile, take some tea with me awhile. And every day we'll turn another page. Behind our glass we'll sit and look at our ever-open book, One brown mouse sitting in a cage." "One Brown Mouse" from Heavy Horses, Jethro Tull 1978

Last Visit: 31-Dec-99 18:00     Last Update: 10-Jun-24 1:38 Refresh ᐊ Prev1...15250152511525215253152541525515256152571525815259 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

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