|
When you take data from the database you vil have to replace linefeeds with a html br-tag.
c#:
string Text = TextFromDatabase.Replce("\n", "<br />");
Response.Write(Text);
vb.net:
Dim Text As String = TextFromDatabase.Replace(VbCrLf, "<br />")
Response.Write(Text)
-- modified at 15:19 Monday 15th January, 2007
---------------
http://serverside.no
|
|
|
|
|
Hi All,
I am using GridView to display the Data.My problem is that I get the values from DB as ID,Name,Rights(eg:AXXVP;where A-ADD,X-Not allowed,V-View,P-Print).Now I have to put rights in diferent columns named Add Modify delete View and Print,these columns are checkbox and it is checked or unchecked depending upon values Rights column from DB.
Eg:Suppose I get row from DB as 1 User AXXVP
then Gridview will have
ID Name Add Modify Delete View Print
1 User checked unchecked unchecked checked checked
Since X denoted Unchecked.
Please Help.Thanks in Advance...
|
|
|
|
|
Hi,
Try this,
Call procedure CheckBoxListValues() on CheckBoxList's OnDataBinding event to show check/uncheck checkbox
Your aspx code....
<aspatagrid id="dg" runat="server" AutoGenerateColumns="False">
<COLUMNS>
<asp:templatecolumn HeaderText="Behörighet">
<ITEMTEMPLATE>
<asp:checkboxlist id="Checkboxlist2" runat="server" Width="544px" DataTextField="Name" DataValueField="ValueField"
RepeatDirection="Vertical" OnDataBinding="CheckBoxListValues">
<asp:ListItem Value="Add" Selected="True">Add</asp:ListItem>
<asp:ListItem Value="Modify">Modify</asp:ListItem>
<asp:ListItem Value="Delete">Delete</asp:ListItem>
<asp:ListItem Value="View">View</asp:ListItem>
<asp:ListItem Value="Print">Print</asp:ListItem>
</asp:checkboxlist>
</ITEMTEMPLATE>
</asp:templatecolumn>
</COLUMNS>
/aspatagrid>
and code behind code is ....
Public Sub CheckBoxListValues(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Checkboxlist2.DataBinding
Dim i As Integer
Dim str As String = "AXXVP" 'Pass value from Database
For i = 0 To Checkboxlist2.Items.Count - 1
Select Case i
Case 0 ' Add
If str.Substring(i, 1) = "A" Then
Checkboxlist2.Items(i).Selected = True
Else
Checkboxlist2.Items(i).Selected = False
End If
Case 1 'Modify
If str.Substring(i, 1) = "M" Then
Checkboxlist2.Items(i).Selected = True
Else
Checkboxlist2.Items(i).Selected = False
End If
Case 2 ' Delete
If str.Substring(i, 1) = "D" Then
Checkboxlist2.Items(i).Selected = True
Else
Checkboxlist2.Items(i).Selected = False
End If
Case 3 'View
If str.Substring(i, 1) = "V" Then
Checkboxlist2.Items(i).Selected = True
Else
Checkboxlist2.Items(i).Selected = False
End If
Case 4 ' Print
If str.Substring(i, 1) = "P" Then
Checkboxlist2.Items(i).Selected = True
Else
Checkboxlist2.Items(i).Selected = False
End If
End Select
Next
End Sub
Hope this will help..
Trishul
|
|
|
|
|
Thanks for the reply.I got how to do this.Now I need to save the Gridview Values on Save Button Click.
Thanks in Advance...
|
|
|
|
|
Hi,
I have an application used by customers for sending in warranty-claims.
This is solved by a wizard in 8 steps. On the final step I need to write all the data to a database so our warranty-administration application can process the information.
The problem is when the customer is clicking the Finish-button and then clicks it again.
It seems as if the Finishbuttonclick-method doesn't have time to really finish and begins again which results in more than one entry in the administration application.
I need to find a way to disable the Finish-button when the users clicks on it so I have time to finish my db operations.
How do I begin to solve this? I need some sort of script but how do I access the Finishbutton so I can disable it?
Very thankful for any help or suggestions!
/Dennis
|
|
|
|
|
Disable it by client side javascript function or by server side function
Best Regards
3ala2 
|
|
|
|
|
Thank you for your reply.
I realise that this is the way to do it but how do I access the finishbutton so I can disable it?
Best regards
Dennis
|
|
|
|
|
i'm not sure
but this should be put in the finish event someting like
<br />
Dim btn as button = Page.FindControl("FinishButtonId")<br />
btn.Enabled = False<br />
Hope this would help
Best Regards
3ala2
|
|
|
|
|
Hi,
I've done this code in c# in asp.net 1.x. same thing i want to do in asp.net 2.0 in vb.net.
im getting an error in vb.net .
dsGrd = (dsGrd) Session["GridDataSet"];
how do i type cast the same to vb.net.my code in vb was,
dsorders = CType(Session("GridDataSet"), dsorders) and error was the bolded dsorders type was not defined.can somebody help me.
Regards,
Tasnim.
|
|
|
|
|
Do you have a strongly typed dsorders dataset in your project?
|
|
|
|
|
yes i do.dsorders is an xsd schema.
|
|
|
|
|
if my website have 100 pages and i want that 25 aspx pages be displayed when he is logged in.How can i achieve this with web.config file?
Mohinder Singh
|
|
|
|
|
I'm not sure if I understand what your problem is....
---------------
http://serverside.no
|
|
|
|
|
Hi,
I have created a new virtual directory and my validation controls are not working. My virtual directory is H:\ABC and My project lies in H:\ABC\MyProject.
Where i have to add WebUIValidation.JS File. I tried putting in ABC folder as well as MyProject But still not working. Do i have to configure anything. My IIS has a separate site for this virtual directly. This does not lie in Default web site. Pleaes help me out.
Ramya
|
|
|
|
|
I would like to put ASP software on my server, but I have heard that it has security issues. is this true
|
|
|
|
|
What ASP software do you mean? Do you mean the IIS web server that supports ASP, or some application developed using ASP?
What kind of security issues are you talking about?
---
Year happy = new Year(2007);
|
|
|
|
|
IIS web server that supports ASP
|
|
|
|
|
You've 'heard' it has security issues ? Wow.
IIS without any patches on a machine with no firewall is probably not secure. Do you mean ASP, or ASP.NET ? Either way, doesn't matter too much, what is it you want to install, and why ? What security issues are you worried about ?
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Plain vanilla ASP on IIS 4.0 did have security threats from CodeRed and NIMDA. However, subsequent ServicePacks and patches from Microsoft have filled the gap sufficiently.
It is upto the web administrator to suitably firewall the webserver and apply enough judicious security precautions.
|
|
|
|
|
Hi guys,
I have a database in SQL Server and I wanted to create a web interface in C#. I have 3 Listbox controls and a Textbox and two buttons for this. What I want to do is to select values from 3 Listbox controls and input some text in the textbox i.e year to display information on another page including all the information from listboxes too. I have no idea how to program this part. I have populated the 3 Listboxes from the database tables and I want to select some values from these listboxes and display information on another page. Could somebody help me in this regard. Below is the code I developed so far.
protected void Page_Load(object sender, EventArgs e)
{
// create the connection string and command string
string connectionString = "Server=.\\SQLEXPRESS;Database=NorthWind;Integrated Security=SSPI;";
string commandString = "Select * from Customers";
string commandString1 = "Select * from Orders";
string commandString2 = "Select * from Employees";
//pass the strings to the sql data adapter constructor
SqlDataAdapter dataAdapter = new SqlDataAdapter(commandString, connectionString);
SqlDataAdapter dataAdapter1 = new SqlDataAdapter(commandString1, connectionString);
SqlDataAdapter dataAdapter2 = new SqlDataAdapter(commandString2, connectionString);
SqlDataAdapter dataAdapter3 = new SqlDataAdapter(commandString2, connectionString);
// create a data set
DataSet dataSet = new DataSet();
// fill the dataset object
dataAdapter.Fill(dataSet, "Customers");
dataAdapter1.Fill(dataSet, "Orders");
dataAdapter2.Fill(dataSet, "Employees");
dataAdapter3.Fill(dataSet, "Products");
// for loop for customer table
foreach (DataRow dtrow in dataSet.Tables["Customers"].Rows)
{
ListBoxCustomers.Items.Add(dtrow["CustomerID"].ToString());
ListBoxCustomers.Items.Add(dtrow["City"].ToString());
ListBoxCustomers.Items.Add(dtrow["CompanyName"].ToString());
ListBoxCustomers.Items.Add(dtrow["ContactName"].ToString());
}
// for loop for Employees table
foreach (DataRow dtrow in dataSet.Tables["Employees"].Rows)
{
ListBoxEmployees.Items.Add(dtrow["EmployeeID"].ToString());
ListBoxEmployees.Items.Add(dtrow["LastName"].ToString());
ListBoxEmployees.Items.Add(dtrow["FirstName"].ToString());
}
// for loop for order table
foreach (DataRow dtrow in dataSet.Tables["Orders"].Rows)
{
ListBoxOrders.Items.Add(dtrow["OrderID"].ToString());
ListBoxOrders.Items.Add(dtrow["CustomerID"].ToString());
ListBoxOrders.Items.Add(dtrow["EmployeeID"].ToString());
}
And here is the Event Handler which I want to select values from the listboxes and a textbox and redirect the user to display relevant information on another page. Unfortunately I don't know how to code this part.
protected void BtnSubmit_Click(object sender, EventArgs e)
{
Response.Redirect("Default2.aspx"); // another page to display
}
I appreciate your help.
Koonda
|
|
|
|
|
This is the wrong way to do it. Use a datagrid or a grid view, and assign your datatable as a datasource to the control, then call databind. It will do this iterating for you.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Thanks Christian Graus,
I just wanted to develop it in a programming way, but anyways the GridView is also a good idea so I will go ahead and use GridView.
Thanks
Koonda
|
|
|
|
|
koonda007 wrote:
I just wanted to develop it in a programming way,
You should always try to do stuff the *right* way, which usually means, the easiest way.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
|
Hi, how can i open a new window (not same window!!) from an ImageButton using asp.net??
Adrian De Battista: .Net Programmer, Java Programmer and Web Designer.
|
|
|
|
|
target="_blank" in the button attributes. ASP.NET will ignore it, as it's not a server tag, and it will be passed through as is.
Christian Graus - C++ MVP
'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
