|
* You can try an optimise the queries you are using.
* You can return the minimum information (saving on network bandwidth and memory in the SQL Server)
* You can install a faster network
* You can install more memory in the SQL Server
* You can install faster hard disks in the SQL Server
* You can fine tune the indexes on the tables
I could go on if you wish, but you would be better buying a book on how databases work.
|
|
|
|
|
Thnx for reply,
sorry for late respose from my side..
regars
Shriya
|
|
|
|
|
use cache for fast result
parwej and dev
|
|
|
|
|
Thnx for reply,
sorry for late respose from my side..
regars
Shriya
|
|
|
|
|
Thanx 
Keep Smiling !!!
Parwej Ahamad
g_parwez@rediffmail.com
|
|
|
|
|
hi friends
i have textboxes in dataview for qty field and one command button.
now i update qty field on click of UpdateCommmand button.
and database is updated.
i have one usercontrol in which i bind qty and total price.
my problem is that when i update qty field in .aspx page then usercontrol is not updated records.
i want to rebind usercontrol when i click on button.
how to rebind?
plz reply me
thanks in advance
Pathan
|
|
|
|
|
update dataset oleDB from datagrid
this is not working !! why??
or send working link... i dont wanna write SP or any query for that (update table values.....)
just using commandbuilder...
Private Sub DataGrid1_UpdateCommand(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs) Handles DataGrid1.UpdateCommand
con.Open()
adapter = New OleDb.OleDbDataAdapter("Select * from Customers", con)
Dim cmd As OleDb.OleDbCommandBuilder
cmdbuilder = New OleDb.OleDbCommandBuilder(adapter)
adapter.UpdateCommand = cmdbuilder.GetUpdateCommand()
adapter.DeleteCommand = cmdbuilder.GetDeleteCommand()
adapter.Update(ds.Tables(0))
DataGrid1.EditItemIndex = -1
setData()
End Sub
"You can do any thing you set to your mind" - theGhost_k8
|
|
|
|
|
hello All ,,
I am very New For C# and Asp.net programming..I have Made Two C# Files..One Is First.cs having Class Name FirstClass On Public Access Level ..
Such As
**First.cs**
public class FirstClass : System.Web.UI..Page
{
//Some variable n Properties--
}
And another File Second.cs Having Class SecondClass On Public Access level..
Such As...
**Second.cs**
public class SecondClass : System.Web.UI.Page
{
// Some Code here;
FirstClass obj = new FirstClass(); ///// Error On this Line
}
And i have Made One aspx file. Which IS user.aspx
Such As ..
**user.aspx**
<%@ Inherits="SecondClass" Src="Second.cs" Language="C#"%>
....
...
...
My Problem Is That..
I have Included Second.cs file in user.aspx
How I can Create Object of FirstClass From First.cs In
The SecondClass Which is in Second.cs File..
I am Making Inline Program in asp.net ...
How i come over from this problem..
plzz Let me Soooon.
Thanx in Advance
Life is not easy ,let's make it.
|
|
|
|
|
hello... iam working on a Expert system project and i hav a problem how to move from one webpage to another..
something like the NEXT button which we can see in this webpage.....which is directing us to a new webpage i want to do this in ASP.net or c#.net....
|
|
|
|
|
on next button click event use:
Response.Redirect("NewForm.aspx");
|
|
|
|
|
|
when i used vs2003 i used to code like below...
[Transaction(TransactionOption.Required, Isolation = TransactionIsolationLevel.ReadCommitted)]
public class BizClass : ServicedComponent
{
[AutoComplete(true)]
public void InsertBBS()
{
using (DAClass da = new DAClass())
{
try
{....
}
}
}
}
but when i coded like the above using vs2005 it didn't work...
there is a runtime error...(i didn't do the websharing thing... as you know.. vs2005 provides the dummy iis.. )<-- is this why it didn't work??
i wonder how the transaction setting is changed in .net Framwork 2.0
that's not how i suppose to do??
Then how i set the isolation level and transaction options...??
|
|
|
|
|
how to call javascript and server function in a server button in a datagrid
|
|
|
|
|
in an itemcreated event
use find.control to find the button and bind the javascript function
button.attribute.add("onclick","function name")
hope this can solve u problem
Dev
|
|
|
|
|
sorry..
i didt got.
because i cant get the buttom using findcontrol from the datagrid.
yesu
|
|
|
|
|
This problem is happening when we redirect from one page to another page within our website using response.redirect(With some query string values) then it is giving error "Host Unavailable"
FYI: The same thing is working fine in our staging server but having problem in Live only.
Anyone having some idea???
Thanks advance for help.
|
|
|
|
|
configure .net settings on ur server u need to enable it first using the account provided to u by ur hosting service provider
|
|
|
|
|
I have implented Forms authendcation and using Authentication mode as "Windows".I am using right credentials to login.
Every thing working fine .This problem is happening only when we do the redirection.
Which settings you want me to change??
|
|
|
|
|
Hi all
I have one datagrid at runtime in asp.net
I have added checkboxes also in drid which is created at runtime also at runtime.
when i click on checkbox,which event is fired?
Thanks
monika
|
|
|
|
|
|
Hi
Thanks for yr kind response.
But I am not getting in yr code.Pls if any other help,suggest me.
Is it possible using javascript?
Thanks
monika
|
|
|
|
|
The code is simple .
1-You create the control.
2-You create the Event handler function i.e "dynamicHandler "
3.Create the event handler and assign it to the command of the button
t.Command += new CommandEventHandler(dynamicHandler);
now when the click of this button fires the function"dynamicHandler" will be executed where you can handle this event.
Hope things are clear now.
|
|
|
|
|
Hi
I create control like checkbox
dim chk as new checkbox
i have'nt chk property as command.
What i do?
Thanks
monika
|
|
|
|
|
Hi friends
I have buttons as a ItemTemplate in Gridview.i want to delete row by clicking on button but how to get row index which i want to delete.
Plz reply me
Pathan
|
|
|
|
|
Use Event Handler Like Bellow
Public Sub delete(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridCommandEventArgs)
Dim result As Boolean = False
qry = "Delete from Payment_Gateways where Pay_gateway_Id = " & Me.dgD.DataKeys(e.Item.ItemIndex)
Try
Conn.Open()
Command = New OleDbCommand(qry, Conn)
Command.ExecuteNonQuery()
Catch ex As Exception
Response.Write(ex.ToString)
Finally
If (Not Conn Is Nothing) Then
Conn.Close()
End If
End Try
End Sub
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
