Recent content by satchi

Thanks for the replies. I know a little more about how connections between Access and my MS*SQLserver works.

Thanks for the replies.

Hi, I'm relatively new to VBA but know basic SQL, VB, etc. I have a remote MS SQL server 2000 database that I want to connect to via Access (2000). My question is, how would I go about to setting up a connection to the SQLserver database, and then copy the table onto an Access table? I know I...

Hi, I was wondering if it's possible to rename a field in Access using SQL statements? I'm using access databases and would like to rename a field of a table remotely. Thanks

Hi, I have a question regarding switching themes in a webpage. Is it possible to change the styles of a webpage w/ the use of only CSS and Javascript? For example I notice some websites have 2 icons on the top corner, and by selecting a certain one, the whole page design changes (but layout...

Hi, I have this sql server db where I want to update, create new records, and delete records from a DetailsView, without the use of asp's datasource controls. I have been reading that I need to manually write code to do these in the DetailsView1_ItemInserting, _ItemUpdating, _ItemDeleting, and...

Ok, I've done a little more digging on the issue and it seems to be related to the SqlDataAdapter's capability to doing updates on the database? Basically I was following this article below: http://www.codeproject.com/cs/database/sqldawithoutsqlcb.asp#__comments ..to try doing...

Hi, thanks for the replies. The <div align="center"> works nicely! Thanks. I have been reading about using div to do layouts other than table. I'll have to check on that later as I'm currently learning ASP extensively :) . Thanks again

Hi, I am having some trouble doing the usual insert, update, delete on my sql database. I have a Master/Details setting where the selected GridView item is shown on a DetailsView. When I select an item in GridView, that item shows up on my DetailsView. The Insert, Edit, and Delete command links...

Hi, this sounds somewhat trivial but I can't seem to get it right. I have a page that is created via Master/Content pages. There are three tables: header, content, and footer. I want to center the whole page in the center of the screen, but leave the text/pics/etc in the content page...

Ah this works great. Thanks!

Hi, I'm having some trouble understanding how to connect a parameter gathered from a dropdownlist web control value and use it to query up w/ a datalist(sql db). Basically I have a drop down list that is filled with CategoryIDs w/ integer type (eg. cid = 1, 2, 3 in database). I then choose a...

Hi, I have a question regarding this solution posted by a fellow poster DotNetGnat on these forums. http://www.dotnetjohn.com/articles.aspx?articleid=48 This seems like a great solution to accessing paging in datalists and it works, but it seems each time you look at another page, the...

Thanks for the post jbenson001. Initially I had a short and long description field but I wanted to combine them thus using the long description field as a short one but simply cutting some text off. I was doing some research on the ItemDatabound event, but I'm still learning asp.net (2.0) so I...

Hi, I'm working w/ ASP.net 2.0 and I have a datalist with this element within the <ItemTemplate> tag: <asp:Label ID="descLabel" runat="server" Text='<%# Eval("desc", "{0}") %>' /> This element basically displays the description text. Is there a simple way to truncate this text file to show...