20,899 Topics
![]() | |
Hi, i'm using vb.net 2005 and i'm using crystal report also.when i try to open the reports ,this error will be shown "[B]directory or file cannot be created[/B]". i can't find the exact solution. Please help me to find out the solution for this crystal report error | |
I can Insert table from Old_Table_Database to New_Table_Database with this code. [CODE] Dim cmd5 As New OleDbCommand Dim cmd6 As New OleDbCommand cmd6 = New OleDbCommand("select * from " & "Product ", OldConn) Dim dr6 As OleDbDataReader dr6 = cmd6.ExecuteReader For j As Integer = 0 To dr6.FieldCount - 1 … | |
[CODE] Dim NewConn As New OleDbConnection(strConn) NewConn.Open() Dim dlt1 As New OleDbCommand("DELETE * FROM Invoice ", NewConn) Dim dlt2 As New OleDbCommand("DELETE * FROM InvoiceDetail", NewConn) Dim dlt3 As New OleDbCommand("DELETE * FROM Receiver ", NewConn) Dim dlt4 As New OleDbCommand("DELETE * FROM ReceiverDetail", NewConn) dlt1.ExecuteNonQuery() dlt2.ExecuteNonQuery() dlt3.ExecuteNonQuery() dlt4.ExecuteNonQuery()[/CODE] How … | |
Hi, I'm not exactly sure if this is the correct question to be asked but I will tell you what I am attempting. I have an ASCII txt file with data in it. It does not have headers. I am looking for a way to convert this data into an … | |
Frnds i want to insert image into picture box using the file dialog and that image should get stored into a local folder..... But the problem is the image is not getting saved n the below line is throwing an exception. i want to also rename the image with my … | |
What I am trying to do? update a database field with a richtextboxfield. Please help. I have tried using Dim range1 As New System.Windows.Documents.TextRange(RichTextBox1.Document.ContentStart, RichTextBox1.Document.ContentEnd) but this did not work for me either. [CODE] Dim cnn As SqlConnection Dim connectionString As String connectionString = "Integrated Security=SSPI;Initial Catalog=rploperations;Data Source=" & Environment.MachineName.ToString … | |
Hi all I need help with connecting to and manipulating a microsoft access 2007 database using code in visual basic 2008 express edition. It's for a project I'm doing for University that's due on the 12th of October:S. Please help me out in whatever way you can - links to … | |
I have this code where I get all the IP's connected to the network.. [CODE] Dim oWMI = GetObject("winmgmts:") Dim IP = GetObject("winmgmts:") Dim oPings = GetObject("winmgmts:") Dim PcName = GetObject("winmgmts:") For i = 100 To 105 IP = "192.168.168." + i.ToString oPings = oWMI.ExecQuery("Select * from WIN32_Pingstatus where address='" … | |
is there any way i can do this? As normally you can use a BB code on the post. But when using POST string it says error. i'm not sure if its because of the characters in the URL which are giving it an error but i've added \ in … | |
hey im doing a project and am having problem getting this code correct could you please have a look at it and help me understand were i am making the mistake the code [CODE] Private Sub m_buttonAddUserRole_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles m_buttonAddUserRole.Click Dim roleIndex As Integer … | |
Good day!. I have here a SQL database named Database1 and it has a tables (StudentID, Student name, Age, Gender,) vb.net and i want that if i input a records in vb.net it automatic save to sql database. Help me please. | |
Hi every 1 i am trying to register an employee but for some reason my record is inserted twice. if i enter all details of employee and when i click save..after that if i chk my employee list i could see same record entered twice.here is my code. Private Sub … | |
I have this code [CODE] Dim replace As String = System.DateTime.Now.AddDays(7).ToString("yyyy-MM-dd")[/CODE] What I'm trying to do is [CODE] Dim replace As String = textbox1.text.AddDays(7).ToString("yyyy-MM-dd")[/CODE] is there a way to use that add days from a text or string value already? | |
hey guys, So my works app uses a .rdlc file to print a membership card, and looks for a up to date .rdlc file to use as the template. i have VS2010 Pro installed. The other programmer created this program and published it in an earlier version of VS. Heres … | |
Hey guys, Heres what my app is trying to do: Print a members card Heres my code: [CODE]Me.AccountsTableAdapter.Connection = mainConnection Me.AccountsTableAdapter.NewQuery(Me.WaynokaDataSet.Accounts) With Me.ReportViewer1 .LocalReport.ReportPath = "G:\Bin\Waynoka Management\MemberCard" & varCardYear & ".rdlc" .LocalReport.DataSources.Add(New Microsoft.Reporting.WinForms.ReportDataSource("WaynokaDataSet_Accounts", dsReportList.Tables(0))) .SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout) End With Catch ex As Exception System.Windows.Forms.MessageBox.Show(ex.Message) End Try[/CODE] The title is the error it … | |
The problem is in lies in TA.Insert(txtfirst.text) I really dont know what is parameter,,,,all about pls help me...pls [CODE] Public Class AddOutPatient Private Sub btncancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btncancel.Click Me.DialogResult = Windows.Forms.DialogResult.Cancel End Sub Private Sub btnaddout_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles … | |
I have a listbox and would like to save the items added/deleted when the form closes. any ideas? | |
Heres my issue my fellow coders: My works VB program uses some .asp files to create reports. This is the error I am getting: Microsoft VBScript runtime error '800a000d' Type mismatch: 'ubound' /reports/wpoa_trans_summary.asp, line 238 I navigated to line 238 in the asp file and here is the code: [CODE]if … | |
Hi All, I am trying to retrieve the telephone number from Active Directory for my script, I found alot of examples online, and I tried to implement what I think should make sense (but since I really don't know vb that well, this is problematic). Below is the piece of … | |
gents please help on the following. I'm creating an small application where I search from the databse table tems and add the result line to a datarow of my datatable "dt", I the set the datagridviewe datatsource to this same dt. My question is: How can I save this dt … | |
Hi, I'm using asp.net together with vb.net. I am trying to develop: 1. a login page in asp.net, once user enter the correct username and password, this will be directed to the User page. 2. In User page, there will be some text fields of the user (eg. name and … | |
I need help creating bootstapper for crystal reports runtime.. I want crystal reports runtime to be installed automatically with the application if its not installed on the target machine. I am using vs2010 anyone have any idea here ? | |
In old vb6.0 it was easy to highlight the target item, where to drop those dragged rows. [CODE]Private Sub listView_OLEDragOver(Data As MSComctlLib.DataObject, Effect As Long, Button As Integer, Shift As Integer, x As Single, y As Single, State As Integer) Set listView.DropHighlight = listView.HitTest(x, y)[/CODE] I have been Googling all … | |
Hello, is there anything wrong with the below code? i want to blink any of the for labels if the back color is LimeGreen. Timer5 is enabled already and starts at form closing event of another for. so on the timer tick i have below code. thanks for your help … | |
[URL="http://www.daniweb.com/software-development/vbnet/threads/360388"]http://www.daniweb.com/software-development/vbnet/threads/360388[/URL] how to make a filter that only show the items that checked and unchecked don't show in checklistbox | |
Just a quick snippet for beginners | |
How are you, I need some help with the following code (Attached Form1 & AccountClass). I am trying to figure out the following: - Figure out the code in ButtonWithdrawal when the amount is bigger than 0. - Show the (Balance) in ButtonBalanceInq. - Show the List of transactions in … | |
Hello Friends, I have compeleted my project but I just need one help.... I want that when the application exe file is running at that time the database associated with the application shud be closed.... Means...I am using the .mdb file... is there any way that when the application starts, … | |
I have a LAN connection with my project and I need to display a running time and date of with labels anyone have an idea? is it curdate and curtime? | |
Hi, When i run the codes i donot get an error, howveer after clicking INsert i get the Syntax error in Insert Into statement error. I do recieve the COnnected MsgBox which then results in the error My code.. Sub connect() Dim acsconn As OleDbConnection = New OleDbConnection _ ("Provider=Microsoft.jet.oledb.4.0;data … | |
Hi, In the following code (Class & Form1), I'm trying to figure out the following: - Create an array that stores the 'Clients' (first name, last name, account number) - 'Button List' the array with the (First Name , Last Name , Array Value , Account Balance) I attached the … | |
Hi, I am trying to "Show" an error message for the user in two cases: 1. If he/she did not enter a correct value for a String. 2. If he/she did not enter a correct value for a Decimal. I know I have to use Try & Catch but each … | |
Hello guys. Im using visual studio 2005 and access 2007 as database. I have already connect the database which have two table with two gridview in a web form (asp.net). Now i want to compared the data in the two gridview, and those who are matching should be displayed in … | |
I have been trying to figure this out for a while and have found some answers, but I can't seem to make them work. I have a datagridview bound to a datatable. I want replace one of the cells with a combo box and bind that combobox to one of … | |
Hi, I am a new programmer of vb.net. My combobox1 has a value of name1, name2, name3, and i want that if the user already choose name1, he/she cant re use that name1 again. and that is autosaved to sql database. help me please! | |
im trying to get the insert to work but the problem i am facing is i keep getting this error Can someone help please thanks in advance my code is [CODE]Dim strsql As String = "Insert into cg_security_user (user_name,user_pwd) values (@field1,@field2) " Dim acscmd As New OleDb.OleDbCommand ' the oledbcommand … | |
i am try to systemdate and rem_date compare but error message is "Incorrect Syntax near'='" [CODE] Dim adp As New SqlDataAdapter("select * from reminder", obcon.con) Dim dset As New DataSet adp.Fill(dset) datagridview1.DataSource = dset.Tables(0) obcon.con.Open() Dim cmd As New SqlCommand("select rem_id,rem_hour,rem_min from reminder rem_date=" & Date.Now.Date.ToString & "", obcon.con) MsgBox("select … | |
hi every 1. i am trying to make a customer registration form. On the form i want to display the employee ID or Employee name who is servring or registring the customer. In short the employee who is logged in the system ,his Name or id should appear in the … | |
Our prof gave us this code Dim sql As String sql = "INSERT INTO OrderDetails" _ & "(orderid,prodid,price,qtyordered,amount,status)VALUES(" _ & "'" & OrderDetail.Orderid & "','" & OrderDetail.Prodid & "'," _ & "'" & OrderDetail.Price & "','" & OrderDetail.Qtyordered & "'," _ & "'" & OrderDetail.Amount & "','open')" I know this … | |
will someone help me on how to solve this error? The database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF' cannot be opened because it is version 661. This server supports version 655 and earlier. A downgrade path is not supported. Could not open new database 'D:\FEB. 29, 2012\WAIS SYSTEM-UPDATED JAN25\WAIS SYSTEM\BIN\DEBUG\WAIS.MDF'. … | |
[CODE]insert into po_detail (item_code,qty,item_rate,item_tax) select a.item_code,qty,item_rate,item_tax from mr_detail a,mr_head b where a.mr_no = " & combo_mr_no.Text & " and a.mr_no=b.mr_no""[/CODE] what's the error in the above code ? | |
'i am trying to get f_name + m_name + l_name three diferent columns combined from data grid view on cell content click into combobox. [CODE] Private Sub bugdgv_CellContentDoubleClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles bugdgv.CellContentDoubleClick Dim row As Integer = bugdgv.CurrentCell.RowIndex frmbug.bugcmbdeliver.Items.Clear() Try obcon.cmd.CommandText = "select d.del_name from … | |
Hello guys i'm getting a massive memory leak which over period of 1min its increase alot and always increases. How to i prevent the memory stacking? I looked all around the internet as im not just posting coz im lazy, i cant find a solution for my code. [CODE] Private … | |
I can't seem to figure this out- I have a single text box that has text in it. When I put the mouse in it and click it, I need the text to clear so new text can go in. Does anyone have a sample? TIA | |
i'm a relative newbie in vb.net and at an earlier thread i got the code as to how to add a datetimepicker to datagridview. it's just i dont know how to access this with my datagridview. [CODE]Public Class CalendarColumn Inherits DataGridViewColumn Public Sub New() MyBase.New(New CalendarCell()) End Sub Public Overrides … | |
I have two different forms. one has a listbox and the other has a masked textbox. the masked textbox is used as a login and i would like the masked textbox to be checked against the listbox items to be able to "gain access" and login Any ideas? | |
Hello How do i reset 2 textbox text of out four textbox at random avoiding a textbox whose text = 'A' for clarification. i have Textbox1.text = "B" Textbox2.text = "C" Textbox3.text = "A" Textbox4.text = "D" how do i set an empty value "" to any two textbox at … | |
I'm new to Visual Basic and I am trying to set up a currency converter. I have converted a currency to UK Sterling on the first form and on the second form I want to have the same label with the same amount of UK Sterling as on the first … | |
Im having problem downgrading because it will show error from resource file that has 4.0.0.0 in the line .. I try changing it to 2.0.0.0 but now my body form will not show up. I tried removing my resource file and upload it again but still wont work.. | |
im working on this piece of code and for sum reason i cannot understand why i keep getting this message can you please advise me thanks in advance [CODE] 'sql statements strsql = "insert into c_security_user (user_name, user_pwd,) values ('" & txtuser.Text & "','" & txtpass.Text & "')" Dim acscmd … |
The End.