linking a sql field to point to the value of another sql field
is it possible to create hyperlinks in powerbuilder such
that if you retrieve two fields from a database.. and want
to display the first field on the screen and have it link to
the value of the other field (when clicked) which is
actually a URL address, you can?
any help will be appreciated. thank you!
...How to save a picture in a SQL image field and how to show a picture from a SQL image field
I am searching now a real long time in the forum and I found a lot of stuff to this topic. But please help me it doesn't work!
On my webapplication there is a possibility to save a private picture.If a new user is saved in the database I want to save a fixed picture as startpicture.Dim picturePath As String = Request.ServerVariables("APPL_PHYSICAL_PATH") & "img\anonymous.jpg"
Please tell me the way how to save this anonymous.jpg from the picturePath into the database and after that how to display the picture.
...UserID field in SQL Express won't match to SQL 2000 field
Hi - I am using .net2, with Sql Express for the Users/Membership etc, and a SQL 2000 database for my actual web application.I want to associate my user in the aspnet_Users table of the SQL Express database, with records from the SQL 2000 database.In SQL Express the datatype for the UserID field is uniqueidentifier, length 16. In SQL 2000 therefore, I added a table, with a column name of UserID as uniqueidentifier, length 16.When I try to insert the UserID from SQL Express into the UserID field of the SQL 2000 table, I get the error: Guid should containt 32 digits with 4 dashes (xxxxxxx...description field vs. comment field
I am upgrading several PDMs from powerdesigner6.0 to powerdesigner 8.0. In
6.0, we put table description in the "descripton" tab. That seemed to be
the only place to put it.
However, since we upgrade to PD8.0, there is a "comment" field on the
general tab and a "descripton" section under the "notes" tab.
While importing the data model, all the table descriptions in the old
"description" tab was put into the "description" section under the "notes"
This seems very innocent, but when I tried to sear...How to call or retrieve fields from sql and display in table without using ADO.net, I'm using a dynamic link library....Is the coding different?
Help me! I'm doing my school project on Software Change Management Tool, CR Tracker. I want to display table in the webform, and the table data is retrieve form the sql server. So how do I call the sql so as to display the data in a table?
hy..What does that dll contain ?Does it already contains relevant code to connect to a database ?
Have a look hereThanksDinuj Nath
The easy way to do this is with the use of a data bound grid. The Grid can be customised to look and feel you like. You will need to add a data adapter to your page and a grid. When you setup the data adapter you will nee...How to retrieve Unit field from SQL ?
Hello,while making a custom module I saw that the Users' Unit field is stored in the 'PropertyValuesString' in aspnet_Profile table. Any idea about getting the Unit value knowing the UserID, in a SQL view or Stored Procedure?Sorry I know that the field has been moved from original Users table for long time, just I didn't need to develop custom module for 3.1 until now! :)Probably this have been discussed already in some other post, but my search in the forum didn't bring much joy...Thanks,DaveDotNetNuke.it - Comunità Italiana DNNRole: Development Manager
http://forums.asp.net/874189/S...retrieve a field/row from sql
I am currently doing a project using web developer with sql server. I have created some tables which contain of my data and trying to retrieve it but i couldn't get it done.
there's a text box,when i key in a word, i want it to retrieve the data from the sql database and list out all other data in other colummns/rows which match this the word that i have key in(one of the column). How can i make it?
If ihave connected to the sql database using the wizard(connection string & tableadapter,do i still need to write my vb code thr?)
I have spents few days on the database p...How to define Comment fields with SQL
Using SQL Central I can define a comment as part of a column property.
How do I do it using either SQL or ODBC?
E-mail from: Steve Garland,Hyper Logic Resource Group http://netnow.micron.net/~sgarland
CAD Text Magician-CTM32 (Condoc Management), Paradox Infirmary & Resort (fix paradox files and more!)
Delphi Visual CADD (tm)Component (HVCADD)- View and Manipulate AutoCAD (c) DWG Files
See the COMMENT statement for adding comments programmatically.
Jim Egan [TeamPS]
Dealer Solutions, LLC
...How to define field attribute for a numeric field in SQL table?
I need create a field to store tax rate. I need only 2 decimal points. I defined the field as decimal, precision=5 and scale=2. Does it mean that it can hold value from 0.00 to 999.99?
Actually, it should be able to hold from -999.99 through 999.99.
TerriTerri MortonEngagement Manager, NeudesicHow to ask a question
True... here comes my really problem. My aspx form always does rounding for me while I update the table. If I enter 0.7 it will become 0 in the table. If I enter 2.7 it will become 3 in the table. What is the trick?
You'll have to show us your code surrounding th...Retrieving field names through SQL query
could you please tell me if there is the way I can retrieve the names of
the fields of some table with the SQL query. It is supposed that I know the
name of the table. TIA.
"Maxim V. Dolgov" <email@example.com> wrote in message
> Hi all!
> could you please tell me if there is the way I can retrieve the names
> the fields of some table with the SQL query. It is supposed that I know
> name of the table. TIA.
select name from syscolumns
whe...Retrieving file from SQL Image field
I'm trying to extract a file from SQL. The following sample works, but not with Option Strict = true
Dim con As New SqlConnection _
Dim da As New SqlDataAdapter _
("Select * From tblBLOB WHERE ID = 2", con)
Dim MyCB As SqlCommandBuilder = New SqlCommandBuilder(da)
Dim ds As New DataSet
Dim myRow As DataRow
myRow = ds.Tables("MyImages").Rows(0)
Dim MyData() As Byte
MyData = myRow(&...Databinding form fields to a SQL datasource
I have a form and a sqldatasource that will have 1 item. I want to populate the textboxes and dropdownlists from the sqldatasource so that I do not have to check for null, can use 2 way databinding, and compareallvalues. How would I go about doing this?
sorry if this is a duplicate post, I posted 3 hours ago and it did not appear...
Not very clear your purpose. What do you mean by "compare all values"?
The 2- way binding to the textbox and dropdlownlists is:
<ItemTemplate> <asp:DropDownList id="ddl" SelectedValue='<% # Bind("xxx")%>' runa...Sql fields.
What is the command to see how many lines were returned with a Select statement?
@@ROWCOUNT***********************Dinakar NethiLife is short. Enjoy it.***********************...retrieve one field from sql table
hello , my application has uploading ability , in the sql am giving each uploaded file automatically an id , a primary key incremented by 1 , how can i have the Id of the uploaded file immediately when it's uploaded ?!?
Refer solution links:
http://msdn.microsoft.com/en-us/library/aa259185.aspxSSNPlease remember to click "Mark as Answer" on the post that helps you.
I read the links you gave me , I understood a bit but was kind l...