|
Hi i am using Listbox control...,
In that i am selecting more than one record..,
Using for loop i get what are the records has been selected in that listbox...,
If i selct one record, i can pass that value to my sqlcmd parameter easily...,
Now more than one records are there,
how to pass those values to my stored procedure using sqlcmd parameters?,
Plz any give me some ideas abt this...,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
So do you need each item selected to be inserted as a new record ? Then, iterate the listbox items, pass current item to the parameter, insert it to the DB. Continue this once you insert all the selected items.
|
|
|
|
|
Hi see thi is my code:
SqlCmd.Parameters.Add("@User", SqlDbType.VarChar, 500);
SqlCmd.Parameters["@User"].Direction = ParameterDirection.Input;
SqlCmd.Parameters["@User"].Value = myCodes.Trim();
SqlCmd.Parameters.Add("@FromDate", SqlDbType.DateTime);
SqlCmd.Parameters["@FromDate"].Direction = ParameterDirection.Input;
SqlCmd.Parameters.Add("@ToDate", SqlDbType.DateTime);
SqlCmd.Parameters["@ToDate"].Direction = ParameterDirection.Input;
That mycodes value contained, values like this 'Admin','User'
Now how i can check in my stored procedure those records?,
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
In the Stored Proceedure(SP) You have to check with IN i.e.
Select col1,col2,col3 from tbltest where col1 IN(@User)
Where @User is the variable in which you are retrieving the values wich are passed to the SP
Note:Do you want to Achieve this...if not what you want to get the Out put
|
|
|
|
|
hai friends
does sessions doesn't apply for the page opened in new window
i have to display a page in a new window in my website
in that new window, on page load
i written like this
if (session("booked")="t") then
// do some task
end if
this is not happening in my website
but it is happening in my local server/pc or when i run the project with localhost
when i check it thru website then it is not happening
plz help me
thanks in advance
vijay
|
|
|
|
|
vijaylumar wrote: does sessions doesn't apply for the page opened in new window
I have seen different behaviors for this. AFAIK, session will be available on the new window if it's opener window has session. I mean if you open browser by clicking on it's exe, session won't be shared . Session would be shared if the new window is opened by another window which has session. I have seen Firefox sharing session across tabs.
|
|
|
|
|
hai navaneeth
does the same problem will comes with
Application memory variable
cache variable
class variable if declared as shared
|
|
|
|
|
vijaylumar wrote: Application memory variable
cache variable
class variable if declared as shared
No. Application variables are available long time on the server. It's not user specific. So you will get it everywhere. Cache also will be available to all the browser instances.
Static (shared) variables stay alive in the memory till application domain unloads. So you will get this too in multiple browser instances.
|
|
|
|
|
vijaylumar wrote: does sessions doesn't apply for the page opened in new window
yes .you can !!
check your if statement.
vijaylumar wrote: if (session("booked")="t") then
// do some task
end if
|
|
|
|
|
Hi,
A session will be available as long as that user is using the site. No matter the page. So it’s clear that your session is available. By default, session variables are stored in memory. What I suggest you is, first in your web site find what is the setting you have given for the session state mode. It should be “InProc” to store the session in the memory. This could be found in Web.Config.
<sessionState mode="InProc"></sessionState>
Thx,
Gayani
|
|
|
|
|
I have to write a classic ASP page.I have a page which has a html table with some row , each row has some controls with several textboxes and 3 select controls(dropdownlist). At table's below, there is a Add button to add new row. When click on Add button, the new row will be added(with full of textboxes and select controls as same to other rows, and they have the same ID, too). What I wanna do is after selected an item from the first dropdownlist, data will be loaded from server and filled in the second dropdownlist on the same row, and after selected an item from the second one, data will be loaded form server to fill in the third one. I wonder after select an item from the first dropdownlist, I need to reload page to load data and fill the second one, and if I have some rows already has been filled data in textbox control etc will be lost. To resolve it, I've tried to use AJAX technology but It didn't work with IE though that worked with Firefox. Please help me to resolve this problem? If you can show me code better.
<![CDATA[<%@ LANGUAGE="VBSCRIPT"%>]]>
<![CDATA[
<![CDATA[
<html>
<head>
<title>Add a row in table</title>
</head>
<script language="javascript">
function InsertRow()
{
count++;
var table = document.getElementById("tblAddRow");
if (!table) throw "Table not found";
var row = table.insertRow(0);
var cell1 = row.insertCell(0);
var cell2 = row.insertCell(1);
var cell3 = row.insertCell(2);
var cell4 = row.insertCell(3);
cell1.innerHTML = 'Test' + count;
cell2.innerHTML = '<input type="text" id="txtDate">';
cell3.innerHTML = '<select id="cboCompany" name="cboCompany" onchange="javascript:ShowPermission(this, this.value);">' +
'<option value="0">????</option>' +
'<% Do while Not rs.EOF %>' +
'<option value="<%=rs(0)%>"><![CDATA[<%=rs(1)%>]]></option>' +
'<% rs.MoveNext() %>' +
'<% Loop %>' +
'</select>';
cell4.innerHTML = '<select id="cboPermission" name="cboPermission">' +
'<option>????</option>' +
'</select>';
}
</input></script>
<body>
<form name="frmAddRow" action="" method="post">
<table id="tblAddRow" border="1">
<tr>
<td>Colum1</td>
<td>Colum2</td>
<td>Colum3</td>
<td>Colum4</td>
</tr>
</table>
<input type="button" name="btnAddRow" onclick="javascript:InsertRow();" value="AddRow" />
</form>
</body>
</html>
<
|
|
|
|
|
Thanks 
|
|
|
|
|
Hello friend,
I have specefied Font-Names="Mangal" on textbox control in asp.net, but still at runtime on entering some text on it, it is displaing text in english.
Please help me to enter and find text in hindi.
nikki
|
|
|
|
|
Hi,
I using ASP.NET with C#, how can i get Active Directory from my server?
Socheat
|
|
|
|
|
using System.DirectoryServices;
and use DirectoryEntry and DirectorySearcher Class.
if you have any doubts you can ask me !!!
|
|
|
|
|
Can you give a full example?
Socheat
|
|
|
|
|
create connection
public static DirectoryEntry GetDirectoryEntry()<br />
{<br />
DirectoryEntry de = new DirectoryEntry();<br />
de.Path = LDAP:
de.Username = @"yourdomain\sampleuser";<br />
de.Password = "samplepassword";<br />
return de;<br />
}
Click Here For details
Active Directory .NET[^]
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
