Comments by bernova (Top 107 by date)

how do i use chi array in javascript ?! , what have solution ?!!
for example :
http://www.codeproject.com/Questions/554912/sendplusfileplusnameplusformplusclientplussideplus

just i change it to array

could you shows an example ?
thanks a lot

I Change it :
public class MyPrintDoc : PrintDocument
{
public delegate void MyPrintPageEventHandler(object sender, PrintPageEventArgs e, string[] arr);
public event MyPrintPageEventHandler PagePrintHandler;
private string[] arr;

public MyPrintDoc(string[] iarr)
{
this.arr = iarr;
}
public MyPrintDoc()
{ this.iarr = null; }
protected void MyOnPrintPage(PrintPageEventArgs args)
{
PagePrintHandler(this, args, this.iarr);
}
}

Certainly you are a programmer, programmers is flexible in solutions that will be faces and solve it . just with small search you find the IETab that support activex in all browser , so the activex is not big abuse because the problem required use the activex

thanks a lot , I just know syntax of the DISTINCTROW command in Sql

thanks Sergey Alexandrovich Kryukov

what do you mean?

Thanks a lot.

Thanks a lot

I don't understand , I ask a hard question???????
I ask when use datagridview in function and call(in windows application) , don't show any data in datagridview????
in the all of comment and solution , don't refer a good solution for my problem???
all of comment is about syntax C# language, not for my question.

my problem doesn't solve

thanks but i'm using desktop application

Indeed when change datagridview on function and call function , don't return data on datagridview , but in the normal state , code does run.

what's related to data ?????!!!!! are you ok???

Indeed when change datagridview on function and call function , don't return data on datagridview , but in the normal state , code does run

the solution that use "ref" ,that find in stackoverflow that be accept solution.

my code is run , but if use in function don't return data on datagridview

Hi all
thanks for your response.

my code is run , but doesn't return any data.

please keep calm. I just ask a question!!!!!!!.
I thinks you are very very professional. but the professional man should use Polite words
my problem is solved.
I change the connection string to :
DataSource=.;Initial Catalog=Finanacial.mdf;Integrated Security=true;

I have been face above error

algorithm is true but the problem is Syntactic error not logical.

....
just and just I going to check if ( date(today) += 1) , that is tomorrow , my function does fire. but I can't get the tomorrow.

thanks for your very good response , Now I change the code:

re_dat = SDKClass.Selct_Date_now(); // select date from database field
DateTime date_now = DateTime.Parse(re_dat).Date;

if (date_now.Date == DateTime.Now.AddDays(1).Date)
{
SDKClass.Update_date(DateTime.Now.ToShortDateString());
int re_t = Convert.ToInt32(select_today_view);
int re_yes = Convert.ToInt32(select_yesterday_View);
int re_s = re_t + re_yes;
SDKClass.Update_yesterday_View(Convert.ToString(re_s));
}

but in the database , the value of date_now is 2015/06/13(yesterday) and we compare this with the (DateTime.Now.AddDays(1).Date) that is mean today date
and our condition don't fire, I do this but don't run.

thanks

I don't understand your purpose.
this condition don't fire...

date_now value in date base is last date and in the condition , we check
if ( tomorrow(DateTime.Now.AddDays(1)) == yesterday(date_now) ) , so this condition don't fire.

sorry My internet connection has been lost.

thanks , but this condition don't fire.

if (DateTime.Now.AddDays(1) == date_now)
{
SDKClass.Update_date(DateTime.Now.ToShortDateString());
int re_t = Convert.ToInt32(select_today_view);
int re_yes = Convert.ToInt32(select_yesterday_View);
int re_s = re_t + re_yes;
SDKClass.Update_yesterday_View(Convert.ToString(re_s));

SDKClass.Update_today_View("1");
}

Thanks for your response.
But you say that if DateTime.Now.AddDays(1).Date equal to date that return from database , so today is tomorrow ?!!!

<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1"runat="server" >

<asp:Panel ID="Panel1" runat="server" DefaultButton="Button1">
<asp:Button ID="Button1" Text="register" ForeColor="Blue" Font-Bold="true" Font-Names="tahoma" Font-Size="Medium" Height="40px" runat="server" onclick="Button1_Click"/>

I delete the tag but don't fire yet

in the another thread , I read that put the button to the <div> tag , but doesn't fire yet.
what is the solution ?

Button1_click source code:
protected void Button1_Click(object sender, EventArgs e)
{
Page page = HttpContext.Current.Handler as Page;

Boolean re = SDKClass.News_InsertNew(Subject_News_textbox.Text.ToString(), Brief_News_textbox.Text.ToString(), CKEditor1.Text.ToString(), date_now_textbox.Text, "Image1", true);
if (re == true)
{
ScriptManager.RegisterStartupScript(page, page.GetType(), "message", "alert('register_news')", true);

}
}

when click on the button , doesn't fire

two solution don't work

Thanks for your response But not useful.

Sacha. could you send your test project to me?

Thanks a lot.

Otherwise we know that the datagridview is not textbox. this datagridview is part of application form.

In the accounting software that we designed , for the Convenience , the user edit her information in the datagridview and press enter. indeed the user(customer) request to us , now we validating datagridview cells.

thanks a lot.

ok. that's so very good sites.

"You don't understand" Is bad Sentence.
I know your Purpose. because I use the function word instead of event.
I know what is different between event and function ... if don't know , can not write part of code that run correctly?!!

you are master.

thanks a lot.
best regards

ok.
but this code is run correctly. I don't know . just part of code have problem , not all of code..

Excuse me SA , I wanna edit comment , for this reason I delete it

Now when user change 0,1,2 column cells , the another datagridview2.keypress is running out.

Indeed don't allow to user that write number in datagridview cell.(first function)
don't allow to user that write string in datagridview cell ( secound function ).

how do it ?

Indeed I want to validate some datagridview cell...

Dear Surgey
when I use just dataGridView2_keypress function , that run correctly.
example :


private void dataGridView2_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
if (dataGridView2.CurrentCell.ColumnIndex == 5 || dataGridView2.CurrentCell.ColumnIndex == 6 || dataGridView2.CurrentCell.ColumnIndex == 7)
{
e.Control.KeyPress += new KeyPressEventHandler(dataGridView2_KeyPress);
}

}


private void dataGridView2_KeyPress(object sender, KeyPressEventArgs e)
{
if (!char.IsNumber(e.KeyChar))
{
e.Handled = true;
}
if (char.IsControl(e.KeyChar))
{
e.Handled = false;
}
}

where I should Define Subclass?

thanks for your answer. this solution is worked for me.

this is good solution.

how to i define two sponsor in table that have same property(eg: personal code is primary key)??

with do this I faced an the following error :

"The changes you requested to the table were not successful because they would create duplicate values in the index"

my [PK] in sponsor table is personal code

which one of field is primary key??

and field that called called Buyer_Sponsor in which of table is defined??

in the next version of application , we change database to sql server , because we have been forced to use access database , we should write VBA code for security and hide table and set password , but it is Vulnerable.

yeeeees. thanks a lot.
I release my solution as AnyCpu configuration . and test in many pc . that's right idea.

thanks a lot.

-SA thanks for your response.
I write customize message box in C# and run correctly and use it in the N-layer project (team work) for pretty UI. all of thing is ok.

for access to static modifier :
if that is variable we could use auto-Implementation ( that i use this and run correctly) .
or if it be function we could use namespace.classname.static-function that it run correctly but for default control(eg:panel) don't be.

thanks a lot.

this function run correctly without static modifier , but in this function i define pnlshow control that shows button

my exactly question :
how do i define the control inform static modifier?

the one of cell type is combobox. so whene merging , don't show any thing

Thanks , but i want to combine two datatable in one and set in one datagridview!!

thanks a lot . my problem is solved.

I do not get it

thanks my friend . but don't create new row at all.

the whole function is 80 code line , just this section is not going on

DataTable dt = new DataTable();
DataSet ds = new DataSet();

dt = ghestingTableAdapter.GetData();
DataRow newRow = dt.NewRow();
newRow["Explain"] = "pay";
dt.Rows.Add(newRow);
dataGridView1.DataSource = dt.DefaultView;

don't create new row at all

don't create row in last of rows

Edit your code , but don't create row in last of rows
DataTable dt = new DataTable();
DataSet ds = new DataSet();

dt = ghestingTableAdapter.GetData();
DataRow newRow = dt.NewRow();
newRow["Explain"] = "pay";
dt.Rows.Add(newRow);
dataGridView1.DataSource = dt.DefaultView;

thanks.but I have same error

datatype is string
and error is
Specified cast is not valid.

Thanks but just i have following error :
Specified cast is not valid.

I test first answer as follow :

public void disable_ghesting(string U_codem,string serial_kala)
{
string _comm_delete_ghest = "DELETE DISTINCTROW Ghesting.* FROM ((kala INNER JOIN buyer ON kala.buyer_codem = buyer.code_m_buyer) INNER JOIN Ghesting ON buyer.code_m_buyer = Ghesting.fk_code_m_buyer) WHERE ([Ghesting.fk_code_m_buyer] = ?) AND ([kala.serial_kala]= ?))";

OleDbParameter[] pa_delete_ghest = new OleDbParameter[2];
pa_delete_ghest[0] = new OleDbParameter("fk_code_m_buyer", OleDbType.Char);
pa_delete_ghest[0].Value = Convert.ToString(U_codem);
pa_delete_ghest[1] = new OleDbParameter("serial_kala",oledbtype.char);
pa_delete_ghest[1].value = convert.tostring(serial_kala);
a.query_Delete_command(_comm_delete_ghest, pa_delete_ghest);
}
but i have same error. i write project in form three-layer

when I test above query as following in WHERE parameters

WHERE fk_code_mbuyer = "2366381" AND kala.serial_kala = "202030"

run correctly. but when pass parameter with (?) shows error.

yet I have following error :
No given for one or more required parameter

Excuse me.

thanks phil.o , but i should pass two parameter to query , because i want to delete special record , not all of records.

the problem is that don't be pass parameters to delete query with innerjoin relationship.

I test my Query in Query design and this error shows in query design not in Visual C#.net

DELETE Ghesting
FROM ((kala INNER JOIN buyer ON kala.buyer_codem = buyer.code_m_buyer) INNER JOIN Ghesting ON buyer.code_m_buyer = Ghesting.fk_code_m_buyer)
WHERE(Ghesting.fk_code_m_buyer= ?)

shows error " no given value for one or many parameter "

My problem don't solved

this way have been cracked with software

Thanks , but I say install two program in your solution and i have same error

I write a module in VBA that Hide Access table , and set password on module , is it good way ?

Thanks Joan . Is it good idea to hash table data in the another thread?

yes I does your solution. but when click on the test connection shows the following error :

Can not open database ". It may not be a database that your application recognize, or the file may be corrupted.

thanks. I used same above code as following :
AppDomain.CurrentDomain.SetData("DataDirectory", Directory.GetCurrentDirectory());

I Write my Connection String in Class Library (dll). but I can't use above code and shows error

tanks. but Your solution shows the same error.

How to Set DataDirectory in the class library

My Question is
are the connection string is correct ?

???????

Tanks OriginalGriff.
because I set password on the access database . shows the same error.
My connection string is wrong.

No How Do I?

thanks . but i have same error
when remove WHERE statement , the query run correctly.

Dear Tadit Dash,
your solution don't work , because i want change button text per in row that i click , not all rows.

Tanks . but i can't change button text in per row

because i convert date field to Helical date

string date=dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["date_pay_ghest_grid"].Value.ToString();
string mabl = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["mablagh_ghest_grid"].Value.ToString();
string co = dataGridView1.Rows[dataGridView1.CurrentRow.Index].Cells["code_m_buyer_Grid"].Value.ToString();
using (OleDbConnection con = new OleDbConnection(tt.Access_Con))
{
con.Open();
using (OleDbCommand cv = new OleDbCommand())
{
cv.CommandType = CommandType.Text;
cv.CommandText = "UPDATE Ghesting SET date_ghest = [dat_gh] , mablagh_ghest = [mabl] WHERE (( fk_code_m_buyer = [fk_co]) AND (date_ghest = [dat_ghes]))";
cv.Connection = con;
cv.Parameters.AddWithValue("dat_gh", OleDbType.Char).Value = date;
cv.Parameters.AddWithValue("mabl", OleDbType.Char).Value = co;
cv.Parameters.AddWithValue("fk_co", OleDbType.Char).Value = mabl;
cv.Parameters.AddWithValue("dat_ghes", OleDbType.Char).Value = fg.Date_m_ghest;
//cv.Parameters.AddWithValue("phon_num", OleDbType.Char).Value = phone_number_textbox.Text.ToString();
//cv.Parameters.AddWithValue("date_ghest", OleDbType.Char).Value = fg.Date_m_ghest;

cv.ExecuteNonQuery();
//fr = bb.select_ghesting(code_m_buyer.Text);
//dataGridView1.DataSource = fr;
}
}

tanks a lot
but the code is run but don't correctly

Your purpose that is Create all of Database in Dynamically using CREATE DATABASE command and run in Storedprocedure And Don't Create Database And All of Table in wizard SQl Management Studio. Is it correct?

This line : Try creating the database directly in SQL, so that it is stored in the "normal" SQL Server data directory.

Exactly what should I do please?

thank you.

OK.Could you explain more please?

Server Error in '/Robotic' Application.
Login failed for user 'OWNEROR-TKU95F4\IWPD_173(zarinpor)'.
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: Login failed for user 'OWNEROR-TKU95F4\IWPD_173(zarinpor)'.

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): Login failed for user 'OWNEROR-TKU95F4\IWPD_173(zarinpor)'.]
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +428
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +65
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.SqlClient.SqlConnection.Open() +122
System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +87
System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +256
System.Web.Security.SqlRoleProvider.GetRolesForUser(String username) +760
System.Web.Security.RolePrincipal.IsInRole(String role) +164
UserBoss_Forum.Menu_Main_MenuItemDataBound(Object sender, MenuEventArgs e) +113
System.Web.UI.WebControls.Menu.OnMenuItemDataBound(MenuEventArgs e) +108
System.Web.UI.WebControls.Menu.DataBindRecursive(MenuItem node, IHierarchicalEnumerable enumerable) +3019
System.Web.UI.WebControls.Menu.DataBindItem(MenuItem item) +231
System.Web.UI.WebControls.Menu.PerformDataBinding() +50
System.Web.UI.WebControls.HierarchicalDataBoundControl.PerformSelect() +85
System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +73
System.Web.UI.WebControls.Menu.DataBind() +4
System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82
System.Web.UI.WebControls.Menu.EnsureDataBound() +40
System.Web.UI.WebControls.BaseDataBoundControl.OnPreRender(EventArgs e) +22
System.Web.UI.WebControls.Menu.OnPreRender(EventArgs e, Boolean registerScript) +15
System.Web.UI.WebControls.Menu.OnPreRender(EventArgs e) +25
System.Web.UI.Control.PreRenderRecursiveInternal() +80
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Control.PreRenderRecursiveInternal() +171
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +842


Version Information: Microsoft .NET Framework Version:2.0.50727.5472; ASP.NET Version:2.0.50727.5471

tanks a lot
I write two Query :

Query_1 -> ( first I insert value into Tbl_subteam table ) :
INSERT INTO Tbl_subteam (SubTeam_name , SubTeam_Familli, Code_m, birth_date, Sex, proof_tahsil, Address, email, Tel_home, Tel_mobile) VALUES (@SubTeam_name, @SubTeam_Familli, @Code_m, @birth_date, @Sex, @proof_tahsil, @Address, @email, @Tel_home, @Tel_mobile)

//------------------
Then I Update Manage_ID as below:
Query_2 -> (beacause I want to Return Sub team :

UPDATE Tbl_subteam
SET Manage_Id = Tbl_manager.UserId
FROM Tbl_manager INNER JOIN
aspnet_Users ON Tbl_manager.UserId = aspnet_Users.UserId CROSS JOIN
Tbl_subteam
WHERE (aspnet_Users.UserName = @UserName)
--------------------------------------------------------------
if I use two query in SQLCommand C#.net , when I Run in main Server , it cause Reduce Speed for insert or return data in database?

Thanks for your reply

but when i delete the Private Statements , for example :

private CHECK_APICompletedEventHandler CHECK_APICompleted;

I faced the following error :

'WCF_SMS.FanavaranBishapour_PanelSms.CHECK_APICompletedEventArgs.CHECK_APICompletedEventArgs(object[], System.Exception, bool, object)' must declare a body because it is not marked abstract, extern, or partial

if i delete all of the private statements in the above 'public event' statement , I have 22 errors

How could I handle CHECK_APICompletedEventArgs method??

best regards
tanks

I change the code in form this:

OleDbCommand comm = new OleDbCommand("update azade set fname='" + txt_name_janbaz.Text + "' ,lname ='" + txt_famili_janbaz.Text + "' ,father_name='" + txt_address_home.Text + "' , address_work='" + txt_address_work.Text + "'image=@image where codem='" + masked_txt_codem.Text +"'" , con);

OleDbParameter my = new OleDbParameter("@image", OleDbType.LongVarBinary,imageData.Length);
my.Value= imageData;
comm.Parameters.Add(my);

int n = 0;
n = comm.ExecuteNonQuery();
if(n>0)
{
messagebox.show("yes");
}
con.Close();

but i have same error