19,728 Topics
 | |
| | Why do I get an error creating a temporary table with something even as simple as this:"CREATE TABLE #Results"? But this "CREATE TABLE Results" works. I thought we put # when we need to create temporary tables (Access), its like I've once done that. Help on that please? Thanks! |
| | Hi, I'm updating an application to .net from VB 6.0. It uses crystal reports to display reports but we get issues around versioning and having to have the client install Crystal so we would prefer not to depend on Crystal. I was originally going to use an XMLReader object to … |
| | Hi there, I'm reading the contents of a text document and saving all of the values (csv) into an array. My issue is that the very first article in the document is always being saved with "" appended to the beginning. eg. Text document reads: Hello,Doctor,Name,Continue,Yesterday,Tomorrow When it is brought …  |
| | How to create sound recorder to record from sound card.  |
| | Hello friends, This is my first port so please bear with me. I am developing a simple software in Vb.net 2010. In this software you can add, edit, delete, print records. I have done everything except print option as I dont have any idea on how to do this. I …  |
| | Dim odcell = OutgoingdeliveriesDataGridView1.Rows(e.RowIndex).Cells(e.ColumnIndex).Value.ToString() Using _conn As New MySqlConnection("Server = localhost; Username= root; Password =; Database = forms") Using cmd With cmd MsgBox("Connection Established") .Connection = _conn .Parameters.Clear() .CommandText = "SELECT FormName, Description FROM FormMaintenance WHERE FormCode = @Code" .Parameters.AddWithValue("@Code", odcell) _conn.Open() Dim dr As MySqlDataReader dr = cmd.ExecuteReader() If … |
 | I have two tables major and student majorname is the foreign key of Student table Student primary key=Reg_No I want to delete entire student record from student i used the coding like this........... Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click myConnection = New SqlConnection(connectionstring) myConnection.Open() … |
| | Hello guys, I am trying to dynamically update a combobox using mysql database, however I get the Error Catch Message. Any help would appriciated. Private Sub cmbName_DropDown(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmbName.DropDown Try dbCon = New MySqlConnection("SERVER=localhost;DATABASE=test;") strQuery = "Select name from customer_details" cmbName.Items.Clear() If DR.HasRows … |
| | Hello as title says, i would like to see if it is possible somehow to write in vb.net simple application that check if port 80 is used by some application and if it is to show Error message that it is used by APPLICATION NAME and asking if you want … |
| | I used this code delete recods from table ............ in VBP is database name Sell-is a table name The DELETE statement conflicted with the REFERENCE constraint "FK_Sells_Product_Details". The conflict occurred in database "VBP", table "dbo.Sells", column 'P_Id'. The statement has been terminated. Dim check As Integer Dim cmdproduct As New … |
| | "SELECT * FROM table where column=" & Request.QueryString("querystringfeild") i want to add order by condition along with where condition. But i don't know how to write syntax please help me. thanks!  |
| | in my work i get 03:00:00 as the total hours work..how can i make it in just 3? Dim TimeOutHours = TimeSpan.FromHours(Val(DateTime.Parse(TimeOfDay.ToString(Me.TimeOutTextBox.Text.Trim)).Hour)) Dim TimeInHours = TimeSpan.FromHours(Val(DateTime.Parse(TimeOfDay.ToString(Me.TimeInTextBox.Text.Trim)).Hour)) Dim TimeOutMins As Integer = (Val(DateTime.Parse(TimeOfDay.ToString(TimeOutTextBox.Text)).Minute)) Dim TimeInMins As Integer = (Val(DateTime.Parse(TimeOfDay.ToString(TimeInTextBox.Text)).Minute)) Dim mingreat As TimeSpan = TimeOutHours.Subtract(TimeInHours).Subtract(TimeSpan.FromHours(1)) Dim minless As TimeSpan = TimeOutHours.Subtract(TimeInHours) … |
 | Hi All, Got an issue that I know is quite common and read through lots of guides but cant see where I am going wrong. Got the code below which when form is loaded goes and grabs user from a table of usernames and puts them against a combo box … |
| | Here is what I am trying to do: From VB.net open a word template --- Done Populate it from a database ------Done Have word report back with the saved file name so as I can add it to the database history ----Not done. I know is has something to do … |
| | My Insert statement is not working for some reason and I cannot figure out why. Any help would be highly appriciated. Imports MySql.Data Imports MySql.Data.MySqlClient Public Class frmCreateUser Dim connectionstring As String Dim dbCon As MySqlConnection Dim strQuery As String = "" Dim SQLCmd As MySqlCommand Dim DR As MySqlDataReader … |
| | I'm working on a homework in which i need to create a Pizza order form. I've created the form along with the code but when i debug it, it gives me error. Errors below:(i've attached my code) C:\Users\Vasquez\Documents\Visual Studio 2005\Projects\Pizza Order\Pizza Order\Form1.vb(113) : error BC30451: Name 'txtSurname' is not declared. … |
| | hello, i'm doing a searching form, here is my code [CODE] Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim rd As OleDbDataReader con.ConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Bengkel\Project\db.mdb") cmd.CommandText = "SELECT * from Book where authorName like '%" & textsearch.Text & "%'" cmd.Connection = con con.Open() rd = cmd.ExecuteReader … |
| | ok i need help with this code i more than triple checked the spelling so i dont know what is wrong anymore and i have checked that i inserted the right data also. This is my code i use to insert into my DB when i break it i get … |
| | hi, frnds i am making a project on Grading System of school and i am using vb.net 2010 as my front end and SqlExpress as my back end . i have a Marks_Table in my database in which user stores student marks info . i want to generate marksheet on … |
| | Can someone please show me how to get the Odd number using the For..Next loops in VB I have declared the following; Dim intCounter As Interger Dim intStartValue As Interger Dim intEndValue As Interger Dim intSum As Interger intStartValue = 0 intEndValue = 50 intSum = 0 Iam trying to …  |
| | Hi! How should I get date, month & year in ascending order there in Crystal report? I have written following code there in my form to show report. Imports System.Data.SqlClient Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class Income_Sheet_Report Private Sub Income_Sheet_Report_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load cmbisrbdt.Items.Clear() … |
| | I have a loop to look for the key i.d. "veh2." The loop is there because even though the next line in the text file is where it should be, it is not there in all cases. The problem I'm having as far as wording or a way to go … |
| | hi all, i am not able to redirect/login to my owa page. when i run my code below commandd windoe comes and disappears nothing happens. please seemy code below: Sub main() Dim strServerName As String = "12.345.56.789" ' my owa ip Dim strPassword As String = "password" 'my password Dim … |
| | i am trying to get crystal report of my Marks_master Records From Table . I tried Following Code But It is Giving Me Exception As : System.IO.FileNotFoundException was unhandled Message=Could not load file or assembly 'file:///C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86\dotnet1\crdb_adoplus.dll' or one … |
 | Hi, How can i change the bar chart color after I click a button? Here is the senario. I have a bar chart to show line progress. Here is the 3 condition for the bar chart: 1) Before the bar chart reach maximum limit, the color will set to blue. … |
| | If ofd.ShowDialog = Windows.Forms.DialogResult.OK Then Try TempImage = Image.FromFile(ofd.FileName) imagename = ofd.FileName System.Diagnostics.Process.Start("filetest.exe", imagename) System.Diagnostics.Process.Start("sobel2.exe", ofd.FileName) PictureBox1.Image = TempImage this is my code. sobel2.exe works file with the argument. but filetest.exe hangs and gives win32 unhandles exception if i give a proper filename within codes to imagename filetest.exe works fine.. … |
| | Imports System.Data Imports System.Data.SqlClient Imports System.Configuration Partial Class books Inherits System.Web.UI.Page Dim con As New SqlConnection Dim cmd As New SqlCommand Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load If Not IsPostBack Then BindRatingControl() End If End Sub Protected Sub RatingControlChanged(ByVal sender As Object, ByVal e … |
| | How can I change the color of bar chart based on value in database column? For example, in table "STATUS" in my database, I have 3 type of value. What I want is: 1) If the value = 0, then color will change to blue. 2) If the value = … |
| | Sub empno() ComboBox2.Items.Clear() sql = "select empno from tbl_empinfo" If rs.State = 1 Then rs.Close() rs.Open(sql, conn) Do While rs.EOF = False ComboBox2.Items.Add(rs(0).Value) rs.MoveNext() Loop End Sub how do i write this for an access connection??? |
 | Need help while working with timer.... I am trying to do the database restoring part.... When the user clicks on the restore database button the progress bar shud be shown and as soon as the restoring is completed the progress bar shud stop and display success msg... Right now I … |
The End.