C#

FirstPrevNext

Store multiple items from listbox to database elci27-Jul-09 20:26 elci 27-Jul-09 20:26  Hi all I'm working in listbox. I have to store multiple items from listbox into database. Plz help me with some sample code Thanks in advance..... Elizabeth.. Re: Store multiple items from listbox to database Blikkies27-Jul-09 22:47 Blikkies 27-Jul-09 22:47  Here is a peace of code, did not test it but it sould work: using System; using System.Collections.Generic; using System.Drawing; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; namespace test { /// <summary> /// Description of MainForm. /// </summary> public partial class MainForm : Form { public MainForm() { // // The InitializeComponent() call is required for Windows Forms designer support. // InitializeComponent(); // // TODO: Add constructor code after the InitializeComponent() call. // } void Button1Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(@"User ID=username; Password=pass; Initial Catalog=databasename; data source=localhost"); SqlCommand cmd = conn.CreateCommand(); foreach(object i in listBox1.SelectedItems) { cmd.CommandText = "INSERT INTO TableName (columnName) VALUES('"+i.ToString()+"')"; cmd.ExecuteNonQuery(); } conn.Close(); } } } Accesing remote files Kushi Bobby27-Jul-09 20:16 Kushi Bobby 27-Jul-09 20:16  Hi, In my application.i want to connect to server and read the files drive by drive. I tried in local by using System.IO namespace and succeeded. Could any body help me to connect server and retreive file list. Shall i need to use RDC or any other option? thanks in advance Bobby Have a Nice Day Dudes Re: Accesing remote files Tamer Oz27-Jul-09 20:49 Tamer Oz 27-Jul-09 20:49  If you dont know the names of drives you can get the names of drives using System.Management namespace with wmi. After that i assume you have sharings on folders. then all you have to do is using a code like below System.IO.Directory.GetFiles(@"\\10.10.0.50\d$"); Also you can use getdirectories or similar methods like this. Re: Accesing remote files Kushi Bobby27-Jul-09 21:16 Kushi Bobby 27-Jul-09 21:16  HI Tamer, THank u very much Till now am using Directoryinfo class,so am unable to solve this. My remote system is provided by Username and password.so when i tried i got the following error at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Directory.InternalGetFileDirectoryNames(String path, String userPathOriginal, String searchPattern, Boolean includeFiles, Boolean includeDirs, SearchOption searchOption) at System.IO.Directory.GetFiles(String path, String searchPattern, SearchOption searchOption) at System.IO.Directory.GetFiles(String path) at FileSearcher.Searcher.SearchThread() is there any way to pass the credentials and then access the remote system.could u pls suggest me? thanks in advance Have a Nice Day Dudes Re: Accesing remote files Tamer Oz27-Jul-09 21:34 Tamer Oz 27-Jul-09 21:34  I think first you have to make an impersonation to a user that have rights on remote server. Yo can find it here how to make. Windows Impersonation using C#[^] Re: Accesing remote files Kushi Bobby27-Jul-09 21:44 Kushi Bobby 27-Jul-09 21:44  HI thanks for the reply, Firstly i need to access the remote system based on IP address and then need to traverse the drives. As u suggested,i used getfiles() and able to access,but the problem is, as the system is password protected, am unable to connect programatically. so is there any way to pass the User id and password and access the remote system Harddisk drives thanks in advance Have a Nice Day Dudes Re: Accesing remote files Tamer Oz28-Jul-09 1:01 Tamer Oz 28-Jul-09 1:01  For getting drive informations of a remote computer with wmi Windows Management Instrumentation (WMI) Implementation[^] will help. For password protection of files issue only solution that comes to my mind is impersonation(Working the application under credentials of an user that has access to that files. Re: Accesing remote files Kushi Bobby28-Jul-09 15:25 Kushi Bobby 28-Jul-09 15:25  HI Tamer, Thanks for the reply. But my intention is i just want to access remote system from my Window application.as its password protected,is there any way to send User name and password and then access system Have a Nice Day Dudes Error.. mjawadkhatri27-Jul-09 20:15 mjawadkhatri 27-Jul-09 20:15  please read this and tell me my mistake. cn.Open(); cmd.CommandText = "Select ATT_DATE,DEP_ID,to_char(timein,'HH:MI'),to_char(timeout,'HH:MI'),EMP_NAME from attandance where emp_id = '" + id.Text + "' and shift = '" + shift.SelectedItem + "'"; odr = cmd.ExecuteReader(); while (odr.Read()) { ename.Text = odr["emp_name"].ToString(); dept.Text = odr["dep_id"].ToString(); timein.Text = odr["timein"].ToString(); timeout.Text = odr["timeout"].ToString(); Dte.Text = odr["att_date"].ToString(); } Re: Error.. Christian Graus27-Jul-09 20:26 Christian Graus 27-Jul-09 20:26  That depends. what is going wrong ? Is there an error message ? Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: Error.. mjawadkhatri27-Jul-09 20:32 mjawadkhatri 27-Jul-09 20:32  Error Message is INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED Re: Error.. Mbah Dhaim27-Jul-09 20:52 Mbah Dhaim 27-Jul-09 20:52  that because you dont specify return field name for time in try change your query in "to_char('timein',...) as timein" hope it helps dhaim ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro" in the front line gave a lead, in the middle line build goodwill, in the behind give power support Re: Error.. mjawadkhatri27-Jul-09 21:00 mjawadkhatri 27-Jul-09 21:00  I change my query like; "to_char('timein','HH:MI')as timein" now Error Message Change ERROR [22018] [Microsoft][ODBC driver for Oracle][Oracle]ORA-01722: invalid number Re: Error.. Mbah Dhaim27-Jul-09 21:09 Mbah Dhaim 27-Jul-09 21:09  then try to follow this link ORA-01722: invalid number[^] hope it helps dhaim ing ngarso sung tulodho, ing madyo mangun karso, tut wuri handayani. "Ki Hajar Dewantoro" in the front line gave a lead, in the middle line build goodwill, in the behind give power support Re: Error.. riced27-Jul-09 20:30 riced 27-Jul-09 20:30  mjawadkhatri wrote: tell me my mistake. Not telling us what the error message says and which line it occurs on? Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis Re: Error.. mjawadkhatri27-Jul-09 20:36 mjawadkhatri 27-Jul-09 20:36  Error Message is INDEX OUT OF RANGE EXCEPTION WAS UNHANDLED line of Error is timein.Text = odr["timein"].ToString(); Re: Error.. Christian Graus27-Jul-09 21:01 Christian Graus 27-Jul-09 21:01  So, there is no column called 'timein'. I suspect you need to read a few basic books before doing any more work, the error message is pretty self documenting, and googling it would have got you a ton of info Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: Error.. Blikkies27-Jul-09 23:09 Blikkies 27-Jul-09 23:09  In your select statement set "to_char(timein,'HH:MI')" to "to_char(timein,'HH:MI') AS 'timein'" same with "to_char(timeout,'HH:MI')" Re: Error.. 0x3c027-Jul-09 23:12 0x3c0 27-Jul-09 23:12  In addition to your missing columns, your code is vulnerable to SQL injection. You might want to look into stored procedures Between the idea And the reality Between the motion And the act Falls the Shadow Re: Error.. PIEBALDconsult28-Jul-09 8:15 PIEBALDconsult 28-Jul-09 8:15  "You might want to look into stored procedures parameterized statements." (Regardless of whether or not the statement executes a stored procedure.) Re: Error.. 0x3c028-Jul-09 9:01 0x3c0 28-Jul-09 9:01  Whoops. I thought that stored procedures and parametrized statements were the same thing. Thanks for the tip - research time methinks Between the idea And the reality Between the motion And the act Falls the Shadow Images on the winform Milind Panchal27-Jul-09 19:10 Milind Panchal 27-Jul-09 19:10  I am developing window application in C#.NET. My form has a many images. If I run the project, images on the form are appearing one by one and form is vibrating. So plz give me any solution for this. Thanks in advance.. Re: Images on the winform Christian Graus27-Jul-09 19:59 Christian Graus 27-Jul-09 19:59  I'm not sure what you'd like to hear. I mean, what do you expect us to do here ? You have not told us how you show the images. You have not even told us if you want to show lots of images at once, or one at a time. I have no idea what 'form is vibrating' means. At the end of the day, if you can't provide some details, and some code for us to try to correct for you, I don't see how you expect to get any help Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks. Re: Images on the winform Luc Pattyn27-Jul-09 22:46 Luc Pattyn 27-Jul-09 22:46  please read my sig below and act accordingly. Luc Pattyn [Forum Guidelines] [My Articles] The quality and detail of your question reflects on the effectiveness of the help you are likely to get. Show formatted code inside PRE tags, and give clear symptoms when describing a problem.

Last Visit: 31-Dec-99 18:00     Last Update: 17-Apr-24 19:09 Refresh ᐊ Prev1...4630463146324633463446354636463746384639 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.