Actually think I've gotten around the 'issue' by concatenating the two fields together as a new column when creating the table in the dataset.
Cheers,
Menthos
I'm trying to create a datarelation using two columns instead of the one that all the examples I've seen use.
Anyone know if this is possible? is there a way to create a datarelation using a multiple column key perhaps?
Cheers,
Menthos
OK, here goes... apologies for the sloppy code :)
<%@ Page Language ="VB" debug="true" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.ODBC" %>
<script runat="server">
Sub Page_Load(Source as Object, E as EventArgs)
'DB connect goes here
Dim objDataSet As...
I wasn't checking for that, however I set the default values for the DDL's in the main page load, and if I check for postback and don't set them they reset to the first item in the list.
Does that make sense?
Look forward to seeing the solution for this, as it's a similar problem to mine (http://www.tek-tips.com/viewthread.cfm?qid=1000235&page=1)
Spooky :)
Cheers,
Menthos
OK, I've run into another problem :)
The desired outcome of this datagrid setup is to be able to use the DDL on each row to set the access level for a corresponding forum (the rows show forum names).
The child datagrid's rows have a hidden unique ID column which I use to reference an array to...
OK, found out where I was going wrong, I had to cycle through the parent datagrid to get all the child datagrid controls... the code changes are as follows:
Private Sub Submit_changes(source As Object, e As EventArgs)
Dim ParentGriditem as datagriditem
dim ChildGridItem as datagriditem
dim...
Ok, I've got a parent/child datasource setup and bound to a datagrid with a nested datagrid within to show hierarchal info. For each row of the nested datagrid shown, I have a DropDownList with 3 options.
What I want to be able to do is click a submit button and read through each of the...
You need to grant your user access from your client. Check the manual for usage of GRANT. I think it's something like GRANT ALL PRIVELIGES ON <db> TO <user>@<host> IDENTIFIED BY <password>
Cheers,
Menthos
I'm sure this is possible, probably with a sub-query... I want to update a record with a value from another record in the same table.
E.G.
Name Val_1 Val_2 Check_col
Test1 0 0 s
Test1 10 20 M
Test2 0 0 s
Test2 20 25...
Aha :)
I guess we're moving OT for this particular forum, but are you able to let us have a look at the Scriptor.bat file in detail??
Not sure if the forum admins will want to move this thread to a more appropriate place.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.