Santanu.Das

Never think like a lazy one. Think deeply how could you do it by writing your own code which can give more grip on codification. You can use selection changed event of text box to do your owns.

Suggestion: Do it through SQL not from datagrid which could be more easier for you

You can use Dynamic array to store your users.

Use of Executescalar() function to get the count of record numbers. Therefore, you must have to use Count keyword before StudentId into the select statement. My suggestion: Store StudentId and do same in logout procedure as you do in log in

Form Load() event is not a way to show a form in wpf. There has no conception exists as fom like vb form in wpf. Every one is a window. Wpf does not support mdi

@සශික : Nothing wrong in your codes to print data. Just alter some lines in your codes. 1) Never declare the variable `Dim mRow As Integer = 0` at Event level like PrintPage Event, always declare it at Form level and set its value to 0 at BeginPrint Event. 2) …

"**+**" Charactor always concatinates two string type values i.e "200" +"200" always give you the result **200200** instead of **400**, because you treat them as string type. If you declare them as numeric type then it will give you 400. Your mistake is at line no 2. Declare **tot** as …

In my project I did it in VB.Net. But I do not know PHP. If you like I can post it, but it is in vb2010. You would convert it in PHP.

Now I am going through a project with colors. And then I think that if I try to display color values with their names in a simple combobox, it could be amazing. I tried and did it and it is looking like  And  And finally the …

Function **OleDbCommand.ExecuteNonQuery()** always returns an integer value of affected row So, to get the number of affected Row you must have to use it as function type not statement type. i.e. Dim icount As Integer = sqlCom.ExecuteNonQuery()

You can use [**Union All**](https://www.daniweb.com/programming/databases/threads/506558/select-data-from-two-mysql-tables-using-one-query-not-working-properly#post2211792) Clause. Your sql syntax should be SELECT tt.product_id, tt.purchase, tt.sale FROM (SELECT product_id, SUM(quantity) AS purchase, SUM(0) AS sale FROM purchase GROUP BY product_id) UNION ALL (SELECT product_id, SUM(0) AS purchase, SUM(quantity) AS sale FROM sale GROUP BY product_id) tt

Would be nothing.

My opinion is you can solve your problems most easily if you create two seperate functons one to check Blank Text and another to check duplicate value. If the function (1) finds the blank text then exit from save. and if the function (2) finds the duplicate value from database …

From my opinion: before use **If sqlRead.Read() Then** at line No. 27 of your code, ensure that the Reader object has any row to read on matching parameters you supplied in your sql statement. If the reader does not hold any record it may raised an exception, because it has …

Change **ADP = New OleDbDataAdapter(query, cnnOLEDB)** with **cmdOLEDB = New OleDb.OleDbCommand(query, cnnOLEDB)** at the line no 78. without initializing command object u canot use it.

from my opinion: when you have tried to add parameters with command object by using **parameters.Add()** method you must have to convert the type of the value which you want to save in respect of the parameter type you declared in your code. Exception could be raised from your code …

Please post, what you tried in your sql statement. Clue: just Join and select the max value.

' Check if any rows exist If rd.Read() Then If rd.GetString(3) = "small" Then MessageBox.Show("small") ElseIf rd.GetString(3) = "Big" Then MessageBox.Show("big") ElseIf rd.GetString(3) = "Midium" Then MessageBox.Show("Mid") End If End If This is not the proper way to check any record if it exists. datareader.Read() always produce a single record …

> strSearchText = TextBox2.Text > Dim sqlquery As String = "Select * from Housedat where (PROPID LIKE '%" & TextBox2.Text & "%')" Why do you not using the 'strSearchText' ? In Sql Query any string type condition must be within a single quation. strSearchText = TextBox2.Text Dim sqlquery As String …

Fiestly please show the code what you did. Secondly, for every catagory at the end the subtotals should be added as a listitem for that catagory. Or you have to create an User Control for your use.

You can use **MINUS Clause** in SQL Statement. Multiple queries can be put together and their output combined using the minus clause. The **Minus** clause outputs the rows produced by the first query, after **filtering** the rows retrieved by the second query. The statement should be "SELECT DISTINCT id FROM …

FROM WHICH TABLE YOU ARE GETTING THESE `[AMOUNT],[INTEREST],[TERMS], [TotalInterest]`. YOU MUST SPECIFY THEM IN FROM CLAUSE. YOU CAN USE `BETWEEN` CLAUSE FOR A RANGE OF DATES IN WHERE CLAUSE. `WHERE (LOANS.RELEASED BETWEEN @d1 and @d2)

You can do it by using a `STRUCTURE`which can give you full functionality to solve your problem. Read [this post](https://www.daniweb.com/programming/software-development/threads/495590/help-with-formating-zones#post2168625) you can get your way to solve the problem by yourself.

A cumulative update May-18 released by Microsoft, there are some new features added and I update my W10 in my lap but after updating VS-15 Pro does not load its full features, when I try to run it and for that reason I do not open any solution or create …

`adapterDelete.DeleteCommand = MysqlConnection.CreateCommand()` `adapterDelete.DeleteCommand.CommandText = sql` These two lines are caused for your error. `adapterDelete` does not declare in your code. except that every thing are ok.

You can get an idea from [this post](https://www.daniweb.com/programming/threads/507797/how-to-authentication-users-using-ms-access) in daniweb

Why gg.Dispose() ?? fro my opinion from there your problem has been arised.

You can read this [overview](https://docs.microsoft.com/en-us/dotnet/framework/wpf/advanced/drag-and-drop-overview), which can help you.

Post your codes which you tried to store data to database from datagridview by which we can help you to solve your problem. Well! pick up the current row (i.e. the row in which you are writting the values) of the datagridview and creating an sql command you can store …

From my opinion your problem should be in construction of sql statement i.e.`"SELECT '#' FROM tblBasicInfo, tblAccData WHERE ID =" + Convert.ToInt32(AcNotextBox.Text)` Use **Inner join** clause to join two tables. You can try it "SELECT A.ID,A.Name,.....,B.Pro FROM tblBasicInfo A Inner Join tblAccData B On B.ID=A.ID WHERE A.ID =" + Convert.ToInt32(AcNotextBox.Text) …

From my opinion your error should be occurred in between these following lines. `cmd1.ExecuteNonQuery()` `cmd1.CommandText = InsertOrderTBSelect` First dispose/close the sqlcommand object then use it for another sql statement.

First post your codes you already tried.

Split the sentence with space and store it in an array then convert to proper case of the first and last element of that array. After that join the array elements with space.

Group By clasue always produce a count or summation of another field. It never shows other feilds, if you tried to so the values of other fields without aggregating them it shows an error message. If you want to group by with a single field you only can get the …

To backup data you must have to execute a process to run `mysqldump.exe` file, which resides in C:\Program Files\MySQL\MySQL Server 5.?\bin\ folder. The syntax is `mysqldump --host=[HOSTNAME] --user=[USER] --password=[PASSWORD] -R [DATABASE NAME] > [PATH TO BACKUP FILE]`. To restore data you must have to execute a process to run `mysql.exe` …

You can read this [link](https://www.daniweb.com/programming/software-development/threads/320160/visual-basic-reading-text-file-into-array) to read a text file to get the lines.

?? WHERE [Item_Number]='"+ textBox1.Text +"'" Do it with parameter as you did about 'qun'.

INSERT INTO <DESTINATION TABLE NAME> SELECT * FROM <SOURCE TABLE NAME> BUT FIELDS NAME AND TYPE OF DESTINATION SHOULD BE SAME AS SOURCE.

ya! Jim more warmer than yours. 8C in birbhum district at morning, should be 12C in kolkata

No need to use canvas, h.alingment of ellipse should be left.

With reference from @AndrisP you will have to use the clause `on delete cascade`. But you have no need to use `joining` between three tables. Simply delete record(s) from the table `TABHDBHCHUYEN`. DELETE FROM TABHDBHCHUYEN WHERE (CONVERT(VARCHAR, NGAYCHUYEN, 101) <= '01/07/2017') which can delete all records from TABHDBH & TABHDBHCT …

Reverend Jim is correct. To get support from various expertise you must have to show your effort, from which every one can understand for what cause you didn't get your desired result. There are many expertise present here to help you about your codes from their hart. well; you can …

@Jayanta_1: In a parameterised sql statement you must have to use the parameter before adding/creating the parameter. In your first sql statement you didn't use the parameter into the statement. use of parameterised sql statement is the best practice to prevent your database from sql injections. The codes should be …

Go through two loops 1. by row count & 2. by selected column count

despite of crystal report vb.net2008 has a rich report viewer to display and print your report. You can use report document or print document to do your report most easily.

More shortly the codes should be For Each iItem As ListViewItem In ListView4.SelectedItems Label2.Text = Val(Label2.Text) - Val(iItem.SubItems(1).Text) 'And also remove the selected Item here Next Hope it can help you.

Go through the rows , pick and add your desired cell values. Dim x As Double = 0.0# Dim y As Double = 0.0# For i As Integer = 0 To DataGridView1.Rows.Count - 1 x += CDbl(DataGridView1.Rows(i).Cells(4).Value) y += CDbl(DataGridView1.Rows(i).Cells(5).Value) Next TextBox1.Text = x TextBox2.Text = y

Incorrect sql syntax used to update a table. >$sql = "UPDATE users SET Status_To_Public "$db_status_to_public" WHERE Username = '".$user."'"; Use an equal to sign i.e. `=`to set a value to a field of a table. $sql = "UPDATE users SET Status_To_Public ="$db_status_to_public" WHERE Username = '".$user."'";

> Text textbox but its value should be assigned to Modular Variable LN and then applicable to all sub procedures in that frmMain. >Modular Variable LN ??????? You have to read the [declaration & scope](https://msdn.microsoft.com/en-us/library/ms973875.aspx) of variables.