Last Seen
Ranked #518
Strength to Increase Rep
Strength to Decrease Rep
97% Quality Score
Upvotes Received
Posts with Upvotes
Upvoting Members
Downvotes Received
Posts with Downvotes
Downvoting Members
18 Commented Posts
0 Endorsements
Ranked #254
~113.75K People Reached
About Me

Moving from Delphi to C#. Many years in SQL development. When not programming, I ride horses.

Morgan Horse Shows
Favorite Forums
Member Avatar for JerryShaw

Well I guess it is my turn to ask a question, since most of the time I spend answering questions on DaniWeb. The Problem: DataViewGrid throws a "System.ArgumentException parameter is not valid..." when the dataset contains an SQL 2005 TimeStamp type column. The error occurs in System.Drawing.FromStream... da da da …

Member Avatar for work.caglar
Member Avatar for jitupatil_2007

There are a number of ways to do this. Using directing insert statement is one, another is using a stored procedure, calling as ssis package is another. The easiest is probably the insert statement. Simple get you SqlConnection, then use an SqlCommand. use the string.Format method to parse the data …

Member Avatar for AITM_1
Member Avatar for flash121
Member Avatar for Wiizl

I sugest you take a different tact. What I typically do for managing thread messages is I create a simple EventArgs class to hold the message information, a Delegate to represent the main thread method that will use the information, and an eventhandler in the main thread that can be …

Member Avatar for Matthew.diggide.speakman
Member Avatar for jainendra.shah

Let me re-state your question to see if I understand you correctly. You have two forms. First form has a check list box, and the second form has a listbox. When the user checks an item in the check list box, you want that item to be added to the …

Member Avatar for Emmanuel Jay
Member Avatar for aa361

As danielernesto said, store it to a column type that supports byte arrays such as Image or VarBinary(max). // Jerry

Member Avatar for nargis.hemani
Member Avatar for kobi
Member Avatar for JirkaJirka
Member Avatar for IT_Techno
Member Avatar for Momerath
Member Avatar for 1qaz2wsx7

#3, you can't stop it from sending the a minimize command (without some Windows API calls), however if you want it to do more things before it minimizes, you can use the Deactivated Event handler or the SizeChanged event ([URL][/URL]). If you want to stop the minimize action, then you …

Member Avatar for JerryShaw
Member Avatar for ryudo1987

Doesn't close because the while statement runs out of reads, and drops into the dr & lgnconnection close... It does not make sense to have both the true and false of a conditional result in the same statement "Close()". Why compare at all if the result is always going to …

Member Avatar for prathamesh3090
Member Avatar for NguyenThai

Instead of using a private bool variable, use a private variable for Form2, then you have some options... [code] public partial class Form1 : Form { private Form2 _form2 = null; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { button1.Enabled = false; _form2 = new Form2(); …

Member Avatar for adetolah
Member Avatar for Exelio

Are you speaking of the Header cells, or a data cell ? I havn't tried it on tried it on the header, however I am pretty sure it can be done. If you are speaking of data cells, you can use the CellFormatting([COLOR=#0000ff]object[/COLOR] sender, [COLOR=#008080]DataGridViewCellFormattingEventArgs[/COLOR] e) CellFormatting event to set …

Member Avatar for sachinmuley
Member Avatar for Prodian

Writing an ini parcer is pretty straight forward. I have attached a class library that I use, and included the source code for you to check out.

Member Avatar for duffmanleesin
Member Avatar for Nareshp_123

Yes you can do this. I have a service that does this type of work for archiving files. Remember that a mapped drive is in the context of the currently logged on user. A Windows service runs in its own context. So, your mapped drive may not be visible to …

Member Avatar for JerryShaw
Member Avatar for fkhaeer

As BlackSun explained, you will need to manage it yourself using the image Graphics. It is a bit more complicated than the example above, but should move you into the right direction. The image onPaint event will have to remember that you have an active selection (the rectangle, and its …

Member Avatar for JerryShaw
Member Avatar for AniWeb

What Ramy is saying is that you do not specify a File name, but rather a ConnectionString. [code] SqlConnection conn = new SqlConnection("Data Source=Servername;Initial Catalog=Marketing;Integrated Security=SSPI"); conn.Open(); [/code]

Member Avatar for lianpiau
Member Avatar for JerryShaw

I have the multiple level path of a filename, and I want to pull out just the immediate parent directory name of this file. Example: Filename = "c:\temp\extra\test\myfile.txt" How can I get "test" from this string ? Thanks in advance Jerry

Member Avatar for Derek W
Member Avatar for er.sajal

"Give same Code ??" Do you mean giving them all the same event handler ? then let the event handler determine the button that was used ?

Member Avatar for S.Santosh
Member Avatar for charlie81

Another hint for you, Your assignment says to compute the rate at 7.5 for the first 40 hours, and 11.25 for each additional hour. Your condition is only checking for if the hours equal exactly 40 hours then use 7.50, else use 11.25. So with your condition, if worked any …

Member Avatar for derea.tadea
Member Avatar for it2051229

It all depends on when you are letting the user delete the file. Even through the dialog is closed, does not mean it has been disposed by garbage collection. To insure you no longer have the picture file handle open, before closing the dialog (or in the FormClosed event handler), …

Member Avatar for tanisha123
Member Avatar for Ramon78

Instead of mangling the SQL statement (embedding CRLF), just iterate through the rows and columns, and populate the text box. Here is a simple example: [CODE] private void toolStripButton1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=SHAWHP;Initial Catalog=SalonWiz;Integrated Security=True"); conn.Open(); DataSet ds = new DataSet(); SqlDataAdapter adapter = …

Member Avatar for
Member Avatar for ironbill

Here is a snip of code from my Login screen. It has the usual Server Name, User name and Password texboxes, and a Login and Cancel button. Mine is hardcoded for a database named SAFEnet. This is using the SQLclient (SQL2005). If you are using another type DBMS, let me …

Member Avatar for kumar169
Member Avatar for zachattack05

You will be wrapping the code that creates the database anyway, so just supply good error messaging and go with the assumption. IOW, why add additional code when SQL is going to do those checks for you anyway regardless of your pre-checks. JMO

Member Avatar for zachattack05
Member Avatar for d87c

Why so much code? Try this to get started [code] static void Main(string[] args) { string[] meals = System.IO.File.ReadAllLines("meals.csv"); foreach (string meal in meals) Console.WriteLine(meal); Console.ReadKey(); } [/code]

Member Avatar for JerryShaw
Member Avatar for erfanjan

Look at [URL][/URL] then after e.Handled = true; set focus to the next control / textbox.

Member Avatar for Geekitygeek
Member Avatar for Ved_TheOne

Are you aware that the Jet engine is very picky about the dBase file version. This is why I prefer to use the ODBC classes instead of Ole. I had a similar problem using your code, and after switching it out to use ODBC, everything worked fine, and even a …

Member Avatar for ckhong
Member Avatar for majestic0110

First, your ASP is the one connecting to the database using the credendials of the web site setup. (Windows authentication mode). You are to validating the information from the login screen against the database. Just keep in mind that SQL sees the web service as the one logged in not …

Member Avatar for khusiaaaan
Member Avatar for baladeveloper

***what is MyGrid referring to in this code ^^^ ???*** [U]Answer: A DataGridView[/U] ***hi ... how to create the stored procedure?, and how to call the stored procedure in c# ?.... *** [U]Answer: Creating a stored procedure is done at the SQL Server using the tools provided by the database …

Member Avatar for Jinnybat
Member Avatar for olibara

[code] ************************************************************************************************** private void ShowForm(DataTable dtDagChauff) { if (FrmZTour == null ) { FrmZTour = new FrmDgvZoomTour(); FrmZTour.SelectTour += new FrmDgvZoomTour.SelectTourHandler(DgvTourSelected); FrmZTour.FormClosed += new FormClosedEventHandler(FrmZTour_FormClosed); FrmZTour.Show(this); } FrmZTour.FillDgv(dtDagChauff); } private void FrmZTour_FormClosed(object sender, FormClosedEventArgs e) { FrmZTour.Dispose(); FrmZTour = null; } [/code]

Member Avatar for RicardoE
Member Avatar for MillStrike

What you need is a place in your MyProgram.cs class to store the command line arguments received in the constructor (Main). Something like public string SelectedFile; In the Main constructor, do this: [code] public static void Main(string[] args) { string SelectedFile; if (args.Length > 0) { SelectedFile = Convert.ToString(args[0]); MessageBox.Show(SelectedFile); …

Member Avatar for PierlucSS