Microsoft Windows
Member Avatar

Intro: I am Almario and I would like to discuss windows installation especially and more specifically out of the box installations. Why it should be partitioned to at least two …

Topic by almarionoah

If you have the system backup(s) and the data in a partition of the system HDD, effectively you are only securing yourself from user error. If the drive goes bad …

Software Development
Member Avatar

i have a mssql datagridviewer. i only need when user load the form..they must get empty datagrid...data only show when they search any item or add item....i worked on search …

Topic by omi4u

Usually unless we act on something, nothing happens. I'm guessing that you have already binded the datagridviewer to your dataset, from the VB GUI.
Instead, just place an empty datagridviewer …

Software Development
Member Avatar
    Try
        Dim Adapter As New OleDbDataAdapter
        Dim Command As New OleDbCommand

        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(" "))

        sqlQuery = MainQuery …
Topic by Sam_49

I believe you are closing one parenthesis from the "FROM" clause in your where.
Try this :

        sqlQuery = sqlQuery & " INNER JOIN Barangay ON Borrowers.BRGYNO = Barangay.BRGYNO)) " …
Software Development
Member Avatar

Hi Guys,

im facing problem at cmd.ExecuteNonQuery()
kindly correct me wer is the mistake? n how to correct?

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click …
Topic by maharaskal

1st of all this is a very old thread. You should have opened a new one.
2nd I see you closing the Conn but never open it. Try to open …

Databases
Member Avatar

i want to insert invoice values into databade invoice amount limit and split into multiple row if amount is grater than limit and insert it indicia or group

Topic by SRI SAI

Because you are not giving a lot of information, I cannot provide a specific solution.
Try to use a case when inserting or a trigger or use a stored procedure …

Software Development
Member Avatar

i want to update row after union conection

code conect

  Dim cmd As OleDbCommand = New OleDbCommand("SELECT tb1_type ,tb1_price FROM tb1 UNION SELECT tb2_supp,tb2_debt FROM tb2 UNION SELECT tb3_name,tb3_price FROM …
Topic by Ahmed_99

Generally the update will not update 3 tables at once and your syntax is wrong.
I assume that you are trying this because you don't know which of the 3 …

Databases
Member Avatar

I'm implement if else in stored procedure with and oprator .

If both Conditions are true the if statement should return 1 else -1.

here username and email should not …

Topic by morfious90

I believe that you problem doesn't lie with the if, but with how you give values to @Ucount and @Ecount:

select @Ucount = count(Username), @Ecount= Count(Email)
from userdata 
where Username=@nameUsername …
Databases
Member Avatar

I am developing a inventory software in VB6 using MS Access 2010 as Database, We have a main Store where we receive Products from different Vendors and then distribute the …

Topic by M.I.Sahil

This is a bad design / idea / report and the solution won't be really nice.
It's been a while since I've done anything with Access, but since nobody else …

Databases
Member Avatar

How do I get average of the duration for multiple weeks.

Currently I get something like

Student Avg completion time Week Year

STUDENT 1 0 1 2013

STUDENT 1 5 …

Topic by amishraa

I'm not sure why you group by "Avg Completion Duration". That means that you want a separate record for each completion duration.
If you want the average to include results …

Databases
Member Avatar
I have a simple sql table with four columns The data types are

Athlete nvarchar(30)
Mydate  date
Mytime  varchar(8)
Session nvarchar(40)

Sample Data
**Athlete  Mydate     Mytime   Session**
  Jerry   14/07/2014  00:00:32 …
Topic by Vb.Netter

This guy talks about dynamic columns in pivots:

https://www.simple-talk.com/blogs/2007/09/14/pivots-with-dynamic-columns-in-sql-server-2005/

Databases
Member Avatar

I am receiving a Code in sms like "yyyy/mm-digit" (digit increments with every message). so i want to ensure that the code sent by user is exactly in that format …

Topic by HunainHafeez

I'm not sure what you are trying to do, but try something like this:

Declare @msg as varchar(20)

SELECT @msg = '2014/9-1'

declare @slash as int 
declare @minus as int …
Databases
Member Avatar
I have a simple sql table with four columns The data types are

Athlete nvarchar(30)
Mydate  date
Mytime  varchar(8)
Session nvarchar(40)

Sample Data
**Athlete  Mydate     Mytime   Session**
  Jerry   14/07/2014  00:00:32 …
Topic by Vb.Netter

Assuming that you only need Mytime1 to Mytime10 (10 pivoted columns) only:
http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

If it's a dynamic pivot, one where Mytime can be anything from 1 column up to whatever, …

Software Development
Member Avatar

Hi, I have an vb.net application linked to Oledb database.
here is my code in Button_Click event to prevent duplicate entry with same ID, ID is not the primary key …

Topic by Satyam_1

In the Else part of the if..end if you are only setting the com, you are not executing it. Try executing the command you've just set.