Hi Kanuri

Pls. do the following
1) add a label in ur aspx page
2) modify the code ...


if dr.hasrows = false then
label1.text = "No Record(s) found for the given criteria!!!"
else

Convert your date columns(date_of_arr, date_of_dept) while select and insert in same pattern dd/mm/yyyy

SELECT convert(varchar(10), CAST( date_of_arr AS DATETIME) , 103)

Mark as solved if it...

Change the following line
txtProductName.Text += "," & cblPlanets.Items(i).Value

Pls. Mark as solved!!!

Hi there
code for you!!!

Protected Sub ibtnCancel_Click(ByVal sender As Object, ByVal e As System.Web.UI.ImageClickEventArgs) Handles ibtnCancel.Click
Dim i As Integer
...

Hi
Because your selected item is only one.
you can use if i understood you correcly!!! do your stuff in for loop


for i=0 to CBInsurance.items.count-1
next

Hi
It's as simple as that. take a look at the eg:
<asp:Menu ID="Menu1" runat="server" BackColor="#E3EAEB" DynamicHorizontalOffset="2" Font-Names="Verdana" Font-Size="0.8em" ForeColor="#666666"...

Pls. check your HTML Source page in contact.aspx and defaulf.aspx
Codebehind="contact.aspx.vb" ???

<%@ Page Language="vb" AutoEventWireup="false" Codebehind="frmAnnouncmentsAndMemos.aspx.vb"...

Hi
Use the following Code

<table>

<tr>
<td style="border:dotted">
<asp:Label ID="Label1" runat="server" Text=""></asp:Label>
...

Hi

You can compare the Path Stored in DB with physical path of the file along with their file extension eg .bmp/.jpeg etc...

Hi Sandeep

1) set Autopostback Property = true of Textbox1
2) protected Sub Textbox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtNewJobRankSerial.TextChanged
...

Hi
If i understood u correctly, u need to search records based on your Query value stored in session("Example").

Write: "select * from mytable where mycolumn like '%" & session("Example") & "%'...

Hello dear

You can use select_IndexChangeEvent Like this...

Protected Sub MyDropDownList_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles...

Hi there

Use the Query like this . The result is tested in 'Adventureworks' database


Select
product.ProductID,
product.Name,
ProductInventory.Quantity,
product.Name+'('+...

Hello there

You can do this with the resultset from your dataset source.
You can write the Group query to select eg:

select ProductID , ProductName and Value as Contactinate Productname +...

Hi there

try connection pooling . It may help you
<add key="DBConnection" value="Data Source=10.100.50.93;Initial Catalog=billing_production;User Id=sa;Password=;Pooling=true;Min Pool Size=2;Max...

Hi There

Pls. see the code that uses reader

You can assign data to sql reader

Public Function CheckRequest(ByVal response As String) As Boolean
Dim reader As SqlDataReader
...

Hi

Try this code


Try
'(1) Create the MailMessage instance
Dim mm As New MailMessage(FromEmailAddress, ToEmailAddress)

'(2) Assign the MailMessage's properties

As i understood from you code in selectindexchanged event:


daItems.SelectCommand.CommandText = "Select ProductName, UnitPrice, UnitsInStock, ProductImage from dbo.Products where CategoryID = " ...

hii
Add the 3rd line code while binding DDlist.

ddlItems.DataSource = dsCategory;
ddlItems.DataMember = "Categories";
ddlItems.DataValueField= "CategoryID"...

.aspx code

<table>
<tr>
<td style="height: 21px">
File Name
</td>
<td style="height: 21px">
<input...

Hi,

pls. look at this code below. it might help u