|
You can either filter with a SQL query or use datatable's 'Select' method like
DataRow[] dr=ds.Tables[0].Select("id="+yourid);
|
|
|
|
|
hi I want like query like this way
i am filling dataset in following way
<pre>
SELECT O.name , study_uid_mask FROM study_org_mapping s INNER JOIN Organization O ON O.PK = S.ORG_FK"
ds.Tables[0].Select(myid + "LIKE 'study_uid_mask'";
</pre>
but it seems it is not working
Thanks,
Amit
|
|
|
|
|
|
hi.. currently i m using asp.net 2.0 and sql server 2000.
As when the session expires automatically, i would like to update the session values to my database table. i cant write sql statements, connections in Session_End function (Global.asax). how to handle this. help me - KARAN
|
|
|
|
|
|
Hi,
If i want to show newly released products from one site on my site without manually add it, how do i do this?
What should i search after?
|
|
|
|
|
Check whether that site provides the RSS Feeds for the same.
|
|
|
|
|
for one of the sites there is a rss feed
|
|
|
|
|
you can scrap the data from that site and show it on your site.
|
|
|
|
|
ok, should i search for scrap data?
|
|
|
|
|
Good morning.
I am develop an application in asp.net 2.0 in C#.How to restrict the browser's back button from review after logout.
kindly help me.
Your's
Debapriya
|
|
|
|
|
Once Back button is clicked, the browser may display the Cached version of the page.
If you wish to avoid that, Expire the page using Response.Expires = -1;
Don't forget to kill the session for logged out user.
If you wish to disable browser back button, use Request.ServerVariables["HTTP_REFERER"] to get the info
about the url of the client's previous request.
string s = "";
if(Request.ServerVariables["HTTP_REFERER"] != null)
{
s = Request.ServerVariables["HTTP_REFERER"].ToString();
}
Hope this will help.
|
|
|
|
|
<script language="javascript" type="text/javascript">
<!--
javascript:window.history.forward(1);
</script>
call the above JS in all pages
|
|
|
|
|
|
I want o generate my reference.cs from a wsdl in my .net application
I have used Wsdl to create the .cs file, but I have no idea of how to import it in my visual studio application
How do I create my .map file and call the methods?
Can someone provide the information. Is there any step by step guide? I have search the web but I have find nothing
Thanks
|
|
|
|
|
|
I have only the wsdl file not the web service. My application is a windows service and I need to create the proxy class in order to call the webservice. I don't have the site for the webservice.
Please help
|
|
|
|
|
gerom77 wrote: I have only the wsdl file not the web service. My application is a windows service and I need to create the proxy class in order to call the webservice. I don't have the site for the webservice.
You don't need to have a site for webservice for generating proxy classes. You can add web reference of WSDL file from local disk too like c:\consumer.wsdl as an URL while adding a web reference.
Knock out 't' from can't,
You can if you think you can
|
|
|
|
|
hi there,
i got following error when downloading ZIP file having size 4GB
the error says
The size parameter must be between zero and the maximum Int32 value.
Parameter name: size
Actual value was 2166897372.
i have used following code
code]
Response.ContentType = "application/zip";
Response.AppendHeader("Content-Disposition","attachment; filename=SailBig.zip");
Response.TransmitFile( Server.MapPath("~/images/sailbig.zip") );
Response.End();
[/code]
what should i do ???
thanks in advance
koolprasad2003
Rating always..... WELCOME
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
koolprasad2003 wrote: i got following error when downloading ZIP file having size 4GB
the error says
Have you configured in your Web.Config to deal with such size of response?
Look here: http://msdn.microsoft.com/en-us/library/e1f13641.aspx[^]
Set appropriate MaxRequestLength attribute and try.
|
|
|
|
|
Hi Friends,
I need to save an arabic data into sql server using dataset.The Arabic data will be enteered correctly but it will be saved using a dataset.In Dataset the Arabic data willnot display correctly.It displays like ??.How can i solve the issue.I need to save the data in arabic format.But the data will be added into the dataset like ??.Please help me to overcome this issue.
|
|
|
|
|
Install Arabic MUI(localization pack) and then change your system to Arabic locale. You should be able to see the data in Arabic.
|
|
|
|
|
hi every1,
I am developing code in MVC project. I craeted a class in Model and define related function. the problem is I don't know what I have to write in Controller part.
this is my program
its my class:item.cs
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
namespace MvcApplication1.Models.Repository.DTO
{
public class Item
{
public int _id;
public int _code;
public string _description;
public string _creator;
public DateTime _created;
public int Id
{
set
{
_id = value;
if (value &lt; 0)
throw new ArgumentException(string.Format("Id should be greater than 0 !"));
}
get { return _id; }
}
public int Code
{
set { _code = value; }
get { return _code; }
}
public string Description
{
set { _description = value; }
get { return _description; }
}
public string Creator
{
set { _creator = value; }
get { return _creator; }
}
public DateTime Created
{
set { _created = value; }
get { return _created; }
}
public Item(int id, int code, string description, string creator, DateTime created)
{
this._id = id;
this._code = code;
this._description = description;
this._creator = creator;
this._created = created;
}
}
}
then in Model part in another class I write:
using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
using MvcApplication1.Models.Repository.DTO;
namespace MvcApplication1.Repository
{
public class ItemRepository
{
private const string datasource =
"Data Source= Dell\\SQLEXPRESS;Initial Catalog=DB_Furniture.mdf;Integrated Security=True;User Instance=True";
private SqlConnection _connection;
private SqlCommand _sqlcommand;
private SqlDataReader _datareader;
public ItemRepository()
{
_connection = new SqlConnection(datasource);
}
public void Insert(string code, string description, DateTime created, string creator)
{
_sqlcommand = new SqlCommand("Ins_item",_connection);
_sqlcommand.CommandType = CommandType.StoredProcedure;
_sqlcommand.Parameters.AddWithValue("@Code", code);
_sqlcommand.Parameters.AddWithValue("@Description", description);
_sqlcommand.Parameters.AddWithValue("@Created", created);
_sqlcommand.Parameters.AddWithValue("@Creator", creator);
_datareader = _sqlcommand.ExecuteReader();
}
}
}
the problem is here. I don't know what should I write in Controller part
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using System.Web.Mvc.Ajax;
using MvcApplication1.Models.Repository.DTO;
using MvcApplication1.Models.Repository;
using MvcApplication1.Repository;
namespace MvcApplication1.Controllers
{
public class FurnitureController : Controller
{
public ActionResult Index()
{
return View();
}
public ActionResult Create()
{
return View();
}
public ActionResult Craete(Item item)
{
try
{
ItemRepository ItemRep = new ItemRepository();
??????????????????????????????????????????????????????????????????????????????????
?
??
}
catch
{
}
}
}
}
Plaese help me what I have to write here. give me some code.
thxxxxxxxx
modified on Tuesday, June 29, 2010 11:19 AM
|
|
|
|
|
Code part is supposed to be in PRE block and not the text. It's not readable otherwise. Please format it such that one can look at it and reply back.
|
|
|
|
|
I edit the code. could u please check it now?thxxx
|
|
|
|