|
Which type of report you need to generate?
Sathesh.
Blessed is the season which engages the whole world in a conspiracy of love.
|
|
|
|
|
Is crystal report is possible
|
|
|
|
|
Everything is possible.
Sathesh.
Blessed is the season which engages the whole world in a conspiracy of love.
|
|
|
|
|
Dear friends
I am working with asp.net & vb.net for an intranet web application.
There is login system for employee to work on it.
Suppose, Ajay logined from a system, and he wants to login from another system.
I want that he logined from another system, but logout from frist system.
How it can possible?
Thanks in advanced for reply....
Sanjeev
|
|
|
|
|
Store a list of session ids in the database. When a user logs in update the session ID in the database. After that, each time a user does something check that the session id they currently have matches the one in the database. If it doesn't match log them out. If it does match allow them to proceed.
Although it cannot imdiately log someone out (that is the nature of web applications). It does mean that the moment they try and do something they will be required to log in again.
|
|
|
|
|
Hi all,
I make one application in which i have one requirement that, i have to put multiple emailids with semicomma seperated like - "abc1@abc.com; abc2@abc.com; abc3@abc.com; ..."
but its give me an error when i assign it in "To"!!!!
When i put single emailid then it don't gives any error...
Need some suggesion to solve this issue...
Krishnraj
|
|
|
|
|
You need to write some code. Sorry about that. You need to turn your list of emails into a collection of addresses which get applied to the to and the bcc, I guess.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi Christian,
First-of-all thanks for replying...
there is no issue to put the code and here is my code...
Dim Strsmtp As New System.Net.Mail.MailMessage
' MailFrom and MailTo come from the database
Dim from As New System.Net.Mail.MailAddress(objReader("MailFrom").ToString())
' Here i Put hard code emailids
Dim toList As New System.Net.Mail.MailAddress("abc1@abc.com;abc2@abc.com")
Strsmtp.From = from
Strsmtp.To.Add(toList)
Strsmtp.Subject = "Hi"
Strsmtp.IsBodyHtml = True
Strsmtp.Headers.Add("Content-Type", objReader("MailContentType"))
Strsmtp.Headers.Add("Reply-To", objReader("MailReplyTo"))
Strsmtp.Body = "Test"
Dim sp As New System.Net.Mail.SmtpClient()
sp.Send(Strsmtp)
and when i put the single emailid, then it gives different error that - Host Name is not specified.
But i already specified host name in my web.config file. Here is the code..
<system.net>
<mailSettings>
<smtp>
<network host="localhost" />
</smtp>
</mailSettings>
</system.net>
as i work in my local pc, so i write "localhost"...
Now i don't understand what i have to do???
Krishnraj
|
|
|
|
|
The issue is that the object you call toList is not a list but a single object. You must add a separate MailAddress object for each address in your string.
|
|
|
|
|
Dear All, I am having problem in configuring .aspx in window xp.
i have configured IIS and create it virtual directory as well.
when i am executing .aspx file from "localhost/folderName"
I am getting the following error
Line 26:
Line 27:
Line 28: <sessionstate timeout="60"></sessionstate>
Line 29: <authorization>
Line 30: <allow users="?" /></authorization>
the error appears in this line
Source File: C:\Inetpub\wwwroot\folderName\web.config Line: 28
I can run this without any error from VWD or VS 2005.
modified on Saturday, March 28, 2009 2:22 AM
|
|
|
|
|
What is the actual error message?
|
|
|
|
|
I have a form with many controls and on several of the controls there is a on leave handler added. where each one connects to db and does validation and disconnects. is there a way i can connect to the db only once and then when submit is hit...disconnect. so i don't have many connect disconnects.
This is for ASP.net website form.
modified on Friday, March 27, 2009 9:25 PM
|
|
|
|
|
You should try using a dataset instead of making mutiple calls to the database. When you use a dataset, you'll make one query to your database and populate the dataset with that information. At which point you can bind that data to your controls. The link below is the msdn article for working with Datasets.
http://msdn.microsoft.com/en-us/library/system.data.dataset.aspx[^]
hope this helps
|
|
|
|
|
I can't use that because the reason i am making multiple calls is to validate the value in the text box control. So there are many controls that need validation..so on postback all this happens.
Is there any other way ... to keep a global db connection open for that page till submit is hit.
|
|
|
|
|
my gridview has image and when i try to edit and click update i get this
Server Error in '/WebSite2' Application.
--------------------------------------------------------------------------------
Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +177
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +68
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2305
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +147
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +1021
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +314
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +413
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +115
System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +392
System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +643
System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78
System.Web.UI.WebControls.GridView.HandleUpdate(GridViewRow row, Int32 rowIndex, Boolean causesValidation) +1217
System.Web.UI.WebControls.GridView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +853
System.Web.UI.WebControls.GridView.OnBubbleEvent(Object source, EventArgs e) +87
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.GridViewRow.OnBubbleEvent(Object source, EventArgs e) +117
System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35
System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +86
System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +155
System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4921
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Can someone guide me????
|
|
|
|
|
learningman wrote: Implicit conversion from data type nvarchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.
don't you think this error is self explanatory? check your input.
Yusuf
Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]
|
|
|
|
|
learningman wrote: Can someone guide me????
Well, as Yusuf said, the message is self explanatory. You have something that is a string (nvarchar) that you are treating as binary (varbinary) in SQL Server. SQL Server can't do that implicity. You have to be explicity and tell it how you want the information converted (or just confirm that you do really want it converted and it isn't an error in your code)
Since you've not shown the SQL code (this is a SQL Exception after all) we can't guide you into the portion that may be causing the error.
|
|
|
|
|
I have three ListBox on a page. Select a few items from ListBox1 and then click a button, the selected items are added to ListBox2 and ListBox3. Here is the interesting behavior I observed. See the code below. After the first loop, items are added to ListBox2. I de-select the added items in ListBox2 (ListBox2.SelectedIndex=-1). This statement not only de-select items in ListBox2 but also causes the loss of selections in ListBox1. As a result, the second loop does not add anything to ListBox3. If this statement is commented out, the second loop add all selected items from ListBox1 to ListBox3. Does anyone know why this is happening? Is this a designed behavior? How to workaround this? Thanks,
foreach(ListItem itm in ListBox1.Items)
{
if (itm.Selected)
{
ListBox2.Items.Add(itm);
}
}
ListBox2.SelectedIndex = -1; //This line makes difference
foreach (ListItem itm in ListBox1.Items)
{
if (itm.Selected)
{
ListBox3.Items.Add(itm);
}
}
TOMZ_KV
|
|
|
|
|
hi..
Try out this..
foreach (ListItem itm in ListBox1.Items)
{
if (itm.Selected)
{
ListBox2.Items.Add(itm);
}
}
foreach (ListItem itm in ListBox1.Items)
{
if (itm.Selected)
{
ListBox3.Items.Add(itm);
}
}
ListBox2.SelectedIndex = -1;
And following will be the best option according to me:
foreach (ListItem itm in ListBox1.Items)
{
if (itm.Selected)
{
ListBox2.Items.Add(itm);
ListBox3.Items.Add(itm);
}
}
ListBox2.SelectedIndex = -1;
Thanks..
|
|
|
|
|
Thanks for your reply. Your solution definitely work. However, I placed one loop into a class to reuse it for all list controls like the following:
public void MoveListItem(ListControl Box1, ListControl Box2)
{
foreach (ListItem itm in Box1.Items)
{
if (itm.Selected)
{
Box2.Items.Add(itm);
}
}
Box2.SelectedIndex = -1;
}
I then call the method:
MoveListItem(ListBox1, ListBox2);
MoveListItem(ListBox1, ListBox3);
I guess the possible workaround could be to remove the de-selection statement Box2.SelectedIndex=-1 from the method and use it outside of the method:
MoveListItem(ListBox1, ListBox2);
ListBox2.SelectedIndex = -1;
MoveListItem(ListBox1, ListBox3);
ListBox3.SelectedIndex = -1;
Another possible way is to place ListItemCollection in the mehod to hold the selected items from Box1. After adding items to Box2, re-select the items in Box1. In this case, no de-selection is needed outside of the method call.
These are all workarounds. I still think the Box1 should not lose its selection when Box2 selection is cleared.
Thanks,
TOMZ_KV
|
|
|
|
|
The issue was resolved. It is object reference that results in this behavior. When adding to ListBox2, create a new ListItem object to avoid the object reference between ListBox1 and ListBox1 like that following
ListBox2.Items.Add(new ListItem(itm.Text, itm.Value);
instead of
ListBox1.Items.Add(itm);
TOMZ_KV
|
|
|
|
|
When I bring in a Report Viewer to my web form in crystal 11.5.37 it automatically adds references to 11.5.33 as well as 11.5.37 giving me duplicate references errors. If I delete the 11.5.33 references, it keeps recreating them when I build the web site. How can I permanently destroy them?
|
|
|
|
|
It turns out that Crystal 11.5 is not compatable with Visual Studio 2008. I need to update to Crystal 2008.
|
|
|
|
|
Hello to everybody, i hope you can help me, I have a dataset which contains datas from a table..this table has 2 fields (id and data) both are string, well i want to do this:
i need to get all the datas from every id and save them into an array, i need this for every id...
Note: the id may be repeated according to the number of datas that contains that id.....for example:
...........................................................................
This is what my dataset contains
ID DATA
-------- ----
04231050 368 ...here you can see that the id is repeated
04231050 234 ...
04333333 445 ......other id repeated
04333333 557 ......
04235789 786
...........................................................................
But I want it like this:
ID DATA DATA
-------- ---- ----
04231050 368 234
04333333 445 557
04235789 786
modified on Monday, April 6, 2009 2:10 PM
|
|
|
|
|
Not really related to Asp.Net.
I recommend you to repost your question in the appropriate forum to enhance the chance to get a proper answer.
But until then you can read up on Jagged Arrays here[^] or here[^] depending on your lingual taste.
"Lots of programmers have had sex - some have even had it with members of the same species." - Pete O'Hanlon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
