|
|
Try using RotateTransform method.
C isn't that hard: void (*(*f[])())() defines f as an array of unspecified size, of pointers to functions that return pointers to functions that return void
"Always program as if the person who will be maintaining your program is a violent psychopath that knows where you live." - Martin Golding
|
|
|
|
|
Not sure if it is a Sql issue or a syntax error of sorts so here it is.
I have a DataTable with a single column Player Name. It is filled with some 20,000 rows. I need to insert this into a Sql database.
I have a Sql database setup with a table called Unknown, it has 2 columns, an Indentity column ID, and a varchar(50) column Player Name.
I copied the data over one-by-one and it took like 15-30 minutes to do, not I am using SqlBulkCopy. The problem is, it simply isn't working. No error, no warnings, no nothing. I have SQL Profiler open and don't see it even hitting the database. Code is attached, what am I doing wrong?
SqlConnection connection = new SqlConnection(Properties.Settings.Default.TibiaSQLConnection);
connection.Open();
SqlBulkCopy copier = new SqlBulkCopy(connection);
copier.BatchSize = 500;
copier.NotifyAfter = 1000;
copier.SqlRowsCopied += new SqlRowsCopiedEventHandler(copier_SqlRowsCopied);
copier.DestinationTableName = "Unknown";
copier.WriteToServer(dtUnknowns);
copier.Close();
connection.Close();
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
copier.ColumnMappings.Add(sourceCol, DestColumn);
Just a note: I would open the connection right before WriteToServer() method and wrap it in a try block and catch exceptions
|
|
|
|
|
It all is wrapped in a try except. That was just a snippit. Let me try that and see how it works.
Do you have to do that even when both columns have the same name?
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
That worked great, thanks a ton.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
hi
I want to implement data versioning in a application...
I need a Text Diff class library
where can I find it?
thanks.
Mohammad Khansari
modified on Monday, December 22, 2008 2:00 AM
|
|
|
|
|
Hello,
I have an .NET 1.1 C# application that gets it's input from webservices and saves proccessed info to SQL2005 database. First I deserialize the webservices envelope, then iterate over elements I care about and then call a stored procedure to save the processed info. Problem is - dates sometimes don't parse correctly.
After I get the date element from XML, I converted it to .NET datetime by first checking if it's a datetime using DateTime.Parse() and checking if conversion from text was successful (if not, some other value from earlier data is used). Then I use Convert.ToDateTime() to actually convert it to datetime.
Works fine. BUT. If I put the program on another machine (a server to be exact), from time-to-time, some dates do not get converted (DateTime.Parse wont cooperate when checking if conversion is possible). I suspect it might have something to do with globalization (as they DO get converted on MY machine, but not on the other) but other than that, I have no ideas.
To counter it, I thought of trying to Convert the datetime using XmlConvert.ToDateTime() but that failed, too. Then I tried to convert it using DateTime.ParseExact() like this:
IFormatProvider format = new System.Globalization.CultureInfo("en-US", true);
DateTime.ParseExact(xmlDate, pattern, format, DateTimeStyles.AdjustToUniversal);
However, then I got an exception complaning that DateTime has to be between 1773 and 9999 or something like that, which totally freaked me out as debugging showed that my datetime that generated such an error was something like 2. december 2008.
Any ides ?
Best wishes from Tallinn, Estonia
|
|
|
|
|
A) Always use an ISO 8601-compliant format, particularly in XML and when international communication is involved.
B) Yes, DateTime is affected by the system's "Regional and Language Options". I always set Short Date Format to yyyy-MM-dd with -
|
|
|
|
|
hi all,
i want to run the slide show say ten slides and then close it programaatically , but in my code given below it opens the slide show and closes immediately ... ..
please give me a solution to this problem
Microsoft.Office.Interop.PowerPoint.Application ppApp = new Microsoft.Office.Interop.PowerPoint.Application();
ppApp.Visible = MsoTriState.msoTrue;
Presentations ppPresens = ppApp.Presentations;
Presentation objPres = ppPresens.Open(fullPath, MsoTriState.msoFalse, MsoTriState.msoTrue, MsoTriState.msoTrue);
Slides objSlides = objPres.Slides;
Microsoft.Office.Interop.PowerPoint.SlideShowWindows objSSWs;
Microsoft.Office.Interop.PowerPoint.SlideShowSettings objSSS;
objSSS = objPres.SlideShowSettings;
objSSS.StartingSlide = 1;
objSSS.EndingSlide = objSlides.Count;
objSSS.Run();
objSSWs = ppApp.SlideShowWindows;
for (int i = objSSS.StartingSlide; i <= objSSS.EndingSlide; i++)
{
System.Threading.Thread.Sleep(100);
}
objPres.Close();
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(objPres) > 0) { };
objPres = null;
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(ppPresens) > 0) { };
ppPresens = null;
ppApp.Quit();
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(ppApp) > 0) { };
ppApp = null;
I have tried with
System.Threading.Thread.Sleep(10000);
but not worked.
|
|
|
|
|
|
kirandilip wrote: the date difference between two datetimepickers is lessthan 7 then only application run otherwise to display a error message
I didn't get your above line.Can you be more specific.Application run means?
Cheers!!
Brij
|
|
|
|
|
I guess the point is some kind of a trial protection...
Regards,
Lev
|
|
|
|
|
Check the DateTime and TimeSpan structures
Regards,
Lev
|
|
|
|
|
Hi
I have to insert value in db from textbox which create at runtime i have done the coding the for creating it
but need help in inserting value in Database?
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
if (txtbox.Text != "")
{
CreateControl();
}
}
}
private void CreateControl()
{
TextBox txttest;
LiteralControl LCT1;
for(int i=0; i <= Convert.ToInt32(txtbox.Text)-1;i++)
{
LCT1=new LiteralControl ();
LCT1.Text="
";
txttest=new TextBox ();
txttest.ID="txt"+ (i+1);
Panel1.Controls.Add(LCT1);
Panel1.Controls.Add(txttest);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
for(int i=0; i<= Convert.ToInt32(txtbox.Text)-1;i++)
{
TextBox txtCntrl=(TextBox)Panel1.FindControl("txt"+(i+1));
if(txtCntrl != null)
{
TextBox tbox = new TextBox();
tbox.Text=tbox.Text + "tbox"+txtCntrl.Text;
}
}
}
any help
|
|
|
|
|
your main issue, apart from variables with names like Panel1 and txtbox ( and code that will blow up if someone types a non number into a textbox ) is that you're asking ASP.NET questions outside the ASP.NET forum.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi all,
Can anybody tell how to hide the query string in the url and how to make the website working on the https.
Thanks
|
|
|
|
|
HTTPS is just a secured website, you'll need a certificate and it's not too difficult using IIS.
Hiding the QueryString requires URL Rewriting, CP has some good articles.
Now you should have some search terms for Google and CP.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
Hi,
Thanks for the answer but I had some queries :-
(i)
I had created the certificate by right clicking the Default web site icon in the iis but i donot no how to use it for my website.
(ii) I had used the server.transfer to hide the query string on the first page load it does not show query string but when button is clicked it again shows the query string.
Thanks
|
|
|
|
|
tauras81 wrote: I had created the certificate by right clicking the Default web site icon in the iis but i donot no how to use it for my website.
Just access your website with HTTPS.
tauras81 wrote: I had used the server.transfer to hide the query string on the first page load it does not show query string but when button is clicked it again shows the query string.
If you feel query string is insecure, why not using other state management techniques?
|
|
|
|
|
Again, you can use Google to find out how to do the HTTPS side of it, and search for articles here on CP that have to do with URL Rewriting.
The best way to accelerate a Macintosh is at 9.8m/sec² - Marcus Dolengo
|
|
|
|
|
As others have said, if you are scared of putting stuff on the URL, then don't put it there. Use the session instead. Typically you shouldn't have to put much in the session, but anything that is a security issue, goes there.
Just to add, you're lucky to get so much help, given that you asked in the wrong forum.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Guys,
How to match single specified character with regular expression?
E.g. I should be able to get string with single slash only "\something" not something "\\something".
Thanks.
|
|
|
|
|
Search for the slash followed by any character that's not a slash. There's a great program called Expresso you can get from CP and elsewhere, it really helps with building regex.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hello
I have 2 tables: Comperitor(idcompetitor, Name, Adress) and Competition(idcompetition, About, Town). Between them is a also table named Participate(PFK idcompetitor, PFK idcompetition, Date)[because relationship is N:M]
I have those tables on my sql server 2005 and on dataset inside vs.05. I put a Datagrid on my form and tryed to fill data from table Participate to my datagrid. I achieved but values were afcourse only ID-s of competitor and competition...So i tried to create new tableadapter with his own sql statemetn : SELECT c.Name, cs.About, p.Date FROM Competition c, Competitor cs, Participate p WHERE c.Idcompetitor=p.Idcompetitor AND cs.idcompetiton=p.idcompetition. When called tableadapter.Fill method on this datatable wverything is fine but what to do when you want to update values on table participate with this datagrid is that possible or there is another way of doing?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
