|
I am not getting what is the problem you are facing when binding the data ? Please be more specific to your problem
|
|
|
|
|
in my raing forum i took a button rate when ever i clicked on that... this z the following code in that...
if (Page.IsPostBack)
{
string x;
x = rbtnRating.SelectedItem.ToString();
if (x != "")
{
switch (x)
{
case "Excellent":
strRate = "5";
break;
case "Good":
strRate = "4";
break;
case "Average":
strRate = "3";
break;
case "Bad":
strRate = "2";
break;
case "Terrible":
strRate = "1";
break;
}
btnRate.Enabled = false;
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["KMSConnectionString"]);
con.Open();
string str = "insert into Rating(Rate,Authorname,Replies,QId) values('" + strRate + "','" + btnName.Text + "','" + lblReply.Text + "' ,'" + btnSno.Text + "' )";
//string strT="count
SqlCommand cmd = new SqlCommand(str, con);
DataSet ds = new DataSet();
cmd.ExecuteNonQuery();
con.Close();
now the problem is how can i retrive the data to label like is the user gets 5 points i want to calculate the total replies rated.....how to bind this to my label.
harika
|
|
|
|
|
Normal rating will be calculated for a message will be like taking the average of score. So you need to calculate the average with total users rated and score. Then show this to label. To make the calculations more easier, use stored procedures. If you are using a normal query, you need to get the results into some datatable and then do the calculations. Stored procedures allows you to do all these calculations inside it.
|
|
|
|
|
hi,
I want to generate <TD>'s at runtime depending upon the records returned by a stored procedure.I am creating layers using <Div> tags in my aspx page.How do i do it?
My code is as below:
<!-- DROP DOWN MENU --><a name="2"></a>
<script language="JavaScript" type="text/javascript">
document.write("<div id=\"menu2\" style=\"filter:revealTrans(duration=.5, transition=3) progid:DXImageTransform.Microsoft.Shadow(direction=135, color=#AAAAAA, strength=5);\" onmouseout=\"killMenu('menu2')\" onmouseover=\"checkMenu();\">");
document.write("<layer name=\"menu2\" onmouseout=\"killMenu('menu2')\" onmouseover=\"checkMenu();\">");
</script>
<TABLE cellSpacing="0" cellPadding="0" width="150" border="0">
<tr>
<td vAlign="top"><A class="menulink1" href="javascript:ViewSettings();">User Settings </A>
<A class="menulink1" href="javascript:ViewSignature();">Signature </A><A class="menulink1" href="javascript:ViewDistributionList();">
Define Distribution List </A><A class="menulink1" href="javascript:ViewFolderManager();">
Folder Manager </A>
</td>
</tr>
</TABLE>
<script language="JavaScript" type="text/javascript">document.write("<\/layer><\/div>");</script>
<!-- END DROP DOWN MENU -->
Here <A class="menulink1" href="">Record1 </A> will be generated depending on the number of records fetched from the database.
For e.g. If 5 records are returned then 5 <A href ></A> tags shld be generated.
plz let me knw how to do it?
Thanks,
Riz
|
|
|
|
|
|
Hi frndz,
How are you all???
I am using MSasp.net 1.0 .I would like to know ,how we can send SMS to a mobile phone from my application??
I think some service access like... needs from connection providers and wat about the programming side??
any help is appreciatable....
Thank you
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
You could get some webservice from the mobile service providers. Use that to send SMS.
|
|
|
|
|
Hi,
I have a datatable called dtEmployeeData. In the datatable the Employee's name can sometimes be in there more then once(I get this data from a sql database). Now I can't change my select query, to bring back the employee name only once, as the his name is allowed to be in the gridview more then once(due to transaction history).
What I want to do now is, is to select only the name from that datatable, and only show his name once in a dropdownlist. I use this dropdownlist to show all the employee names, and the name must only appear once. How would I do this?
Here is my code I have so far:
<br />
Dim dtEmployeeData As DataTable = New DataTable()<br />
dtEmployeeData = BO.getData()<br />
<br />
drpSort.DataValueField = "EmployeeName"<br />
drpSort.DataTextField = "EmployeeName"<br />
<br />
drpSort.DataSource = dtEmployeeData<br />
Using this code, I get:
Abraham
Bennie
John
John
John
Peter
Stewart
I want to have the following:
Abraham
Bennie
John
Peter
Stewart
|
|
|
|
|
Hi, i think u can add some constraint to this datatable...here u can use UNIQUE constarint to employee name.....
Please search for Adding constarint to a datatable.. i hope that ll help u.
happy programming
All I ever wanted is what others have....
CrazySanker
|
|
|
|
|
Use DISTINCT statement in your SELECT query.
Eg:
SELECT DISTINCT emp_name FROM emp_master
The above query would give you the unique names.
|
|
|
|
|
Hi Venkatesh,
I need to select from a datatable, not the sql database. I need to do something like a groupBy in the datatable, on a certain column. Any idea how to do that?
|
|
|
|
|
i am using this code to scroll test from DB and on click of specific result i am opening another page showing its detail. my problem is as i ahve used repeater control it is scrolling text in multi lines i want a single line.
any help in this regard
<% Response.Write("<marquee id="myMarquee" onmouseover="this.stop()" onmouseout="this.start()" scrolldelay="100" height="100" width="600" direction="left" bgcolor="#EFF7FF"> ")%>
<asp:repeater id="RepNews" runat="server">
<itemtemplate>
<%#", " & DataBinder.Eval(Container.DataItem, " NewsDate") & "
" & DataBinder.Eval(Container.DataItem, " Title") & " "
%>
<% Response.Write("")%>
K Dastgir
|
|
|
|
|
Respected Members,
I have a question, when out aspx page is trying to access the SQL Server 2000 database than before this do we have to craete a user with the name of ASPNET in SQL Server 2000, or without creating this paticular user(its the default user of ASP.NET account) our aspx pages can also access the SQL Server 2000,I have already SQL Server 2000 running in "SQL Server Authentication Mode" so while crating the user do I have to create it in "Windows Authentication" or "SQL Server Authentication", can you provide some link where I could find complete steps for craeting the ASPNET user.
|
|
|
|
|
You dont need to create ASPNET user in SQL Server.
You can just use Windows Authentication to access SQL Server but dont forget to impersonate.
In Web.Config, put the following line.
<br />
identity impersonate="false"<br />
-- modified at 2:18 Monday 9th July, 2007
|
|
|
|
|
Thanks Michael, but I am working in SQL Server authentication mode and I want to continue working in SQL Server authentication mode than whats the solution.
|
|
|
|
|
Well, you can connect to SQL Server with sa account while you are using SQL Server Authenticatin Mode.
If you wanna add ASPNET account or any other local account to SQL Server, plz follow the steps
1. Go to User.
2. Click "new user"
3. There is one combobox or textbox with button at the top of "New User" dialog.
4. then chose the local user account (eg: ASPNET) from this list...
Hope it helps.
|
|
|
|
|
How to align(left,right,justify)text of the text box while clicking image button?
|
|
|
|
|
Plz try this. let me know if it doesn't work.
<br />
document.getElementById('cusTextBox').style.text-align ="center";<br />
|
|
|
|
|
It is not working.. I am working with ASP.Net 2.0.Please check whether given code is of ASP.Net 2.0 or 1.0..
waiting for ur reply..
|
|
|
|
|
function foo(){
alert('foo');
var textbox = document.getElementById('txt');
txt.style.textAlign='right';
}
|
|
|
|
|
Sorry for late reply.. not text-align . it should be "textAlign"..
Hope, it helps.
|
|
|
|
|
Hi good morning,
Using month value and year value how to display all dates in that month,
Means,suppose month value=6(june) and year value=2007,
Then it want to display,
6/1/2007
6/2/2007
...
...
6/30/2007
How to do that,
Advance thanks,
Regards,
Magi
|
|
|
|
|
Get it[^]
Regards,
Satips. ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Don't walk in front of me, I may not follow;
Don't walk behind me, I may not lead;
Walk beside me, and just be my friend. - Albert Camus
|
|
|
|
|
Hi in that link they used some procedure,
In that i dont know where the month value passing and where the year value passing...,
In backend coding its possible to get all dates of that month?,
Regards,
Magi
|
|
|
|
|
int[] TotalDates = {31,29,31,30,31,30,31,31,30,31,30,31};
int CurrentYear = 2007;
int CurrentMonth = 6;
if( DateTime.IsLeapYear(CurrentYear) )
TotalDates[1] = 28;
for(int i=1; i<=TotalDates[CurrentMonth - 1]; i++ )
{
Console.WriteLine(CurrentMonth.ToString() + "/" + i.ToString() + "/" + CurrentYear.ToString());
}
Console.ReadLine();
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
