Showing results 1 to 25 of 396
Search took 0.20 seconds.
Search: Posts Made By: cuber_killua
Forum: .NET Database and Reporting 07-31-2013, 07:14 PM
Replies: 5
Views: 634
Posted By cuber_killua
Thank you very much for the help sir.. i got...

Thank you very much for the help sir..

i got it now.. here is the code:


str = ""
str = str & "SELECT SUM(CASE WHEN (trmdwm = 2 OR trmdwm = 3) AND date_add(isdate, INTERVAL 61 MONTH) >= '" &...
Forum: .NET Database and Reporting 07-31-2013, 12:50 AM
Replies: 5
Views: 634
Posted By cuber_killua
Hi, Thanks for the help and sorry for the...

Hi,

Thanks for the help and sorry for the late reply..

i use your code here it is:


str = ""
str = str & "SELECT SUM(CASE WHEN (trmdwm = 2 OR trmdwm = 3) AND date_add(isdate, INTERVAL 61...
Forum: .NET Database and Reporting 07-28-2013, 10:32 PM
Replies: 5
Views: 634
Posted By cuber_killua
SQl Query Case When

hi,

i have here a sample of code i created. and this is the situation:

Sum(Amount) where issuedate = issue date + 61 months if TRMDWN field value is 2 or 3

Sum(Amount) where issuedate =...
Forum: .NET Database and Reporting 01-26-2012, 07:07 PM
Replies: 0
Views: 684
Posted By cuber_killua
MySQL and VB2010 Database Mirroring

hello,

can anyone please share me their knowledge with regards to database mirroring, especially in mysql..

1. what i want to know is, do i have to create a connection on my vb project to...
Forum: .NET Database and Reporting 11-01-2011, 09:13 PM
Replies: 0
Views: 404
Posted By cuber_killua
Timeout lapse error

Please Help!!!

Dim newvalue As String = ""

str = ""
str = str & "Select intfee,intdec from inttrn where intidt>='2010-01-01' and intidt<='2011-10-31'"

cmd = New...
Forum: .NET Interface and Graphics 05-15-2011, 07:45 PM
Replies: 4
Views: 1,782
Posted By cuber_killua
Thanks for reply.. actualy it is not a school...

Thanks for reply.. actualy it is not a school project, this is for our company and this is just a part of the whole interment program.

And i am not asking someone to do it for me, i know the rules...
Forum: .NET Interface and Graphics 05-09-2011, 09:18 PM
Replies: 4
Views: 1,782
Posted By cuber_killua
there is a shape control in vb2010.. i'd like to...

there is a shape control in vb2010.. i'd like to use ovalshape for every lot..
Forum: .NET Interface and Graphics 05-09-2011, 07:00 PM
Replies: 4
Views: 1,782
Posted By cuber_killua
Cemetery Mapping

Hi guys!

Ive been studying this project for a months now, i was assigned to develop this kind of project but unluckily untill now i dont know how do it. i came up with so many plans to do it but...
Forum: .NET Interface and Graphics 04-05-2011, 06:46 PM
Replies: 3
Views: 2,492
Posted By cuber_killua
wow.. tnx for the info.. but how can i use...

wow.. tnx for the info.. but how can i use rectangle class?.. do i have to create it or there is a built in rectangle class in vb.net?..

i am going to create a system for a memorial park, so...
Forum: .NET Interface and Graphics 04-04-2011, 07:20 PM
Replies: 3
Views: 2,492
Posted By cuber_killua
Image Map

Hi guys!

Just want to know if it is possible to do an image mapping in VB2010?..

tnx and god bless..
Forum: .NET Database and Reporting 03-10-2011, 05:19 PM
Replies: 2
Views: 1,379
Posted By cuber_killua
yeah thtas what i am telling to my superior, that...

yeah thtas what i am telling to my superior, that we dont have to spend lots of money just for converting an old AS400 system to a new system, infact were just handling datas such as for interment,...
Forum: .NET Database and Reporting 03-07-2011, 06:24 PM
Replies: 8
Views: 1,531
Posted By cuber_killua
this is from your code: dv.RowFilter =...

this is from your code:

dv.RowFilter = "WHERE Forename ='" & txtFirstName.Text & "OR Lastname ='" & txtLastName.Text & "'"


how about adding aa single quote before the OR so that txtfirstname...
Forum: .NET Database and Reporting 03-07-2011, 06:14 PM
Replies: 3
Views: 706
Posted By cuber_killua
Thanks for the help.. its ok now guys.. Qua is...

Thanks for the help.. its ok now guys.. Qua is right i forgot to format the date to match the date format of MySQL, i didnt notice that part... it should be;

format(datebegin, "yyyy-MM-dd")
...
Forum: .NET Database and Reporting 03-02-2011, 08:27 PM
Replies: 8
Views: 1,531
Posted By cuber_killua
str = "" str = str & "SELECT Name FROM...

str = ""
str = str & "SELECT Name FROM Prescriber WHERE Name = '" & txtprename.Text & "'"
cmd = new mysqlcommand
cmd.connection = cn
cmd.commandtext = str
reader = cmd.executereader
while...
Forum: .NET Database and Reporting 03-02-2011, 08:16 PM
Replies: 3
Views: 706
Posted By cuber_killua
SQL Query doesnt return right value

hi guys!!! can you please help with this query, it seems that this query doesnt read the begindate and only displays record with enddate.


str = ""
str = str & "Select sum(quantity) as...
Forum: .NET Database and Reporting 01-28-2011, 02:10 AM
Replies: 2
Views: 1,379
Posted By cuber_killua
Database for Multi-user Application

hi,

i just want some opinnion or suggestions regarding database softwares. we are going to develop a system for 20 or less users, i am planning to use MYSQL community server as our database to...
Forum: .NET Database and Reporting 11-10-2010, 01:40 AM
Replies: 6
Views: 588
Posted By cuber_killua
isn't it something like this: Dim i As...

isn't it something like this:


Dim i As Integer
For i = 0 To Table1DataGridView.Rows.Count - 1
Dim row As DataGridViewRow
row = Table1DataGridView.Rows(i)
...
Forum: .NET Database and Reporting 11-06-2010, 12:24 AM
Replies: 0
Views: 772
Posted By cuber_killua
crystaldecision.crystalreport.engine in vb2010

hi guys.. i already installed the crystal report beta 2 of sap for vs2010, but i cant see any reference regarding that.. i want to try the old way that the vb.net uses but i cant see this reference;...
Forum: .NET Database and Reporting 11-05-2010, 11:36 PM
Replies: 6
Views: 588
Posted By cuber_killua
i think what flyguy means is, just change all...

i think what flyguy means is, just change all your msgbox to just a string var that holds the msg you want then call it after the loop.. i think you dont have to google it.. :D
Forum: .NET Database and Reporting 11-03-2010, 11:17 PM
Replies: 0
Views: 481
Posted By cuber_killua
Crystal Report Tutorial

hello guys.. i am searching the net for some help or at least basic tutorial for vb 2010 crystal report.. hope that there is someone here who can help me, but not only me, for sure there are lots of...
Forum: .NET General 09-29-2010, 07:20 PM
Replies: 1
Views: 221
Posted By cuber_killua
control creates another same event

hi guys i have a problem with my control..
i already finish this module but while doing 2nd module i notice that my 1st module doesnt work anymore, then i checked my code, i double click the control...
Forum: .NET Database and Reporting 09-23-2010, 06:01 PM
Replies: 0
Views: 368
Posted By cuber_killua
Update SQL Statement with sub queries

hi guys..
can you please analyze this sql statement if it will work..



update table1 set qty=(select sum(qty) from table2 where itemcode=reader.item) + (select qty from table1 where...
Forum: .NET Database and Reporting 09-23-2010, 05:48 PM
Replies: 9
Views: 1,352
Posted By cuber_killua
i just change the way i update my stocks.. what i...

i just change the way i update my stocks.. what i want to do is just add the total quantity of newly received items to the tables that has the same items, heres the changes to code i made..


...
Forum: .NET Database and Reporting 09-23-2010, 05:45 PM
Replies: 9
Views: 1,352
Posted By cuber_killua
heres how i declare 2 connections..: :D:D:D ...

heres how i declare 2 connections..: :D:D:D



host = GetSetting(Application.ProductName, Application.ProductName, "Host")
If host = "" Then
host = InputBox("Enter Server...
Forum: .NET Database and Reporting 09-23-2010, 06:57 AM
Replies: 9
Views: 1,352
Posted By cuber_killua
yeah... i use separate reader for different...

yeah... i use separate reader for different connections.. will it really work, though they have the same connection the only difference is the variable for each connection, but the value is the...
Showing results 1 to 25 of 396

 
Forum Jump
Advertisement:



Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe