|
Yes. I want the table structure for that?
|
|
|
|
|
Karthick_gc wrote: I want the table structure for that?
this depends exactly on your requirements ....
first think what functionality you want to have in your forum, then go on adding corresponding field to your database (or separate tables !)
Apurv
A man is but the product of his thoughts. What he thinks, he becomes.
.......Mahatma Gandhi
Be the change you want to see in the world.
.......Mahatma Gandhi
|
|
|
|
|
<pre>
<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<script runat="server">
Dim MyReader As SqlDataReader
Dim mySQLConnection As SqlConnection
Dim mySQLCommand As SqlCommand
Dim PID As Integer
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs)
If (TextBox1.Text <> "") Then
Panel1.Visible = True
Panel2.Visible = True
Else
Panel1.Visible = False
Panel2.Visible = False
End If
End Sub
Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click
mySQLConnection = New SqlConnection("server=localhost;AttachDbFilename=C:\Documents and Settings\ANISHA\My Documents\Visual Studio 2005\ROHINI\WindowsApplication1\WindowsApplication1\Database.mdf;Integrated Security=True;User Instance=True")
mySQLCommand = New SqlCommand("SELECT * FROM PATIENT WHERE PID='111'", mySQLConnection)
Try
mySQLConnection.Open()
MyReader = mySQLCommand.ExecuteReader()
If (MyReader.Read()) Then
Panel1.DataBind()
End If
Catch ex As Exception
MsgBox(ex.ToString())
Finally
MyReader.Close()
mySQLConnection.Close()
End Try
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<center>
<table>
<tr>
<td colspan="2">
<asp:Label ID="Label2" runat="server" Height="4px" Text="Patient Details" Width="139px" Font-Bold="True" Font-Size="Larger"></asp:Label></td>
</tr>
<tr>
<td style="width: 114px">
<asp:Label ID="Label1" runat="server" Text="Patient Id"></asp:Label></td>
<td style="width: 100px">
<asp:TextBox ID="TextBox1" runat="server" Height="15px" Width="66px"></asp:TextBox></td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="Button2" runat="server" Text="Display" OnClick="Button2_Click" /></td>
</tr>
<tr><td style="width: 114px"><asp:Panel ID="Panel1" Visible="false" runat="server" Height="176px" Width="185px" HorizontalAlign="Left" BorderColor="Cyan" >
Panel1<br /><br /><br /><br /><br /><br /><br /><br /><br /><br />
<tr><td>
<asp:Label ID="Label3" runat="server" Text="Report Incident" Width="117px"></asp:Label></td>
<tr><td><asp:DropDownList ID="drop1" runat="server" Height="6px" Width="54px">
<asp:ListItem>Yes</asp:ListItem>
<asp:ListItem>No</asp:ListItem>
</asp:DropDownList></td><br /><br /><br />
<center>
<asp:Button ID="Button1" runat="server" Text="Enter to Report" PostBackUrl="~/Rep Entry Screen.aspx" OnClick="Button1_Click" /> </center>
</asp:Panel>
</td>
<td style="width: 100px">
<asp:Panel ID="Panel2" Visible="false" runat="server" Height="176px" Width="185px" HorizontalAlign="Left" BorderColor="Cyan" >
<center>
Displayed Report Entry Scren</center><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><center>
</center></asp:Panel>
</td>
</tr>
</table>
</center>
</asp:Content>
</pre>
Thanx,
KOUNDINYA
|
|
|
|
|
Hi i just give u a logic .
Bind Dataset ds or DataReader dr with Query ... select * from tablename where pid =@pid
for dataset use
if(ds.Teables[0].Rows.Count>0)
{
Panel1.DataBind()
}
else
{
"NOthing"
}
for datareader use
while(dr.read())
{
if(dr.HasRows())
{
Panel1.DataBind()
}
else
{
"NOthing"
}
}
Try This May Be This Help .
|
|
|
|
|
i think i did use the same logic... haven`t i??
Thanx,
KOUNDINYA
|
|
|
|
|
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
var change = false;
function showmsg(id) {
var res = confirm("proceed");
if (res)
change = true;
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Label runat="server" ID="lbl" />
<asp:TextBox ID="TextBox1" runat="server" onblur = "showmsg(this.id)" ></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="Button"
OnClientClick = "return change;change=false;" onclick="Button1_Click" />
</div>
</form>
</body>
</html>
.cs
public partial class blurtest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
lbl.Text = "test msg";
}
}
How can i set the label text here.
|
|
|
|
|
Hi expertzzz
i am working with a searching tool...i am using google API for finding the location ..
that latitute and longitude along with company address i am keeping in database...
i want to list some of nearest companies with my selected location..
eg: i selected a location "Grand Rapids"..from there i want to list the nearest location with in the specified kilometer range(eg:100 KM).
Regards
Rajeesh MP
|
|
|
|
|
Hi all,
I don`t know whether it`s the right forum to ask this question, i had some problems using the crystal reports.
Well the first problem is the crystal report that comes bundled with VS 2005 doesn`t support newline characters set through code behind. So to solve the issue you have to add the stored proc in the field explorer and drag in the field to report and tick the check box in field format to "can grow".
But then the proc has an input parameter which it receives from the querystring. I tried doing
rpt.SetParameterValue("@param1", Request("Trans_no").ToString)
but it always asks for this parameter before loading the report. Instead it should take it from the query string.
Does any one know how do i achieve this...
|
|
|
|
|
Solution found...
Just use in the foll code in your page load event
<br />
Dim paramField As New ParameterField()<br />
Dim paramFields As New ParameterFields()<br />
Dim paramDiscreteValue As New ParameterDiscreteValue()<br />
paramField.Name = "@param1"<br />
paramDiscreteValue.Value = Request("Trans_no").ToString<br />
paramField.CurrentValues.Add(paramDiscreteValue)<br />
paramFields.Add(paramField)<br />
CrystalReportViewer1.ParameterFieldInfo = paramFields<br />
|
|
|
|
|
Hi All,
I was trying to find out a correct regular expression to match 0 < i < 1 with no luck. It will be very helpful to me if you can provide me some help on wrtiting a regular expression to validate any values between in 0 and 1.
Thanks and Regards
Pani
|
|
|
|
|
|
You can use an online regular expression generator to validate your fields. This one is explains how to construct one-
http://gskinner.com/RegExr/[^][^]
Good luck!
Ranjit Viswakumar
Professional Services Specialist
HostMySite.com[^]
|
|
|
|
|
Hi,
I have a problem with binding data to dropdownlist from database in alphabetical order.
My database contains some fields like All,Air,Airline,Books,Cars etc.
There are 2 dropdown lists one dropdown contains A to Z list like A,B,C,D..Z.
2nd list contains above items like All,Air,Books.Now I want that when I select A from A-Z list it will display A items in alphabetical order and the Top item should be "All" after that remaining items.But if I display items in alphabetical order All is displaying like Air,Airline,All.Can anybody help me to resolve the problem.
Thanks in advance
Pavani
|
|
|
|
|
So you can't sort alphabetically, you have to provide your data sorted in the order you want.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
U have to use "Order by" clasue. Each and every change event of your drop down list, you have to change your query to bind data.....
Balasubramanian K.
|
|
|
|
|
Thanks for your response.
I already used order by clause to display in alphabetical order.Then it looks like Air,Airline,All.When we select alphabets A-Z i want to display first All and after that remaining items.Eg if i select A it will display All,Air,Airline if i select B it will display All,Books,Bank etc.All should be at top position.
|
|
|
|
|
I think that it is not possible if 'All' is in your database. I think that even you cant use "union all" also. Bind data by excluding 'All' and add it. Before adding add 'All' in to your drop down list directly as first index. I think it is possible. Try it.
Balasubramanian K.
|
|
|
|
|
Thanks for your suggestion.I tried with that I have so many dropdowns like that and I already saved All in database. Now i need to change for all pages.I will follow your suggestion first i will remove binded "All" from dropdown and i will insert at top position.Thank you.
|
|
|
|
|
HI , in first dropdownlist1 you Bind All Allphabates . in selection of First Dropdownlist you have to Bind Second Dropdownlist with query ;
it may be like this . select * from tablename where fieldname like 'dropdownlist1.selectedtext.text%'
Try This may be its help .
|
|
|
|
|
user.aspx.cs:
public partial class user : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
Label1.Text = Session["val"].ToString();
}
}
login.aspx.cs:
if (reader["pword"].ToString() == pswd.ToString())
{
Session["val"] = TXtLoginName.Text;
Response.Redirect("User.aspx");
}
Still "Object reference not set to an instance of an object" error occurs  sir.
can u please help me?
|
|
|
|
|
Well, your code really sucks. You should not hard code session keys, you also should never check the session without first making sure the value is not null.
You should step through in the debugger to try to work out if you are setting the session value, and why it's null on the other end.
you should also not write code that returns the correct password, that's not secure.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi All,
I want to write in C#, a SOAP client over an SSL connection to a server which supports SOAP requests and gives back SOAP responses.
The way i am currently doing it is
1) I use a open source .NET SSL library to connect to the server.
2) I manually create SOAP requests(in the form of strings stored as resource and in XML files) and send these request over the connection created in 1.
3) I get back the response over the SSL connection and then parse it to get the response.
Now my question is, Can i a use .NET framework class library which provides all these features, so that i can just create a SOAP web service client(which would work over SSL) and then use these .NET web service classes to actually get my work done.
Any help or direction would be really appreciated.
.Net Programmer
(RedDiamond)
|
|
|
|
|
Why not just create a webservice, which will create SOAP for you ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
|
Try explaining yourself in your post, not in your header. As far as I can see, you have written *no* code to do what you want. I see no database code here. So, perhaps if you have no idea where to start, you should buy a book, work through it, try to write some code, and ask us if you get stuck AFTER trying to do your own work ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
