see,if this was sql server,then it was easy.
Since it is msaccess.Then i dunno.
Don't know how to declare variable in msaccess,query window and use it.
Any way you can also this in front end.
Proceed then ask.
Set rs = CurrentDb.OpenRecordset("Primary", dbOpenDynaset)
With rs
.MoveFirst
Do Until .EOF
If ![image] = image Then
mystring = mystring & ![AKA/HS1] & ", "
End If
.MoveNext
Loop
End With
mystring = Left(mystring, (Len(mystring) - 2))
concat = mystring
End Function
<div>
</div><div>
</div><div>I implemented this function in Access DB.When i run this query with this function in access.It works perfectly fine.But when i get the access database n use the particular access DB in my webform.It is not recognizing the function.</div><div>I can
do this easily with MSSQl server but my requirement is i need to use access database itself.I m newbie to access.</div><div>
</div><div>Can you please guide me how to implement this particular function in frontend.I cant work on that access database anymore.Can you please guide me how can i do this in FrontEnd.</div><div>
</div><div>Thanks </div>
i) did you refer to the link i gave above ?Any problem ask.
in msaccess,where you pasting this function,Module ?Is it public ?
ii) in front end, iam giving you idea.
Sorry you understand the logic only and not the language.
in your table1 you hv 2 column filename and AKA,both text,right ?
first you make qry in one recordset rs,
string strfilename
string strAKA
sql="Select distinct filename from table1"
while not rs.eof
straka=""
sql1=Select aka from table1 where filename=strfilename
while not rs1.eof
strAKA=strAKA+rs1["aka"]
<tr><td>filename</td><td>AKA</td></tr>
end while
end while
Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)
Dim objCommand As OleDbCommand
Dim objAdapter As OleDbDataAdapter
Dim objDataSet As DataTable
Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
Dim strHSA As String
Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\App_Data\project2.mdb"
Dim cn As New OleDbConnection(objConnection)
Dim strSQLQuery As String
Dim strSQLQuery2 As String
cn.Open()
rs.Open("Select * From Primary", cn)
rs1.Open("Select * From Primary", cn)
strSQLQuery = "select distinct [image] from [Primary]"
While Not rs.EOF
strHSA = ""
strSQLQuery2 = "Select [AKA/HS1] from [Primary] where [image]=strimage"
xception Details: System.Runtime.InteropServices.COMException:
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Source Error:
Line 63:
Line 64: cn.Open()
Line 65: rs.Open("Select * From Primary", cn)
Line 66: rs1.Open("Select * From Primary", cn)
Line 67:
hello,
you are mixing asp and asp.net code.
guess you are using asp.right ?
i told you to apply the logic not the code.
And no problem,if you are using asp.net.Even gridview control is ok.
you can format same in gridview too.
just lemme know the latest developement.
Nimmy.K
Member
13 Points
50 Posts
Need Help one to many relationship between columns
Mar 31, 2010 02:57 PM|LINK
Hi,
I have a table Structure
filename AKA
12-3-09.pdf 443567
12-3-09.pdf 345678
12-3-09.pdf 456789
3-3-10.pdf 78901
filename AKA
I want to output as 12-3-09.pdf 443567,345678,456789
3-3-10.pdf 78901.
Any Help would be appreciated
Thanks!
Access Database - FileDSN in ASP.NET 2.0 access oledb Access 2003 Access 97 transactions Access db access 2007 strings SQL Access C# VB database Access 2003 with asp.net C#
KumarHarsh
All-Star
15133 Points
3647 Posts
Re: Need Help one to many relationship between columns
Apr 01, 2010 07:02 AM|LINK
see,if this was sql server,then it was easy.
Since it is msaccess.Then i dunno.
Don't know how to declare variable in msaccess,query window and use it.
Any way you can also this in front end.
Proceed then ask.
Kumar Harsh
KumarHarsh
All-Star
15133 Points
3647 Posts
Re: Need Help one to many relationship between columns
Apr 01, 2010 07:48 AM|LINK
refer this,
http://www.access-programmers.co.uk/forums/showthread.php?t=64611
Kumar Harsh
Nimmy.K
Member
13 Points
50 Posts
Re: Need Help one to many relationship between columns
Apr 01, 2010 04:42 PM|LINK
Hi Harsh,
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Function concatproducts(image As String) As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Dim mystring As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Dim rs As Recordset</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Set rs = CurrentDb.OpenRecordset("Primary", dbOpenDynaset)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">With rs</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> .MoveFirst</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Do Until .EOF</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If ![image] = image Then</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> mystring = mystring & ![AKA/HS1] & ", "</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> .MoveNext</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Loop</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">End With</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">mystring = Left(mystring, (Len(mystring) - 2))</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">concatproducts = mystring</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">End Function</div> <div></div>Function concat(image As String) As String
Dim mystring As String
Dim rs As Recordset
Set rs = CurrentDb.OpenRecordset("Primary", dbOpenDynaset)
With rs
.MoveFirst
Do Until .EOF
If ![image] = image Then
mystring = mystring & ![AKA/HS1] & ", "
End If
.MoveNext
Loop
End With
mystring = Left(mystring, (Len(mystring) - 2))
concat = mystring
End Function
<div></div><div>
</div><div>I implemented this function in Access DB.When i run this query with this function in access.It works perfectly fine.But when i get the access database n use the particular access DB in my webform.It is not recognizing the function.</div><div>I can do this easily with MSSQl server but my requirement is i need to use access database itself.I m newbie to access.</div><div>
</div><div>Can you please guide me how to implement this particular function in frontend.I cant work on that access database anymore.Can you please guide me how can i do this in FrontEnd.</div><div>
</div><div>Thanks </div>
KumarHarsh
All-Star
15133 Points
3647 Posts
Re: Need Help one to many relationship between columns
Apr 02, 2010 04:33 AM|LINK
i) did you refer to the link i gave above ?Any problem ask.
in msaccess,where you pasting this function,Module ?Is it public ?
ii) in front end, iam giving you idea.
Sorry you understand the logic only and not the language.
in your table1 you hv 2 column filename and AKA,both text,right ?
first you make qry in one recordset rs,
string strfilename
string strAKA
sql="Select distinct filename from table1"
while not rs.eof
straka=""
sql1=Select aka from table1 where filename=strfilename
while not rs1.eof
strAKA=strAKA+rs1["aka"]
<tr><td>filename</td><td>AKA</td></tr>
end while
end while
write it correctly.
Kumar Harsh
Nimmy.K
Member
13 Points
50 Posts
Re: Need Help one to many relationship between columns
Apr 02, 2010 01:43 PM|LINK
Nimmy.K
Member
13 Points
50 Posts
Re: Need Help one to many relationship between columns
Apr 02, 2010 01:47 PM|LINK
Nimmy.K
Member
13 Points
50 Posts
Re: Need Help one to many relationship between columns
Apr 02, 2010 02:44 PM|LINK
Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)
Dim objCommand As OleDbCommand
Dim objAdapter As OleDbDataAdapter
Dim objDataSet As DataTable
Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
Dim strHSA As String
Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\App_Data\project2.mdb"
Dim cn As New OleDbConnection(objConnection)
Dim strSQLQuery As String
Dim strSQLQuery2 As String
cn.Open()
rs.Open("Select * From Primary", cn)
rs1.Open("Select * From Primary", cn)
strSQLQuery = "select distinct [image] from [Primary]"
While Not rs.EOF
strHSA = ""
strSQLQuery2 = "Select [AKA/HS1] from [Primary] where [image]=strimage"
While Not rs1.EOF
strHSA = strHSA + Convert.ToString(rs1("[AKA/HS1]"))
Dim cmd As New OleDbCommand(strSQLQuery, cn)
cmd = New OleDbCommand(strSQLQuery2, cn)
objCommand = New OleDbCommand(strSQLQuery, cn)
objCommand = New OleDbCommand(strSQLQuery2, cn)
objAdapter = New OleDbDataAdapter(objCommand)
objDataSet = New DataTable()
objAdapter.Fill(objDataSet)
dgPaging.DataSource = objDataSet
dgPaging.DataBind()
End While
End While
cn.Close()
End Sub
</script>
<html>
<head>
<title>Search</title>
</head>
<body>
<form id="Form1" runat="server">
<asp:Button id="btnSearch" runat="server"
Text ="Search"
OnClick ="btnSearch_OnClick"
/>
<asp:GridView ID="dgPaging" runat="server" AutoGenerateColumns="false" HorizontalAlign="Justify" ShowHeader="False">
<EditRowStyle ForeColor="White" />
<AlternatingRowStyle ForeColor="White" HorizontalAlign="Justify"></AlternatingRowStyle>
<Columns>
<asp:TemplateField HeaderText="HS1">
<ItemTemplate>
<img src="pdf\<%#Eval("image")%>" />HS1-<%#Eval("AKA/HS1")%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</form>
</body>
</html>
I am getting a runtime exception :
xception Details: System.Runtime.InteropServices.COMException: Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Source Error:
Line 63: Line 64: cn.Open() Line 65: rs.Open("Select * From Primary", cn) Line 66: rs1.Open("Select * From Primary", cn) Line 67:Can you please suggest me
Thanks,
Nimmy
<div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">Sub btnSearch_OnClick(ByVal sender As Object, ByVal e As EventArgs)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objCommand As OleDbCommand</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objAdapter As OleDbDataAdapter</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objDataSet As DataTable</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch2 As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch3 As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch4 As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch5 As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSearch6 As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim rs As New ADODB.Recordset</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim rs1 As New ADODB.Recordset</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strimage As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strHSA As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim objConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\nimmy.k\Desktop\achievemath_1\WebSite1\App_Data\project2.mdb"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim cn As New OleDbConnection(objConnection)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSQLQuery As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim strSQLQuery2 As String</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch = txtSearch.Text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch2 = txtSearch2.Text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch3 = txtSearch3.Text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch4 = txtSearch4.Text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch5 = txtSearch5.Text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSearch6 = txtSearch6.Text</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> If (Len(Trim(strSearch)) & Len(Trim(strSearch2)) & Len(Trim(strSearch3)) & Len(Trim(strSearch4)) & Len(Trim(strSearch5)) & Len(Trim(strSearch6))) > 0 Then</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> rs.Open("Primary", cn)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> rs1.Open("Primary", cn)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> cn.Open()</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSQLQuery = "select distinct [image] from [Primary]"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> While Not rs.EOF</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strHSA = ""</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strSQLQuery2 = "Select [AKA/HS1] from [Primary] where [image]=strimage"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> While Not rs1.EOF</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> strHSA = strHSA + rs1[[AKA/HS1]]</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End While</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End While</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Dim cmd As New OleDbCommand(strSQLQuery, cn)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> cmd = New OleDbCommand(strSQLQuery2, cn)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objCommand = New OleDbCommand(strSQLQuery, cn)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objCommand = New OleDbCommand(strSQLQuery2, cn)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objAdapter = New OleDbDataAdapter(objCommand)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objDataSet = New DataTable()</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> objAdapter.Fill(objDataSet)</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataSource = objDataSet</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> dgPaging.DataBind()</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> cn.Close()</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Else</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> txtSearch.Text = "Add the text here!!"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End If</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> End Su</div>hans_v
All-Star
35986 Points
6550 Posts
Re: Need Help one to many relationship between columns
Apr 02, 2010 09:24 PM|LINK
You're mixing up Classic ASP code with ASP.NET! Do not use recordset in ASP.NET, use OleDbDataReader instead.
KumarHarsh
All-Star
15133 Points
3647 Posts
Re: Need Help one to many relationship between columns
Apr 03, 2010 06:01 AM|LINK
hello,
you are mixing asp and asp.net code.
guess you are using asp.right ?
i told you to apply the logic not the code.
And no problem,if you are using asp.net.Even gridview control is ok.
you can format same in gridview too.
just lemme know the latest developement.
Kumar Harsh