|
You have to use the right provider.
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mydatabase.mdb"
- Morten
|
|
|
|
|
Actually I used DSN connection, but with the way you showed it worked fine 
Argh... need to read more about several providers, lol
Thanx again
Philip Patrick
"Two beer or not two beer?" (Shakesbeer)
Web-site: www.saintopatrick.com
|
|
|
|
|
Hay, Any One Got A Code For Short Messaging System(SMS)?
I Need A Code To deal With Webpages?
Thanks For Help. ( Hay Please I'm New In This Field )
__________________
..:: GooGle ::..
|
|
|
|
|
I had a strong belief that when a property of an Object is defined as ReadOnly then it means that you can only read its value at runtime and cannot modify the value. If this is wrong just donot read further, but just correct me.
This is what I found confusing...
In MSDN's documentation for Style property of a Web Control it says,...
[Visual Basic]
Public ReadOnly Property Style As CssStyleCollection
[C#]
public CssStyleCollection Style {get;}
...
But then they have shown an example of how to use the "visibility" key of the CssStyleCollection to hide and unhide a label control programmatically, like this....
void Button1_Click(Object sender, EventArgs e)
{
Label1.Style["visibility"]= ((Label1.Style["visibility"]=="hidden")?"show":"hidden");
}
If one is able to change a property's value then why the hell do they declare it as *ReadOnly*. And if you are a C# programmer, check out their declaration above that they dont have the set() method.
Then how does it work???
omkamal
|
|
|
|
|
In this example they do not change the Style property - they change the value of one of the items in collection that is pointed to by Style property.
|
|
|
|
|
Hey Guys,
I created this function that doesn't always link. If you query to the end of my data...I get the links, but if I start from the beginning of the files, I can't link to the links that I'm calling. It only works when I fast forward to the end, then work backward. What is wrong with this stuff?
-------
Function CreateFolderLink (field)
dim str, str_link
str = objRS(field)
str_link="<A HREF = """ & str & """ TARGET = ""_blank"" >Web Folder Link</A>"
CreateFolderLink = str_link
End Function
Function CreateLink (field)
dim str, str_link
str = objRS(field)
str_link="<A HREF = """ & str & """ Target = ""_blank"" >" & str & "</A>"
CreateLink = str_link
End Function
------
|
|
|
|
|
I have DataAdapter and DataSet,my dataadapter string is something like this:
"SELECT * FROM TABLE",and I fill dataset with this dataadapter,and I bound Datgrid to it and it's ok.
Now after this I want to set a filter for the recorsets that datagrid show.Can I use those dataadapter and dataset and set the filter in the way that I don't know it,
or I HAVE TO fill dataadapter and dataset from the beginning with new SQL statement?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Mazdak wrote:
or I HAVE TO fill dataadapter and dataset from the beginning with new SQL statement?
The standard thinking is that the sqlDataAdapter should be the one controlling what goes into the DataSet. So you should put the filtering on the sqlDataAdapter command text.
This is good because lets say you have 10000 records and you only need 10 of them based on a specific filter. If you did the filtering on the DataSet then the sqlDataAdapter still has to download 10000 records, rather than just 10.
I do know you can filter on the DataSet or DataGrid itself, if you want to. But I don't know how offhand. If you want to know how, just holler.
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge
Sonork ID: 100.9903 Stormfront
|
|
|
|
|
Paul Watson wrote:
I do know you can filter on the DataSet or DataGrid itself, if you want to. But I don't know how offhand. If you want to know how, just holler.
I don't know about it,Could u tell me about it?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
I'm trying to page a recordset, but in one case I have a problem. The code looks like:
<br />
sSQL = "SELECT Table1.*, Table2.* " &_<br />
"FROM Table1 LEFT JOIN Table2 ON Table1.Name = Table2.Name"<br />
rec.CursorLocation = adUseClient<br />
rec.CacheSize = 25<br />
rec.PageSize = 25<br />
rec.Open sSQL, con, adOpenForwardOnly, adLockReadOnly<br />
In case that the Table1.Name exists in Table2.Name, all is working correct. But if not... I'm getting E_FAIL from Microsoft Cursor Engine when I'm trying to do anything with returned Recordset. Though without paging and having a client cursor, it works fine.
Any ideas what is going on and how to fix it?
Philip Patrick
"Two beer or not two beer?" (Shakesbeer)
Web-site: www.saintopatrick.com
|
|
|
|
|
This may not be, but are you validating after you open your connection:
<small>Philip Patrick wrote:
</small>sSQL = "SELECT Table1.*, Table2.* " &_
"FROM Table1 LEFT JOIN Table2 ON Table1.Name = Table2.Name"
rec.CursorLocation = adUseClient
rec.CacheSize = 25
rec.PageSize = 25
rec.Open sSQL, con, adOpenForwardOnly, adLockReadOnly
Are you checking the EOF and BOF flag?
dim iCount
iCount = 0
if not rec.EOF or rec.BOF
do until rec.EOF or iCount = 24
response.write rec("SomeValue") & vbcrlf
rec.MoveNext
iCount = iCount + 1
loop
else
response.write "You have no results" & vbcrlf
end if
Hope this helps some?
Nick Parker
|
|
|
|
|
Hmm, well, actually I'm using rec.PageSize and rec.RecordCount to determine it. Of course, PageSize I don't have to. But seems like the recordset is broken or I dunno what wrong with it. I'm running the same query in Access and it works fine and returns records. Same if I won't use Client cursor (adUseClient) but server-side.
But for client, it just don't want to work 
Philip Patrick
"Two beer or not two beer?" (Shakesbeer)
Web-site: www.saintopatrick.com
|
|
|
|
|
Help!
I am producing a Web enabled application and am trying to
run an ISAPI extension dll using an HTML Form input in
Front Page 2000.(I have installed IIS, Server Extensions
etc. on my PC.)
However, when I press the "submit" button to call the
extension, passing in the string in the Text Box on the
Form, I get the "Page cannot be displayed" message and
the "Error 501/505 - Not implemented or not supported
Internet Explorer "
The HTML for the Form looks like this:
<FORM ACTION="http://myServer/Scripts2/ISAPI002.dll?
Default?" METHOD="POST" >
<p>Text Input: <input type="text" name="Text" size="12"
tabindex="1"></p>
<p><input type="submit" value="Submit" name="B1">
<input type="reset" value="Reset" name="B2"></p>
</FORM>
I have overloaded the Default function in the Parse Map to
accept the String input, as follows:
BEGIN_PARSE_MAP(CISAPI002Extension, CHttpServer)
ON_PARSE_COMMAND(Default, CISAPI002Extension,
ITS_PSTR)
ON_PARSE_COMMAND_PARAMS("Input=~")
DEFAULT_PARSE_COMMAND(Default, CISAPI002Extension)
END_PARSE_MAP(CISAPI002Extension)
I can run the dll from a Hyperlink, on the same HTML page,
with no problem at all using HTML as follows:
<p><a href="http://myServer/Scripts2/ISAPI002.dll?Sample
Text">Input</a></p>
But, when I try to run this using the Form to input
the "Sample Text" (or any other text) I get the message
above.
I have produced the dll using the MFC Wizard and have
changed the Parse Map to accept a string variable. This
works using the Hyperlink version but not the Form Input.
Any help would be greatly appreciated.
code dope.
|
|
|
|
|
Further to the first post, I can actually make the page show now by refreshing (F5) when the "Page cannot be displayed" message is shown, although the text I input is not shown. In my Parse Map I have included a default (~) in case the text box is empty when the Submit button is pressed. This is being displayed so my handler function must be working OK.
My Parse Map now looks like this:
BEGIN_PARSE_MAP(CISAPI002Extension, CHttpServer)
ON_PARSE_COMMAND(Default, CISAPI002Extension, ITS_PSTR)
ON_PARSE_COMMAND_PARAMS("Input=~")
ON_PARSE_COMMAND(InputText, CISAPI002Extension, ITS_PSTR)
ON_PARSE_COMMAND_PARAMS("Input=~")
DEFAULT_PARSE_COMMAND(Default, CISAPI002Extension)
END_PARSE_MAP(CISAPI002Extension)
and it is being called with the following HTML:
<FORM ACTION="http://myServer/Scripts2/ISAPI002.dll?InputText?" METHOD="POST" >
<p>Enter Text : <input name="Text" size="12" tabindex="1"></p>
<p><input type="submit" value="Submit" name="B1">
<input type="reset" value="Reset" name="B2"></p>
</FORM>
Any ideas???
code dope.
|
|
|
|
|
How can I change the place of a control (for example textbox) in the page programmicaly?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
If you are using ASP.NET TextBox control then *I believe* you can use its style property (I have not done that, yet).
omkamal
|
|
|
|
|
In web application when you put a control in one place then
you can't change the place or size of it and all of them are fixed?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Mazdak wrote:
you can't change the place or size of it
I dont think so. Just try to create an example like this...
Create an <asp:label id="TestLabel">. Then in your code-behind page you can always do the following...
TestLabel.Style["Top"] = "200px"; //or whatever value you want to use...
This will certainly work. Nonetheless, I am not sure about a TextBox.
omkamal
|
|
|
|
|
Simply add the control to the Controls collection of a different control on the page.
|
|
|
|
|
Andy Smith wrote:
Simply add the control to the Controls collection of a different control on the page.
Sorry could you be more specific?I didn't get it.
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Well, I guess it depends on what you mean by "place of a control".
If you mean moving it a few pixels to the left or right or something, then use the Left and Top properties.
If you want the control to be in a different place in the page structure, then add your control to the Controls collection of a different, container control. A good one to use for this purpose is the PlaceHolder control. It would look something like this:
TextBox myTextBox = new TextBox();
myPlaceHolder.Controls.Add( myTextBox );
|
|
|
|
|
I have a DataGrid in asp.net form,It connected to a database,and I overriden PageIndexChange of it.Each time I click the next,the hieght of grid change but the position of another controls in the form does not change so all controls go into each other position.What property or event
should I use for datagrid to solve this problem?
Mazy
"So,so you think you can tell,
Heaven from Hell,
Blue skies from pain,...
How I wish,how I wish you were here."
Wish You Were Here-Pink Floyd-1975
|
|
|
|
|
Hi everyone. I need to do the following but have been unable. I was wondering if anyone can point me in the right direction.
Something like this in the aspx :
<asp:linkbutton id="bla" runat="server">
<%= getLinkText("bla") %>
or
<asp:linkbutton id="bla" runat="server" text="<%= getLinkText(" bla")="" %="">" />
"getLinkText" is a method define in the codebehind class that returns a string with the text the link should display.
Neither of these work. Is there anyway to make this possible ?
TIA
Marco Cunha
|
|
|
|
|
In the page load event on your code behind couldn't you just say myLinkButton.Text = getLinkText("bla")?
James
Sonork ID: 100.11138 - Hasaki
"Smile your little smile, take some tea with me awhile.
And every day we'll turn another page.
Behind our glass we'll sit and look at our ever-open book,
One brown mouse sitting in a cage."
"One Brown Mouse" from Heavy Horses, Jethro Tull 1978
|
|
|
|
|
I am not 100% sure what you are actually trying to do but here are a few solutions which may help you.
For some odd reason I also cannot define a variable in my Code Behind file and then use it in the aspx, still trying to figure that one out.
But what you can do is use a Label control and set the Label controls Text property to getLinkText("bla"). The Label control just outputs whatever you put in really, does not have any begin or end Tags.
However if you need the getLinkText("bla") result to be the HREF of an A Tag then use the Hyperlink Webform control. Then you can reference it from your Code Behind code easily.
If you fill us in on what you are actually trying to achieve then maybe we can help more 
regards,
Paul Watson
Bluegrass
Cape Town, South Africa
"The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge
Sonork ID: 100.9903 Stormfront
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
