|
yes but no way at all ?
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
I am not sure. BTW, why you need to do this?
|
|
|
|
|
Single exe, i know its not good but i need
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Generally speaking, modifying a compiled assembly at runtime is a bad idea. You run the risk of corrupting the assembly. Beyond that, many virus scanners keep track of file sizes for executable type files on a system. If the size of an executable changes, virus scanners identify that as a virus (since they usually tack themselves onto executable packages, modifying their size). Merging resources into an executable is a pretty bad idea, and even if it were possible (its .NET...so it probably is), I wouldn't recommend it.
|
|
|
|
|
Hi Guys,
Ive tried to do a simple caching application and have traced/debugged it, however it does not seem to store the datatable into the cache.
No matter how many times I load it it always retrieves the data from the Database instead of the cache after refreshing the page. Could someone interpret my code, Cheers.
public partial class Caching_ApplicationCaching : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
string query = "SELECT FIRSTNAME, LASTNAME FROM CUSTOMERS";
DataView source = (DataView)Cache["Client"];
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString()))
{
if (source == null)
{
conn.Open();
SqlCommand command = new SqlCommand(query, conn);
SqlDataAdapter adapter = new SqlDataAdapter(command);
command.CommandType = CommandType.Text;
adapter.Fill(ds, "Customers");
Cache.Insert("Client", ds);
foreach (DataRow item in ds.Tables["Customers"].Rows)
{
string Firstname = item["FirstName"].ToString();
DropDownList1.Items.Add(Firstname);
source = new DataView(ds.Tables["FirstName"]);
Cache["Client"] = source;
}
}
else
{
DropDownList1.DataSource = source;
DropDownList1.DataBind();
}
}
}
}
|
|
|
|
|
CrimeanTurtle2008 wrote: Cache.Insert("Client", ds);
Here you are putting the DataSet in the cache, which is pointless as you later overwrite it.
CrimeanTurtle2008 wrote: source = new DataView(ds.Tables["FirstName"]);
Cache["Client"] = source;
Here you try to read a table named "FirstName" from the DataSet, but there is no such table so you get an empty DataView.
Then you replace the value in the cache with the empty DataView. For some reason you do this over and over, once for every row in the table "Customers", but it doesn't help how many times you do it as long as there is no DataTable.
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
How would I remedy this?
Would I need to insert the dataset into the cache after declaring what the
source is?
|
|
|
|
|
CrimeanTurtle2008 wrote: Would I need to insert the dataset into the cache after declaring what the
source is?
You already insert the DataSet into the cache. If you have a cached DataSet then use that rather than what ever it was you were attempting to insert.
|
|
|
|
|
CrimeanTurtle2008 wrote: How would I remedy this?
You store in the cache what you want to fetch from the cache.
CrimeanTurtle2008 wrote: Would I need to insert the dataset into the cache after declaring what the
source is?
Why would you want to insert the DataSet in the cache? Aren't you trying to store a DataView?
By the way, why are you trying to store a DataView? Why not store the DataTable?
Despite everything, the person most likely to be fooling you next is yourself.
|
|
|
|
|
Hmm ok, I will tinker with what you recommended ,Thanks.
|
|
|
|
|
public partial class Caching_ApplicationCaching : Page
{
const string QUERY = "SELECT firstname, lastname FROM customers";
const string CACHE_KEY = "Client";
protected void Page_Load(object sender, EventArgs e)
{
DataTable source = GetCustomersTable();
DropDownList1.DataSource = source;
DropDownList1.DataTextField = "FirstName";
DropDownList1.DataBind();
}
private DataTable GetCustomersTable()
{
DataTable source = (DataTable)Cache[CACHE_KEY];
if (source == null)
{
source = PopulateCustomersCache();
}
return source;
}
private DataTable PopulateCustomersCache()
{
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
using (SqlCommand command = new SqlCommand(QUERY, conn))
{
conn.Open();
command.CommandType = CommandType.Text;
SqlDataAdapter adapter = new SqlDataAdapter(command);
DataSet ds = new DataSet();
adapter.Fill(ds, "Customers");
DataTable dt = ds.Tables["Customers"];
Cache.Insert(CACHE_KEY, dt);
return dt;
}
}
}
}
|
|
|
|
|
I was just about to write an answer to this question until I saw your response - which is almost exactly what I was going to write!!
It definitely isn't definatley
|
|
|
|
|
Well, as they say...Great minds think alike, right? 
|
|
|
|
|
When are app config settings for a windows service initialized.
During a restart event?
During a Start event?
During OnContinue event?
During Runtime?
At install time?
For example:
OracleConnection oConn = new OracleConnection(ConfigurationManager.AppSettings["DatabaseConnection"].ToString());
is used at the time that its needed and is working. Currently I'm not making this call or similar in any of the service events. Should I be?
When are you pro's assigning windows service config options? Whats the recommended way to handle config changes?
p.s. If I've posted in the wrong forum, please flame away.
Just because we can; does not mean we should.
|
|
|
|
|
KaptinKrunch wrote: and is working. Currently I'm not making this call or similar in any of the service events.
I'm confused, if your're not using it how do you know its working?
If you want to monitor for changes to a file you'd use something the FileSystemWatcher. In the case of your connection string it would be read as it was accessed, and you should be using ConnectionStrings instead of AppSettings
only two letters away from being an asset
|
|
|
|
|
I'd go for the simplest solution first, which is onStart (also takes care of Restart)
Sunny Ahuwanya
"The beauty of the desert is that it hides a well somewhere"
-- Antoine de Saint Exupéry
|
|
|
|
|
Hi,
whats wrong in this code. iam getting this error at AddWithValue. what value i need to set for what.
protected void GridView2_RowUpdating(Object sender, GridViewUpdateEventArgs e)
{
string connectionstring = WebConfigurationManager.ConnectionStrings["RoyalHotelManagement"].ConnectionString;
SqlConnection con = new SqlConnection(connectionstring);
SqlCommand cmd = new SqlCommand("InsertSuite", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@filleddate", GridView2.SelectedRow.Cells[3].Text);
cmd.Parameters.AddWithValue("@freedate", GridView2.SelectedRow.Cells[4].Text);
cmd.Parameters.AddWithValue("@nameofcustomer", GridView2.SelectedRow.Cells[7].Text);
try
{
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
}
thanks in advance
|
|
|
|
|
I am guessing that something in the GridView is null. It could be:
1. SelectedRow, if there is no selected row.
2. Any of the cells
3. The Text value of the cell (null string)
|
|
|
|
|
hi,
yes database values are null(gridview is populated with database values), i need to input the values through gridview in edit mode.
|
|
|
|
|
I understand that the database values are null...I was talking about GridView values. Your NullReferenceException is most likely because the SelectedRow is null, or the Text of one or more Cells is null. Both will cause a NullReferenceException.
|
|
|
|
|
As has already been said, it could be a null SelectedRow, or the value in the Cells might be null. What you need to do is put a breakpoint on the line with the first AddWithValue (just click F9 to insert the breakpoint), and then run the application. When you hit this method, hover your mouse over the different properties until you see one that pops up the tooltip "null".
There - now you know how to solve these issues for yourself.
|
|
|
|
|
hi,
but i need to input values to the blank cells. i cannot populate them with some other values. they has to be null/blank.
|
|
|
|
|
First of all try to explain what you want to do with the code.
if you want to store the value (which is added directly in the gridview) in the database,
then try to use GridView2.Rows[e.RowIndex].Cell[3].Text for all the cells, becuase it can be possible that no rows selected at that time.
also assign the Values of the gridview to some variable and the check wether the value is null or not.
i.e.
string FilledDate = GridView2.Rows[e.RowIndex].Cell[3].Text;
if (FilledDate != null)
cmd.Parameters.AddWithValue("@filleddate", FilledDate);
else
cmd.Parameters.AddWithValue("@filleddate", "");
-----------------------
or you can use directly
e.NewValues[3] Instead of GridView2.SelectedRow.Cells[3].Text
in your original code.
e.NewValue will give you all the new updated values.
e.OldValue will give you all the old existing values.
do this for all the fields.
and one more thing give GridView2 some appropriate Name, instead of using auto generated name.
|
|
|
|
|
This is quite confusing. Your procedure name is InsertSuite, which sounds like you're inserting data into the database. However you're executing a reader so it seems like you're actually fetching data. This is also the impression from your replies.
If you're trying to update the database I think you should use e.RowIndex to get the actual row, but if you're trying to fetch the data I think you should use different event since RowUpdating is raised when rows update button is clicked.
|
|
|
|
|
SALAM SIR;
HOW CAN MADE MESSENGER IN C#.NET?
HOW CAN MADE STUDENT FORM IN C#.NET?
THANKS SIR
mohammedali
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
