Santanu.Das

Please post your snippets, how far you did?

Post your snippet to understand your problem.

Quite right. you should get the result is zero because you tried to count the number, but didn't try to get the number. To get the appropriate result your codes should be the followings. Dim str = "select count(*) from [tblprestamosinteres] where [idcliente] = '" + txtid.Text + "'" Dim …

PLease post th code you did. where from we can help you. You already create same discussion in another thread. Please mark solve if your purpose is solved.

Agreed with pritaeas.

Use "Where" clause in SQL Statement. You can use the followings if you like. SqlDataAdapter sda = new SqlDataAdapter("SELECT prod_id, prod_name, quantity,item_status FROM Table_3 Where item_status= 'ACTIVE'", con);

Your problem is either in line 1 Dim ANPSql As String = "Select * from Table1 limit 0,20" or in line 14 & 15. ANPDa.Fill(ANPDs, "ANPDatabase") ANPDt = ANPDs.Tables("ANPDatabase") Which is the correct TableName? SQL Statement's <TableName> and the argument value for <srcTableName> in Fill function and Table property should …

How do I restore my database?

There is no cause to interrupt the execution of your codes. You should initialized the Object variable `yenifaturaekle` when application starts and also when the ChildForm closes. You can do some thing like this. Imports System.Windows.Forms Public Class MDIParent1 Dim yenifaturaekle As New Form1 Private Sub MDIParent1_Load(sender As System.Object, e …

Why have you attached a text area to a solved discussion, If you would not give any reputation for further posting? From my opinion, please remove or inactivate the text area for a solved question.

I am new in MySQL. I do not about model and how can I store data in the tables created in amodel.

Varchar DataType is the appropriate one.

Your codes are too some correct. but you did some mistakes to initialize the variable "i" and should be open the connection. In DataGridView1_CellMouseClick event you did not do that. i = e.RowIndex TextBox1.Text = dt.Rows(i)(0) TextBox2.Text = dt.Rows(i)(1) and also in form_Load event you did not do con.Open() adapter.Fill(dt) …

There are no Ribbon object in toolBox but I desire to add a ribbon instead of MenuBar or ToolBar like Office. I search everywhere in vb.NET2010. How do I add it in my project. I have no idea.

How do I create a BackUp File of Database File?

You can get here all references of [ConnectionStrings](http://www.connectionstrings.com/) of every RDBMS

Yes, it should be.