- Strength to Increase Rep
- +4
- Strength to Decrease Rep
- -1
- Upvotes Received
- 6
- Posts with Upvotes
- 5
- Upvoting Members
- 6
- Downvotes Received
- 2
- Posts with Downvotes
- 2
- Downvoting Members
- 2
- Interests
- Like to try many new things
this is my first time of creating trigger..I tried to create trigger using mysql to count how many 2007 data in the table when inserting new record but it not working....... My table have more than 50 data... CREATE TRIGGER No_of_Publisher_year Before Insert ON Book FOR EACH ROW SET @Count_No=New.Copyright; … |
|
Re:
Hi Just asking for a better solution for my approach in getting sql result with different multiple conditions based on comboboxes. I have a 4 comboboxes, for Branch, Type, Status and other info. User can select conditions from this comboboxes. The default value is "All", meaning no specific condition at … |
|
Re:
hello.. i have problem load two data from different table and column.. for example, each data from product table into product combobox and brand table to brand combobox..i succussfully load data to combobox but got multiple same data into combobox.. Dim conn As New OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source=" & Application.StartupPath & "\mydatabase.mdb;Jet … |
|
Re:
Hey, does anybody know how to read cloumn from MySQL? I mean, like if I have in my MySQL the schema "Bdatabase" and the table "accounts". In that table there are username and password. How can I do in my program that it'll read the username and password? |
|
Re:
I am using MS-Access & VB.Net I want to change Database password which use for connection string in Vb.Net forms (DB password change using, Open DB through MS-Access) For the beginning I used My.setting to save password and retrieve it from project load, but it not secure. My.Setting files easily … |
|
I'm doing a project about lighting.I don't know how tp draw beams does anybody know about it? |
|
Re:
I have this problem, I have a SQL code working perfectly on SQL Query windows... SELECT ID_no, nom_navire, date_mes, date_sav, description, nom_fourn, no_facture, date_facture, accept, decline FROM DB_FACTURE WHERE( ID_no = 39) Answer perfect On my code Is ... SELECT devise FROM FOURNISSEURS WHERE nom_fourn = '" + Nom_FournPass + … |
|
Is there possiblity to send, 5 data(5rows) at one time to the sql database in vb.net2008 |
|
I want to retrive data from table to combobox I used this coding though I didn't get an error the outpiut(data) is not displaing in the combobox Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click MessageBox.Show("Please Insert the Sample note no", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information) Try myConnection … |
|
Re:
I'm completely clueless to this as I have never used crystal reports before. So I want to use a textbox to pass values into my crystal report so basically only those I inputted into my textbox will be read and be outputted into my crystal report. Here is my code … |
|
When to trying to display data to datagrid view using query i got an error "a column named date already belongs to this datatable in net 2008" Dim dt As New DataTable Try myConnection = New SqlConnection(connectionstring) myConnection.Open() Dim cmd As New SqlClient.SqlCommand With cmd .CommandText = "SELECT [Date],[Totalamount] FROM … |
|
I taking data from 3 tables to crystal report.Tables are 1.Moblization -primary key is Fen_Inovoice_No 2.invovoice details -Primary keys are Fen_Inovoice_No and description 3.Client details-primary key is Contract name I 'm using this query to retrive data Dim cryRpt As New ReportDocument CrystalReportViewer1.SelectionFormula = "{Mobilization.Fen_Inovoice_No}= '" & Varibles.invoice1 & "'" … |
|
I have to tables 1.[Mobilization]-Primary key is [Fen_Inovoice_No] it is the forgien key is of [invovoice details] 2.[invovoice details] the primary keys are [Fen_Inovoice_No],[Item] when I tried to view the data , the all data are not loading to listview why is that? Dim intResponse As Integer intResponse = MsgBox("Please … |
|
Re:
Anyone familiar with kind of error? I'm so lost. Please help. |
|
When tried to update the data I got this error "incorrect syntax near '4' Unclosed quotation mark after the character string" Can someone fixed this error Public Sub Save() Dim indate As Date = DateTimePicker1.Value.Date If String.IsNullOrEmpty(TextBox1.Text) Or String.IsNullOrEmpty(TextBox2.Text) Then 'Show your message here MsgBox("Please fill all Data") Else 'Show … |
|
Dim startdate1 As String = DateTimePicker1.Value.Date Dim enddate As String = DateTimePicker2.Value.Date myConnection = New SqlConnection(connectionstring) myConnection.Open() Dim insert As SqlCommand = New SqlCommand(" INSERT INTO Client_Details (Contract_Name ,Client_Name ,VAT_No ,Cilent_Address,Start_Date,End_Date ,Contract_Value,Telephone_No) VALUES('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & … |
|
When I used the code though there ara no I won't get anwser.I couldn't whatis the error I did. cvowel([],0). vowel([a],Counter):-Counter is 1. vowel([e],Counter):-Counter is 1. vowel([i],Counter):-Counter is 1. vowel([o],Counter):-Counter is 1. vowel([u],Counter):-Counter is 1. vowel([_];[],Counter):-Counter is 0. cvowel([H|T],Counter1):-cvowel(T,Count),vowel(H,Counter),Count is Count +Counter,Counter1 is Counter1+Count. answer I got "Faulse" |
|
Re:
I've built an application that displays the contents of an access database in a datagrid and also a form which allows a user to add a new record to the database. When I tried to run the exe in the bin folder on another computer it displays an error when … |
|
When I used this coding I didn't any output though is no errors. palli([H]). palli([]). palli([H|T])-append(T,H,[T|H]). I got the output as [4] 6 ?- palli([m,a,m]),append(K,L,J). K = [], L = J . |
|
I write count the letters in a list, > ERROR: countvowels/2: Arguments are not sufficiently instantiated I got this error" why is that? this is the coding I used countvowels([],0). countvowels([H|T],Count1):-Count is Count1 + 1,countvowels(T,Count),Count1>1. |
|
I want to transate no to Letters ,and letters to no,as a Example when germantoenglish([e,t,th],Y).Y shoul be like below Y=[1,2,3] but I get answer as false............ trans(e,1). trans(t,2). trans(th,3). germantoenglish([S|H],[G|Ta]):-trans(H,Ta). englishtogerman([J|Ta],[L|H]):-trans(H,Ta). ` |
|
Can anybody explain why this is not working.Can someone help me. fib(0, 0). fib(1, 1). fib(N, NF) :- N>=0, fib(N-1, AF), fib(N-2, BF), NF is AF + BF. . |
|
Re:
Hello, who can help me to get the source code (VB.NET) from this application (http://www.4shared.com/file/fch3Wylw/InheritedForm2.html) |
|
Re:
Hi there, I have created a vb.net application. Every time i open any of the reports for the first time on only some of the computers then it says Logon Failed. Please try again. When i then open the report again it opens fine! The report however opens first time … |
|
Re:
hello, i am trying to save data in my listview item to access database.. i am new to programming and i am currently working on a project i need to submit very soon, this is really urgent and i will be much happy if i could get assisted as soon … |
|
Re:
Hey all, Sorry if this is really simple but I couldn't think how to phrase what I'm looking for on google. I've designed a piece of software for a friend for their business. When I learned VB we were always taught how to use it with Access Databases. I've decided … |
|
Re:
Hi, Can anyone tell me why datareader is no reading user_id from this code? I debugged and the user_id_select remains 0 and I am getting no errors. Protected Sub btnAddUser_Click(sender As Object, e As EventArgs) Handles btnAddUser.Click Dim conn As New SqlConnection("Data Source=BRIAN-PC\SQLEXPRESS;Initial Catalog=master_db;Integrated Security=True") Dim searchComm As String = … |
|
Re:
Ok, so this will be longwinded, but I'll try and explain what I'm trying to accomplish. Our form has 3 buttons. 1. Clear Database (Working) 2. Load database from Text File 3. Load listbox from database (I have this working) Our project has 2 forms, one being the form which … |
|
Re:
Hi - I am a pretty remedial visual studio express user. I recently understood how to do cascading comboboxes using the binding sources of the related tables, eg tbl 1 Make, Table 2 model, so as eg only ford models displayed in cbo2 if Ford selected in cbo1 - thanks … |
|
Re:
hi i have problem with my VB.net program I have a form and 3 GroupBox in the same form. i want go next 2 GroupBoxes afther Clicking the Next Button.. Can you Help me ? plz.. GroupBoxes1 to next GroupBoxes2 next GroupBoxes3 using same Next button |