|
What is the sql statement which you are using?
Best Regards,
Apurva Kaushal
|
|
|
|
|
select [StudentID],[Name],[Percentage] from tblstudent WHERE (StudentID = @StudentID AND Name=@Name AND Percentage=@Percentage)
this was the statement in the sqldatasource tool.
Babu
|
|
|
|
|
Hi,
Do you have any record in the database which is satisfying all the conditions here because your query is correct.
Best Regards,
Apurva Kaushal
|
|
|
|
|
hi,
i've applied this query for another table too.that is for customers.even for that it was not working.
can you give me the sql statement using OR Condition.will it work.
Actually in sqldatasource there is no need to write coding manually.just in configuration mode we can create with the option "Where" button.
Babu
|
|
|
|
|
Hi,
If you are using and condition then all the conditions has to be satisfied then only you will be able to get the result. So according to your query is you are having a record which is having all the StudentID, Name and Percentage which you have passed that will be fetched.
For OR condition just replace and with or.
Hope this will help you.
Best Regards,
Apurva Kaushal
|
|
|
|
|
SELECT [CustCode], [Name], [Addr], [OrdType], [Area], [Lob] FROM [Customer] WHERE (([CustCode] = @CustCode) OR ([Country] = @Country))
i was using dis query for another table access.but its not working.
Babu
|
|
|
|
|
are you getting any error or simply not getting the result. In case of of the second just check whether you are having the required records in the table.
Best Regards,
Apurva Kaushal
|
|
|
|
|
Can i give yearwise scroll criteria to <asp:calender>?
thanks in advance.
|
|
|
|
|
Hi All,
I have a doubt in datagrid.
I created a datagrid with Header template columns.
In a button click event how to disable the Header template column of datagrid.
Pls gve me suggestion..
Thanks
PAul
Paul
|
|
|
|
|
dtGrid1.ShowHeader =false;
|
|
|
|
|
Hi all,
I am using linkbutton in datagrid and ONCOMMAND event I collect row ID. This Id I am saving in Session("ID").I displayed this session("ID") by messagebox on same page.Everything goes fine,but when I redirect to another page and try to use session("ID") it gives nothing.
Sub Navigation(ByVal sender As Object, ByVal e As CommandEventArgs)
Session("ID") = e.CommandArgument
MsgBox(Session("ID"))
Response.Redirect("ResumeSearchDetails.aspx")
End Sub
///ResumeSearchDetails.aspx
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Not Page.IsPostBack Then
MsgBox(Session("ID"))
end if
end sub
MsgBox(Session.SessionID) gives some value on both page which is not same
that means total session is not expired only value lose.
I hope you understand my problem.
Thanks.
Teach Life To Laugh.......
|
|
|
|
|
In global.asax
on Session_onStart
initialize as
Session("ID")=null
and find whether there is any other assignment in the other pages for Session("ID").
set break point on session_onstart event to find when session got initialized
|
|
|
|
|
Hi Saumal,
We are meeting second time last time You teach lots to me.
It may be my mistake that I could not find Global.Aspx in my application.I am using .net2005 (I know in .net2003 global.ascx present in current application folder)
|
|
|
|
|
You can add global.asax by choosing new item and global application class in .net 2005
|
|
|
|
|
Hi,
Thanks,Ones again you solve my problem.
I have added
Session("ID")=null
in Global.asax
Now It's working fine.
But Is there any problem if any another page in application assign value to Session("ID")
Best Regards,
Nagraj
Let's Teach Life To Laugh.......
-- modified at 8:03 Monday 19th June, 2006
|
|
|
|
|
Hi all,
Is it possible to make a dynamic treeview in ASP.net 1.1 with VB.NET 1.1.Can somebody send any link if possible
Thank You
|
|
|
|
|
I am using asp.net(VB) and javascript in my project.
I want to redirect username from onepage to another and then popup thatusername at the bottom of that window as (welcome Username).
So i am able to achive redirecting the username useing Request.queirystring but i want to popup that thing pls help me tell how to popup that thing.
If possible send code for it.
Thanks in advance
|
|
|
|
|
window.status='hi username';
You can use this code to display in status bar of the window using javascript
|
|
|
|
|
Hi
i am developing asp.net web application in which i have to read and send all the name ranges of the excel sheet i am using com Excel object but it is taking too much time to read the excel sheet . Please suggest me what to use for performance basis ?
Here is code
ExcelObj=new Excel.Application();
Excel.Workbook theworkbook=null;
string[] strColumnDetails=new string[180];
int excelRows=1,excelColumns=1;
string[] excelColumnnames={"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"};
int columnRecordIndex=0;
try
{
theworkbook = ExcelObj.Workbooks.Open(path,0,true,5,"","",true,Excel.XlPlatform.xlWindows,"\t",false,false,0,true,false,false);
Excel.Sheets sheet=theworkbook.Application.Worksheets;
Excel.Worksheet worksheet=(Excel.Worksheet)sheet.get_Item(1);
int rows = worksheet.UsedRange.Rows.Count;
int columns = worksheet.UsedRange.Columns.Count;
for( excelRows=1;excelRows<=rows;excelRows++)
{
for( excelColumns=1;excelColumns<=columns;excelColumns++)
{
try
{
Excel.Range ExcelRange=(Excel.Range)worksheet.Cells[excelRows,excelColumns];
Excel.Name rangeName=(Excel.Name)ExcelRange.Name;
string columnName= rangeName.Name.ToString(); //strColumnNames[columnRecordIndex,2];
strColumnDetails[columnRecordIndex]=columnName+"#$"+excelColumnnames[excelColumns]+"$"+excelRows.ToString();
columnRecordIndex++;
}
catch(Exception ex)
{
ex.ToString();
}
}
}
}
catch(Exception ex)
{
ex.ToString();
}
finally
{
ExcelObj.Quit();
}
-- modified at 2:42 Monday 19th June, 2006
|
|
|
|
|
take a look on this link http://zamov.online.fr/EXHTML/CSharp/CSharp4.html
Pilo
|
|
|
|
|
Hi Pilo i can't access that page from organization please give some other link or paste the content on that page please
|
|
|
|
|
Hi all,
I am implementing two pages for resume Search one page contain Brief information about searched resumes as shown in following link.
http://dynamicscareers.com/Employer/Resumes/List.aspx?
Second page Is contain detail information about selected resume as shown in
http://dynamicscareers.com/13964
I completed First Page.Now I want to create secod page,So what should use(i.e.Nested datagrid,Repeater,Gridview etc.) If some one have implemented such thing please let me know
Let's Teach Life To Laugh......
Regards,
Nagraj
|
|
|
|
|
In my page i am having a dropdownlist control. I have populated the data for this dropdown using javascript.
i.e it has 5 items.
But upon postback ,it says that the data in the dropdown is 0.How to solve this.
|
|
|
|
|
I think to make a Postback you must use a control that run at server...
May you write your code so you make every thing clear?
"I am too late but i will never give up"
|
|
|
|
|
see my code
1<code>.<asp:DropDownList ID="ddemp" runat=server></asp:DropDownList></code>
2.I have used this javascript to populate the dropdown ( For sample i have used the count,it is getting at runtime)
<code><script language=javascript type="text/javascript" >
function add()
{
var ddlobj = document.getElementById('ddemp');
for (var count = ddlobj.options.length-1;count >-1; count--)
{
ddlobj.options[count] = null;
}
for (var count = 0; count < 5;count++) // For sample i have used the count,it is getting at runtime
{
value = count;
text = "List" + count ;
listItem = new Option(text, value , false, false);
ddlobj.options[ddlobj.length] = listItem;
}
}
</script></code>
3.while clicking one more button, i am not getting the selected value. it shows ddemp.Items.Count as 0
|
|
|
|