Take a look at it
http://www.dotnetbips.com/articles/fb517596-9838-454b-b65d-999a7bb78445.aspx

Hello

Just check your web.config file for connection string or send us the error message to find exact problem.


Mark as solved if it helps you!!!

Hello there

If i understand u correctly, u need a Nested/group dataset in a single dataset

Do the following, i have created an eg for you.
follow the steps
1) In solution explorer Add-> new...

Hello

You can use the following code
ASPX

<asp:TemplateColumn>
<headertemplate>
<asp:checkbox id="chkSelectAll" runat="server" Width="30px"...

Hi there

I assume that you have " " single blanck space as separator in ur input. pls. follow the code below...





Private Function DoStuff() As String
Dim arr As Array

you can retrieve the Product Registration date then compare while accessing. have a look at the sample code

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

check out this link
http://support.microsoft.com/kb/175168

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 There

You can try this code
Note : RegisterDate is your actual date from table

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

If...

Hi

are you using Website or Web Project? if yours is website then ur solution saved in the following path

C:\Users\yourusername\Documents\Visual Studio 2005\Projects

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,

Use the following code...

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim dsTemp As New ProductGridDS
obj = New...

Hi Husna

You can use Typed Dataset and merge the additional ROLE column to it, the dataset can be used to bind your GRIDVIEW and so on and so forth...

Regards

Hi

We can display dropdownlist in gridview but not gridview in DDL
Tell us what is the scenario and what u want to achieve?.

Regards

Hi There

Pls. try this

Text='<%# Bind ("price", "$ {0:f2)") %>'>


Mark as fixed if it helps you!!!

Hi
if i understood correctly, u need a SQL query after joining those two tables ??

Pls. gimme what columns u needed from each of these tables and where conditions if any...

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

Pls. follow the link, this is a solved thread by me.

http://www.daniweb.com/forums/thread174460.html

Mark the thread as solved if it helps you!!!
Happy coding

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

This is not a recommended solution... it's not a good programming practice... the maintenance would be a big issue as you move in development stage.

Try keep n-tier architecture.
1) keep...

Hi

Can you post errors u r receiving... and be clear n specific about your problem..

Hope we i can help you.

Hi

Whats the error message??

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 there

Try something like this


Dim MyTxt As TextBox
MyTxt = CType(Page.Master.FindControl("ContentPlaceHolder1").FindControl("TextBox2"), TextBox)
...

Hi

Try this code


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

'(2) Assign the MailMessage's properties

Hi there

Try this

Aspx

<asp:GridView ID="gvBranchInfo" runat="server" BackColor="linen" AutoGenerateColumns="False"
DataKeyNames="ID"...

Hi

Populate your dataset with appropriate data



Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load


Dim sb1 As New StringBuilder

Hi there

This peace of code can be handy to deal with file extensions.


Public Shared Function GetFileName(ByVal Path As String) As String
Try
Dim RetVal As String
...

Dear
Do Something like this.. you can convert your code to C# easily


Public Shared Function ReadBillFile(ByVal Filename As String) As String
Try
Dim sr As StreamReader
...

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 code code in your .aspx


<asp:DropDownList id="ddl1" runat="server" AutoPostBack="True" AppendDataBoundItems="True" >
<asp:ListItem Selected="True"...

hii
Add the 3rd line code while binding DDlist.

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

Hi

Try to find the value of the grid's control


Dim MyTxt As TextBox

MyTxt = CType(Mygridview.FindControl("ord_Date"), TextBox)

Let me know if it solves your problem!

If i understand correctly, you need to instantiate your dataset

VB code

dim ds as new dataset

C# (Pls. correct the syntax if its wrong)

dataset ds = new dataset

Pls. use SQL query viz

strQuery = "Select * from customers where customer name like '%" textbox1.text &" %'"

Pls. make sure to change your approriate db connection string


Public Function...

Hi

Pls. use SQL query viz

strQuery = "Select Zipcode from Ziptable where Zipcode like '%" & your param &" %'"

Pls. make sure to change your approriate db connection string

Public...