|
i have design a report with crystal report where main report has some parameter and as well as main report has also
a sub report and that sub report also has parameter. so at the runtime how can i pass the parameter for the both i mean
pass parameter for main report and as well as for sub report. please guide me with sample code.
thanks in advancetbhattacharjee
|
|
|
|
|
|
|
stancrm wrote: if I forgot to use lock,
how to detect this error ?
If you "forget" to use proper coding techniques or test your code the indication will be when you loose your job.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
As the initiator it is your responsibility to communicate effectively.
Don't start getting an attitude because you can't ask the proper questions or don't know how to to test your code. If you can't be civil then go elsewhere.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
|
http://www.codeproject.com/Messages/1278604/How-to-get-an-answer-to-your-question.aspx[^]
6. Do not remove or empty a message if others have replied. Keep the thread intact and available for others to search and read. If your problem was answered then edit your message and add "[Solved]" to the subject line of the original post, and cast an approval vote to the one or several answers that really helped you.
8. Be courteous and DON'T SHOUT. Everyone here helps because they enjoy helping others, not because it's their job.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi guys,
I have a problem when synchronizing web publication.
I begin by giving you an insight into my soft installed:
sql-server 2005
7even-windows so IIS7.5
I created a publication MaPublication.I made a right click on publication-> Release Local> MaPublication then I chose to configure synchronization Web.Then, next-> sql server mobile-> created a new directory select default website ->next->in Alias: SQLCE-> 2 messages appear successively OK OK-> next-> clients connect anonymously-> next-> OHH now when I click on the Edit tab to change a user account error message appears:
The program can not open the required dialog box because no location has been found.Close this message and try again
What is the problem? Is it a problem IIS??
Thank you for your contribution
|
|
|
|
|
You posted in the wrong forum.
This is technically a cross post as well - since you have also posted in the General Database section.Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
modified on Tuesday, March 16, 2010 7:47 AM
|
|
|
|
|
Hey Experts 
I have a littel problem maybe som of experts can help me:
I have this code to select somthing for sql database, now i need to send this query like email, how can i send the Dataset like email ?
The code:
int Customerid =(int)(dr["CustomerId"]);
string customer = dr["Customer"].ToString();
SqlCommand cmd2 = new SqlCommand("licensesexpireddato", con);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@KundeID", Customerid);
DataSet ForDataset = new DataSet();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(ForDataset);
cmd2.ExecuteNonQuery();
I hope i can help me, sorry my english.
|
|
|
|
|
You can't send it directly as e-mail as the object would need to be marshalled across an application boundary.
One of the following is probably what you need:
1. Expose your method in a WCF/Web service
2. Google "Serialization", which allows you to write objects out as text.Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
A dataset is an XML document, so you could use an XSLT transform to convert your dataset XML to text or HTML, then send it to an email recipient.
|
|
|
|
|
I have a bytes array and I want to create a new video file, I need to know exactly what the fomat's structure should be and then add the data chunk.
|
|
|
|
|
yftah1989 wrote: I need to know exactly what the fomat's structure should be
That depends on the codec used to compress the movie. This CodeProject-article[^] might get you started  I are Troll 
|
|
|
|
|
I think you can use the DirectShow, and it can help you get the type of the video and decode the video.
Try this:
http://en.wikipedia.org/wiki/DirectShow
modified 27-May-14 4:48am.
|
|
|
|
|
Hi,
I'm wondering if there is a way to achieve this :
I know you can but some arguments to the compiler to condition compiling with #if #else #endif
But what if I would like to have in some cases :
using namespace1.subspace1; //in one case
using namespace2.subspace3; //in another case
and so on ... without knowing by advance the list of namespaces (in a code file used by several projects)
I wish I could write :
using #MYNAMESPACE;
telling the compiler MYNAMESPACE=namespace1.subspace1
Is there any syntax for this ?
Thanks
|
|
|
|
|
Do you mean using a namespace alias as shown here[^]?Me, I'm dishonest. And a dishonest man you can always trust to be dishonest.
Honestly. It's the honest ones you want to watch out for...
|
|
|
|
|
|
Yes this is approximately what I need, with the "using project=namespace.project" statement beeing outside the code file, so I do NOT have to change the content of the code file in each project using it ...
|
|
|
|
|
This should be really simple, but im having one of those mornings...
Im trying to close my connection, but its staying open
if (Border.BLL.Inventory.SqlConnect.GetConnection().State == ConnectionState.Open)
{
Border.BLL.Inventory.SqlConnect.CloseConnection();
}
//BLL
public static SqlCeConnection CloseConnection()
{
return DAL.Helpers.SQLconnect.CloseConnection();
}
//DAL
public static SqlCeConnection GetConnection()
{
SqlCeConnection conn = new SqlCeConnection();
try
{
conn.ConnectionString = Helpers.ConnectionCommand.ConnectionString;
conn.Open();
return conn;
}
catch(Exception e)
{
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
Border.Model.Helpers.FileWriter.Write(e.ToString(), true);
}
return conn;
}
public static SqlCeConnection CloseConnection()
{
try
{
if (GetConnection() != null)
{
if (GetConnection().State == ConnectionState.Open)
{
GetConnection().Close();
}
}
return GetConnection();
}
catch (Exception e)
{
if (GetConnection().State == ConnectionState.Open)
{
GetConnection().Close();
}
Border.Model.Helpers.FileWriter.Write(e.ToString(), true);
}
return GetConnection();
}
|
|
|
|
|
Please put your code in <pre> tags, it is currently difficult to read.
consider using the following snippet:
using(SqlCeConnection connection = GetConnection())
{
}
as this will close the connection automagically for you, even if the database call throws an exception.Dalek Dave: There are many words that some find offensive, Homosexuality, Alcoholism, Religion, Visual Basic, Manchester United, Butter.
Pete o'Hanlon: If it wasn't insulting tools, I'd say you were dumber than a bag of spanners.
|
|
|
|
|
Hi,
I went through your code, and got a point to tell you if that helps. I noticed that in catch block in DAL you are closing the connection only if the connection state is OPEN. I remember there is another option that you may also check before you are closing the connection and that is BROKEN. So what I am suggesting is ,
if ((GetConnection().State == ConnectionState.Open)||((GetConnection().State == ConnectionState.Broken))
{
GetConnection().Close();
}
or
if (GetConnection().State != ConnectionState.Closed)
{
GetConnection().Close();
}
Give a try and let me know.Thanks,
Arindam D Tewary
|
|
|
|
|
Arindam Tewary wrote: if ((GetConnection().State == ConnectionState.Open)||((GetConnection().State == ConnectionState.Broken))
This isn't a good idea since his code is returning a new connection object on every call to GetConnection. It's not returning the same connection object, but a new one every time. So, you're comparing the first connections .State to Open OR the second connection objects state to Broken. It's not doing what you think it's doing.
|
|
|
|
|
doh!
thanks that makes perfect sense.
|
|
|
|
|
I deduce inquiry data from data base in dataGridView (on image) I wish to deduce these data in Excel as on the image. How to me it to make?
http://www.cyberforum.ru/windows-forms/thread105166.html#post601894
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
