How To Display Message In Textbox If The Selected Record Cannot Be Found In Database
Dec 16, 2010
i m doing when i enter travel id in textbox1 and click on button1 then in textbox2 i retrieve the travel agency name according to the travel id i entered in textbox1, I want when no record is found according to the travel id i entered in textbox1 then in textbox2 it shows the message no record found ...this is coding i use to retrieve record in textbox2 by enter travel id in textbox1 : have a look ...
Protected Sub Button4_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button4.Click
Dim SQLData As New System.Data.SqlClient.SqlConnection("Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|ASPNETDB.MDF;Integrated Security=True;User Instance=True")
Dim cmdSelect As New System.Data.SqlClient.SqlCommand("SELECT * FROM a1_vendors WHERE VendorId ='" & TextBox1.Text & "'", SQLData)
Dim dtrReader As System.Data.SqlClient.SqlDataReader = cmdSelect.ExecuteReader()
Protected Sub movebtn_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles movebtn.Click Dim con As New SqlConnection con.ConnectionString = ConfigurationManager.ConnectionStrings("26ConnectionString").ConnectionString con.Open() If persno.Text = "" Then Page.ClientScript.RegisterStartupScript(Me.GetType, "Forms", "<script> alert('Enter Pers No of Offr ..........') </script>")
I want to add a confirmation before deleting the data and popup message box...
how to show error msg in literal if no record found in database according to the text entered in textbox1 and textbox2 else if show record in gridview if the text entered in textbox1 and textbox2 will be found in database ...
I have QuoteNumber(ddquotes.text),partnumber(txtpart),Lastmodifieddate(txtLMD) which is a time stamp on my webform.I am sending all these information to my vendaor as an email with attachment .
When i click on email button a message should be recorded in a Textbox saying so and so quotenumber,so and so partnumber has been sent on ,so and so datetime to so and so vendor.how can i acheive this with single button click.
i have two textboxes 1 button and 1 gridview and 1 buttondatabase structure :i have to text boxes textbox1 in which user enter from date and in textbox2 user enetr to date and after button clickevent the gridview will display the record between fromdate and to date..
SELECT Ticket_no, journey_date, Travels, route, sel_seat, seat_opt, net_pay, name, mob, book_date, PNR_no FROM a1_ticket WHERE journey_date BETWEEN journey_date1 AND journey_date2 ORDER BY ID DESC journey_date1 =textbox1 journey_date2 =textbox2
I have a aspxtextbox and its validated from database.If text exists in database then it shows message Username exist.Now this is all happens on click of a aspxbutton after typing some text into aspxtextbox.I just want that when user defocus the textbox then it will automatically check from database and shows the message if exists.
I have edit, delete,update,next,previous,first and last button. my problem ismy next button doesnt show beyond second record even though there are 91 records in the table. I have used text box to display data from ms access database. this is my logic
I am trying to bind a record to a textbox using a Dropdown selected index change. I get the error.
Conversion failed when converting the nvarchar value 'DrFirstName DrLastName,Ph.D.' to data type int. is it because I concatenate the name and prefix of the DR into the Dropdown list like this,
Code: SELECT ID,EmailAddress, DrName + ',' + PreFix AS DrName FROM DrNames
Here is the dropdownlist code that I want to populate the textbox with the emailaddress in the table associated with Dr name and ID.
Code: Private Sub DropDownList1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles DropDownList1.SelectedIndexChanged Dim dt As New DataTable() If DropDownList1.SelectedItem.Text = "OTHER,..." Then txtRx1.Visible = True DropDownList1.Visible = False End If