Hi, I would like to know how to merge 2 daniweb accounts because there was a time I accidentally created a new account (Username: samuel1991) via Facebook which used a slightly different email address (samuel_lee_1991@qq.com) from my main email address (samuel_lee_1991@hotmail.com) used in Daniweb. TYVM

Member Avatar
Member Avatar
+0 forum 1

Hi, I need to use query to check if a person has made a purchase during the month of his / her birthday. If yes, I have to give the person 10% discount. So, I have my database as such (Some of the tables are omitted due to its relavancy): Shopper Table (Details of each registered shopper): [code] /* Table: dbo.Shopper */ CREATE TABLE dbo.Shopper ( ShopperID int IDENTITY (1,1), Name varchar (50) NOT NULL, BirthDate datetime NULL, Address varchar (150) NULL, Country varchar (50) NULL, Phone varchar (20) NULL, Email varchar (50) NOT NULL, Password varchar (20) NOT NULL, …

Member Avatar
Member Avatar
+0 forum 3

Ever since the "disatrous" Adobe Encore (CS4 and 5 does not matter)'s way of storing the installation directory details in Sqlite database file and some uninstall string in the registry, I would like to create dll to get the install directory from Sqlite database as per recommended by the Inno Setup (I can only use that to create some language pack installer for now.) users ([URL="http://news.jrsoftware.org/read/article.php?id=24706&group=jrsoftware.innosetup.code#24706"]http://news.jrsoftware.org/read/article.php?id=24706&group=jrsoftware.innosetup.code#24706[/URL]). Hence, I have written a dll in VB.NET as I am only familiar with that (I do not have any experience in C++, so sorry for that) and only to realized that Inno Setup …

Member Avatar
Member Avatar
+0 forum 27

Hi, as I am using Inno Setup to do the installer job, which requires a dll to check for installation path (Please refer to a previous thread: [URL="http://www.daniweb.com/forums/thread310549.html"]http://www.daniweb.com/forums/thread310549.html[/URL]), only to find out that [I][URL="http://news.jrsoftware.org/read/article.php?id=24737&group=jrsoftware.innosetup.code#24737"]VB.NET DLLs are .NET managed code. The DLL import feature of Inno can only talk to native DLLs.[/URL][/I]. I wish to convert the VB.NET dll into native dll. How should I start it? Or which programming language should I choose, it would be better if it has 64bit support reserved for future use. Thanks a lot.

Member Avatar
+0 forum 0

Hi, I would like to know how to write a "Console application" in dll form for a patch installer so that I could call it from the installers and find out the installation of a program. I have created a VB.NET class project and checked the COM Interoperation or sort of on project's property, build section. Now the main thing is on receiving parameters and returning the value. (I try to do this DLL as "all-in-one" DLL because this application is part of a bigger suite family, which means there are few others applications that requires the similar approach, and …

Member Avatar
Member Avatar
+0 forum 2

Hi, I got a question on how to convert SMS PDU code in a VB.NET application. All I need is just a function to convert a given PDU code. Well, I have googled for it, and this is what I got: Source: [URL="http://www.rednaxela.net/pdu.php"]http://www.rednaxela.net/pdu.php[/URL], [URL="http://www.codeproject.com/KB/IP/PDUDecoder.aspx?msg=934853"]http://www.codeproject.com/KB/IP/PDUDecoder.aspx?msg=934853[/URL] But I got an issue: If I use a String to PDU convertor (Eg: [URL="http://www.codeproject.com/KB/IP/PDUEncoder.aspx"]http://www.codeproject.com/KB/IP/PDUEncoder.aspx[/URL]), and if the text is an Unicode (Data Coding Scheme is 8 instead of 0) to generate a super long text (More than 70 characters, regardless if the text is plain alphabets that can be used 0 instead or contains special …

Member Avatar
+0 forum 0

Hi, I got a question to check if a date time is within another date range (So as to check conflicting schedule) There are various possible types of schedule: 1: One time start - end event. Typically such schedules is like a tour / outing / camp event, and hence I compare it using VB code as [CODE] If CurrentStartDate >= checkstartDate And CurrentEndDate <= checkendDate Then 'Do whatever 'CurrentStartDate is the selected start date time of the time slot while cuurentEndDate is the selected ending date time of the time slot. 'checkstartdate and checkenddate is the previously selected starting …

Member Avatar
Member Avatar
+0 forum 3

Hi, I am creating a forum which has 2 linkbuttons in [I]each gridview row[/I] that shows each posts. One is edit and the other is reply. I intended to have 2 different actions when the button is clicked. The problem is, I can only click either of them once. Subsequent press wont work. So, this is my ASP.NET code [CODE] <asp:TemplateField> <ItemTemplate> <div style="text-align: justify"> <asp:LinkButton ID="btnReply" commandargument = <%# container.DisplayIndex%> commandname ="Reply" runat="server">Reply</asp:LinkButton> <br /> <asp:LinkButton ID="btnEdit" commandargument = <%# container.DisplayIndex%> commandname ="Reply" runat="server">Edit</asp:LinkButton> </div> </ItemTemplate> [/CODE] VB code [CODE] Protected Sub gvPosts_RowCommand(ByVal sender As Object, ByVal e As …

Member Avatar
Member Avatar
+0 forum 1

Hi, I found myself a difficulty on creating a image uploader to my database. This is because in .NET CF, I cant find File Upload control. Is there any other options and how should I do it? I know there is a OpenFileControl but there is a problem on saving it / previewing it on a picture box. Thanks for any help.

Member Avatar
Member Avatar
+0 forum 4

Hi, I am using datagrid to show my products. The products have a image and I should show it. Problem is, datagrid is only text and there was some reference on creating custom columns but I still dont quite understand (Mostly are custom url columns). Any help please, thank you!

Member Avatar
Member Avatar
+0 forum 1

Hi I have a ASP.Net code below that need to query with MS SQL database. [code] "select SUM(ShopCartItem.Price-OfferedPrice) As Discount from ShopCartItem " & _ "Inner Join Product " & _ "On ShopCartItem.ProductID = Product.ProductID " & _ "Where(ShopCartItem.ShopCartID = @ShopCartID) And ShopCartItem.ProductID != @ProductID" [/code] The MS SQL query is effectively: [code] select SUM(ShopCartItem.Price-OfferedPrice) As Discount from ShopCartItem Inner Join Product On ShopCartItem.ProductID = Product.ProductID Where(ShopCartItem.ShopCartID = @ShopCartID) And ShopCartItem.ProductID != @ProductID [/code] Where @ShopCartID is a particular ShopCart (Fixed value, not a issue) and @ProductID is something variable values where it takes its value from another dataset. The …

Member Avatar
Member Avatar
+0 forum 5

Hi, I am currently doing an advanced search of a product. It is such varies into 3 categories: Product Title / Description, Price and Product Specifications I have called 3 datasets to check on each of these categories. Now, for reason, when I merge these 3 dataset [code] dsPrice.Merge(dsKeyword) 'Then Merge with specs dsAll.Merge(dsPrice) [/code] , I will get results that is in either one or 2 of them but not as across a whole where all 3 have a thing in common. How should I do it that to return a dataset that contains only data that are common …

Member Avatar
+0 forum 0

Hi, I have a 3 tables needed to be inner join before I got a full details of a transaction history (What item, shipment details, quantity, who bought it etc). The involved tables are ShopCart,ShopCartItem and OrderData ShopCart: [code] CREATE TABLE dbo.ShopCart ( ShopCartID int IDENTITY (1,1), ShopperID int NOT NULL, OrderPlaced int NOT NULL DEFAULT (0), Quantity int NULL, SubTotal money NULL, Tax money NULL, ShipCharge money NULL, Discount money NULL DEFAULT (0), Total money NULL, DateCreated datetime NULL DEFAULT (getdate()), CONSTRAINT PK_ShopCart PRIMARY KEY NONCLUSTERED (ShopCartID), CONSTRAINT FK_ShopCart_Shopper FOREIGN KEY (ShopperID) REFERENCES dbo.Shopper(ShopperID) ) GO [/code] ShopCartItem: [code] …

Member Avatar
Member Avatar
+0 forum 2

With regards to another thread, [url]http://www.daniweb.com/forums/thread251069.html[/url] on how to compare the current date to retrieve relevant data (Details there), now I have issue on storing this query result on a VB.net variable. It works in this way. It is an academic work to do a ecommerce website, and I need to compute some tax imposed on the goods purchased. Relevant subtotal etc has been implemented except on computing the tax. It is supposed to be a function and I have coded it in this way: [code] Public Function computeTaxCharge(ByVal dblSubTotal As Double) As Double Dim dblTaxRate As Double Dim dblTaxCharge …

Member Avatar
Member Avatar
+0 forum 1

Hi everyone, I have a problem in MS SQL. Due to academic nature, I am supposed to use a query to find out the present applicable tax rate (GST, Good & Sales Tax) without altering the table. The table has 3 tax rates, 1: WEF (With Effect From) 2004 Jan 1 --- 5% 2: WEF 2007 Jul 1 --- 7% 3: WEF 2011 Jan 1 --- 8% As of writing in 2010, I would need to use a query to return tax rate as 7% (1 year later, this code should return 8% instead) This was what I found: [code] …

Member Avatar
Member Avatar
+0 forum 3

Hi, I need to create a login program where it reads / writes to that file. It must first detect if the file present or not. If yes, it should not overwrite this file, else, it will have to create a default configuration file containing [i]Username[/i],[i]Password[/i] & [i]User Group[/i]. PS: It is an academic prototype only, where I cant afford to use actual database (Unless can in $0 cost & simple way). I could have just use a list of arraylist to do it, but whenever the program is close, these array values are lost too. The button "Login"(btnLogin) must …

Member Avatar
+0 forum 0

Hi everyone, I am trying figure out is there a "more proper" way to show the multiple lowest values in an array. My array has 2 of the values that are lowest among the 8 values. I would like to know is there a way to show both of them without using: [code] for (int i = 0; i < price.length; ++i) { if (price[i]<= lowest) { lowest = price[i]; loworderNo=i;//make the lowest price order number equals to the i //value, who is index contains lowest price } } System.out.println("Most Economical Food:\t" + (loworderNo-1) +"\t\t"+ item[loworderNo-1] + "\t" + lowest); …

Member Avatar
Member Avatar
+0 forum 12

The End.