|
I will check this on monday, now it is time for weekend.
Have a nice weekend too and thanks for answering.
|
|
|
|
|
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Diagnostics;
using System.Data.SqlClient;
namespace GUI
{
public partial class GUI : Form
{
public GUI()
{
InitializeComponent();
}
private void GUI_Load(object sender, EventArgs e)
{
}
private void btnCreate_Click(object sender, EventArgs e)
{
if (ifthursday())
{
CreateDatabase(GetDatabasename());
CreateDatatable(GetTableName(), GetDatabasename());
}
}
///
/// Gets the name of the database from datetime picker and returns the value to the createDatabase Method
///
/// <returns>
///
public void Kill()
{
return;
}
public string GetDatabasename()
{
string namedatabase = dateTimePicker1.Value.ToString("MMdd");
string nameDB = "CustList_PGE_" + namedatabase;
MessageBox.Show("The name of the database will be CustList_PGE_" + namedatabase);
return nameDB;
}
public bool ifthursday()
{
//string dayisthursday= dateTimePicker1.Value.ToString("")
if (dateTimePicker1.Value.DayOfWeek.ToString().Equals("Thursday"))
{
MessageBox.Show("Thursday");
}
else if (MessageBox.Show("The selected date is not Thursday,Do you want to continue?", "Options", MessageBoxButtons.YesNo,MessageBoxIcon.Warning) == DialogResult.No)
{
return false;
}
return true;
}
///
/// Gets the name of the table from the datetime picker and returns the value to the createDatatable Method
///
/// <returns>
public string GetTableName()
{
string nameTable = dateTimePicker1.Value.ToString("MMddyy");
string nameTB = "CustList_PGE" + nameTable;
MessageBox.Show("The name of the Table will be CustList_PGE" + nameTable);
return nameTB;
}
//public void con()
//{
// Businesslayer.Businesslayer newobj = new Businesslayer.Businesslayer();
//}
///
///Creates an object to communicate to the Business Layer to create the DataBase
///
/// <param name="dbName" />
public int CreateDatabase(string dbName)
{
Businesslayer.Businesslayer createObj = new Businesslayer.Businesslayer();
int i=createObj.createDatabase(dbName);
if (i == 1801)
{
MessageBox.Show("The Database already exists");
return false;
}
}
///
/// Creates an object to communicate to the Business Layer for creating the Datatable
///
/// <param name="tableName" />
/// <param name="dbName" />
public void CreateDatatable(string tableName,string dbName)
{
Businesslayer.Businesslayer tableObj = new Businesslayer.Businesslayer();
tableObj.createTable(tableName, dbName);
}
}
}
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
namespace Businesslayer
{
public class Businesslayer
{
//public void createObject()
//{
// Datalayer.Datalayer obj = new Datalayer.Datalayer();
//}
public int createDatabase(string databaseName)
{
Datalayer.Datalayer createObj = new Datalayer.Datalayer();
int i = createObj.CreateDatabase(databaseName);
return i;
}
public void createTable(string tableName,string dbName)
{
Datalayer.Datalayer tableObj = new Datalayer.Datalayer();
tableObj.createTable(tableName, dbName);
}
public void get(SqlException ex)
{
}
}
}
>>>>>>>>>>>>>>>>>>>
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace Datalayer
{
public class Datalayer
{
string Test3;
string Testldf3;
SqlConnection conObj;
public void conSql()
{
try
{
//string con = "Data Source=TSPL-DEV07;Initial Catalog=PGEImport;Integrated Security=True";
conObj = new SqlConnection();
conObj.ConnectionString = ConfigurationSettings.AppSettings["con"];
if (conObj.State == ConnectionState.Closed)
{
conObj.Open();
}
}
catch (SqlException ex)
{
}
}
public int CreateDatabase(string nameDB)
{
int value =0;
try
{
conSql();
SqlCommand cmdObj = new SqlCommand();
cmdObj.Connection = conObj;
cmdObj.CommandText = "CreateDataBases";
cmdObj.CommandType = System.Data.CommandType.StoredProcedure;
cmdObj.Parameters.AddWithValue("@databaseName", nameDB);
// cmdObj.Parameters.AddWithValue("@databaseName_Log", nameDB + "CustList_PGE_0228_log");
cmdObj.Parameters.AddWithValue("@databaseName_Log", nameDB + "_log");
//CreateStrings(nameDB);
string Assign = CreateStrings(nameDB);
CreateConnections(Assign, cmdObj);
string Assignldf = CreateStringsldf(nameDB);
CreateConnectionsldf(Assignldf, cmdObj);
value = cmdObj.ExecuteNonQuery();
#region Comments
// CreateConnections(CreateStrings());
//cmdObj. = ConfigurationSettings.AppSettings["pathM"];
//string Test = ConfigurationSettings.AppSettings["pathM"];
//string Test1 = nameDB+".mdf";
//string Test2 = Test;
//string Test3 = Test2 + Test1;
//cmdObj.Parameters.AddWithValue("@mdfName",Test3);
//string Testldf = ConfigurationSettings.AppSettings["pathL"];
//string Testldf1 = nameDB + ".ldf";
//string Testldf2 = Testldf;
//string Testldf3 = Testldf2 + Testldf1;
// cmdObj.Parameters.AddWithValue("@ldfName", Testldf3);
//cmdObj.Parameters.AddWithValue("@ldfName",Testldf);
//cmdObj.CommandText = ConfigurationSettings.AppSettings["pathL"];
//cmdObj.Parameters.AddWithValue("@mdfName", @"C:\mssql1\data\0225.mdf");
//cmdObj.Parameters.AddWithValue("@ldfName", @"C:\mssql1\data\0225.ldf");
#endregion
return value;
}
catch (SqlException ex)
{
if (ex.Number == 1801)
{
value = 1801;
}
return value;
}
finally
{
if (conObj.State == ConnectionState.Open)
{
conObj.Close();
}
}
}
public string CreateStrings(string nameDB)
{
string Test = ConfigurationSettings.AppSettings["pathM"];
string Test1 = nameDB + ".mdf";
string Test2 = Test;
Test3 = Test2 + Test1;
return Test3;
}
public string CreateStringsldf(string nameDB)
{
string Testldf = ConfigurationSettings.AppSettings["pathL"];
string Testldf1 = nameDB + ".ldf";
string Testldf2 = Testldf;
Testldf3 = Testldf2 + Testldf1;
return Testldf3;
}
public void getstringfromBL()
{
}
//public void CreateConnections(string Test3, Datalayer cmdObj)
//{
// cmdObj.Parameters.AddWithValue("@mdfName", Test3);
//}
public void CreateConnections(string Assign,SqlCommand cmdObj)
{
cmdObj.Parameters.AddWithValue("@mdfName", Test3);
}
public void CreateConnectionsldf(string Assignldf,SqlCommand cmdObj)
{
cmdObj.Parameters.AddWithValue("@ldfName", Testldf3);
}
public void createTable(string tableName, string nameDB)
{
conSql();
SqlCommand cmdObj = new SqlCommand();
try
{
cmdObj.Connection = conObj;
cmdObj.CommandText = "createTable";
cmdObj.CommandType = System.Data.CommandType.StoredProcedure;
cmdObj.Parameters.AddWithValue("@databaseName", nameDB);
cmdObj.Parameters.AddWithValue("@databaseTable", tableName);
cmdObj.Parameters.AddWithValue("@primaryKey", @"ClientCoCustListID");
cmdObj.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
}
}
}
}
|
|
|
|
|
|
35 postings, 5 of them voted 1, with one 2 voter. Think that speaks for itself.
I'm largely language agnostic
After a while they all bug me 
|
|
|
|
|
Trustapple, Trustapple, Trustapple.... you just don't learn do you?
|
|
|
|
|
Last I checked, the CodeProject site didn't become a source code repository. You might want to ask an actual question on this code before someone start flaming you...oh, wait... My bad! I was too late!
|
|
|
|
|
You might want to consider investing in a source control system or moving this to the recylce bin. Either way, don't clutter up the forums. But I do have to catch you with this bit:
Trustapple wrote: try
{
cmdObj.Connection = conObj;
cmdObj.CommandText = "createTable";
cmdObj.CommandType = System.Data.CommandType.StoredProcedure;
cmdObj.Parameters.AddWithValue("@databaseName", nameDB);
cmdObj.Parameters.AddWithValue("@databaseTable", tableName);
cmdObj.Parameters.AddWithValue("@primaryKey", @"ClientCoCustListID");
cmdObj.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
}
}
Never ever catch an exception and do nothing with it - and certainly don't have a finally block that does nothing.
|
|
|
|
|
Hi all,
I have an application written in C#, and it is using P/Invoke to access functions defined in a custom (open source) dll, written in C++. My app is running as a service at client site, and occasionally it has failed, leaving an entry in the System Event Log, and the log message hasn't been terribly helpful. Basically it has said that an error occurred in this particular module (the native C++ one), but nothing more than that.
I have the full source code for this module, and I believe all compiler settings are correctly set in the release build configuration (Generate Debug Info, Program Database etc.). What is my best shot at getting as much information about the crash when it occurs?
Obviously, I'm handling all managed exceptions in my own code.
Any help whatsoever would be great.
Regards,
Daníel
Wenn ist das Nunstück git und Slotermeyer? Ja! Beierhund das oder die Flipperwaldt gersput!
|
|
|
|
|
You should be able to create a C++ / CLI mixed mode assembly that catches the native exception and then throws a managed exception back up to the C# code.
led mike
|
|
|
|
|
What is in the .NET3.x framework the "state of the art" way to implement role-based user authentication in a c# application?
I found some examples based on the "Authorization Manager" e.g. http://msdn.microsoft.com/msdnmag/issues/03/11/authorizationmanager/default.aspx
A solution with the "authorization manager" and the microsoft.interop.security.azroles.dll is from a functional view exactly what I would like to have but I suggest that it is not "state of the art" for a new application. I also found a lot of articles/examples on cardspace and concepts based on System.Security (Principal, Identity, etc.) but I don't see at the moment which of those implementation possibilities is the correct and best way for a new application. Thanks for any suggestions or hint or links on this topic.
|
|
|
|
|
rok0815 wrote: but I suggest that it is not "state of the art" for a new application.
See if this helps[^]
led mike
|
|
|
|
|
|
Member 4370898 wrote: i am fresh gruduate
I can see the education was well worth it.  
only two letters away from being an asset
|
|
|
|
|
Obviously never used a spell checker either
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
huck awn fawnix rilly wurkt fer him.
Otherwise [Microsoft is] toast in the long term no matter how much money they've got. They would be already if the Linux community didn't have it's head so firmly up it's own command line buffer that it looks like taking 15 years to find the desktop.
-- Matthew Faithfull
|
|
|
|
|
Dear Friends,
This is sorath here i am fresh gruduate and developing webiste i want to know that how user can download vedios from my website and where should i add these vedios in my application so users can easily download vedios.
|
|
|
|
|
Videos are just files. Treat them like any other file.
|
|
|
|
|
Don't post the same thing twice...
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi to all.
This is my first question in C# forum because I just started with VS2005 C#. My question concern resizing window. To achieve resizing controls on form I used three panels and some docking and anchoring, even add a single line of code on Resizing method on panel to force it to maintain a width of half of a form.
private void panel2_Resize(object sender, EventArgs e)<br />
{<br />
panel2.Size = new System.Drawing.Size((int)(this.Size.Width * 0.5), panel2.Size.Height);<br />
}<br />
It works but it's bad. When I resizing window this calculation (panel2.Size) is not happening always it is delayed and often jumps so it looks early bad.
BTW
In each panel (upper left and upper right) I have tree view controls, on Bottom one I placed some buttons and label's.
|
|
|
|
|
try :
Application.DoEvents();
or
this.Refresh();
or
panel2.Refresh();
after resizing the panel
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-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
never needed to in c#.net but i suspect you need to double buffer because your drawing to the screen it will be jumpy.
|
|
|
|
|
Do I find this (double buffer) under Properties bar in VS, because it seems I can't find it there?!
Or, I can add it in code using 'SetStayle'?
Thanks for replay
modified on Monday, March 3, 2008 4:03 AM
|
|
|
|
|
Hi,
i have got a error when i double click on ListView of .Net control,
in windows form.can any one tell me its solution.
at System.Windows.Forms.ListViewItem.set_Checked(Boolean value)
at System.Windows.Forms.ListView.WmNmDblClick(Message& m)
at System.Windows.Forms.ListView.WmReflectNotify(Message& m)
at System.Windows.Forms.ListView.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
amit
|
|
|
|
|
Don't repost. READ the reply you got to this last time you posted it.
He who makes a beast out of himself gets rid of the pain of being a man
|
|
|
|
|
amit_83,
Reposting wont get an answer to you any quicker.
Regards,
Gareth.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
