|
I'm not sure how to help you without just doing all the work for you. You've provided a ppt that has all the maths you need. If you can't work out how to turn this math into code, then I guess this is beyond you for now. But, it's really pretty easy, you just need to sit down and think it through.
If you posted your code, I'd be happy to look at it and compare it to the algorithm provided.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
i m trying to configure db in remote server through C# , locally it is configuring but in Remote Server db is is not creating. Following is the code
public bool createDB(object sServerName, String sDBName,object sAdminUname,object sAdminPwd)
{
object objServerName;
objServerName = sServerName;
SQLDMO.SQLServer gSQLServerDMO = new SQLDMO.SQLServer();
SQLDMO.Database nDatabase = new SQLDMO.Database();
SQLDMO.DBFile nDBFileData = new SQLDMO.DBFile();
SQLDMO.LogFile nLogFile = new SQLDMO.LogFile();
try
{
gSQLServerDMO.Connect(objServerName, sAdminUname, sAdminPwd);
nDatabase.Name = sDBName;
nDBFileData.Name = sDBName;
nDBFileData.PhysicalName = gSQLServerDMO.Registry.SQLDataRoot + "\\DATA\\" + sDBName + "_Data.mdf";
nDBFileData.PrimaryFile = true;
nDBFileData.Size = 2;
nDBFileData.FileGrowthType = SQLDMO.SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB;
nDBFileData.FileGrowth = 1;
//Adding DBFile object
nDatabase.FileGroups.Item("PRIMARY").DBFiles.Add(nDBFileData);
nLogFile.Name = sDBName + "_Log";
nLogFile.PhysicalName = gSQLServerDMO.Registry.SQLDataRoot + "\\DATA\\" + sDBName + "_Log.ldf";
nLogFile.Size = 2;
nDatabase.TransactionLog.LogFiles.Add(nLogFile);
gSQLServerDMO.Databases.Add(nDatabase);
return true;
}
catch (Exception sqlDBException)
{
String errSqlDBexception = sqlDBException.Message;
return false;
}
finally
{
gSQLServerDMO.DisConnect();
}
}
//Section for creating the database login and user in the above created Database.//
public bool Createdatabaselogin(String sDataSource, string databsename, String sScriptName, String sUserId, String sPwd, string loginName, string loginpass)
{
try
{
string sqlConnectionString = "Data Source=" + sDataSource + ";Initial Catalog=" + databsename + ";USER ID=" + sUserId + "; PWD=" + sPwd + ";Persist Security Info=True";
SqlConnection conn = new SqlConnection(sqlConnectionString);
Server server = new Server(new ServerConnection(conn));
string sqlquerylogin = "EXEC sp_addlogin '" + loginName + "','" + loginpass + "'";
string sqlqueryuser = "EXEC sp_adduser '" + loginName + "','" + loginName + "','db_owner'";
if (!server.Logins.Contains(loginName))
{
server.ConnectionContext.ExecuteNonQuery(sqlquerylogin);
}
server.ConnectionContext.ExecuteNonQuery(sqlqueryuser);
return true;
}
catch (Exception ex)
{
String error_str = ex.ToString();
return false;
}
}
What is wrong in this , can anyone suggest some idea?
|
|
|
|
|
hi friends
how to get current console application path
thanks
|
|
|
|
|
l.laxmikant wrote: how to get current console application path
That is very vague. Are you looking for the startup directory or the current working directory? The latter can be found in the Environment class.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
Environment.CurrentDirectory
Environment.CommandLine
Simon
|
|
|
|
|
I have A query From Which I Want To Seperate Columns And Values
I Had Written Code For This.
My Query------
Insert Into DEPARTMENT_MASTER(DPM_ID,DPM_CM_COMP_ID,DPM_BM_ID,DPM_NAME)
values(-2147483614,'2','2','abc,xyz')
Code:--------
//// string StrQue Contains Above Query////////////////////////
string StrQue=Query.ToUpper();
String[] Arr1 = Regex.Split(StrQue.Trim(), "INTO");
String[] Arr2 = Arr1[1].ToString().Split('(');
String[] Arr3 = Arr2[1].ToString().Split(')');
String[] Arr4 = Arr2[2].ToString().Split(')');
String[] ArrCol = Arr3[0].ToString().Split(',');
String[] ArrVal = Arr4[0].Split(',');
But With Above Code Problem Is That In ArrCol I am Getting Correct 4 columns but
In ArrVal I am Getting 5 Values because it is Spliting coma(,) from last
value('abc,xyz') Thats whay I am getting 5 Values but I want 4 Values.
Can anyone give me solution. Its urgent
Thanks,
|
|
|
|
|
You need to parse the string manually.
Use a for loop to iterate down every character in the string. Keep a track of all the characters parsed so far. Every time you hit a , character, store the characters parsed so far in your array, clear and continue. Set a flag to false when you encounter a ' character, and then ignore all , characters until you pass another ' character, when you can set the flag back to true again.
Simon
|
|
|
|
|
Thanks For Reply.
But Simon,What If my insert query contains 70 columns and their values in that case it become time taking process to process that query charater by character.
|
|
|
|
|
Firstly, it's really not going to be time consuming to parse a few hundred characters. Unless your parsing 10's of thousands just don't worry.
Secondly. Use a Regex like Christian says.
(That's better than my suggestion anyway)
Simon
|
|
|
|
|
ArifShaikh wrote: Can anyone give me solution. Its urgent
I just checked, and it turned out it's not urgent at all. But, if it was, then you'd think you'd do what I already told you, to use a regex to parse this string.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
 Hi,
Sorry i am not having code.
i want to develop a web page. in this i am designing one page with some fields.this field will be entered by the user.and this full format should save in pdf file and again it should disply online. please can any one help me.
i want the code in C#.Net.
thanks in advance,
kavita![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
You need to get a PDF library to help you generate the PDF file. ItextSharp[^] is one example. There are others out there if you google.
So you take the user input, you use ItextSharp to generate your PDF file, then you return it to the client for display.
Simon
|
|
|
|
|
Hello,
while inserting arabic value into mydatabse , i have to put N before each field value to help sql to handle arabic language, is it any properties to give to the table in sql and help me to not put an N before fields.
best regards
dghdfghdfghdfghdgh
|
|
|
|
|
|
Why do you ask variations on the same question over and over ? Did you try a google to understand what the 'N' does ?
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
Hi,
I have some data which has a state and a time stamp. I need to places this data in a list but have to be sure that items with the active state are all ontop sorted on the timestamp and when the status or timestamp is changed, it should be reordered accoring the new data.
Does any body knows a way to solve this?
greetings,
Rudy
|
|
|
|
|
I usually use a dataview to populate my data controls when I need sorting. You can then use and columns you wish in the sort string. When an item is changed refresh the dataview
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
But in a dataview I can't use an object with it's own intelligence ( own timer, properties etc)
|
|
|
|
|
How about using a SortedList, and when changing an item you remove it and insert it again?
|
|
|
|
|
I've thought about it, but I was more looking for a self ordering object/ list. The data can has something like a delay which will be handled by an internal timing function and when the timer expires the object state is changed and it should go up the list and get it's new place
|
|
|
|
|
It seems like a simple binary tree would satisfy your requirements.
|
|
|
|
|
Hi Friend's
Good Morning
I want Copy File Faster Than windows Explorer. it can be Possible Please Help me
Thanks
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
C:\> copy file.ext destination
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
|
I am not getting your Point Sir.
Basically i am using IO class for copy file but it equal to Explorer Copy.
i want copy fast than explorer copy.
Piyush Vardhan Singh
p_vardhan14@rediffmail.com
http://holyschoolofvaranasi.blogspot.com
http://holytravelsofvaranasi.blogspot.com
|
|
|
|
|
Piyush Vardhan Singh wrote: I am not getting your Point Sir.
You were not very clear 
Piyush Vardhan Singh wrote: Basically i am using IO class for copy file but it equal to Explorer Copy.
Much better You could try reading the file into a (large) byte[] and copy it to it's new location, however, I doubt it will be much faster, if not slower. Best will be to try various combination's.
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 beta 1 - out now! ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
