public Int64 id(string fd, string tb) { Int64 I = 0; if (con.State == ConnectionState.Open) { con.Close(); else { con.Open(); } SqlCommand cmd = new SqlCommand(“SELECT MAX (” + fd + “) FROM ” + tb + “”, con); cmd.CommandType = CommandType.Text; if (con.State == ConnectionState.Closed) { con.Open(); I = Convert.ToInt64((cmd.ExecuteScalar().Equals(DBNull.Value) ? 0 : cmd.ExecuteScalar())) … Read more
I would use a HashSet<string> in this case: var files = new HashSet<string> { “file0”, “file1”, “file2”, “file3” }; string originalFile = “file0″; string file = originalFile; int counter = 0; while (!files.Add(file)) { file = $”{originalFile}({++counter})”; } If you have to use a list and the result should also be one, you can still … Read more
You can write your own extension method that works like the built-in LINQ methods: public static class Extensions { public static IEnumerable<T> DistinctWhere<T>(this IEnumerable<T> input, Func<T,bool> predicate) { HashSet<T> hashset = new HashSet<T>(); foreach(T item in input) { if(!predicate(item)) { yield return item; continue; } if(!hashset.Contains(item)) { hashset.Add(item); yield return item; } } } } … Read more
The first thing I want to mention, since I believe it is answers the root of your question, is that your performance (latency, concurrent connection capacity, etc) is going to be largely defined by the hardware you are running this software on and the network performance for each specific client. Software can improve some things … Read more
The first few times you execute some code, the C# runtime is going to optimize it in the background – this is known as “JIT”, or “Just in Time compiling”. So if the code you’re measuring is meant to be repeated many times – say, in a loop that’s running 24h/24, then you want to … Read more
That is so totally not a string.format issue that it is not funny. Please consider doing a little basic debugging yourself. Values (abc,efd,gr,y,t,ui,u,re,re This is not valid SQL. See, string values have to be in paranthesis of some sort (‘abc’ instad of abc). Simply speaking your (btw, the old string.format syntax is hard to read … Read more
In JSON format, numbers and booleans do not have quotes around them, while strings do (see JSON.org). If you want quotes around all your primitives, you have a few options: Change the properties of the object you are serializing to be of type string. Put your values into a Dictionary<string, string> (or a DTO) and … Read more
Many thanks to Jdweng for providing a solution. I modified their code slightly so that it didn’t rely on making the datatable manually and instead took it from my SQLite database file. Jdweng’s code also made a ‘Root’ node which was not necessary for my application so I changed it to only include the nodes … Read more
Since #define in C# is different from C and C++, you should use method call instead. private int xtime(int x) { return (x << 1) ^ (((x >> 7) & 1) * 0x1b); } solved What is the C# equivalent code for C programming statement? [closed]
You can use the Tag property of each control. So set it to something meaningful and on Click event do something like this: (sender As Control).Tag EDIT: Also you may do this: foreach (Control item in this.Controls) //this IS YOUR CURRENT FORM { if ((sender as Control).Equals(item)) { //Do what you want } } 1 … Read more
You want to do two things in single shot: Get the integer value if first digit after decimal is 0 Get the rounded value upto last 2 digits if its first digit after decimal is not 0. For second option you can use: newValue = Math.Round(value, 2) Now comes the first requirement: Once you get … Read more
Here’s a simple example using the Reflection approach: private void button1_Click(object sender, EventArgs e) { Form f2 = TryGetFormByName(“Form2”); if (f2 != null) { f2.Show(); } } public Form TryGetFormByName(string formName) { var formType = System.Reflection.Assembly.GetExecutingAssembly().GetTypes() .Where(T => (T.BaseType == typeof(Form)) && (T.Name == formName)) .FirstOrDefault(); return formType == null ? null : (Form)Activator.CreateInstance(formType); } … Read more
The DragOver event will be fired when the mouse moves over the tabcontrol while the drag action is still in effect. You can use similar logic to the mousemove logic in Change SelectedTab of TabControl on MouseOver in your DragOver handler to make the tabs switch. Edit: I did a little MSDN research and found … Read more
There is a limitation called ExecutionPolicy, setting, which can prevent from running scripts from files. From C#, you can create an instance of InitialSessionState with ExecutionPolicy = ByPass and create Powershell with this initial session state. Then try to run your script file with Invoke-Command -FilePath command. solved How to check PowerShell disable by group … Read more
Process.Start will let you run any application including GCC (or any other compiler/make utility) and pass arguments. Process.Start(“gcc.exe”, “my.c”); You probably need more command line options than just file name (i.e. output/include folder locations) and may need to specify path to compiler if it is not already available in the PATH environment variable. 3 solved … Read more