Re: runtime dropdownlist in grid..., - ASP.NET Discussion Boards

Urs Enzler31-Aug-07 4:28

31-Aug-07 4:28

As a starting point you can take a look at my article about sorting: ASP.NET GridView Sort Indicator Component

To add Add, Update, Delete you can extend this sample, the base concepts with GridView - ObjectDataSource stays the same.

-^-^-^-^-^-
no risk no funk ................... please vote ------>

How to create web application like windows application

PadmaPriya.S31-Aug-07 1:49

PadmaPriya.S

31-Aug-07 1:49

Hi friends

i want to create a web application which should look like windows application.
Plz let me know what shoul i do?

D.Willington

Re: How to create web application like windows application

Urs Enzler31-Aug-07 4:24

Urs Enzler

31-Aug-07 4:24

What do you mean by "look like windows application"?

Because:
- not all types of usercontrols that are possible within a windows forms application are possible on a web application (FileOpen dialog, FileSave dialog, hierarchical GridViews, multicolumn DropDownLists, ...)

- you will always have the browser window as a host window

- HTML is very limiting in layouting compared to a windows forms/WPF application.

Silverlight might though be an alternative in the near future.

-^-^-^-^-^-
no risk no funk ................... please vote ------>

Re: How to create web application like windows application

Vasudevan Deepak Kumar31-Aug-07 7:29

Vasudevan Deepak Kumar

31-Aug-07 7:29

A very rich look is achieved through developing an ActiveX Control and bringing it on the webpage. Otherwise, there is a distinct line of demarcation between the web platform and the windows desktop.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

runtime dropdownlist in grid...,

Member 387988131-Aug-07 1:20

Member 3879881

31-Aug-07 1:20

Hi i am displaying in my grid some datas...,
In that i am using button type column...,
Using that pushbutton i am doing update process on that grid...,
Now my question is:
In that grid click edit button its displaying the datas in textbox...,
And i like to show some dats in dropdown so i given this fformat...,
Its not showing the dropdownbox,itsshowing only textbox...,
Plz whats the probs in this one?,
I have attached my code here:

Private Sub dgrdview_UpdateCommand(ByVal source As System.Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles dgrdview.UpdateCommand
Dim names As System.Web.UI.WebControls.TextBox
names = e.Item.Cells(2).Controls(0)
Dim SkillType As System.Web.UI.WebControls.DropDownList 'mag inserted
SkillType = e.Item.Cells(3).Controls(0)

sqldad = New SqlDataAdapter("SELECT skilltypeid as ids,Skilltype as Name FROM tblmasterSkilltype", sqlconn)
dst = New DataSet
sqldad.Fill(dst, "tblmasterSkilltype")
If dst.Tables(0).Rows.Count > 0 Then
SkillType.DataSource = dst
SkillType.DataTextField = "Name"
SkillType.DataValueField = "IDS"
SkillType.DataBind()
SkillType.Items.Insert(0, "Select One")
Else
SkillType.Items.Insert(0, "Select One")
End If
dst.Dispose()
sqldad.Dispose()

Dim sqlquery As String = "-"
sqlquery = "select count(TempEmpID) from tblMasterTempEmployee where TempEmpID <>" & Val(dgrdview.DataKeys(CInt(e.Item.ItemIndex))) & " and Empname= '" & singletodouble(names.Text) & "' and SkillType='" & Val(SkillType.SelectedItem.Value) & "'"
sqlcmd = New SqlCommand(sqlquery, sqlconn)
sqlcmd.Connection.Open()
If sqlcmd.ExecuteScalar() > 0 Then
lblMessage.Text = "" & singletodouble(names.Text) & " is already exist "
sqlcmd.Connection.Close()
sqlcmd.Dispose()
Exit Sub
End If
sqlcmd.Connection.Close()
sqlcmd.Dispose()

sqlquery = "update tblMasterTempEmployee set EmpName= '" & singletodouble(names.Text) & "', SkillType='" & Val(SkillType.SelectedItem.Value) & "' where TempEmpID=" & dgrdview.DataKeys(CInt(e.Item.ItemIndex))
If sqlquery <> "-" Then
sqlcmd = New SqlCommand(sqlquery, sqlconn)
sqlcmd.Connection.Open()
sqlcmd.ExecuteNonQuery()
lblMessage.Text = "Data has been updated Successfully "
dgrdview.EditItemIndex = -1
sqlcmd.Connection.Close()
sqlcmd.Dispose()
Gridview()
Else

End If
End Sub

Regards,
Magi

Re: runtime dropdownlist in grid...,

VenkataRamana.Gali31-Aug-07 1:36

VenkataRamana.Gali

31-Aug-07 1:36

code is ok.
plz mention u r problem & requirement clearly.

GV Ramana

Re: runtime dropdownlist in grid...,

Member 387988131-Aug-07 1:44

Member 3879881

31-Aug-07 1:44

See in my grid i am displaying datas..,
And i have push button column in that grid...,
In that while click edit button,i am getting my datas in textbox...,
Instead of textbox display i like to show some field datas in dropdowwnlist...,
So i have created one dropdown box in runtime in update command:
Dim SkillType As System.Web.UI.WebControls.DropDownList
And i fill the dats in that...,
But its not showing there...,
Did u got my probs?,

Regards,
Magi

Re: runtime dropdownlist in grid...,

VenkataRamana.Gali31-Aug-07 1:56

VenkataRamana.Gali

31-Aug-07 1:56

check weather column3 type column4 type are same (templatecolumn ) or not. otherwise change the type.

tell me one more thing, when clicking on edit button, u r showing textbox(with data) in 3rd column & dropdownlist(with populated data from Db) in 4th column
is it right?

GV Ramana

Re: runtime dropdownlist in grid...,

Member 387988131-Aug-07 2:01

Member 3879881

31-Aug-07 2:01

See i have totaly 3 columns only...,
All are boundcolumn...,
First (0)th column only push botton...,

ya while click the edit bitton i am showing the datas in textbox...,
no see in that code i have fill the dropdown list box in code time itself only from the db(select query)...,

Regards,
Magi

Re: runtime dropdownlist in grid...,

Imran Khan Pathan31-Aug-07 1:57

Imran Khan Pathan

31-Aug-07 1:57

Dont create DropdownList at runtime

place it in EditItemTemplate instead of TextBox

Find out it on RowDataBound Event of Gridview and bind it with datas

Best regard

Pathan

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

Help regarding creating PDFs

anu8131-Aug-07 1:08

anu81

31-Aug-07 1:08

hi all,

I have a asp.net application where i display data in a datagrid from a datasource with some constraints. i need to convert the datas in the datatable as a pdf.

i want to do this without using any third party components.

Can anybody suggest me a link for implementing the same?

Thanks in advance. Smile | :)

Regards

Anuradha

Re: Help regarding creating PDFs

Vasudevan Deepak Kumar31-Aug-07 7:30

Vasudevan Deepak Kumar

31-Aug-07 7:30

http://lavanyadeepak.blogspot.com/2006/12/quicker-pdf-generation-in-net.html[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

authorization and customErrors

Itay Levin31-Aug-07 0:34

Itay Levin

31-Aug-07 0:34

Hey,

i don't know why, but i posted last night my question, and it seems to be deleted or something, and i have no idea why?

i will try to write it again: hope it won't be deleted....
i have a group of users which i want to be authorized to access my site.
and i want that anyone who is not in that group, will be redirected to a custom error webpage.
the problem is, that when i try to redirect him, it seems that he doesnt has any authorization to access my custom page.

i have 2 Web.Config files:
one for the all website which i set over there:
<authorization>
<allow roles="myWebSiteMembers">
<deny users = "*">
</Authorization>

<customErrors mode = "On" defaultredirect="Login/NoAccess.aspx">
<error statusCode = "401" redirect = "Login/NoAccess.aspx">
</CustomErrors>

and the other web.config i put in the Login folder, along whith the custom error page NoAccess.aspx
and this web.config has a <allow users = "*"> attribute alone.

the problem is that i don't get redirected and i get the default Access denied (asp.Net page) whith status code 401.2 explaning that i don't have access to the site.
also the url doesn't change so i think it means that he doesnt actually try to redirect to the otherpage.

hope you can help me to solve this problem fast,
Thanks alot.
p.s please do not delete this post, if it has errors or things againts the Boards rules,tell me and i will fix it.

Itay Levin

Validations in gridview

anujose30-Aug-07 23:37

anujose

30-Aug-07 23:37

i want to validate a databound column and a template column in a datagridview.Databound colum i am displaying from database and in template colum i am allowing the user to enter a value.when user is entering value in template column i want to check whether the user enterd value is less than or equal to the value of databound column....How can i do this.........

Can anyone can help me...give some samples also........

Anu

Anu

Re: Validations in gridview

VenkataRamana.Gali31-Aug-07 1:13

VenkataRamana.Gali

31-Aug-07 1:13

anu,
In RowDataBound Event write this code

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)<br />
{<br />
 if (e.Row.RowType == DataControlRowType.DataRow)<br />
 {<br />
    int dbValue = (int)e.Row.Cells[0].Text;<br />
    TextBox txtbox =  (TextBox)e.Row.FindControl("TextBox1");<br />
    txtbox.Attributes.Add("onblur", "validateValue('"+ dbValue +"','"+ (int)txtbox.Text  +"');");<br />
 }<br />
}<br />

add this javascript code in head section

function validateValue(dbvalue, enteredValue)<br />
{<br />
   <br />
	if(enteredValue < dbvalue)<br />
	{<br />
	   alert("please enter the value equal or greate of column1 ");<br />
	}<br />
}

hope this will help, as per the ur requirement fire this javascript validation related event.
Smile | :)

regards
GV Ramana

Re: Validations in gridview

anujose31-Aug-07 2:27

anujose

31-Aug-07 2:27

How i can assignto gridview colum what i typed in template colum textbox

AJAX and FileUpload

steve_a_p30-Aug-07 23:18

steve_a_p

30-Aug-07 23:18

How can I perform uploading files to the webserver without refreshing whole page?
AJAX UpdatePanel and standard FileUpload do not work together...

Re: AJAX and FileUpload

qtuan30-Aug-07 23:44

qtuan

30-Aug-07 23:44

you can read this article : http://www.codeproject.com/useritems/simpleajaxupload.asp

Re: AJAX and FileUpload

steve_a_p31-Aug-07 2:17

steve_a_p

31-Aug-07 2:17

I didn't mean that. The question was how to organize asynchronous upload of the file.

Re: AJAX and FileUpload

Vasudevan Deepak Kumar2-Sep-07 1:02

Vasudevan Deepak Kumar

2-Sep-07 1:02

http://www.seemysites.net/projFolder/uploader/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: AJAX and FileUpload

steve_a_p2-Sep-07 23:22

steve_a_p

2-Sep-07 23:22

Have you got any similar information that doesn't need knowledge of PHP?

how we navigatetourl with buttonfield column in gridview

puspendra napit30-Aug-07 23:16

puspendra napit

30-Aug-07 23:16

sir i want navigate on other page when we click buttonfield column in the gridview.
thanks

Re: how we navigatetourl with buttonfield column in gridview

VenkataRamana.Gali31-Aug-07 1:22

VenkataRamana.Gali

31-Aug-07 1:22

write a javascript function & call that method onclick of that button.

common url for all buttons of grid ? or for each button different url ?

regards
GV Ramana

Error: Value of type 'Byte' cannot be converted to '1-dimensional array of Byte'

Milind Panchal30-Aug-07 22:42

Milind Panchal

30-Aug-07 22:42

Hi,

I am Retrieving the binary image from sql database on web page. For that I have written following code in vb.net

Dim stream As MemoryStream = New MemoryStream()

Dim image As Byte()
Dim bitmap As Bitmap
Dim username As String
username = Session("memberuser")
con = New SqlConnection("server=ABC-0A55D6C3C90;database=satphere;uid=sa;pwd=")
Try
con.Open()
cmd = New SqlCommand("select photo from ViewProfile where userid = @userid", con)
cmd.Parameters.AddWithValue("@userid", username)
>>>>>>>>> image = CByte(cmd.ExecuteScalar())
stream.Write(image, 0, image.Length)
bitmap = New Bitmap(stream)
Response.ContentType = "image/gif"
'bitmap.Save(Response.OutputStream, ImageFormat.Gif)
bitmap.Save(Server.MapPath("TempImage/aa.gif"))
Image1.ImageUrl = "TempImage/aa.gif"
Catch ex As Exception
con.Close()
Stream.Close()
End Try

I am getting the error as
Value of type 'Byte' cannot be converted to '1-dimensional array of Byte'

line is mentioned by >>>>>>

C#.net code for same is working fine--------------as follwos

MemoryStream stream = new MemoryStream ();
SqlConnection connection = new SqlConnection(@"server=ABC-0A55D6C3C90;database=Test;uid=sa;pwd=");
try
{
connection.Open ();
SqlCommand command = new SqlCommand("select Picture from Image", connection);

byte[] image = (byte[])command.ExecuteScalar();
stream.Write(image, 0, image.Length);

Bitmap bitmap = new Bitmap(stream);

Response.ContentType = "image/gif";

bitmap.Save(Response.OutputStream, ImageFormat.Gif);
//bitmap.Save(Server.MapPath("TempImage/aa.gif"));

}
finally
{
connection.Close ();
stream.Close ();
}

can any one give me solution for this

Thanks to all

Re: Error: Value of type 'Byte' cannot be converted to '1-dimensional array of Byte'

Imran Khan Pathan30-Aug-07 23:15

Imran Khan Pathan

30-Aug-07 23:15

try this code

image = CType(cmd.ExecuteScalar(),Byte())

Best Regard
Pathan

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.