- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
56 Posted Topics
 | i think since you didn't have code at all this can be a good starting point and if this code is helpfull could u pliz vote [CODE] Imports System Imports System.Threading Imports System.ComponentModel Imports System.IO.Ports Public Class Form1 'connect your mobile/GSM modem to PC, 'then go in device manager and … |
| | I am getting this error when I try to pass an sql string to an external crystal report. extenal in the the report is not part of the project but a crystal report file. I have uploaded a summarised version of the project Dim Report As New CrystalReport1 Set rs …  |
| | I want to format my textboxes in such a way that when someone fills in the details in the textbox if they press enter button on the keybord the focus is given to the next textbox that they should fill in .I tried the code below that we used in … |
| | I have a background worker thats doing some database work for me. The reason why I resorted to using using the background worker is because the database work is taking up a lot of time. So the code work the first time but as you continue to update the database …  |
| | when i use this code to save my datatable to the databaseit works well on the initial save save but when I access the database fill the datatable and then I delete some rows from the datatable and the "SAVE" the changes are not carried on to the database.How come …  |
| | I am using this code to compare two datatables(myTable and Dtable) and when I find two rows with common data I delete the rows in my other datatable(dtable) so that dtable comes up with data that is not already in myTable. However the code is not doing that at all. … |
| | I would like to though my datatable and seach in one particular column if there are any zeros.Currently I've been using the code below but I am not happy with the results . Any suggestions, ideas If FormatNumber(myTable.Compute("0.00", "ProductCode = '" & txtProductCode.Text & "' "), 2) IsNot Nothing Then … |
| | I am usiing the code below to calculate the sum of rows in my datatable with the productcode in the textbox but if the code is not in the datatable I get the error "conversion from dbnull to sting is not valid". How can i trap this error in this …  |
| | I am using the code below to bind my Gridview to a datatable and the code works well. However I now want to add data to the datable and its giving me an error "Rows cannot be programmatically added to the DataGridView's rows collection when the control is data-bound.". So …  |
| | Does anyone know how to do a login form in vb.net 2008 with an sql database? |
| | I am going through some tutorials in java and I would like to do my first insert into an SQL express database using java .I saw some tutorial recomending jdbc insert. I would like to know which is the best and most reccomended way to carry out an insert into … |
| | I ve got a propertyin my class that I have given the task of holding the username of the person that logged in and I would want to access that username in another form anoother time.How do I go about this? this is the code for my property: Private _LogInUser …  |
| | my login code works fine but the it gives me problems when the username and password in questin are not on the first row in the datatable. This is because when the code in debug mode, I took the time to check the contents of the datatable using the datatable … |
| | I am trying to have a situation where if a user clicks on a certain row in a datagridview control the value in the datagridview row will be shown for a a certain column. Column 1 in my datagridview control has Names in it so I want if a user …  |
| | I have been programming woth vb.net for a long time but now i want to start with java. and I wanted to know where i can find enlightening guidance tutorials and code samples that work . I also heard that java requires other programs to run with it. any links …  |
| | I am trying to delete a record from a table by using dao recordset. Currently I am working with the code listed below. Unfortunately i've realised that this code only deletes the first record in my table, whereas I am looking to delete a record form the table with an … |
| | I wanted to know how I can print reports using vb6 and crystal reports 11 and I am using the following code `Inline Code Example Here` Set Report = appln.OpenReport("C:\SBWBWIN\Report1.rpt") Report.Database.Tables(1).Location = App.Path & "\NewDatabase.mdb" CRViewer.ReportSource = Report CRViewer.ViewReport CRViewer.Zoom (100) Screen.MousePointer = vbDefault Report.PrintOut False, nocopies but the problem … |
| | I want to put some weather in my system and so far its working great. I've been copying the weather stuff from the yahoo website and this is the code 'Tomorrow Conditions startpoint = 0 : endpoint = 0 _search = String.Empty : _search = "Tomorrow" startpoint = _response.IndexOf(_search) + …  |
| | I am trying to save my scale configurations in the database so first I have to check if it exists in the database.and I am using the code below to do that . however when there is no data in the database I will get an error "No row at … |
| | I just attempted to insert a .jpg image into an access 2010 database but now I want to retrieve it and now I have an error that says "parameter is not valid" [CODE] Con.Open() Using com As New OleDbCommand("Select Picture from MyImages where ID =1", Con) Dim imageobj = com.ExecuteScalar … |
| | iam reading scale values from a scale in vb.net. now iam getting values like 33333kg and 55555kg and I want to format it such that I get values like 33.333kg and 55.555kg |
| | i have a small sample seral comms sample project and its working great .however i want it to run such that it will run continually 24 hours a day and not stop. I do not want any unauthorised persons to close the system, or stop it in any way, any … |
| | i ve got two radiobuttons one labelled male and the other labelled female and a client is supposed to choose which gender they are and insert it into the other database along with other information. I want to know how I can insert the chosen value (male or female) into …  |
| | i am inserting a row in an acces table but I also want to get the id of the last inserted row so that I can use that value. Any ideas on how I can go about it? [ICODE] Dim iSql As String = "Insert into CompanyDetails (code,description) 02 Connections.MyDataAdapter(iSql) …  |
| | i wanted to know how to deploy a simple program that is coonected to a access database.I have tried it many times but when I try to install it says that some file is mising. How can I do it so that I dont have to copy the database from … |
| | guys I have a program that i am working on and I want to know how to change the background color of a sstab control to white i am using vb6 here is the program: [CODE] 'Put the code in form1 Option Explicit ' ********************************************************************************* ' API Declarations... ' ********************************************************************************* … |
 | |
| | [CODE] '1 'the function Public Shared Function InsertNewRecord(ByVal myStoredProcedure As String) As Boolean Dim conn As New SqlConnection conn = MyFormz.connec.ConnWeb2() Dim cmdInsert As New SqlCommand Dim sSQL As New String("") Dim iSqlStatus As Integer sSQL = myStoredProcedure cmdInsert.Parameters.Clear() Try With cmdInsert .CommandText = sSQL 'Your sql statement .CommandType = … |
| | [code] Dim Conn_web As SqlConnection Conn_web = MyFormz.connec.ConnWeb2(dbName) Conn_web.Open() Dim sqlcmd_Insert As New SqlCommand(sql_Insert1 + sql_Insert2, Conn_web) Try sqlcmd_Insert.ExecuteNonQuery() MsgBox("The New Record has been saved.") Catch ex As Exception MsgBox(ex.Message) End Try [/code] [code] Sub Insert_New_Converts_Followups(ByVal strFollowup_No As String, ByVal strFollowup_Date As String, ByVal strFollowup_By As String, ByVal strFollowup_Response As … |
| | i have code to produce a database and tables but now i am looking 4 code 2 add relationships to the tables i would have made [code] Sub Create_ALL_Tables(ByVal dbName As String) Dim sql_Area As String = "CREATE TABLE Area (Category_ID bigint IDENTITY NOT NULL," & _ "Category nvarchar(50) NULL,Area_Name …  |
| | hey. i am trying to compile my project into a .exe application. this project has already been compiled already but i made some improvements and i now want to compile can some one help me on ho to go about it. i tried build>build solution but the program is not … |
| | i've just started doing asp.net i am good in vb.net but i've encountered a challenge.First of all isnt it supposed to be private sub not protected.As you can see i want to output a message on the label which is green but i am getting an error saying green is … |
| | I am using this code to to generate a crystal report from aa sql string that i construct using a supplied table name and some column names in txtSQL.This code contains functionality to export to ms word.However when the save dialog comes up and the user enters the intended filename.and … |
| | this code works well but somehow it is giving me a warning saying: "Variable 'str1' is used before it has been assigned a value. A null reference exception could result at runtime."How can i remove the warning. [CODE] Public Shared Function getAllColumnNames(ByVal tblname As String) As String() Dim com As …  |
| | i recently posted a code that i had that i needed assistance for and it was solved it was for displaying all tables in a database.but now i have this code for showing all column names in a table i was in the process of turning it from oledb to … |
| | i have corrected my conn string i am now using sql connection but now when i run the code it gives me he error Object reference not set to an instance of an object. [CODE] 'I put this code in the load event ListBox1.Items.Add(CType(GetTables().ToString, String)) [/CODE] [CODE] Public Shared Function … |
| | i am trying to export a crystal report document to excel but it is giving me an error saying that object refference is ... Any help pliz [CODE] Sub cryview() 'This code contains a functionality to export to Excel '* A sub for every corresponding Crystal Report Dim rpt As … |
| | what's up when i call the function below i get an error that says that oledb is not regstered on this machine i am calling the function like this [CODE] ListBox1.Items.Add(getAllTableNames) [/CODE] [CODE] Public Shared Function getAllTableNames() As String() Dim con As OleDb.OleDbConnection Dim com As New OleDbCommand Dim i …  |
| | I want to use a picturebox in my crystal report the picture that i want to place on the report is now on my form.I have declared the picture object.but i do not know its property for example using crystal reports when you declare a text object u say textobject.text.what …  |
| | i am trying to create a crystal report and run it on the fly so far this is where i am can anyone help or point me in the right direction.Any help will be appreciated [CODE] Private Function SetupReport(ByRef objCrystalReportDocument As CrystalDecisions.CrystalReports.Engine.ReportDocument) As System.Boolean Dim crTableLogOnInfo As CrystalDecisions.Shared.TableLogOnInfo Dim crDatabase … |
| | I am looking to adding a title to my crystal report document programmatically. This is because i am generating the report dynamically. And the other thing is it possible to just create a crystal report and to run a query and get a result on the fly i am working … |
| | I am facing a minor challenge in my coding i am trying to generate reports from sql statements.however the method i was using ealier involves making a crystal report using the "Add new item".in the menu and using the wizard until you end up putting the table you want on … |
| | I am generating crystal reports using sql statements but now i am looking 4 code to allow me to refresh the crystal report. in other words remove the datra on the report and wait for another query |
| | Guyz i have this insert function that is supposed to help me insert data but somehow i dont know how to actullay call it and get it to insert data [CODE] Private Sub btnInsert_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnInsert.Click DataAccess.InsertNewRecord(txtName.Text, txtSurname.Text, txtID.Text) End Sub [/CODE] [CODE] … |
| | i have a checked list box as one of my controls in my code what happens is when i click on the checked list box the item clicked in the checked list box is supposed to be added to a text box, and my code is now doing that however … |
| | Every time i try to run this codei get the following error: "'System.Data.DataRow.Protected Friend Sub New(builder As System.Data.DataRowBuilder)' is not accessible in this context because it is 'Protected Friend'. " this is my first time to insert using oledb and the With method. [CODE] Imports System.Data.OleDb Public Class frmAddd Dim … |
| | i have this insert code and its giving errors because there is something wrong with the connection string. [CODE] Dim MyConnection As SqlConnection Dim SqlString As String = "INSERT INTO items_table (item) VALUES ('" & Me.txtItem.Text & "')" 'Dim data_base As String = " Data Source=.\SQLEXPRESS;AttachDbFilename="C:\vb2008\Visual Studio 2008\Projects\morevariables\morevariables\App_Data\test_db.mdf";Integrated Security=True;User Instance=True" … |
| | thats tight bro i like your confidence, iam quit a begginner in vb.net so i'll be emailing you soon |
| | i have this function and it is giving me this warning. and i have many similar functions so by the time i'll be done i'll have a thousand warnings how can i get rid of the warnings Function 'SelectRows_local' doesn't return a value on all code paths. A null reference … |
| | I am trying to carry out a synchronisation of two databases one on the server and the other on a local machine so that even when they are not connected on the networkthe local database can carry on accepting data but when the network is back on the local database … |
The End.