|
Sorry No link found
|
|
|
|
|
see this link
ok
www.msdn2.microsoft.com/en-us/library/aa159891(office.11).aspx
|
|
|
|
|
sorry page cannot be displayed.......
|
|
|
|
|
http://msdn2.microsoft.com/en-us/library/aa159891(offices.11).aspx
|
|
|
|
|
plz explain .dll hell in .net
|
|
|
|
|
plz refer this link..
http://en.wikipedia.org/wiki/DLL_hell
In computing, DLL hell is a phrase for complications which arise when working with dynamic link libraries, or DLLs.
DLL hell encompasses the difficulties of managing dynamic-link libraries (DLLs) in Microsoft Windows operating systems. These difficulties include conflicts between DLL versions, difficulty in obtaining required DLLs, and having many unnecessary DLL copies.
|
|
|
|
|
|
hi guys
i would like to retrive the data of One cell of the sql database's table
i already know the command will be like this:
select age from kids where nric = 'sss'
this command statement would retrive only 1 result
however i dont know the sysntex to use this command statment with in asp.net (c# coding side)
could anyone show me how it is done pls?
|
|
|
|
|
sqlconnection conn = new sqlconnection(path of the connection);
sqlcommand cmd = new sqlcomand("your query", connection);
string result;
result=cmd.executescalar();
Gautham
|
|
|
|
|
it says
Error 51 The type or namespace name 'sqlconnection' could not be found (are you missing a using directive or an assembly reference?)
|
|
|
|
|
be sure to import System.Data.SqlClient NameSpace
Tirtha
Miles to go before I sleep
|
|
|
|
|
i already added
using System.Data.SqlClient;
if this is not correct pls kindly describe what i shld do pls
|
|
|
|
|
hi ..
here is some code for connecting to database..
i think this would help you.. make necessary changes..
this is just to show you how we can connect to the db..
put connection string in web.config file
using System;
using System.Data;
using System.Configuration;
using System.Data.SqlClient;
public class dbClass
{
private SqlConnection con;
private SqlCommand com;
private SqlDataReader dr;
private SqlDataAdapter da;
private DataSet ds;
public dbClass()
{
con = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["conString"].ToString());
}
///
/// Open an Sql connection.
///
/// <returns>sqlconnection
public SqlConnection GetConnection()
{
try
{
if (con.State == ConnectionState.Open)
{
con.Close();
}
con.Open();
}
catch (Exception ex)
{
string err = ex.Message.ToString();
}
return con;
}
///
/// Executes a query with SqlDataAdapter
///
/// <param name="sql" />sql query
/// <returns>DataTable
public DataTable GetAdapter(string sql)
{
try
{
com = new SqlCommand(sql, GetConnection());
com.CommandTimeout = 0;
da = new SqlDataAdapter(com);
ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
finally
{
con.Close();
}
}
|
|
|
|
|
hi
u can see this code and do it
string strCmd="select age from kids where nirc='sss'";
Sqlcommand cmd =new sqlCommand(strCmd,con);
cmd.CommandType=CommandType.Text;
con.open();
DataReader dr=cmd.ExecuteReader();
while(dr.read)
{
// code to populate data
example u want to populate to combo box then u can writecode like this
cmdAge.add.item(dr.GetValues[1]);
}
try with this code i hope u will come out of the problem
tell me confirm once
ok
|
|
|
|
|
actually in my web.config i already have an connection string called
HASDBConnectionString1
what i basically need is ONE value(int) while using the HASDBConnectionString1 connectionstring name in my web.config
my query is queryed by the key column so it always retrun only 1 value
i am using asp.net2 (2005) and sql server 2005
|
|
|
|
|
What is the difference between heap and managed heap.
|
|
|
|
|
A heap is a memory area that a memory manager uses for allocating memory.
The managed heap is the heaps (four of them) that the memory manager in .NET uses to allocate memory for managed objects.
If you allocate unmanaged memory from within .NET, it's allocated from the Windows heap instead of the managed heap. The .NET memory manager allocates memory from the Windows heap to use for the managed heap.
---
single minded; short sighted; long gone;
|
|
|
|
|
How can .net support multiple languages?
plz describe answer for this
|
|
|
|
|
I'm new to the mobile web application development.. I have developed a web application from which a user can select a .cab file to download to the mobile. I just want to know the steps for downloading a particular file to the mobile.Could anybody help me by giving me the proper guidance for the same..
[ I'm using ASP.net 2.0 with C#]
|
|
|
|
|
Hi All,
I need to display Sr No in GridView, in dataset I dont have Sr No column.Please tell me how do I do this...
Thanks in advance...
|
|
|
|
|
two things can be done...
1.Make an Autogenerate column in your Database table if your query doesnt include any JOINING......i.e if you are fetching record from 1 table....
2.If the case is not so...then u have to make 1 column in your DataSet table
....i.e u have to make a customized dataset from your existing dataset.....
Tirtha
Miles to go before I sleep
|
|
|
|
|
Hi Tritha,
Thanks for Reply.First case I cant use because if few rows are deleted then its will show me sr no as 1 2 4 5 etc.
But I think I can use second option.Can u please help me with the code.I am using ASP.NET 2.0(VB) or is there any way we can do it with Query
Thanks...
|
|
|
|
|
Put column in datagrid
--------------------
<asp:TemplateColumn HeaderText ="#">
<HeaderStyle Width="50px" />
<ItemTemplate >
<asp:Label id="Label1" runat="server" Text="<%# sn1() %>">
</asp:Label>
</ItemTemplate>
</asp:TemplateColumn>
------------------------------------
write in code behind page
public string sn1()
{
int t;
i = i + 1;
t = (grd_category.CurrentPageIndex * pagesize) + i;
return t.ToString();
}
DataGridPageChangedEventArgs e)
{
grd_category.CurrentPageIndex =e.NewPageIndex;
bind();//code to bind the grid
}
hope this would help you..
|
|
|
|
|
I think now u can see it.. else i will send it to you..
|
|
|
|
|
Yes I can see But I am getting error on line
t = (gvExport.CurrentPageIndex * pagesize) + i
Here I cant get CurrentPageIndex.I am using ASP.NET 2.0 (VB)
Please tell me how to do?
|
|
|
|