ASP.NET

Re: Rowspan in html table according to the record from DB....

17-Mar-10 2:51

Any sample code or articles plzz????

Thanx & regards,
Tash

Member 450194017-Mar-10 3:01

Member 4501940

17-Mar-10 3:01

Sure.
http://www.cerritos.edu/dmellas/cis103/chap07-mod.pdf[^]

Re: Rowspan in html table according to the record from DB....

<<Tash18>>17-Mar-10 19:32

Re: Rowspan in html table according to the record from DB....

17-Mar-10 19:32

Sorry im not able to cope with the replies posted here... I mean im not able to implement the logic... Im totally hit with it...
Any advice is appreciated...

Thanx in advance,
Tash

Member 450194018-Mar-10 4:39

Member 4501940

18-Mar-10 4:39

Yes, that whole logic thing will get you everytime.

Dim connection As New SqlConnection("server=MyServer;Trusted_Connection=true;database=MyDatabase")
connection.Open()
Dim command As New SqlCommand("select MyKey,MyField1,MyField2 from MyTable order by MyKey;", connection)
Dim reader As SqlDataReader = command.ExecuteReader()

Response.Write("<table border='1'>")
'Read the first record
reader.Read()
'Set the control break
Dim ControlBreak As Integer = CInt(reader(0))
'Write all cells
Response.Write("<tr><td>" & reader(0) & "</td><td>" & reader(1) & "</td><td>" & reader(2) & "</td></tr>")

While reader.Read()
	If reader(0).Equals(ControlBreak) Then
		'Write some cells
		Response.Write("<tr><td colspan='2'>&nbsp;</td><td>" & reader(2) & "</td></tr>")
	Else
		'Reset the control break
		ControlBreak = CInt(reader(0))
		'Write all cells
		Response.Write("<tr><td>" & reader(0) & "</td><td>" & reader(1) & "</td><td>" & reader(2) & "</td></tr>")
	End If
End While
Response.Write("</table>")
reader.Close()
connection.Close()

Re: Rowspan in html table according to the record from DB....

<<Tash18>>19-Mar-10 20:03

Re: Rowspan in html table according to the record from DB....

19-Mar-10 20:03

Thanx for ur reply... but in my code i dont use reader i store it in a dataset.... so working on it.. Any advice is appreciated..

Thanx in advence..
Tash

<<Tash18>>19-Mar-10 21:10

how to give access to pages and for controls in asp.net2.0 with c#

19-Mar-10 21:10

Thanx a lot i found another solution for my issue.... actually i used the following code to solve it...
i used String collection to store the value and checked it and printed the table accordingly

ElseIf page = "UserApplication" Then
            If DS.Tables(0).Rows.Count > 0 Then
                InsertPageBreak()
                InsertAppUserHeader()
                Dim nfile As StringCollection = New StringCollection
                Session("sc1") = nfile
                For i = 0 To DS.Tables(0).Rows.Count - 1
                    PopulateAppUsrRow(DS.Tables(0).Rows(i)(0), DS.Tables(0).Rows(i)(1), DS.Tables(0).Rows(i)(2), DS.Tables(0).Rows(i)(3), DS.Tables(0).Rows(i)(4))
                    'DataSetToExcel.Convert(DS, Response)
                Next

Now the Html table gets populated by the following code:

Public Sub PopulateAppUsrRow(ByVal Usrid As String, ByVal Usrname As String, ByVal Grpid As String, ByVal Grpdsc As String, ByVal FncDsc As String)
        If Not Session("sc1").Contains(Usrid) Then
            Session("sc1").Add(Usrid)
            Response.Write("<tr><td align=left>" + Usrid + "</td><td align=left >" + Usrname + "</td><td align=left >" + Grpid + "</td><td align=left >" + Grpdsc + "</td><td align=left >" + FncDsc + "</td></tr>")
        Else
            Response.Write("<tr><td align=left> </td><td align=left >" + Usrname + "</td><td align=left >" + Grpid + "</td><td align=left >" + Grpdsc + "</td><td align=left >" + FncDsc + "</td></tr>")
        End If
    End Sub

Im happy with this kinda output.. any advice is appreciated...

Thanx in advance...
Tash

developerit17-Mar-10 1:19

Re: how to give access to pages and for controls in asp.net2.0 with c#

17-Mar-10 1:19

hi, iam using asp.net2.0 with c# with sql server

the table fields are as follows

username nvarchar
password nvarchar
emailid nvarchar
usertype int(1=administrator,2=programmer,3=manager,4=user)
active bit

so based on the user types how to give access on each page and on controls like buttons. and for different users different permissions .can you give me example which helps me

Brij17-Mar-10 1:59

Brij

17-Mar-10 1:59

For this, when user login to application ,also retrieve the type of user say administrator etc and save the type of user in session.And on every pageload, you can just check the type of user and accordingly yoy can take decision which buttions/links you need to disabe/hide.
And if user goes direcly to the page which is not for it ,you can show "Access Denied" message.

Cheers!!
Brij

Re: how to give access to pages and for controls in asp.net2.0 with c#

developerit17-Mar-10 21:21

Re: how to give access to pages and for controls in asp.net2.0 with c#

17-Mar-10 21:21

how to give access permission on menu control using asp.net wit c#

give me example which helps me

Abhijit Jana17-Mar-10 23:04

how to save image in database using asp.net with c# and display in image control

17-Mar-10 23:04

I am giving you some samples of Role Based ASP.NET Menu Control.

It may help you.

Creating Menu Based on Role [^]
and

Creating a role based ASP.NET menu[^]

Have a look and try to implement. If any problem let me know !

Cheers !
Abhijit
Codeproject MVP

developerit17-Mar-10 0:15

Re: how to save image in database using asp.net with c# and display in image control

17-Mar-10 0:15

iam using asp.net2.0 with c# with sql serever i want to store the employees details in the database which includes image of employee also so how to retrieve the image from database and display in image control

please give me suitabe solution which helps me

Abhijit Jana17-Mar-10 0:29

Re: how to save image in database using asp.net with c# and display in image control

17-Mar-10 0:29

You can save the image path in database and store the image in physical location. So, when you are retreiving the from database, retreive the image path and then load the corresponding image from physical path.

You can have a look into this article as a ref.
Displaying Image in Gridview from Database[^]

Let me know if you need any help !

Cheers !
Abhijit
Codeproject MVP

m@dhu17-Mar-10 0:32

m@dhu

17-Mar-10 0:32

oh i dint see your post bro...

Re: how to save image in database using asp.net with c# and display in image control

Abhijit Jana17-Mar-10 0:41

Re: how to save image in database using asp.net with c# and display in image control

17-Mar-10 0:41

No Problem ! Thumbs Up | :thumbsup:

Cheers !
Abhijit
Codeproject MVP

m@dhu17-Mar-10 0:30

m@dhu

17-Mar-10 0:30

store file name of image in db. and image in some folder in your application.
retrieving to image control..
image.imageurl="physical path where you hav stored images"...

LogoProject.ImageUrl = "~/test/" + id + "_" + img;
//where img is filename stored in db..

Re: how to save image in database using asp.net with c# and display in image control

R. Giskard Reventlov17-Mar-10 0:31

R. Giskard Reventlov

17-Mar-10 0:31

developerit wrote:
please give me suitabe solution which helps me

Doesn't work like that: what happens is you try to work it out for yourself using the years of experience and knowledege you already have. Then when you are still stuck you come here and say 'This is what I have already tried: can you help me see where I am going wrong?'

In any case, if you googled you'd probably find a thoudand and one ways to do this.

Tychotics

"The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!"
Larry Niven

Re: how to save image in database using asp.net with c# and display in image control

Brij17-Mar-10 0:33

Brij

17-Mar-10 0:33

Also have a look to link SQL Database Image Storage & Easy Thumbnails.
It'll give you better idea.

Cheers!!
Brij

how to clear the fields of controls in asp.net with c#

developerit17-Mar-10 0:03

Re: how to clear the fields of controls in asp.net with c#

17-Mar-10 0:03

iam using asp.net2.0 with c#,in my website iam using
requiredfield validators and ajax controls. if iam entered any incorrect values in textboxes then i want to clear the text boxes then i have return the code for clearing the controls in clear button . but when i click clear button then validation controls and ajax validator calloutextenders is displaying and the textboxes are not clearing. how to solve this situations please give me example which helps me

Neh.C17-Mar-10 0:20

Neh.C

17-Mar-10 0:20

set the

CausesValidation = "false"

property of the clear button.

Re: how to clear the fields of controls in asp.net with c#

developerit17-Mar-10 0:53

17-Mar-10 0:53

thanks it really helps...thanks for codeproject team

sql profiler

ishwarya mahadevan16-Mar-10 23:26

ishwarya mahadevan

16-Mar-10 23:26

can anyone let me know how to use sql profiler 2005???

Brij16-Mar-10 23:44

Brij

16-Mar-10 23:44

Why dont you use google. Click here

Cheers!!
Brij

Abhijit Jana16-Mar-10 23:47

16-Mar-10 23:47

Hi, This is ASP.NET Forum. SQL Profiler has nothing to with ASP.NET. Better place to ask Database related question is General Database Forum.

BTW : You can check this, which I wrote few years back

SQL Server Profiler Step by Step[^]

and here is many more,
How to use SQL Server profiler

Cheers !
Abhijit
Codeproject MVP

ishwarya mahadevan16-Mar-10 23:57

ishwarya mahadevan

16-Mar-10 23:57

i m sorry...i wanted to post in sql but dint notice i was still in asp.net forum...sorry for the inconvenience...and thanks for providing the links...

Abhijit Jana17-Mar-10 0:08