poojavb

what error are u getting??? things u can check 1. check the datatype ...it shud be number related datatype 2. check the values u r passing to the date column.... 3. the value for date shud be in the same format as it is there in database.... it worked for …

[QUOTE=Smalls;1757641]What I'm trying to do is have a login type windows form to take a user name and password then compare these with data in the db then open an admin type form. I've been trying to get this to work for a few days now with no luck, about …

If login is ur startup form u cannot close it else ur application will be closed... set the form as hide or visible false before showing the other form.... and then show ur main form

write the following code in ur product combobox selection changeevent as below Dim conn As New SqlConnection(ConnectionString) Dim category As String category = cboCategory.Text Dim strSQL As String = "SELECT pt.productidID,pt.ProductName FROM ProductTable pt, categoryTable ct where ct.CategoryName='" & category & "' and pt.categoryid=ct.categoryid" Dim da As New SqlDataAdapter(strSQL, conn) …

u can use a datetimepicker to show the from date and to date.... I will give my example to u... I have one form in which I have two datepickers one for from date and the other one to date...one button to close the form and the second one to …

Please specify more details....

According to me ur Datatype is not correct.... try using .Add("@callup", SqlDbType.VarChar) .Add("@statecode", SqlDbType.VarChar) use SqlDbType instead of OleDbType

Instead of using parameters try it with the text boxes it self.... Dim cmd As New SqlCommand("insert into dbo.RMA values ('"+TxtRMA.Text+"','"+TxtVendor.Text+"','"+TxtDevice.Text+"','"+TxtSN.Text+"','"+TxtModel.Text+"','"+TxtProblem.Text+"','"+TxtDate.Text+"')")

Folder name such as da12e5154f6b530007fd9e got automtically created in my system... Can anyone please tell me why such folders get created and how can I delete it...

[QUOTE=artemix22;1764351]i am so confuse dude.. why in my visual studio 2010 ultimate didn't show crystal report gallery? after i click "add new item" and add crystal report, it just show me SAP page that say "learn and download". i have install SAP crystal report runtime engine for .NET framework 4(32-bit). …

As it is a number datatype a null value wont be stored in the column....it will store 0 as null value.... change it to text and then u can save a null value....

I have one parrot- Mitthi, 5 fishes and one dog - Buzo

The values in datagrid view will be entered manually or thru database ??? please explain in detail...

Hello, I am stuck with this problem.... I have few folders that contains a filename as **registration.txt** --- note the folder names are different since as and when a new user will register a folder gets created with its name and then the text file with the details of the …

First u have to validate all the conditions and if all the conditions are passed then save to database.... Like if emailvalidation = false or other things like name and so on then do this else save to database

i think it should be this way Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Form1.Personal_InfoTableAdapter.Insert(Me.TextBox1.Text, Me.TextBox2.Text, _ Me.TextBox3.Text, Me.TextBox4.Text, _ Me.TextBox5.Text, Me.TextBox6.Text, _ Me.TextBox7.Text, Me.TextBox8.Text, _ Me.TextBox9.Text, Me.TextBox10.Text) MsgBox("Complete") Just check once

My PC has 3 drives C, D, E...when I insert the removable CD drive it should detect that the drive is the F:... it may vary for different systems...how can I find which will can be the CD drive... I had written the following code Try For Each drive In …

Below example is in MS SQL...same can be done in Access database just change the SQLCommant to OLEDBCommand First open the connection and then Dim myCommand As SqlCommand myCommand = New SqlCommand("CREATE TABLE Tablename (col1 datatype1,col2 datatype2)", myconn) 'where myconn is the connection object myCommand.ExecuteNonQuery() 'Keep adding the table names …

Try textbox_TextChangeEvent Label1.Text=Textbox1.text

Hello Friends, Can anyone tell me how to increment a String variable by 1 in database. Suppose the database table has value as SL1000 and we want the next value to be SL1001. What should be done for such type of requirement in java.

Create a module in your vb.net project.... create functions for open connection and close connection.... In open connection give the database complete connection and in close connection just close the connection object..... To call the connections in the form u can call the functions respectively.... find the code below its …

Label1 will display the number of days.... Dim count = 0 Dim totalDays = (DTLeavePayTo.Value - DTLeavePayFrom.Value).Days Dim startDate As Date For i = 0 To totalDays Dim weekday As DayOfWeek = startDate.AddDays(i).DayOfWeek If weekday <> DayOfWeek.Sunday Then count += 1 End If Next Label1.Text = count

User ID comes first.... "Provider=_______;Data Source=_________;User Id=__________;Password=__________;"

To take the back up in Text format on disk Public Sub WritingTo_Textfiles(ByVal TableName As String) Try 'Open connection here Dim line As String Dim mysqlCommand As SqlCommand mysqlCommand = New SqlCommand("SELECT * FROM " & TableName & " ", myconn) Dim myReader As SqlDataReader = mysqlCommand.ExecuteReader Dim fileName As …

Table name shud not contain space

Date variable is a keyword so try giving some other name in ur database

The save data code is given in the above thread.... > Private Sub btnsave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnsave.Click > Dim con As New SqlClient.SqlConnection > Dim com As New SqlCommand > Dim adap As New SqlDataAdapter > Dim ds As New DataSet > con = …

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 …

Add a try catch block around ur sql statements and the insert sql is not correct cmd.CommandText = "INSERT INTO table([Name], [Comment], [emailaddress]) VALUES('" + txtname + "','" + txtcomment+ "','" + txtemail + "')"

ur pie variable sets a new form every time so the value in the old form1 does not get updated Comment the statement where u have declared the pie variable and just call the form name where u are declaring the variable to label Like below 'Dim pie As New …

The answer will be 2 only since subtracting higher to lower will give the result...if u want all the days inclusive just add 1 to ur result...

u need a table which will have the userid, logintime, logouttime columns... whenever the user logs into the application save the system date time into the database with userid as the criteria when the user logs off or directly closes the application then prompt with a yes / no msg …

Every time u delete a record from the datagridview (database) make sure u load the datagridview again completely...and if suppose any data is returned then enable ur delete button else disable... u can add the enabling and disabling of delete button in all ur control events wherever u r dealing …

Try this import java.applet.Applet; import java.awt.Color; import java.awt.Graphics; import java.awt.List; import java.awt.event.ItemEvent; import java.awt.event.ItemListener; // <applet code="AppletInterfaz" width="300" height="200"> </applet> public class AppletInterfaz extends Applet implements ItemListener { List colors; public AppletInterfaz() { colors = new List(4); colors.add("Aqua"); colors.add("Black"); colors.add("Blue"); colors.add("Fuchsia"); colors.add("Gray"); colors.add("Green"); colors.add("Lime"); colors.add("Maroon"); colors.add("Navy"); colors.add("Olive"); colors.add("Purple"); colors.add("Red"); colors.add("Silver"); …

u need to format ur way of displaying the records to display.... u can make use of the lines and design it in a table format...

UBound is not having one opening parenthesis

Dim strSQL As String = "SELECT distinct deptid,deptname FROM tablename" Dim da As New OleDbDataAdapter(strSQL, Connection) Dim ds As New DataSet da.Fill(ds, "tablename") With combobox1 .DataSource = ds.Tables("tablename") .DisplayMember = "deptname" .ValueMember = "deptid" End With

Drop a viewer in ur form...in ur forms load event try the below code Imports CrystalDecisions.CrystalReports.Engine Imports CrystalDecisions.Shared Public Class rptFinance Dim oRead As System.IO.StreamReader Private Sub rptFinance_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim crtableLogoninfos As New TableLogOnInfos Dim crtableLogoninfo As New TableLogOnInfo Dim crConnectionInfo As …

Hello Friends, I want to set the length of the textfield in java... Please check my below code....it works finely if I press the keys one by one slowly... But suppose if I press any key for a longer time the actual length exceeds and so the validation is not …

MessageBox.Show("WELCOME TO MAGIC BEANS INC. ^_^ :* :)) :p", Me.Text, MessageBoxButtons.OK, MessageBoxIcon.Information) Dim button As DialogResult button = MessageBox.Show("Would you like to become a member? (note: membership fee Php 500, non-member 250 for)", Me.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Information) If button = Windows.Forms.DialogResult.Yes Then Me.Show() 'Me.Dispose(False) ElseIf button = Windows.Forms.DialogResult.No Then Form2.Show() Me.Dispose(False) …

Just a brief idea... calculate the length of the array data....check if the last data in the length is , and then try to remove it.... else show some part of ur code...

So u need to show some id based on the selection of ur textbox to some other text box.... u need to add a select query based on ur auto complete text box in the text change event... like select * from tablename where colname='"+Autotextbox.Text+"' later u need to declare …

Try something like this Private Sub FindMySpecificString(ByVal searchString As String) ' Ensure we have a proper string to search for.' If searchString <> String.Empty Then Dim index As Integer = listBox1.FindStringExact(searchString) ' Determine if a valid index is returned. Select the item if it is valid.' If index <> ListBox.NoMatches …

U want to change the datatype in database right??? which database are u using???

Dim bill As integer=textbox14.text Module1.billno = bill Form18.txtbillno = Module1.billno txtbillno is a textbox so u are getting the error.... u need to add .Text after the textbox object Form18.txtbillno.Text = Module1.billno

Check if this will be fine for u Dim cmd As New OleDbCommand("SELECT colname FROM Tablename", Connection) Dim reader As OleDbDataReader = cmd.ExecuteReader combobox1.Items.Clear() While reader.Read combobox1.Items.Add(reader("colname")) End While reader.close()

in which event are u writing this code??? below code works...is this what u want....type in textbox3 and get the same thing in textbox4 Private Sub TextBox3_TextChanged(sender As System.Object, e As System.EventArgs) Handles TextBox3.TextChanged TextBox4.Text = TextBox3.Text End Sub

u can give the command SET NOEXEC ON and then the sql query...it will just compile

U need to give a try before posting.... will give some way restrict ur text box to number and max length as 3 then when clicking on the button.... give ur if conditions....before that just convert ur string to number and then display

Could u please show ur code???