Month: September 2022

[Solved] i cant insert data in ms access database through textbox [closed]

by

maybe you can try this code private void button1_Click(object sender, EventArgs e) { try { cmd = new OleDbCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = “INSERT INTO userinfo (FirstName, LastName, Age, Address, Course)” + “VALUES (@First_Name, @Last_Name, @Age, @Address, @Course)”; cmd.Parameters.AddWithValue(“@First_Name”, textBox1.Text); cmd.Parameters.AddWithValue(“@Last_Name”, textBox2.Text); cmd.Parameters.AddWithValue(“@Age”, textBox3.Text); cmd.Parameters.AddWithValue(“@Address”, textBox5.Text); cmd.Parameters.AddWithValue(“@Course”, textBox5.Text); cmd.Connection = conn; conn.Open(); clear(); cmd.ExecuteNonQuery(); … Read more

[Solved] How to get file size in KB and MB in android [duplicate]

by

Here it’s: public String size(int size){ String hrSize = “”; double m = size/1024.0; DecimalFormat dec = new DecimalFormat(“0.00″); if (m > 1) { hrSize = dec.format(m).concat(” MB”); } else { hrSize = dec.format(size).concat(” KB”); } return hrSize; } SOURCE: Converting KB to MB, GB, TB dynamically 1 solved How to get file size in … Read more

[Solved] This code does’t run and gives no error [closed]

by

You forgot to remove the remove class so it stays hidden. No need for all the if statements, one option is to add a data-tabid to your anchors and use that as the id to display the divs. <!DOCTYPE html> <html> <head> <script src=”https://stackoverflow.com/questions/17261287/jquery-1.9.0.js”></script> <title>test</title> <style type=”text/css”> body, html, div, ul,li,a {margin:0; padding:0;} body {font-family:arial;font-size:12px;} … Read more

[Solved] How to select highest paid employee in dept based on the following? [closed]

by

If you are using SQL-Server, use ROW_NUMBER or DENSE_RANK(if you want to include ties): WITH CTE AS( SELECT e.EmpID,e.EmpName,e.EmpSalary, e.Department,b.EmpBonus, RN = ROW_NUMBER() OVER (PARTITION BY Department ORDER BY (EmpSalary + COALESCE(EmpBonus,0)) DESC) FROM Employees e LEFT OUTER JOIN Bonuses b ON e.EmpID = b.EmpID ) SELECT EmpID, EmpName, EmpSalary, Department, EmpBonus FROM CTE WHERE … Read more

[Solved] Load HTML into a DIV using jquery

by

I think the show hide jq are what you need to use here. Here is a link that I put together. $(“#homeButton”).click(function () { $(“#cuerpo”).show() ; $(“#tablet”).hide() ; }); $(“#procuctsButton”).click(function () { $(“#tablet”).show() ; $(“#cuerpo”).hide() ; }); http://jsfiddle.net/jebr224/GEZth/ You could also try using iframe, you could make the buttons change the src of the frame. … Read more

[Solved] how to get result based on 10 minutes interval in mysql

by

i have found the solution by below query. select a.time_column,group_concat(a.destination order by ct desc) from (select case when time between ’00:00:00′ and ’00:10:00′ then ’00:10:00′ when time between ’00:10:01′ and ’00:20:00′ then ’00:20:00′ when time between ’00:20:01′ and ’00:30:00′ then ’00:30:00′ else ’00:00:00′ end as time_column , destination , count(destination) ct from click group by … Read more

[Solved] Manually Invoke IIFE

by

The whole idea of the IIFE is that its an anonymous function that is immediately executed. So by definition, no there is no way to re-execute it. With that said however, you can store the function expression to a global variable, and execute it. For example window.my_iife = (function() { /* stuff */ }); window.my_iife(); … Read more

[Solved] unrecognized selector sent to instance in Array [duplicate]

by

Your problem is that the compiler thinks you’ve declared “m_ArrContactsOrgEntity” as something other than a NSMutableArray. Otherwise, you wouldn’t be seeing that “unrecognized selector” error. Another hint of advice for you, best practice in Objective-C is that variables should always start with lower case letters. Change “ObjIstructContacts“, “Qnarray” and “Qnstream” to start with lower case … Read more

[Solved] Ajax post returns multiple arrays with objects that have multiple values

by

Your ajax.php should be like this <?php foreach ($messages as $message) { $from = $message[‘contact_value’]; $text = $message[‘message’]; $date = $message[‘date’]; $num = $user[‘phone_number’]; echo json_encode(array(“from”=>$from, “text”=>$text,”date”=>$date,”num”=>$num)); ?> if you really want the quotes then use ‘ ‘ (singlequotes) instead. And the javascript file. success: function (response) { var success = $.parseJSON(response); $(“.messages-table”).append(“<tr><th>”+success.from+”</th><th>”+success.text+”</th><th>”+success.date+”</th><th>”+success.num+”</th></tr>”); } i … Read more

[Solved] Changing button image on hover

by

Here is a simple snippet that accomplishes the items you ask. I used jQuery’s hover function to attach event handlers to modify the images. I set 0 font-size, padding, and margin on the container (body) and used 50% width and 50vh (viewport height) to get 4 equal quadrant buttons. $(‘button’).hover(function() { $(this).find(‘img’).attr(‘src’, ‘http://via.placeholder.com/200×150’); }, function() … Read more

[Solved] JSONObject how to change value depend on key value? [closed]

by

As fas as I understand your problem statment, are you looking for something like this? var data = [ { “pages”: “foo1”, “hasil”: “” }, { “pages”: “foo2”, “hasil”: “” }, { “pages”: “foo3”, “hasil”: “” }, { “pages”: “foo4”, “hasil”: “” }, { “pages”: “foo5”, “hasil”: “” }, { “pages”: “foo6”, “hasil”: “” } … Read more