|
hahaha, wow, what the way you tell.....
nice joke
Becoming Programmer...
|
|
|
|
|
The way i showed was as simple and as easy to follow as possible! Specialy for someone who is renaming DB files the way you follow.
And atleast show some respect, it was surely not the best solution but atleast do-able and easy, which i thought was the best for renaming DB files without getting into much details, instead of the way you were following.
Thanks & Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
And with all due respect, if you are familiar with stored procedures, you may use "sp_renamedb" for renaming database. But before doing that do change it to the original name, so no issue arises.
Regards,
Adeel
Being polite will not harm you.
|
|
|
|
|
sorry boss if you hurt with what i said
that problem is making me crazy since last weak now you can think that what will happen when someone reply something like you did
i just want to copy my database and use it something like clone
i will try "sp_renamedb" too
-- modified at 8:01 Monday 12th November, 2007
yeah renaming work, now i got a trick that will help me out
thanks dude
Becoming Programmer...
|
|
|
|
|
Welcome my friend!
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
madeelch1986 wrote: It stores the data itself in the file, definitly encrypted!
What has encryption got to do with anything?
|
|
|
|
|
Can you not backup your database completely (to a .bak file), create a new empty database, and then restore in your backup to the new database?
Seems a little more simple.
|
|
|
|
|
my problem solved
first deattach database then copy it, attach previous one, change its name to new then attach again(another one)
its my trick that solved my problem
anyway thanks for trying to help
Becoming Programmer...
|
|
|
|
|
Hello,
I have a dataset that is populated with a "customers" table. Some fields in this table include CustomerID, LastName and FirstName.
I am trying to search through this dataset to find a specific customer and display its related information into textboxes for example.
I am lost as to how to accomplish this. Any help would be appreciated.
|
|
|
|
|
On an invoice capture form, I have a binding sources bindingSourceHead, and bindingSourceCust[1]. The bindingSourceCust links to a DataTable that contains a list of customer ID, Name rows. I have a ComboBox comboCustomerId with its DataSource property set to bindingSourceCust, and its DataMember and ValueMember properties set to CustomerId and CustomerName, respectively. In the databindings for the combo, I set SelectedValue to "bindingSourceHead - CustomerId", and all is well.
Now, my problem comes in where I try an additional, explicit update to the invoice header when the customer selection changes. The first time I select a new customer, the ContactPerson column in the invoice header updates, but the CustomerId does not. The ContactPerson change is lost on EndEdit. When I try again, I get the error: "DataTable internal index is corrupted: '5'." I have searched myself blue in the face and found nothing helpful on this except a pathetic drooling by some MS employee that they may have fixed this issue in Orcas. If I remove the Selected value binding of the combo, everything works, except I need to explicitly set the selected customer on the combo when I load an invoice, and explicitly set the customerId on the header when the combo changes selection. The following code only works when the SelectedValue data binding on the combo is set to None:
private void comboCustomerId_SelectedIndexChanged(object sender, EventArgs e)
{
ComboBox cb = sender as ComboBox;
if ((cb != null) && (cb.SelectedValue != null))
{
SetDefaultsForCustomer((int)cb.SelectedValue);
}
}
private void SetDefaultsForCustomer(int customerId)
{
CustomerDefaultsTableAdapter adap = new CustomerDefaultsTableAdapter();
InvoiceDataSet.CustomerDefaultsDataTable dfc = adap.GetData(customerId);
InvoiceDataSet.CustomerDefaultsRow cust = dfc.Rows[0] as InvoiceDataSet.CustomerDefaultsRow;
DataRowView drv = (DataRowView)bindingSourceHead.Current;
InvoiceDataSet.InvoiceRow ir = drv.Row as InvoiceDataSet.InvoiceRow;
if (ir != null)
{
ir.CustomerId = cust.CustomerId;
ir.CustomerContact = cust.ContactPerson;
}
[1] I also have a bindingSourceLines, but this doesn't seem to be playing a role in my issues.
Calling all South African developers! Your participation in this local dev community will be mutually beneficial, to you and us.
|
|
|
|
|
Hi,
I want to name my database with underscores, is there any negatives on doing it? For example abc_def_ghi
Please advise.
Thanks
|
|
|
|
|
.NET Enthusiast wrote: I want to name my database with underscores, is there any negatives on doing it? For example abc_def_ghi
It looks ugly (in my opinion), but that is it. You are permitted to use pretty much anything you like upto 128 characters. Certain sequences will require the name to be enclosed in sqaure brackets (using underscores is not one of them)
|
|
|
|
|
what is the best software for sql reporting and dashboards?
Many Thanks
User
NULL
|
|
|
|
|
|
Hello!
There are number of reporting softwares, depends on the usage! For extremely elegent and quality dashboards & guages i personally prefer Dundas. I am not marketing them just recommending and praising the software!
It also depends in what environment you are going to use it, MS Sharepoint Portal server offers such items as well.
.NET Charting is also pretty handy.
Regards,
Adeel
|
|
|
|
|
Yes it looks bit expensive
NULL
|
|
|
|
|
Still, as i said, it depends on the use. google it like "free chart gauges for .net" hopefuly you'll get something good.
Regards,
Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
|
|
|
|
|
Please, I need to know how to read xml document (created with dataSet.WriteXml) with ado.net 2.0 and update the corresponding table in the database with those values.
I wrote this test code:
using (DataSet ds = new DataSet())
using (SqlConnection conn = new SqlConnection(connectionString))
using (SqlDataAdapter da = new SqlDataAdapter("select * from TableName", conn))
{
try
{
da.Fill(ds);
ds.ReadXml(@"C:\xmldataset.XML");
ds.AcceptChanges();
da.Update(ds);
}
[...]
Nevertheless, the values in the database haven't been modified, after.
What am I missing?
Thanks in advance.
|
|
|
|
|
|
Thanks a lot, but I thought the dataset could do it, why is the ReadXml method for then, if you can open the xml like a XmlDocument?
|
|
|
|
|
|
I want to calculate every 10 records.
|
|
|
|
|
i used sql server 2005
1- create new query on server 1
2- add exec sp_addlinkedserver server2,'Sql Server'
3- add exec sp_addlinkedsrvlogin 'Server2','false','domain\user','user','password'
4- after that execute for query
5- this Error:(Msg 18452, Level 14, State 1, Line 11
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
)
Rami Abdalhalim
|
|
|
|
|
Rami Said Abd Alhalim wrote: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Sounds like you need to make the other server, Server2, allow trusted connections. Have you configured it to allow other connections outside of it's machine?
"If you divide your text into sentences, it might be possible to understand what you are trying to say." - Guffa
|
|
|
|
|