ASP.NET

Re: How to Retrieve the Structure of DataBase

20-Nov-07 21:04

SQL ~

Execute this T-SQL to get the columns of your table..

SELECT column_name  FROM information_schema.columns<br />
WHERE table_name = @table_name<br />
AND table_schema = @owner_name<br />
ORDER BY ordinal_position

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

"Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."

John-ph20-Nov-07 21:13

20-Nov-07 21:13

there are few system stored procs that returns the inforamtion about the database objects. take a look at those.

sp_databases <br />
sp_tables <br />
sp_columns

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

AutoComplete TextBox

kirthikirthi20-Nov-07 20:05

kirthikirthi

20-Nov-07 20:05

HI all

I am trying to create a autocomplete textbox i used this code

The code in c# it is working fine but when i convert to VB it is giving error . Smile | :)

on page load()

" acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)"

can any one tell me what i am missing in the code.

MY CODE

--------------
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))

acSearch.PageType = Me.[GetType]().BaseType

acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)

End Sub

<ajaxpro.ajaxmethod()> _

Public Function GetSearchData(ByVal s As String) As System.Data.DataTable
Dim conn As New SqlConnection("server=DSS1;uid=sa;pwd=sa;database=Northwind")
Dim cmd As New SqlCommand("SELECT FirstName FROM Employees WHERE FirstName LIKE @FirstName + '%'", conn)
cmd.Parameters.Add("@FirstName", s)

Dim da As New SqlDataAdapter
Dim ds As New DataSet

da.SelectCommand = cmd
da.Fill(ds, "Employee")

Return ds.Tables("Employee")
End Function

-----------------

Keerthi

Michael Sync20-Nov-07 20:10

20-Nov-07 20:10

What error are you getting?

kirthikirthi20-Nov-07 20:34

kirthikirthi

20-Nov-07 20:34

Thx For reply

The Error is

C:\Inetpub\wwwroot\20-3-2006\TextBoxAutoCompletion\WebForm1.aspx.vb(31): 'WebCustomControl.Lab.Autocomplete.AutoCompleteHandler' is a delegate type. Delegate construction permits only a single AddressOf expression as an argument list. Often an AddressOf expression can be used instead of a delegate construction.

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
AjaxPro.Utility.RegisterTypeForAjax(GetType(WebForm1))

acSearch.PageType = Me.[GetType]().BaseType

acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)

End Sub

Keerthi

Michael Sync20-Nov-07 20:45

20-Nov-07 20:45

kirthikirthi wrote:
acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(Me.GetSearchData)

acSearch.OnAutoComplete = New Autocomplete.AutoCompleteHandler(AddressOf Me.GetSearchData)

problem with rtf file downloading(plz solve this problem)

kirthikirthi20-Nov-07 21:13

kirthikirthi

20-Nov-07 21:13

Thx Michael Sync

It working

Keerthi

lakshmichawala20-Nov-07 19:48

lakshmichawala

20-Nov-07 19:48

iam using this method for(Response.AppendHeader("content-disposition", _
"attachment; filename=" & name))file downloading ...its working fine with all types file extensions...the problem is that now i installed
DAP download for fast accessing ..now the problem is that when i down load the rtf file using this method it is not getting the rtf file ..instead it is gettind default.aspx file to down load how this problem will be solved

Error Message 401.3

Reddy Prakash20-Nov-07 19:44

Reddy Prakash

20-Nov-07 19:44

Can any one tell me how to solve this problem?

Server Error in '/DataEditor' Application.
--------------------------------------------------------------------------------

Access is denied.
Description: An error occurred while accessing the resources required to serve this request. You might not have permission to view the requested resources.

Error message 401.3: You do not have permission to view this directory or page using the credentials you supplied (access denied due to Access Control Lists). Ask the Web server's administrator to give you access to 'D:\inetpub\wwwroot\DataEditor\Reference.aspx'.

Re: Error Message 401.3

Sun Rays20-Nov-07 21:39

Sun Rays

20-Nov-07 21:39

Hi,
try to give rights to the director named DataEditor..

Thanks,
Sun Rays

Rate this post if you like answer.

My Articles

Images not retriving from Db

Krishna Varadharajan20-Nov-07 19:41

20-Nov-07 19:41

I have given begindcode

while(dr10.Read())
{
Response.Write("<img src=~\"uploads\" width=\"39\" border=\"1\" height=\"40\">");
}

HTML CODE

<asp:TemplateField>
<ItemTemplate>

<asp:Label ID="lbl4" runat="server" Text='<%#DataBinder.Eval(Container.DataItem,"picture") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>

Its not retrieving

krishna

Michael Sync20-Nov-07 19:43

20-Nov-07 19:43

Have you read this one??
http://www.codeproject.com/script/comments/forums.asp?msg=2328302&forumid=12076#xx2328302xx

Don't post new post for the same question! this is not cool.

John-ph20-Nov-07 19:59

20-Nov-07 19:59

Have a look at this One[^], Two[^].

What exactly is the problem?

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Krishna Varadharajan20-Nov-07 21:47

20-Nov-07 21:47

Please understand, i hope u people will help me thats y iam keep sending dont mistake me r to get angry...

The producer wht u had send all storing link to the db, but i have stored a image file name as (9.jpg) no image was there, image was in separate folder having this image file 9.jpg.

In out put its receiving like 9.jpg( no image ), so how to link with that folder to retrieve the image.

Advance Thanx,

krishna

Sun Rays20-Nov-07 21:53

Sun Rays

20-Nov-07 21:53

Hi,
as you have just store image name in your database and your inmage is in another folder of your application.

So, first you have to get image name from database and then you have to concat the string of folder path of that image with file name, then you will get image.

see this below code.
your page is in forms directory and yr image is in images directory.
So now on page.

String path = Server.MapPath("../Images/" + filenameFromDatabase);

So you will get ......../Images/image1.jpg path. Now open the file.

Thanks,
Sun Rays

Rate this post if you like answer.

My Articles

Krishna Varadharajan20-Nov-07 22:25

20-Nov-07 22:25

Which one is this ' filenameFromDatabase' means ?

krishna

N a v a n e e t h20-Nov-07 22:30

N a v a n e e t h

20-Nov-07 22:30

Clickety[^]

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

John-ph20-Nov-07 22:09

20-Nov-07 22:09

ok, all that I understand up till this moment is that you store the File Name in the Database and the Corressponding Images are stored in the folder in the server, right? can you show only the code that you use to set src property of Img?

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Krishna Varadharajan20-Nov-07 22:30

20-Nov-07 22:30

Response.Write("");

krishna

John-ph20-Nov-07 22:45

20-Nov-07 22:45

krishnavaradharajan wrote:
Response.Write("");

sorry, I really don't understand what you are trying to do with the above code.

Here is the tip to solve you problem. If I have to display a Image which lies in a virtual folder in my application then I would write the code as below.

HTML

<-img id="ImgFile" runat="server">

Code-Behind

string FileName = "Pic101.gif"; <br />
ImgFile.Src = "./Images/" + FileName;

Same code will work for you with the ImageName picked from the Database and provided the corressponding Image folder should be available in the given virtual path and Corressponding Image should also availble in the folder.
Try it out.

- Regards -
JON

Life is not measured by the amount of breaths we take, but by the moments that take our breath away.

Krishna Varadharajan20-Nov-07 22:55

20-Nov-07 22:55

Thanx.

krishna

Krishna Varadharajan21-Nov-07 0:41