|
well... this is the most common problem with IE 6. Dropdown always comes over divs. I think what you can do, is to create an IFrame below the div a floating one, or an IFrame just below the dropdown, and then above the IFrame place the menu.
Iframe comes over selects always.![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
i have 2 table in different database and different server, i want select records from one server(e.x. 100 records) and insert them to other table in the other server. do any body know how is my query?
i dont want use for and insert the records one by one,
|
|
|
|
|
ptvce wrote: i have 2 table in different database and different server, i want select records from one server(e.x. 100 records) and insert them to other table in the other server. do any body know how is my query?
Does it any thing related with ASP.NET? 
Any way, you can check this link,
Check
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
yes, its in C#.net
/////
public static SqlConnection connCommDB = new SqlConnection("Data Source=SADAFIT-9D6E926;Initial Catalog=ReservationSynchorizer;Integrated Security=True;");
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "?????"
cmd.Connection = conn;
conn.Open();
da.SelectCommand = cmd;
da.Fill(ds);
conn.Close();
|
|
|
|
|
ptvce wrote: yes, its in C#.net
ASP.NET is a framework dealing with web applications. It has nothing to do with database access. ADO.NET is the part of the .NET Framework that deals with database access.
If you are wanting to INSERT data using SQL, then don't use a SqlDataAdapter unless it is directly related to the source of the data, which in this case it isn't. In fact, I wouldn't use data adapters at all.
The command Text should probably look something like this:
INSERT INTO myTable (column1, column2, column3) VALUES(@column1, @column2, @column3)
Replacing myTable, columnX and @columnX with the approproate table name, column names, and parameter names.
You will also have to create parameters to put the data that you want to insert into the query.
cmd.Parameters.AddWithValue("@column1", myValue);
When you are done, use cmd.ExecuteNonQuery() rather than with a DataAdapters. You can't fill anything with an INSERT statement. Only SELECT.
|
|
|
|
|
try this
INSERT INTO database..tablename (columnname)
(SELECT top 100 columnname FROM database..tablename)
|
|
|
|
|
You can do it all in SQL, but remember to link the servers together too. The source and destination are on different servers.
|
|
|
|
|
|
Why not? What is stopping that solution? It would be the most efficient if it works.
|
|
|
|
|
because insert is onse server and select is from the other server
how i define them?
|
|
|
|
|
A fully qualified table name is as follows:
[server].[database].[schema].[table]
Normally you omit the bits that can be inferred. e.g. if you are in a specific database and the table is in the same database you don't have to specify anything other than the table.
So: SELECT * FROM DB-SRV1.Sales.dbo.Order
You will have to link the SQL Servers together first otherwise it won't know where to find the other server.
Linking Servers[^] (MSDN)
|
|
|
|
|
hi
in asp.net application one user is login then how many active session is created i am confused about that because iis performance
moniter active session display 612 and my login user is only more than 50. also when i particuler user logout that time session active in not not decrease.
thank you advance
urgent please
|
|
|
|
|
pra.chaudhari wrote: moniter active session display 612 and my login user is only more than 50. also when i particuler user logout that time session active in not not decrease.
How did implement the logout? can you please put the code for that section ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
when i login that time i remove the sesstion value
'loginpage page_load event code
If Page.IsPostBack() = False Then
l_objSessionMgr.RemoveAll()
FormsAuthentication.SignOut()
End If
'this is common function
Public Sub RemoveAll()
HttpContext.Current.Session.RemoveAll()
End Sub
|
|
|
|
|
please tell me about the implementation of rss in my final year project
|
|
|
|
|
|
Request the RSS feed from the Source site. and you will recieve response as XML. then populate the information from this XML. .Net framework does provide the API to request RSS feed.
Parwej Ahamad
|
|
|
|
|
Hi,
I have a asp:table on aspx Page. Im adding dynamic rows to the table.
The rows added dynamically are visible on the UI bt im unable to find those dynamically created rows in viewsource of the page.
i.e they are not being rendered. I want to access controls value inside the table cell. i have added textbox control in the table cell whose value i want to calculate.
How i can do that.
Thank you all for your replies.
modified on Monday, April 13, 2009 4:51 AM
|
|
|
|
|
Could you post here your line code way of inding the controls ?
Parwej Ahamad
|
|
|
|
|
<br />
<asp:updatepanel id="UpdatePanel3" runat="server" updatemode="always" enableviewstate="true" xmlns:asp="#unknown" /> <contenttemplate><br />
<br />
<table id="tblRateDetails" runat="server" borderwidth="2px" borderstyle="solid" enableviewstate="true"><br />
<contenttemplate><br />
<asp:updatepanel xmlns:asp="#unknown"><br />
<br />
In the .cs page the rows are added as:<br />
<br />
TableRow tr = new TableRow();<br />
<br />
TableCell tcPlace = new TableCell();<br />
<br />
Label lblPlaces = new Label();<br />
lblPlaces.Attributes.Add("runat", "server");<br />
lblPlaces.ID = "lblPlaces" + i;<br />
lblPlaces.Text = arrstrPlaces[i];<br />
<br />
tcPlace.Controls.Add(lblPlaces);<br />
tr.Cells.Add(tcPlace);<br />
<br />
<br />
TableCell tcRate = new TableCell();<br />
<br />
TextBox txtRates = new TextBox();<br />
txtRates.Attributes.Add("runat","server");<br />
txtRates.ID = "txtRates" + i;<br />
txtRates.Width = 50;<br />
txtRates.Attributes.Add("onkeypress", "fnAccpNumDecimal(event)");<br />
<br />
tcRate.Controls.Add(txtRates);<br />
tr.Cells.Add(tcRate);<br />
<br />
<br />
TableCell tcrfv_FD = new TableCell();<br />
<br />
RequiredFieldValidator rfv_FD = new RequiredFieldValidator();<br />
rfv_FD.Attributes.Add("runat", "server");<br />
rfv_FD.ID = "rfv_FD" + i.ToString();<br />
rfv_FD.ControlToValidate = txtRates.ID;<br />
rfv_FD.ErrorMessage = "Insert Rates";<br />
rfv_FD.Display = ValidatorDisplay.Dynamic;<br />
rfv_FD.SetFocusOnError = true;<br />
rfv_FD.Text = "*";<br />
rfv_FD.EnableClientScript = true;<br />
rfv_FD.ValidationGroup = "check";<br />
rfv_FD.Visible = true;<br />
rfv_FD.Enabled = true;<br />
rfv_FD.EnableViewState = true;<br />
<br />
tcrfv_FD.Controls.Add(rfv_FD);<br />
tr.Cells.Add(tcrfv_FD);<br />
<br />
<br />
tblRateDetails.Rows.Add(tr);<br />
<br />
<br />
</asp:updatepanel></contenttemplate></table></contenttemplate>
modified on Monday, April 13, 2009 5:40 AM
|
|
|
|
|
i am not getting error msg while validating textbox in gridview
i have put custom validator on textbox in grid
i have done this in gvStudent_RowDataBound
if (e.Row.RowIndex >= 0)
{
CustomValidator customValidator = new CustomValidator();
customValidator.ID = "CustomValidator1";
customValidator.ControlToValidate = "txtGrade";
customValidator.ErrorMessage = "Invalid Grade.";
customValidator.SetFocusOnError = true;
customValidator.ValidateEmptyText = true;
customValidator.ClientValidationFunction = "fnClientFunction";
e.Row.Cells[2].Controls.Add(customValidator);
}
and
this is function that i have wrritten in source side
function fnClientFunction(source, arguments)
{
if (arguments.Value=="AA" || arguments.Value=="aa" || arguments.Value=="AB" || arguments.Value=="ab" || arguments.Value=="BB" || arguments.Value=="bb"|| arguments.Value=="BC" || arguments.Value=="bc"|| arguments.Value=="CC" || arguments.Value=="cc"|| arguments.Value=="CD" || arguments.Value=="cd"|| arguments.Value=="DD" || arguments.Value=="dd"|| arguments.Value=="EE" || arguments.Value=="ee"|| arguments.Value=="FF" || arguments.Value=="ff"|| arguments.Value=="I" || arguments.Value=="i"|| arguments.Value=="RR" || arguments.Value=="rr")
arguments.IsValid=true;
else
arguments.IsValid=false;
}
can any body help me to sort out this problem.????
with regards
rahul
|
|
|
|
|
May i know what is JSON? and why we go for JSON...I am working in Asp.net, whether it is related to?
Thanks in advance.
Ramkumar
|
|
|
|
|
getramonweb wrote: May i know what is JSON?
JavaScript Object Notation
getramonweb wrote: and why we go for JSON
Because it is easy to use in JavaScript
|
|
|
|
|
JSON is an acronym to JavaScript Object Notation.
It is a lightweight data-interchange format. Can be used as an alternative to XML.
In asp.net, you can use JSON as a data-interchanger format with AJAX using DataContractJsonSerializer.
|
|
|
|
|
Hello,
This is Vikash again.
This time i have query related to my web site configurations.
I have one module in my website under the App_Code folder and I have put all the .aspx pages with code-behind files and sitemap file in another folder named 'Pages'.
Also i have put the Stylesheet file in the Pages folder. Now when I run the site from VS.net 2005 it runs well, but when I Compile the site and put the compiled site in IIS and run from browser, it does not take the stylesheet styles, Can anyone tell me why this happens?
Another thing is when i put all my files under root directory, it works fine even after compiling.
I also want to know that every time I Compile my site, it by default puts the Compiled DLL files in Bin directory. I don't want to use this Bin directory and want to put the compiled files in the 'Pages' folder where all my other files are present, How can i do this?
Anyone please can give some ideas on the above issues, would be of great help.
And Thanks in Advance.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
