Search results for query: *

  • Users: tgf-47
  • Content: Threads
  • Order by date
  1. tgf-47

    Question Need help with this assignment.

    I'm doing a project where we are re-creating a very old system. The client wants the same base functionality and some improvements. One of the things I'm currently working on is the note-system. These are used as flags of some sort, but are also used as a comment field for some products or...
  2. tgf-47

    Question How do I populate an array while creating a datatable? Breaking it up instead of fill

    I want to modify this function to populate an array with each item in the database. I have tried various options, but I just can't get it to work Private Function ConnectMe() As DataTable Dim conn As String = "Server=192.168.0.36;Port=3306;Database=wswc;Uid=root;Pwd=Jack"...
  3. tgf-47

    Question How to hardcode a connection to a MySQL DB and code a Datatable? I need help

    My system use to run on from a access database. Now I created the database on a MySQL server. I can connect to it using the connection wizzard, but I prefer using my old methods as shown below. I used this to connect to my access database: Private Function MYDATA() As DataTable Dim...
  4. tgf-47

    Question How do I connect to a MySQL Database on a server?

    I have a database in MySQL server called MD Server: Local host User: root Pass: wccmd12 port 3306 How do I connect to this database in vb.net? Can you give me the code and/or what to do please
  5. tgf-47

    Question The maximum message size quota for incoming messages (65536) has been exceeded.....

    The maximum message size quota for incoming messages (65536) has been exceeded. To increase the quota, use the MaxReceivedMessageSize property on the appropriate binding element. here is contents of my Web.config file: <?xml version="1.0"?> <!-- Note: As an alternative to hand editing this...
  6. tgf-47

    Question How do I use variables in a SQL statement

    I got this in my SQL statement. I "BOLDED" the problem. SELECT OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName, ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry FROM Orders WHERE CustomerID = @CustomerID I saw a video tutorial...
  7. tgf-47

    Question I'm having problems loading a 2nd report into reportvierwiewer

    I have 2 reports in my project. That is 2 normal microsoft reports. In reportviewer1, my first report is set to be the default report "rptOne.rdlc" I want to add a button to my form that when clicked "rptTwo.rdlc" gets loaded and displayed in reportviewer1. I have tried this, but with...
  8. tgf-47

    Question Microsoft ReportViewer Problem. Please help

    I have a problem. Everything works perfectly, but on the drillthrough event. Say I clicked on the cell that contains the value of "Peter". How can I get the clicked value of the report to a variable? Public Sub DemoDrillthroughEventHandler(ByVal sender As Object, _ ByVal e As...
  9. tgf-47

    Question Select / click - event

    In my crystal report I have columns and rows. Columns displaying my headings and the rows the data in the table. Here is an example ID | Name ----|------ 123 | John 347 | Max 348 | Merry 749 | Pete and so on, u get the picture. NOW ---> When I click on cell B3 (Merry), I want to know what...
  10. tgf-47

    Question Populating data ERROR--Please help

    I have this code that I am using:(calling a function) ViewReport(Application.StartupPath & "\This_proj.rpt", "select * from users", "@parameter1=test�mter2=10") but then I get this error message: A number, currency amount, boolean, date, date-time, or string is expected here. Error in file...
  11. tgf-47

    How do I fix "StackOverflowException"?

    :confused: When I run my project I get "An unhandled exception of type 'System.StackOverflowException' occurred in System.Windows.Forms.dll" Public Class frmViewReport Dim objForm As New frmViewReport Private Sub frmViewReport_Load(ByVal sender As System.Object, ByVal e As...
  12. tgf-47

    Help regarding crystal reports (Filtering)

    How do I link the data in my crystal report to filter data in another report on the item I clicked. eg. I have my products table (Report1) displaying all the products like soda, chips, sauces..... NOW when I click on, say the data item called soda. I want the other report, brands table...
  13. tgf-47

    Question load a .rdlc report file into the reportviewer in vb'08

    I am having trouble loading and displaying my .rdlc report file in my reportviewer. I've been all over the internet and nothing worked. I think it might be because i am using vb.net 2008. Also I am wondering if there is a click event in Microsoft Reports or in Crystal Reports where I can link...
  14. tgf-47

    Question Crystal Report HyperLink Problem, Please help

    I'm having trouble linking from my crystal report. I want to link to new forms in the vb.net project from data in the Crystal report and can't seen to find a way to do it... Any help would be appreciated.
Back
Top