|
Also set the datasource property as
if(!IsPostBack)
{
ddl.DataSource = collection;
ddl.DataBind();
}
|
|
|
|
|
thank you for your reply,
I am using dataset to load the tables,
i then assign the column i want to show to the list.
how do i databind with the dataset object.
thank you
|
|
|
|
|
it is working now..
thanks everybody.
|
|
|
|
|
set like this
ddl.DataValueField = "columnname1";
ddl.DataTextField = "columnname2";
ddl.DataSource = datatable;
ddl.DataBind();
|
|
|
|
|
Hi All,
I will use application cache in my application. I want where the application cache is stored and which formation.
Please help me
Regards
Rameshkumar.T
|
|
|
|
|
|
Thank you.
But i didnt know which format and location the cache data is stored in web server?
Pleaes help me
Regards
Rameshkumar.T
|
|
|
|
|
P.T.R.K wrote: But i didnt know which format and location the cache data is stored in web server?
I think this all discussed in detail in the article..
data is stored as inmemory objects at the webserver
|
|
|
|
|
Unless they mean the prompilation cache for ASP.Net applications.. (unlikely but you never know):
C:\Windows\Microsoft.NET\Framework64\v2.0.50727\Temporary ASP.NET Files
|
|
|
|
|
i m working on DataList Updating. for that i have taken one label and ImageButton in ItemTemplate of DataList.
I have bound data to DataList in Page_Load Event, When i trying to perform editing in DataList then i m getting following error-
Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.
AND if i m using Response.write() in postback then i m getting following error-
Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed.
But if i m writting binding code in !IsPostBack then it is working .
AND if i m using LinkButton instead of ImageButton then it is working .
So plz tell me wht is the oproblen and how can i solve this problem
thank's
|
|
|
|
|
Here is the infamous error message
Object reference not set to an instance of an object. Yes, I know what the error message means...
Line 18: FuelDSTableAdapters.FuelTableAdapter dsFuelTableAdapter = new FuelDSTableAdapters.FuelTableAdapter();
Line 19: decimal totalFuel = (decimal)dsFuelTableAdapter.TotalFuel(DateTime.Parse(TextBox2.Text), DateTime.Parse(TextBox1.Text));
Weird thing is - it works based on the dates I put into the text boxes. I think it has something to do with when I moved the database from one pc to another...
If I do not query any data added to the database before I moved it to the new computer, it works. However, as soon as the dates I enter into the textboxes try to use new data - I get this error message.
I've deleted all the data - added some new data and now I get this error every time. Then, I deleted the database and added it as well as the ldf that accompanies it - it works only if I do not populate the db with any new data.  - that is the wtf face in case you are wondering.
|
|
|
|
|
May i ask, which object is null?
|
|
|
|
|
Line 19: decimal totalFuel = (decimal)dsFuelTableAdapter.TotalFuel(DateTime.Parse(TextBox2.Text), DateTime.Parse(TextBox1.Text));
Line 19 throws the object reference error - as you can see I instantiate the object in line 18
|
|
|
|
|
I see your Line 19, but I raise you an object 
Can you set a breakpoint and make sure your Textboxes aren't null?
Also, use your immediate window and do a DateTime.Parse(TextBox2.Text) to make sure that doesn't kack out.
Cheers,
|
|
|
|
|
TheyCallMeMrJames wrote: I see your Line 19, but I raise you an object
Can you set a breakpoint and make sure your Textboxes aren't null?
Also, use your immediate window and do a DateTime.Parse(TextBox2.Text) to make sure that doesn't kack out.
haha.
Text boxes are not null - the DateTime.Parse(TextBox) is also good... Wish it were that easy.
|
|
|
|
|
dorkyDonJuan999 wrote: Weird thing is - it works based on the dates I put into the text boxes. I think it has something to do with when I moved the database from one pc to another...
Could it be that both systems have different regional settings? The date-format is something that's defined system-wide, and can be set from the Control Panel.
If the conversion fails (from string to date), wouldn't that leave the object empty, thus resulting in said error?
I are Troll 
|
|
|
|
|
Double checked the regional settings, they are both the same...I think the problem was I did not properly detach the database from host pc and then try to restore from backup on the new pc. I just copied the file and used the add existing item option under visual studios app_data folder.
However, the database works fine with updates, inserts, general select queries...It is just the dates that cause the issue when their is new data that was inserted after I moved the DB file.
|
|
|
|
|
when i export arabic data to csv,some junk values are displayed instead of arabic text
this is my code
Private Sub WriteDelimitedData(ByVal Data As DataTable, ByVal fileName As String)
Dim i As Integer
Try
Dim context As HttpContext = HttpContext.Current
context.Response.Clear()
context.Response.ContentType = "text/csv"
context.Response.AppendHeader("Content-Disposition", String.Format("attachment; filename={0}", fileName))
context.Response.ContentEncoding = Encoding.UTF8
context.Response.Charset = "UTF-8"
'Write column header names
For i = 0 To Data.Columns.Count - 1
If (i > 0) Then
context.Response.Write(",")
End If
context.Response.Write(Data.Columns(i).ColumnName)
Next
context.Response.Write(Environment.NewLine)
'Write data
For Each row As DataRow In Data.Rows
For i = 0 To Data.Columns.Count - 1
If (i > 0) Then
context.Response.Write(",")
End If
context.Response.Write(row.Item(i).ToString())
Next
context.Response.Write(Environment.NewLine)
Next
context.Response.End()
Catch ex As Exception
End Try
End Sub
|
|
|
|
|
i have the same problem too
can any one help us plz
|
|
|
|
|
Hi,
I have put together some code based on an article I found on this site (http://www.codeproject.com/KB/sharepoint/SharePointFBAwDNN.aspx) on how to use DotNetNuke as the authorisation database provider.
While I can add users to the Policy for Web Application that come from the mebership provider, I cannot add any groups from the role provider.
Below is the code from the web application web.config.
*~*~*~*~*~*~*~*~*~*
<connectionStrings>
<add name="DnnSqlServer"
connectionString="Data Source=.\SQLExpress;Initial Catalog=DotNetNuke;User ID=dnnuser;Password=password"
providerName="System.Data.SqlClient" />
</connectionStrings>
.
.
.
<membership defaultProvider="DNNMembershipProvider" userIsOnlineTimeWindow="15">
<providers>
<clear />
<add name="DNNMembershipProvider"
type="System.Web.Security.SqlMembershipProvider"
connectionStringName="DnnSqlServer"
enablePasswordRetrieval="true"
enablePasswordReset="true"
requiresQuestionAndAnswer="false"
minRequiredPasswordLength="4"
minRequiredNonalphanumericCharacters="0"
requiresUniqueEmail="false"
passwordFormat="Encrypted"
applicationName="DotNetNuke"
description="Stores and retrieves membership data from the local Microsoft SQL Server database" />
</providers>
<membership>
<roleManager enabled="true" defaultProvider="DNNRoleProvider">
<providers>
<clear/>
<add name="DNNRoleProvider"
connectionStringName="DnnSqlServer"
applicationName="DotNetNuke"
type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</roleManager>
*~*~*~*~*~*~*~*~*~*
The web.config entries for the Application Management site are the same except the defaultprovider for RoleManager is AspNetWindowsTokenRoleProvider.
As I mentioned, adding users to the Policy for Web App seems to work so I know that the connection settings are correct.
Any ideas of why this won't work would be appreciated...
Thanks,
Baggy
PS... I switched off HTML for this post becuase it seemed to bugger up the code... even with the code block flags...
|
|
|
|
|
string branchid = "";
protected void Page_Load(object sender, EventArgs e)
{
branchid= Session["branchid"].ToString();
Response.ContentType = "image/jpeg";
Stream strm = ShowImage(branchid);
byte[] buffer = new byte[4096];
int byteSeq = strm.Read(buffer, 0, 4096);
while (byteSeq > 0)
{
Response.OutputStream.Write(buffer, 0, byteSeq);
byteSeq = strm.Read(buffer, 0, 4096);
}
Image1.imageurl=byteSeq;
}
public Stream ShowImage(string branchid)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["Safa"].ConnectionString);
string sql = "SELECT imgleft1 FROM tblImages WHERE BranchId = @BranchId";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@BranchId", branchid);
con.Open();
object img = cmd.ExecuteScalar();
try
{
return new MemoryStream((byte[])img);
}
catch
{
return null;
}
finally
{
con.Close();
}
}
hi iam using asp.net with c#
iam retreving image from database but i want to display in
image1.imageurl
but it is not displaying image
can you correct my code
modified on Sunday, May 16, 2010 8:59 AM
|
|
|
|
|
There is no url to display. You understand what a url is right?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Without digging too much into your code, i assume this is the problem:
The code you use - working or not - retrieves the actual image file from the
database, not the url. You try to write this image to response stream on
page load - working or not. This is totally ok, you have to do the following:
- Build a Page or Httphandler which writes the image to response stream
similar to what you did in your code-snippet
- In ANOTHER page, you set the imageurl of your image to this previously implemented "image-page" or handler.
This way, you get the desired effect. If i understood you correctly.
|
|
|
|
|
Hi,
I am trying to retrieve specific records from a table by specifying the parameter value at run time but the following error keeps occuring when i pass in a value of the correct data type.
System.Data.OleDb.OleDbException: No value given for one or more required parameters.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
at Service.RetrieveComments(Int32 ThreadID)
As you can tell from the error message I am using Microsoft Access database provider.
The data type for ThreadID is 'Number' and the field size is set to 'long integer'. The field does exist in the table. In my code I even tried changing datatype from 'int' to 'uint64' but that didnt solve the problem.
Here is the code I had developed.
<br />
[WebMethod]<br />
public DataSet RetrieveComments(int ThreadID)<br />
{<br />
<br />
String queryString = "SELECT * FROM [Comments] WHERE" + "([ThreadID]=@ThreadID)";<br />
DataSet dataSet = new DataSet();<br />
String connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/MyDatabase.mdb;Persist Security Info=True";<br />
OleDbConnection dbConn = new OleDbConnection(connString);<br />
OleDbDataAdapter dbAdapter = new OleDbDataAdapter(queryString, dbConn);<br />
dbConn.Open()<br />
dbAdapter.Fill(dataSet, "Comments");<br />
dbConn.Close();<br />
return dataSet;<br />
}<br />
Is there anything wrong with the above code?
I have tried the above SQL query in MS Access and it runs fine providing I remove the quotes and the "+" operator.
I would much appreciate if anybody could assist me please?
Thanks in advance.
|
|
|
|
|
The problem is because you are not setting the parameter value. Also, you need to use the ? and not a named parameter @ThreadID in the query.
public DataSet RetrieveComments(int threadID)
{
String connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|/MyDatabase.mdb;Persist Security Info=True";
OleDbConnection dbConn = new OleDbConnection(connString);
String queryString = "SELECT * FROM [Comments] WHERE [ThreadID] = ?";
OleDbCommand oleDbCommand = new OleDbCommand(queryString, dbConn);
oleDbCommand.Parameters.Add("@threadID", OleDbType.Integer, 10).Value = threadID;
OleDbDataAdapter dbAdapter = new OleDbDataAdapter();
dbAdapter.SelectCommand = oleDbCommand;
dbConn.Open();
DataSet dataSet = new DataSet();
dbAdapter.Fill(dataSet, "Comments");
dbConn.Close();
return dataSet;
}
Make sure the parameters and syntax are okay. Also use the using statement to make sure your objects get disposed properly.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
