Sign up to connect with Santanu.Das and gain access to their complete profile
  • Member Avatar
    Santanu.Das

    Replied To a Post in Submit button is not functioning (VB.net and Microsoft Access)

    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 …
  • Member Avatar
    Santanu.Das

    Began Watching Submit button is not functioning (VB.net and Microsoft Access)

    Hi. Im doing a login form with decryption. So i did a modification to my login code for decryption. Before i did the decryption, the login form is functioning well. …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VB 2010 ExecuteReader: Connection property has not been initialized.

    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.
  • Member Avatar
    Santanu.Das

    Began Watching VB 2010 ExecuteReader: Connection property has not been initialized.

    Hi Im having an error with my app, Im still learning to code. It gives me error at line rs = cmdOLEDB.ExecuteReader Here's my full code Imports System.Data Imports System.Data.OleDb …
  • Member Avatar
    Santanu.Das

    Replied To a Post in Write information to Database

    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 …
  • Member Avatar
    Santanu.Das

    Began Watching Write information to Database

    Hi group, I'm trying to store the information from a various textboxes into my database. However it is not writing the data (I'm getting my planned error message, "New Record …
  • Member Avatar
    Santanu.Das

    Replied To a Post in How to update one element in column chose with Select in VB.NET

    ' 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 …
  • Member Avatar
    Santanu.Das

    Began Watching How to update one element in column chose with Select in VB.NET

    Hi guys, This is my first post and so glad to start sharing the knowledge. I am using Mysql database with VB.NET and I have this code : Private Sub …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VB.net and sql Like query

    > strSearchText = TextBox2.Text > Dim sqlquery As String = "Select * from Housedat where (PROPID LIKE '%" & TextBox2.Text & "%')" Why do you not using the 'strSearchText' ? …
  • Member Avatar
    Santanu.Das

    Began Watching VB.net and sql Like query

    Hello, I am have been struggling with this and need some help. I am reading and excel sheet and getting the data and trying to search sql server to get …
  • Member Avatar
    Santanu.Das

    Replied To a Post in How To Add Sub Total Row In LISTVIEW1 Report Please Help Me......

    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 …
  • Member Avatar
    Santanu.Das

    Began Watching How To Add Sub Total Row In LISTVIEW1 Report Please Help Me......

    I create a project on vb.net 2010 and SQL server 2008r2 I showing a report in listview report am show fine and error free. But now I want to add …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VisualBasic How to add quantities and display them in a ListBox?

    Post your codes and problems where from we can help you to solve your problem.
  • Member Avatar
    Santanu.Das

    Replied To a Post in VisualBasic How to add quantities and display them in a ListBox?

    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 …
  • Member Avatar
    Santanu.Das

    Replied To a Post in Syntax Error in From Clause. Selecting between two Dates

    How could you use a string value to a date type field i.e. `Dim xFrom As String = dtpFrom.Value.ToString.Substring(0, dtpFrom.Value.ToString.IndexOf(" "))` `Dim xTo As String = dtpTo.Value.ToString.Substring(0, dtpTo.Value.ToString.IndexOf(" "))` `Command.Parameters.Add("@d1", …
  • Member Avatar
    Santanu.Das

    Replied To a Post in Syntax Error in From Clause. Selecting between two Dates

    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 …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VS-15 does not run after update of Win-10

    Thanks rproffitt. The solution for oct'17 there was the same. I already reinstalled the os from recovery drive.
  • Member Avatar
    Santanu.Das

    Replied To a Post in VS-15 does not run after update of Win-10

    didn't update by Windows 10’s April 2018 Update (version 1803).
  • Member Avatar
    Santanu.Das

    Created VS-15 does not run after update of Win-10

    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 …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VS-15 does not run after update of Win-10

    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 …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VB.NET - Delete data from DB MySql Workbench

    It should be a `DataAdapter` object. It has various type of [property](https://dev.mysql.com/doc/dev/connector-net/6.10/html/P_MySql_Data_MySqlClient_MySqlDataAdapter_DeleteCommand.htm) to maintain a database by using a `command` object.
  • Member Avatar
    Santanu.Das

    Gave Reputation to Reverend Jim in VB.NET - Delete data from DB MySql Workbench

    That may be the case except that without seeing all the code we don't know if it was declared at a higher scope.
  • Member Avatar
    Santanu.Das

    Replied To a Post in VB.NET - Delete data from DB MySql Workbench

    @Jim: You are correct. But `adapterDelete` has no use in the procedure and all objects like connectionstring, mysqlcommand are declared before use them except that one. IDE can poit out …
  • Member Avatar
    Santanu.Das

    Replied To a Post in VB.NET - Delete data from DB MySql Workbench

    `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.
  • Member Avatar
    Santanu.Das

    Replied To a Post in How to make a Log in with User type with different form in vb.net connect S

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

    Replied To a Post in Select from multiple tables

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

    Replied To a Post in problem with print preview and picturebox

    Why gg.Dispose() ?? fro my opinion from there your problem has been arised.
  • Member Avatar
    Santanu.Das

    Replied To a Post in WPF - Detect if the dragged control is placed inside another control

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

    Replied To a Post in How to save data from DataGridView to Access Database file using a Button?

    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. …
  • Member Avatar
    Santanu.Das

    Replied To a Post in MS Access Multi Table set data form From1 Textbox in C#

    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. …

The End.